Senior DBA Engineer

This is a fully remote position, open to applicants in Arizona, +19 more states.

📋 Description

• Oversee the planning and implementation of SQL Server modernization on EC2.

• Transition to AWS RDS and/or perform upgrades from SQL Server 2016, including testing for compatibility and upgrades.

• Evaluate, migrate, and manage SSIS ETL packages and SSRS reports.

• Re-platform ETL and reporting to AWS-native solutions like AWS Glue and DMS, or choose to retain and upgrade them on SQL Server EC2.

• Facilitate database cost efficiency through instance right-sizing, Reserved Instance assessments, storage tiering, and reduction of licensing costs.

• Enhance the skills of the Hospice SQL DBA team in AWS database operations, RDS management, and cloud best practices.

• Implement database monitoring, alerting, and performance baselines utilizing Datadog and CloudWatch.

• Design and execute automated backup, restore, and disaster recovery protocols using AWS Backup.

• Conduct query optimization, index management, and capacity planning efforts.

• Work alongside DevOps on Terraform-driven RDS infrastructure automation.

• Ensure compliance with HITRUST E1 through encryption, access controls, and audit logging.

• Assist the Hospice application team with their database development requirements.

• Explore PostgreSQL and Aurora modernization possibilities for the 2027 roadmap.

⛳️ Requirements

• Over 8 years of experience in database administration.

• Extensive knowledge in Microsoft SQL Server (2016+) performance tuning, high availability, and disaster recovery strategies.

• Practical experience with SQL Server version upgrades and migrations past the end of support, including compatibility-level and upgrade testing.

• Strong hands-on familiarity with SSIS and SSRS.

• Experience in setting up, migrating, monitoring, and managing AWS RDS (SQL Server) in a Multi-AZ environment.

• Skilled in AWS-native ETL and data migration tools, including AWS DMS and AWS Glue, or possess a clear strategy for modernizing SSIS-based ETL in AWS.

• Experience in managing database migration projects.

• Solid understanding of backup/restore methods, point-in-time recovery, and cross-region replication techniques.

• Familiarity with Datadog, CloudWatch, and SQL Server DMVs.

• Proficient in T-SQL, stored procedures, and optimizing queries.

• Experience in working within regulated environments such as HIPAA, HITRUST, and SOC2.

• Preferred qualifications include experience with AWS Backup, AWS DMS, AWS Glue, Terraform, PostgreSQL, Aurora, Windows Server administration, AWS certifications, and mentoring.

• Applicants must have authorization to work for any employer within the U.S.

• Must reside in a qualifying U.S. state.

🏝️ Benefits

• Dental, vision, and a variety of group medical plans.

• 401(k) retirement savings plan.

• Group life insurance.

• Accidental death and dismemberment (AD&D) insurance.

• Flexible spending account (FSA) and health savings account (HSA).

• Commuter benefits.

• Employer-sponsored short-term (STD) and long-term disability (LTD) insurance.

• Supplemental life insurance for spouses.

• Legal insurance.

• Employee assistance program.

• Home health testing kits.

• Discounts on fertility medications.

• Flexible vacation time.

• Accrued paid sick leave.

• Ten paid holidays.

• Two floating holidays for full-time non-exempt employees.

• Eight weeks of paid parental leave for eligible employees.

• Additional paid weeks for the birthing parent.

• Four weeks of paid caregiver leave.

• Monthly Lifestyle Spending Account allowance.

• No travel is required.

• Visa sponsorship is not available.