Senior SQL Database Administrator

Amentum•Alexandria, VA

20h•$190,000 - $195,000•Onsite

About The Position

Purpose and Impact: INSCOM executes mission command of operational intelligence forces; conducts worldwide multidiscipline and all source intelligence operations; delivers advanced skills training, linguist support, specialized quick reaction capabilities, intelligence related logistics, and communications in support of Army, Joint, and Coalition command and the National Intelligence Community. You will be part of a team that provides comprehensive automation/information technology support to the Data Capabilities Division (DCD) worldwide intelligence dissemination, data management, and knowledge management missions. Work Schedule: Monday-Friday, 8 hours/day, Core hours: 0900-1500 Essential Responsibilities: Provide database administration and management support for Relational Database Management Systems (RDMS) in a Microsoft SQL Server-based environment hosting databases across the supported networks for various .NET applications. Maintain quality of service and availability of DCD RDMSs by establishing and enforcing organizationally defined standards ensuring the performance, integrity and security of databases through daily system checks with 100% of findings and statuses being recorded to DCD IT Portal. Maintain, report, and update daily checklists. Ensure all SQL servers and instances have the latest Defense Information Systems Agency (DISA) STIGs applied within 30 calendar days of release and uploaded to STIG management portals where available. Notify Government and TTM of any critical findings that cannot be remediated within 3 days of discovery. Manipulate database objects and develop stored procedures, stored functions, and packages when needed based on customer requirements. Ensure healthy and reliable data replication is maintained using technologies such as availability groups, etc. Monitor performance and manage parameters to provide fast query responses to ‘front end’ users optimizing code and stored procedures while assisting application developers with database requirements. Configure and utilize database connectivity tools and utilities while supporting developers, programmers, and engineers during software development. Map out a conceptual design for database enhancements, considering both ‘back end’ organization of data and ‘front end’ accessibility for end user. Research, test, and implement new versions of the Database Management System (DBMS) for inclusion into DCD infrastructure as they become available. Implement security requirements for least privileged access to organizational databases and monitor user access and security. Develop and maintain database documentation to include updating existing and creating new Standard Operating Procedures, TTPs, logical architecture diagrams, entity relationship diagrams, server lists, and other database administration related documentation on monthly basis adhering to organizational templates and policies. Produce entity relationships and data flow diagrams, and database normalization schemas that are logical to physical data maps and data table parameters. Develop, manage, and test backup and recovery plans, ensuring that storage, archiving, backup, and recovery procedures are functioning correctly to include monthly integrity testing of no less than ten (10) percent of DCD database backups on the supported networks. Conduct capacity planning and assistance with storage and architecture design. Review “Database Daily Checks” list on the DCD IT Portal and complete the Daily System Checks assigned. Ensure 100% completion of all CRITICAL checks completed by 0700hrs daily, all other priority checks completed by 1000hrs daily. This includes performance, data integrity, and availability checks that are created daily on SIPRNET portal with required actions. Database administrators shall complete checks and update lists with status and actions taken to resolve issues. Review “Database Restore Checks” list on the DCD IT Portal and complete random testing of no less than ten (10) percent of databases, on each of the supported networks, per month and annotate on SIPR no later than 1200hrs on Friday of each week. This includes ensuring the integrity of database backups and abilities to meet Recovery Point Objectives (RPO) by regularly testing backups. The contractor shall notify the Government of any unscheduled system outages within 30 minutes of each occurrence and add to operations log within four (4) hours. Provide after-hours on-site support to respond to system/application malfunctions. The contractor shall have 2 hours after notification of an issue to respond to the workplace. If after two hours on site the issue is not resolved, the contractor shall escalate the issue to the Project Manager who shall provide hourly telephonic updates to the COR and TTM until the issue is resolved. Make sure configuration management data are updated within one business day of any modification or update of infrastructure. Provide restoration services sufficient to ensure high availability. Monitor and assume responsibility of trouble tickets assigned to the Database Administration branch, assign specific tickets for resolution, and prioritize tickets in line with organizational goals of maintaining 99% system availability rate. Work Environment, Physical Demands, and Mental Demands: Open office work desk within a SCIF. Other Responsibilities: Safety - Amentum enforces a safety culture whereby all employees have the responsibility for continuously developing and maintaining a safe work environment. As appropriate, each employee is responsible for completing all training requirements and fulfilling all self-aid/buddy aid responsibilities, participating in emergency response tasks and serving on safety committees and teams. Quality - Quality is the foundation for the management of our business and the keystone to our goal of customer satisfaction. It is our policy to consistently provide services that meet customer expectations. Accordingly, each employee must conform to the Amentum Quality Policy and carry out job activities in compliance with applicable Amentum Quality System documents and customer contracts. Each employee must read and understand his/her Quality Management and Customer Satisfaction responsibilities. Procedure Compliance - Each employee must read, understand and implement the general and specific operational, safety, quality and environmental requirements of all plans, procedures and policies pertaining to his/her job. Qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, sexual orientation, gender identity, disability or protected veteran status. As part of our commitment to maintaining a safe and compliant work environment, Amentum is a drug-free workplace and requires all personnel to comply with company drug and alcohol policies as a condition of employment. Employment is contingent upon successful completion of the drug screening process. Please note that this may include pre-hire screening for marijuana, as well as other federally controlled substances due to Amentum’s role as a federal contractor and trusted partner to the US Government.

Requirements

