SQL Server Cloud Database Lead

Peraton; Reston (VA); A distancia; USD 104.000 - 166.000; Jornada completa

Descripción de la vacante

Peraton is seeking a Senior Microsoft SQL Server Database Lead to design, implement, and support mission-critical databases on AWS EC2 and RDS. You will mentor junior staff, engage stakeholders, and ensure security and uptime for a large government program. Remote-based with EST hours.

The role requires deep expertise in Always On, DR, encryption, and CI/CD integration, plus strong automation skills using PowerShell or Python. Eligible for national remote work within the US.

Formación

• US citizenship and ability to obtain Public Trust clearance
• Bachelor's degree with 8+ years of relevant experience or equivalent
• Minimum 7 years of production MS SQL Server DBA experience
• Experience with SQL Server 2019/2022 in HA configurations
• AWS RDS databases including PostgreSQL, Oracle, Redshift
• Proficient in SQL Server performance tuning and DMVs
• Strong AWS concepts: VPC, IAM, CloudWatch/Trail/SSM, KMS
• Experience with PowerShell scripting for automation

Responsabilidades

• Lead planning, installation, configuration, and optimization of SQL Server in AWS-cloud infrastructure
• Architect high availability and disaster recovery solutions (Always On, clustering, log shipping)
• Automate database functions and support data migration initiatives
• Collaborate with cross-functional teams to deliver value and outcomes
• Provide technical leadership and mentoring to the DBA team
• Develop and maintain database security controls and auditing per CIS/SCSEM and compliance
• Manage vulnerability remediation and apply fixes from scans
• Implement encryption and key management using SQL Server TDE, TLS, AWS KMS
• Oversee backup/restore and DR verification/testing
• Conduct performance analysis and capacity planning with Datadog
• Coordinate patching/maintenance windows and certificate mgmt
• Tune complex queries and execution plans for performance
• Support CI/CD pipelines with GitLab and Liquibase
• Automate ops tasks with PowerShell, AWS CLI or Python
• Ensure runbooks and change-management procedures
• Collaborate with security and infra teams to meet requirements
• Participate in design reviews and architectural guidance
• Lead incident resolution and root-cause analysis
• Engage vendors for escalated issues
• Review and implement change requests
• Maintain comprehensive docs of configurations and procedures

Conocimientos

SQL Server DBA

Always On Availability Groups

AWS RDS

PowerShell

Python

Security and Compliance

CI/CD

Performance Tuning

Educación

Bachelor's degree

High School Diploma or equivalent

Herramientas

AWS EC2

Windows Server

GitLab

Liquibase

Descripción del empleo

SQL Server Cloud Database Lead

Peraton Overview

Peraton is a next-generation national security company that drives missions of consequence spanning the globe and extending to the farthest reaches of the galaxy. As the world's leading mission capability integrator and transformative enterprise IT provider, we deliver trusted, highly differentiated solutions and technologies to protect our nation and allies. Peraton operates at the critical nexus between traditional and nontraditional threats across all domains: land, sea, space, air, and cyberspace. The company serves as a valued partner to essential government agencies and supports every branch of the U.S. armed forces. Each day, our employees do the can't be done by solving the most daunting challenges facing our customers. Visit peraton.com to learn how we're keeping people around the world safe and secure.

Job Locations

US

Responsibilities

