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
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
- Dice Id: 80183524
- Position Id: 46d53112b42a59df5d98b86a9e221695
- Posted 10 hours ago
Never miss an opportunity! Create an alert based on the job you applied for.