Ten years of experience in SQL database administration supporting and managing databases in a production environment
Ten years of experience installing, configuring, and supporting Microsoft SQL Server in High Availability Group configurations
Ten years of experience with T-SQL and ability to write scripts, stored procedures, triggers, and views to automate maintenance functions.
Ten years of experience troubleshooting and debugging database applications in test and production environments.
Five years of experience planning and implementing security measures to safeguard information against accidental or unauthorized damage, modification or disclosure in accordance with industry’s best practices and DISA STIGs.
Three years of experience serving as a team leader working as both part of a team and independently to assign/review immediate tasks, set priorities, maintain task progress, validate team members’ work consistent with the organizational goals and deadlines.
Three years of experience mentoring junior personnel on proper practices and procedures.
Experience developing database applications in classified environments
Experience migrating and adapting database applications for the Cloud.
Experience with database integrations between systems and across networks.
Clearance Required: TS/SCI clearance with SBI and ability to attain SI, TK, G, HCS, and NATO Secret clearance
Minimum Education: High School Diploma
Minimum Years of Experience: 10 years
Required Certifications: DoD 8140.03 IAT Level II/Intermediate certification (i.e. Security+)
Microsoft Certified Solutions Associate (MSCA) or SQL Server 2016 or SQL Database Administration Certification

Nice To Haves

Experience AWS or other Cloud database application support.
Experience applying Security STIGs.
Experience deploying applications in different environments.

Responsibilities

Provide database administration and management support for Relational Database Management Systems (RDMS) in a Microsoft SQL Server-based environment hosting databases across the supported networks for various .NET applications.
Maintain quality of service and availability of DCD RDMSs by establishing and enforcing organizationally defined standards ensuring the performance, integrity and security of databases through daily system checks with 100% of findings and statuses being recorded to DCD IT Portal.
Maintain, report, and update daily checklists.
Ensure all SQL servers and instances have the latest Defense Information Systems Agency (DISA) STIGs applied within 30 calendar days of release and uploaded to STIG management portals where available.
Notify Government and TTM of any critical findings that cannot be remediated within 3 days of discovery.
Manipulate database objects and develop stored procedures, stored functions, and packages when needed based on customer requirements.
Ensure healthy and reliable data replication is maintained using technologies such as availability groups, etc.
Monitor performance and manage parameters to provide fast query responses to ‘front end’ users optimizing code and stored procedures while assisting application developers with database requirements.
Configure and utilize database connectivity tools and utilities while supporting developers, programmers, and engineers during software development.
Map out a conceptual design for database enhancements, considering both ‘back end’ organization of data and ‘front end’ accessibility for end user.
Research, test, and implement new versions of the Database Management System (DBMS) for inclusion into DCD infrastructure as they become available.
Implement security requirements for least privileged access to organizational databases and monitor user access and security.
Develop and maintain database documentation to include updating existing and creating new Standard Operating Procedures, TTPs, logical architecture diagrams, entity relationship diagrams, server lists, and other database administration related documentation on monthly basis adhering to organizational templates and policies.
Produce entity relationships and data flow diagrams, and database normalization schemas that are logical to physical data maps and data table parameters.
Develop, manage, and test backup and recovery plans, ensuring that storage, archiving, backup, and recovery procedures are functioning correctly to include monthly integrity testing of no less than ten (10) percent of DCD database backups on the supported networks.
Conduct capacity planning and assistance with storage and architecture design.
Review “Database Daily Checks” list on the DCD IT Portal and complete the Daily System Checks assigned.
Ensure 100% completion of all CRITICAL checks completed by 0700hrs daily, all other priority checks completed by 1000hrs daily. This includes performance, data integrity, and availability checks that are created daily on SIPRNET portal with required actions. Database administrators shall complete checks and update lists with status and actions taken to resolve issues.
Review “Database Restore Checks” list on the DCD IT Portal and complete random testing of no less than ten (10) percent of databases, on each of the supported networks, per month and annotate on SIPR no later than 1200hrs on Friday of each week. This includes ensuring the integrity of database backups and abilities to meet Recovery Point Objectives (RPO) by regularly testing backups.
The contractor shall notify the Government of any unscheduled system outages within 30 minutes of each occurrence and add to operations log within four (4) hours.
Provide after-hours on-site support to respond to system/application malfunctions. The contractor shall have 2 hours after notification of an issue to respond to the workplace. If after two hours on site the issue is not resolved, the contractor shall escalate the issue to the Project Manager who shall provide hourly telephonic updates to the COR and TTM until the issue is resolved.
Make sure configuration management data are updated within one business day of any modification or update of infrastructure.
Provide restoration services sufficient to ensure high availability.
Monitor and assume responsibility of trouble tickets assigned to the Database Administration branch, assign specific tickets for resolution, and prioritize tickets in line with organizational goals of maintaining 99% system availability rate.

Benefits

Our health and welfare benefits are designed to support you and your priorities. Offerings include:
Health, dental, and vision insurance
Paid time off and holidays
Retirement benefits (including 401(k) matching)
Educational reimbursement
Parental leave
Employee stock purchase plan
Tax-saving options
Disability and life insurance
Pet insurance
Note: Benefits may vary based on employment type, location, and applicable agreements. Positions governed by a Collective Bargaining Agreement (CBA), the McNamara-O'Hara Service Contract Act (SCA), or other employment contracts may include different provisions/benefits.