SQL Server Cloud Database Lead

This is a fully remote position, open to applicants in United States.

📋 Description

• Oversee the planning, installation, configuration, and optimization of Microsoft SQL Server environments within AWS cloud-based infrastructures.

• Design and execute high-availability and disaster-recovery solutions utilizing Always On Availability Groups, Windows Failover Clustering, replication, and log shipping.

• Automate database operations and deliver data migration solutions.

• Lead innovation discussions and communicate value and outcomes to executive stakeholders.

• Offer technical direction to the DBA team, mentor junior personnel, review technical outputs, and uphold best practices.

• Develop and sustain database security measures and auditing solutions to meet CIS, SCSEM, and federal compliance standards.

• Evaluate NESSUS scan outcomes, address vulnerabilities, and document compliance efforts.

• Implement and oversee database encryption and key rotation using SQL Server TDE, TLS, and AWS KMS.

• Manage backup, restoration, and disaster-recovery processes, ensuring verification and testing.

• Conduct performance assessments, capacity planning, and proactive monitoring utilizing Datadog and other monitoring tools.

• Coordinate database patching, upgrades, maintenance schedules, and certificate management.

• Execute advanced query tuning and analyze execution plans.

• Integrate database deployments with CI/CD pipelines using GitLab and Liquibase.

• Automate operational tasks with PowerShell, AWS CLI, or Python.

• Maintain standardized procedures, operational runbooks, and change-management practices.

• Collaborate with application, infrastructure, and security teams to troubleshoot issues and ensure database reliability.

• Engage in technical design evaluations and provide architectural insights.

• Lead complex incident and problem resolution, root-cause analysis, and long-term corrective measures.

• Collaborate with subject-matter experts or vendor support for escalated issues.

• Review, authorize, and implement database change requests.

• Keep comprehensive database configuration and operational documentation.

• Participate in 24/7 production on-call rotations.

⛳️ Requirements

• Must be a U.S. citizen.

• Ability to acquire and maintain the necessary Public Trust level clearance.

• Bachelor’s degree with 8 years of relevant experience, or a High School Diploma (or equivalent) with 12 years of experience.

• At least 7 years of production Microsoft SQL Server DBA experience in enterprise-scale environments.

• Familiarity with SQL Server 2019/2022 in virtualized and high-availability setups.

• Advanced understanding of Always On Availability Groups, replication, log shipping, SQL Agent jobs, maintenance plans, and Ola Hallengren maintenance frameworks.

• Experience with AWS RDS databases such as PostgreSQL, Oracle, and Redshift.

• Proficient in SQL Server performance tuning using execution plans, DMVs, extended events, and wait statistics.

• Solid understanding of AWS VPC networking concepts, including subnets, routing, and security groups, as they pertain to database deployments.

• Experience with AWS EC2, Amazon RDS for SQL Server, AWS Backup, AWS IAM, AWS CloudWatch, CloudTrail, Systems Manager, Parameter Store, and AWS KMS.

• Strong knowledge of Windows Server, Active Directory, and Group Managed Service Accounts.

• Strong PowerShell scripting abilities for automation and administration tasks.

• Excellent written and verbal communication skills, capable of presenting to both technical and non-technical audiences, including leadership.

• Proven ability to work effectively in a remote setting and collaborate across distributed teams.

• Experience with Transact-SQL development and scripting.

🏝️ Benefits

• Medical insurance.

• Dental insurance.

• Vision insurance.

• Life insurance.

• Health savings account.

• Short-term disability.

• Long-term disability.

• Employee assistance program (EAP).

• Parental leave.

• 401(k).

• Paid time off (PTO) for vacation.

• Company-paid holidays.

• Potential eligibility for overtime.

• Shift differential eligibility.

• Discretionary bonus eligibility.