Peraton is seeking a Senior Microsoft SQL Server Database Lead to provide advanced technical expertise and leadership in support of a large government agency. This role is responsible for the design, implementation, maintenance, and support of missioncritical database environments hosted on both AWS EC2 and Amazon RDS. The Senior DBA will serve as a technical leader within the team, provide mentorship to junior staff, consultations with customer stakeholders (application teams, partners, end users, ensure adherence to security and compliance standards, and support the program's operational, performance, and availability objectives.

Location: Remote

Shift Schedule: 8am - 5pm Eastern Standard Time (EST). This position will participate in 24x7 on-call rotations for the production environment.

What You Will do:

• Lead the planning, installation, configuration, and optimization of Microsoft SQL Server environments in AWS cloud-hosted infrastructures.
• Architect and implement high availability and disaster recovery solutions, including Always On Availability Groups, Windows Failover Clustering, replication, and log shipping.
• Continually seek ways to fully automate database functions, ability to provide data migration solutions, and facilitate innovation conversations.
• Work with cross functional teams to provide solutions to customers, application teams, with the ability to present executive level value and outcomes.
• Provide technical leadership to the DBA team, including mentoring, reviewing technical deliverables, and reinforcing best practices.
• Develop, implement, and maintain database security controls and auditing solutions in accordance with CIS, SCSEM, and federal compliance requirements.
• Manage vulnerability remediation activities by analyzing NESSUS scan results, applying corrective actions, and documenting compliance.
• Implement and manage database encryption and key rotation using SQL Server TDE, TLS, and AWS KMS.
• Direct backup, restore, and disaster recovery processes; perform verification and testing of all backup strategies.
• Conduct performance analysis, capacity planning, and proactive monitoring utilizing Datadog and other monitoring tools.
• Oversee and coordinate database patching, upgrades, maintenance windows, and certificate management.
• Conduct advanced query tuning and execution plan analysis for application performance optimization.
• Support CI/CD pipelines by integrating database deployments with GitLab and Liquibase.
• Automate operational tasks using PowerShell, AWS CLI, or Python (monitoring, patching, deployment, maintenance).
• Ensure adherence to standardized procedures, operational runbooks, and change management protocols.
• Collaborate with application, infrastructure, and security teams to support business requirements, resolve issues, and ensure database reliability.
• Participate in technical design reviews and provide architectural guidance for database-related components.
• Lead the resolution of complex incidents and problems, perform root-cause analysis, and implement longterm corrective measures.
• Engage subject matter experts or vendor support as needed for escalated issues.
• Review, approve, and implement database change requests in alignment with program policies and best practices.
• Maintain comprehensive documentation of database configurations, processes, standards, and operational procedures.

Qualifications

Basic Qualifications:

• Must be a U.S. Citizen with the ability to obtain and maintain the required Public Trust level clearance.
• Bachelor's degree and 8 years of relevant experience, or a High School Diploma or equivalent and 12 years of experience
• Minimum 7 years of production Microsoft SQL Server DBA experience supporting enterprise-scale environments.
• Experience with SQL Server 2019/2022 in virtualized and highavailability configurations.
• Advanced knowledge of Always On Availability Groups, replication, log shipping, SQL Agent jobs, maintenance plans, and Ola Hallengren maintenance frameworks.
• Experience with AWS RDS databases PostgreSQL, Oracle, and Redshift.
• Experience with SQL Server performance tuning using execution plans, DMVs, extended events, and wait statistics.
• Strong understanding of AWS VPC networking concepts (subnets, routing, security groups) as they relate to database deployments.
• Experience with AWS cloud services, including:
  • Amazon EC2 for SQL Server instances
  • Amazon RDS for SQL Server
  • AWS Backup
  • AWS Identity and Access Management (IAM) for database access controls
  • AWS CloudWatch, CloudTrail, Systems Manager, and Parameter Store
  • AWS KMS for encryption and key management
• Strong understanding of Windows Server, Active Directory and Group Managed Service Accounts.
• Strong PowerShell scripting skills for automation and administration.

Preferred Qualifications:

• Strong written and verbal communication skills with the ability to present information to technical and nontechnical audiences, including leadership.
• Experience working effectively in a remote environment and collaborating across distributed teams.
• Experience with TransactSQL development and scripting.

Target Salary Range

$104,000 - $166,000. This represents the typical salary range for this position. Salary is determined by various factors, including but not limited to, the scope and responsibilities of the position, the individual's experience, education, knowledge, skills, and competencies, as well as geographic location and business and contract considerations. Depending on the position, employees may be eligible for overtime, shift differential, and a discretionary bonus in addition to base pay.

Benefits Statement

Peraton offers eligible employees a variety of benefits including medical, dental, vision, life, health savings account, short/long term disability, EAP, parental leave, 401(k), paid time off (PTO) for vacation, and company paid holidays. A full listing of available benefits can be viewed at https://www.careers.peraton.com/benefits.

EEO

EEO: Equal opportunity employer, including disability and protected veterans, or other characteristics protected by law.