Senior SQL DBA - Zachary Piper LLC

Job Title: Senior SQL DBA

Location: Fort Belvoir, VA OR Radford, VA

Company: Zachary Piper Solutions

Clearance Required: Secret

Full Job Description:

Zachary Piper Solutions is looking for a Senior SQL DBA to join a growing team with a highly credible prime contractor, in support of a government agency. This position will be hybrid, two days a week in office and will require a Secret Clearance due to the scope of the work.

Responsibilities/Overview:

·        Design, install, configure, audit, and maintain highly available enterprise database systems

·        Monitor backups on all SQL Server databases

·        Perform routine disaster recovery testing scenarios

·        Troubleshoot and maintain database performance, including the proposal of short-term fixes, long term solutions, and the regular scheduling of index maintenance and database integrity checks

·        Establish and maintain database policies and standards

·        Generate database schema definitions and modifications as required

·        Refresh data from one processing environment to another as required

·        Develop, follow, and maintain team documentation for repeatable processes, including database feature installation, disaster recovery, and common problem resolution

·        Adhere to ITILv4 (Information Technology Infrastructure Library) practices for Change Management

Required Qualifications:

·        Three to five years of experience with Microsoft SQL Server Enterprise Edition and all facets of database administration

·        Three or more years of experience with Microsoft SQL Server High Availability features: Failover Clustering, Log Shipping, Database Mirroring, AlwaysOn Availability Groups

·        Three or more years of experience with Windows Server (2016 and higher) and Microsoft Failover Clusters

·        Installation and configuration experience with SQL Server 2019 (and higher) and SQL Server Cumulative Updates (CUs)

·        Strong documentation skills

·        Strong database performance tuning skills

• Security+ Certification OR any other DoD IAT Level II Certification
• Any AWS Certification
• Microsoft SQL Server 2016 (or higher) Certification
• Active Secret Clearance

Compensation and Benefits:

• $105,000-$145,000+
• Full Benefits: Cigna Medical, Dental, Vision, 401k, etc.

SQL, database administration, senior, data management, performance tuning, database security, backup and recovery, SQL Server, MySQL, Oracle, database design, troubleshooting, high availability, disaster recovery, query optimization, data migration, scripting, ETL processes, capacity planning, system integration, technical support, Secret clearance, clearance, Radford, VA, Fort Belvoir, Virginia, AWS, Microsoft, tuning, hybrid