Database Administrator 5 (Database Administrator 1st Shift, Mon - Friday)

GovCIO; Martinsburg (WV); Hybrid; USD 125,000 - 160,000; Full time

Job summary

GovCIO is seeking an advanced MSSQL Administrator for the Network Security Operations Center in Martinsburg, WV. You will maintain MSSQL 2022 production and development instances, perform design, tuning, backups, and recovery, and work with developers on new applications.

The role requires strong scripting with PowerShell, configuring SQL Agent jobs, SSIS, and Always On, plus enforcing DISA/FISMA/STIG security practices. On-call support is required once a month.

Qualifications

• Bachelor’s degree in CS or related field; 12 years of experience required.
• Experience with MongoDB administration in enterprise environments.
• Must obtain one of the listed certifications within six months of hire.
• Must pass a government Tier 2 Moderate Background Investigation.

Responsibilities

• Install, configure, patch, upgrade, and administer MSSQL 2022 production and development instances.
• Perform design, performance monitoring and tuning, backups/recovery, and query optimization/tuning.
• Configure and maintain SQL Agent jobs, server audits, and SSIS packages.
• Configure and maintain Always On Availability Groups.
• Collaborate with developers to design and implement MSSQL-based solutions.
• Write PowerShell scripts to automate administration tasks.
• Harden SQL instances per DISA, FISMA and GOV Best Practice STIGS.
• Configure TDE and SSL encryption.
• Configure and administer MongoDB.
• Provide 24x7 on-call support one week per month.

Skills

MSSQL 2022

PowerShell scripting

SQL Server Always On

SQL Server security / STIGs

MongoDB administration

Performance tuning

Education

Bachelor’s degree in CS or related field

Tools

SSMS

SQL Agent

SSIS

MongoDB

Job description

The Department of Veterans Affairs Network Operations Center (NOC) defends, manages, and monitors the network operating status and cyber security posture of the VA by providing the day-to-day management, monitoring, operation, and configuration of the Trusted Internet Connection (TIC) Gateways, the delivery of enterprise security systems and services, the conduct of threat and vulnerability analysis, the validation of adequate security controls within the enterprise, and the full range of functions across the spectrum of activities relating to incident management, incident response and enterprise network management.

Seeking an advanced MSSQL for 1st shift, full time work at the VA’s Network Security Operations Center (NSOC) in Martinsburg, WV, working for Service Design and Implementation and Portal Services.

This position is based Martinsburg, WV, and will be a hybrid remote position.

Responsibilities

• Install, configure, harden, patch, upgrade, maintain, and administer production and development MSSQL 2022 SQL instances.
• Perform logical and physical design, performance monitoring and tuning, troubleshooting, capacity planning, database backup and recovery, and query optimization/tuning.
• Configure and maintain SQL Agent jobs, server audits, and SSIS packages.
• Configure and maintain Always on Availability Groups.
• Work closely with developers to design, develop, implement, and maintain new applications using MSSQL 2022.
• Write, debug, and maintain Power Shell scripts to automate administration tasks.
• Harden SQL instances per DISA, FISMA and GOV Best Practice STIGS.
• Configure and maintain Transparent Data Encryption and Secure Socket Layer Encryption.
• Configuring and administering MongoDB.
• Excellent writing, communication, organizational, and troubleshooting skills.
• Ability to work independently.
• High degree of attention to detail.
• Commitment to quality.
• Desire to continuously learn new technology.
• Willingness to provide 24x7 on-call support one week a month.

Qualifications

• Education / Experience: Bachelor’s degree in computer science, electronics engineering or other engineering or technical discipline is required with 12 years of experience. 8 additional years of relevant experience may be substituted for education.
• Experience with MongoDB administration and set up in an enterprise environment
• PWS Specified Certifications: This position requires privileged system access. The applicant shall have six months to obtain ONE of the following industry standard certification.
  • Microsoft SQL Server 2016 Certified Solutions Associate (MCSA) or above
  • Microsoft SQL Server Solutions Expert, Data Platform (MCSE) or above
  • Microsoft Certified IT Professional (MCITP) Database Administrator SQL 2016 (or greater)
  • Microsoft Certified Technology Specialist (MCTS).
• Miscellaneous: Duties may require traveling, Sits up to 6 hours per day using close vision, repetitive wrist, hand or finger movement (to operate computer equipment), lift up to 25 pounds
• Background Investigation: Must be able to pass a government Tier 2 Moderate Background Investigation

Posted Salary Range

USD $124,540.00 - USD $160,000.00 /Yr.