Database Analyst/Programmer - Senior

Overview

Perform modifications to the enterprise database as required to resolve problem reports and implement change requests, as well as maintain and optimize the database for the system, and utilize the priority and severity rankings as assigned by the Product Owner for sprint planning.

Responsibilities

· Recommend and implement changes to the AETCD data model/schema.

· Ensure that software design, database design, and interfaces allow for high levels of performance, maintainability, and reliability

· Define and document logical attributes and data inter-relationships for complex data structures.

· Design and maintain relational integrity, concurrency controls, index optimization, log clean-ups, and page files.

· Develop complex SQL queries and stored procedures, triggers, functions, and indexes to ensure that they are optimized for fast execution speeds to the greatest extent possible.

· Monitor database activity and file usage. Recommend and/or implement tuning opportunities to improve system response and run times.

· Support upgrades/patches of the database management system software as necessary.

· Maintain the IA posture of the database system to include monitoring and resolution of applicable IAVAs. Monitor vendor security bulletins to obtain information on potential threats and install necessary security patches to ensure ongoing database security.

· Support RMF Activities for the system to include producing supporting documentation of IA compliance.

· Assist project managers and team leads in the development of project plans required for data management and database administration activities.

· Develop and implement a data migration solution to support future system migration.

Qualifications

Required:

· BS Degree in computer science AND 5 years’ experience with Windows Server OS, T-SQL, SQL Server Database management, and performing technical documentation and/or operational system test and evaluation functions directly related to the major USAF Management Information System

· OR 10 years’ experience in performing the foregoing functions, of which 2 years of recent experience were performing technical documentation and/or operational system test and evaluation functions.

· SECRET clearance is required.

· Familiar with Microsoft Office suite (Word, Excel, PowerPoint, etc.)

Company Overview

Integral partners with federal defense, intelligence, and civilian leaders to tackle their most important challenges and deliver positive outcomes. Since our founding in 1998, we have helped clients leverage existing and emerging technologies to transform their enterprises, empower growth, drive innovation, and build sustainable success. The forward-leaning solutions we deliver are tailored to each mission with a focus on keeping our nation safe and secure.

Integral is headquartered in McLean, VA and serves clients throughout the country.

We offer a comprehensive total rewards package including paid parental leave and immediate vesting in our 401(k). Give us a try and become part of a curated group of professionals at Integral Federal!

Our package also includes:

· Medical, Dental & Vision Insurance

· Flexible Spending Accounts

· Short-Term and Long-Term Disability Insurance

· Life Insurance

· Paid Time Off & Holidays

· Earned Bonuses & Awards

· Professional Training Reimbursement

· Employee Assistance Program

Equal Opportunity Employer/Protected Veteran/Disability