Job description

Be part of a team that unleashes the power of leading-edge technologies to help improve the health and well-being of those most vulnerable in our country and communities. Working at Gainwell carries its rewards. You'll have an incredible opportunity to grow your career in a company that values work flexibility, learning, and career development. You'll add to your technical credentials and certifications while enjoying a generous, flexible vacation policy and educational assistance. We also have comprehensive leadership and technical development academies to help build your skills and capabilities. Summary As an Advisor-level SQL Server DBA, you will serve as a trusted technical expert, providing leadership in the design, architecture, and optimization of enterprise-grade SQL Server environments across on-premises, AWS, and Azure platforms. You will be responsible for ensuring the performance, scalability, and reliability of mission-critical databases while contributing to data modeling, design, observability, and automation initiatives. This role includes performance tuning, architecture reviews, mentoring, and on-call production support. Your role in our mission • Lead database design and data modeling efforts, translating business requirements into logical and physical database structures. • Define and enforce data standards, normalization, indexing, and partitioning strategies to support scalability and performance. • Architect, implement, and maintain SQL Server environments, including AlwaysOn Availability Groups, clustering, and replication. • Manage and optimize SSRS and SSIS solutions, ensuring high-performance reporting and ETL workflows. • Implement observability and monitoring solutions (Dynatrace, New Relic, Prometheus, CloudWatch, Azure Monitor) for proactive database insights. • Conduct advanced performance tuning (query optimization, execution plans, indexing, workload analysis). • Develop and maintain backup, restore, and disaster recovery strategies, leveraging both native SQL backups and AWS/Azure snapshots. • Collaborate with development and architecture teams to provide database best practices and schema design guidance. • Automate recurring tasks using PowerShell, T-SQL, and DevOps/IaC tools. • Serve as a mentor to junior DBAs, providing technical leadership and fostering knowledge-sharing. • Participate in 24/7 on-call rotation to support critical production environments. What we're looking for • 10+ years of SQL Server DBA experience with proven expertise in database design, modeling, and administration. • Strong background in logical and physical data modeling, schema design, and relational architecture. • Hands-on experience with AWS RDS for SQL Server, Azure SQL Database, and hybrid architectures. • Experience in cloud migration strategies and modern database architectures. • Strong skills in backup, restore, HA/DR, and compliance controls. • Scripting proficiency with PowerShell and T-SQL; exposure to DevOps/IaC preferred. What you should expect in this role • Remote work opportunity within US. • Video cameras must be used during all interviews, as well as during the initial week of orientation. • Participation in production on-call rotations to ensure 24/7 system availability. • Opportunity to influence enterprise data architecture, observability practices, and modernization efforts. • Support for certifications, continuous learning. • The Deadline to submit applications for this posting is October 21, 2025. The pay range for this position is $88,900.00 - $127,000.00 per year, however, the base pay offered may vary depending on geographic region, internal equity, job-related knowledge, skills, and experience among other factors. Put your passion to work at Gainwell. You'll have the opportunity to grow your career in a company that values work flexibility, learning, and career development. All salaried, full-time candidates are eligible for our generous, flexible vacation policy, a 401(k) employer match, comprehensive health benefits , and educational assistance. We also have a variety of leadership and technical development academies to help build your skills and capabilities. We believe nothing is impossible when you bring together people who care deeply about making healthcare work better for everyone. Build your career with Gainwell, an industry leader. You'll be joining a company where collaboration, innovation, and inclusion fuel our growth. Learn more about Gainwell at our company website and visit our Careers site for all available job role openings. Gainwell Technologies is an Equal Opportunity Employer, where all qualified applicants will receive consideration for employment without regard to race, religion, color, national origin, gender (including pregnancy, childbirth, or related medical condition), age, sexual orientation, status as a protected veteran, status as an individual with a disability, or other applicable legally protected characteristics.

Requirements