workday
Senior SQL Database Administrator
Zelis
USA
Full-time
Senior
Discovered 1 weeks ago
awsazureec2gitpostgresqlsql
Key Skills for This Role
awsazureec2gitpostgresqlsql
Full Job Posting
Key Responsibilities:
- · Engineer, administer, maintain, and support enterprise database platforms across AWS, Azure, and on-premises environments, including Microsoft SQL Server, PostgreSQL, Amazon Aurora PostgreSQL, Amazon RDS for PostgreSQL, Amazon RDS for SQL Server, SQL Server on Amazon EC2, Azure SQL Database, Azure SQL Managed Instance, and SQL Server on Azure Virtual Machines.
- · Perform hands-on database performance engineering, including query tuning, execution plan analysis, schema tuning, index design and optimization, statistics maintenance and analysis, stored procedure optimization, database configuration, and analysis of application data access patterns.
- · Troubleshoot and resolve production database issues involving performance degradation, blocking, deadlocks, locking, resource contention, CPU, memory, storage, connectivity, capacity, availability, and database configuration.
- · Perform hands-on migration and re-platforming of databases and applications from Microsoft SQL Server to PostgreSQL, Amazon Aurora PostgreSQL, and other strategic database platforms.
- · Execute database migration activities including discovery, compatibility assessment, schema conversion, data migration, remediation, testing, performance validation, cutover, rollback, and post-migration optimization.
- · Install, configure, patch, upgrade, and maintain SQL Server and PostgreSQL database environments while ensuring database platforms remain current, supportable, secure, and compliant with established standards.
- · Configure, maintain, test, and troubleshoot database high availability, backup and restore, disaster recovery, replication, resiliency, and recovery capabilities.
- · Implement and maintain database telemetry, observability, monitoring, and alerting using IDERA, AWS-native monitoring capabilities, and other database monitoring tools.
- · Analyze database telemetry and performance data to proactively identify query performance problems, capacity constraints, resource contention, configuration issues, and emerging operational risks.
- · Participate in 24x7 production support and on-call rotations, responding to database incidents, troubleshooting problems, restoring service, performing root cause analysis, and implementing corrective actions.
- · Develop and maintain automation and Infrastructure as Code (IaC) for database provisioning, configuration, deployment, maintenance, monitoring, patching, upgrades, and other repeatable database engineering activities.
- · Use Git, GitHub, CI/CD, VS Code or other IDEs, peer review, and version control to develop and maintain database scripts, SQL code, automation, Infrastructure as Code, and engineering assets.
- · Use AI-assisted engineering tools including ChatGPT, Claude, Microsoft Copilot, and GitHub Copilot to assist with SQL development, troubleshooting, performance analysis, scripting, automation, migrations, and documentation.
- · Work directly with application engineers to identify and remediate inefficient queries, database schemas, indexes, stored procedures, data access patterns, and other application-related causes of database performance problems.
- · Create and maintain accurate technical documentation within Confluence, enterprise wikis, or equivalent platforms, including database configurations, operational procedures, runbooks, troubleshooting procedures, migration documentation, upgrade procedures, and disaster recovery processes.
Qualifications:
- · Strong hands-on Microsoft SQL Server experience in business-critical production environments with demonstrated ability to independently diagnose and resolve complex database problems, including performance degradation, blocking, deadlocks, resource contention, failed jobs, availability issues, and production incidents.
- · Demonstrated database performance tuning expertise, including the ability to analyze execution plans, identify inefficient queries, tune T-SQL and stored procedures, design and optimize indexes, evaluate statistics and cardinality, troubleshoot locking and blocking, and identify schema or application data access patterns contributing to poor performance.
- · AWS experience is required, with hands-on production experience operating databases on Amazon RDS, Amazon Aurora, and/or Amazon EC2. Experience with PostgreSQL and Amazon Aurora PostgreSQL is strongly preferred.
- · Demonstrated experience performing database migrations, upgrades, or re-platforming, including assessment, schema and compatibility analysis, data migration, testing, performance validation, cutover, rollback, and post-migration troubleshooting. Experience migrating Microsoft SQL Server workloads to PostgreSQL or Amazon Aurora PostgreSQL is strongly preferred.
- · Demonstrated ability to automate database engineering and operational tasks using scripting and Infrastructure as Code rather than relying primarily on manual administration. Experience with Git, GitHub, CI/CD, APIs, command-line tooling, and modern development environments such as VS Code is expected.
- · Hands-on experience implementing and troubleshooting database monitoring, telemetry, backup and recovery, high availability, and disaster recovery. Experience using IDERA, AWS-native observability services, or comparable database monitoring platforms is preferred.
- · Experience with Microsoft Azure database platforms, including Azure SQL Database, Azure SQL Managed Instance, and SQL Server on Azure VMs, is preferred but not required. Experience using AI-assisted engineering tools such as ChatGPT, Claude, Microsoft Copilot, or GitHub Copilot to improve troubleshooting, scripting, automation, and engineering productivity is also preferred.
- Please note at this time we are unable to proceed with candidates who require visa sponsorship now or in the future.
- Location and Workplace Flexibility
- Zelis is headquartered in the U.S., with multiple locations across the country and in Hyderabad, India. Check out our locations to learn more about our offices. All employee work locations are based on the needs of the position and are determined by the Leadership team. In-office work and activities vary based on work and team objectives in accordance with Company policies.
- While location expectations vary by role, candidates within approximately 50 miles of a U.S. office are generally preferred to support collaboration when needed. Our hybrid approach is flexible, and in-office presence is guided by team and business needs rather than a fixed weekly schedule.
- Base Salary Range
- $105,000.00 - $133,000.00
- At Zelis we are committed to providing fair and equitable compensation packages. The base salary range allows us to make an offer that considers multiple individualized factors, including experience, education, qualifications, as well as job-related and industry-related knowledge and skills, etc. Base pay is just one part of our Total Rewards package, which may also include discretionary bonus plans, commissions, or other incentives depending on the role.
- Zelis’ full-time associates are eligible for a highly competitive benefits package as well, which demonstrates our commitment to our employees’ health, well-being, and financial protection. The US-based benefits include a 401k plan with employer match, flexible paid time off, holidays, parental leaves, life and disability insurance, and health benefits including medical, dental, vision, and prescription drug coverage.
- Equal Employment Opportunity Zelis is proud to be an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws. We welcome applicants from all backgrounds and encourage you to apply even if you don’t meet 100% of the qualifications for the role. We believe in the value of diverse perspectives and experiences and are committed to building an inclusive workplace for all.
- Accessibility Support We are dedicated to ensuring our application process is accessible to all candidates. If you are a qualified individual with a disability or a disabled veteran and require a reasonable accommodation with any part of the application and/or interview process, please email [email protected].
- Disclaimer
- The above statements are intended to describe the general nature and level of work being performed by people assigned to this classification. They are not to be construed as an exhaustive list of all responsibilities, duties, and skills required of personnel so classified. All personnel may be required to perform duties outside of their normal responsibilities, duties, and skills from time to time.
- · AWS experience is required, with hands-on production experience operating databases on Amazon RDS, Amazon Aurora, and/or Amazon EC2.
- Equal Employment Opportunity
- Zelis is proud to be an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.
- We welcome applicants from all backgrounds and encourage you to apply even if you don’t meet 100% of the qualifications for the role. We believe in the value of diverse perspectives and experiences and are committed to building an inclusive workplace for all.
- Accessibility Support
- We are dedicated to ensuring our application process is accessible to all candidates. If you are a qualified individual with a disability or a disabled veteran and require a reasonable accommodation with any part of the application and/or interview process, please email [email protected].
Preferred Qualifications
- Experience with PostgreSQL and Amazon Aurora PostgreSQL is strongly preferred.
- · Demonstrated experience performing database migrations, upgrades, or re-platforming, including assessment, schema and compatibility analysis, data migration, testing, performance validation, cutover, rollback, and post-migration troubleshooting. Experience migrating Microsoft SQL Server workloads to PostgreSQL or Amazon Aurora PostgreSQL is strongly preferred.
- · Hands-on experience implementing and troubleshooting database monitoring, telemetry, backup and recovery, high availability, and disaster recovery. Experience using IDERA, AWS-native observability services, or comparable database monitoring platforms is preferred.
- · Experience with Microsoft Azure database platforms, including Azure SQL Database, Azure SQL Managed Instance, and SQL Server on Azure VMs, is preferred but not required. Experience using AI-assisted engineering tools such as ChatGPT, Claude, Microsoft Copilot, or GitHub Copilot to improve troubleshooting, scripting, automation, and engineering productivity is also preferred.
- While location expectations vary by role, candidates within approximately 50 miles of a U.S. office are generally preferred to support collaboration when needed. Our hybrid approach is flexible, and in-office presence is guided by team and business needs rather than a fixed weekly schedule.
- At Zelis we are committed to providing fair and equitable compensation packages. The base salary range allows us to make an offer that considers multiple individualized factors, including experience, education, qualifications, as well as job-related and industry-related knowledge and skills, etc. Base pay is just one part of our Total Rewards package, which may also include discretionary bonus plans, commissions, or other incentives depending on the role.
About Zelis
Software & SaaS3000 employeesFounded 1995
Private healthcare financial technology company serving payers, providers, and healthcare consumers with claims, payment, and member-engagement solutions.
Visit company websiteJobs and hiring trendsApply for this job in 1 click
Skip the repetitive application forms
Install the Base Career Chrome Extension and autofill job applications across major job boards with your profile.
Trusted by over 500,000 job seekers on Base Career
More from this employer
More jobs at Zelis
IBR Reviwer
, IND
MidFull-time
Zelis is seeking an IBR Reviewer with knowledge of medical insurance and claims processes. The posting lists medical billing and coding, payer and reimbursement policies, and NCC coding guidelines and AHA Coding Clinic u
Discovered 3 days agoView →
Payee Services Representative
, IND
EntryFull-time
Zelis is seeking a representative to support healthcare providers with electronic insurance payments, enrollment, and portal access. The role handles provider calls, payment questions, registration, and basic troubleshoo
Discovered 3 days agoView →
Inside Sales Representative
Hyderabad, IND
Discovered 2 days agoFull-time
Technical Quality Engineering Leader
, USA
Discovered 2 days agoFull-time
Sr SCA Engineer
Hyderabad, IND
Discovered 3 days agoFull-time
Call Center Representative - Hybrid St Petersburg, FL
, USA
Discovered 3 days agoFull-time
Sr Software Engineering
Hyderabad, IND
Discovered 3 days agoFull-time
Senior AI Engineer
Hyderabad, IND
Discovered 3 days agoFull-time
IBR Reviwer
, IND
Discovered 3 days agoFull-time
Payee Services Representative
, IND
Discovered 3 days agoFull-time