Database Administrator Offline

About the Role 

We're looking for an experienced Database Administrator to join our team and bring depth to our cloud database operations. You'll own the administration and maintenance of production and pre-production database environments running on Azure SQL Managed Instance, with real opportunities to expand your skill set into DevOps pipelines, release management, and infrastructure automation. 

About the Project
Our client operates community and specialty hospitals, a managed care organization, a physician network, community health centers, and home care and other health-related entities in the United States. The Research Portal — one of the internal products — is a web-based application with over 10,000 current users developed for the entire research community to review, monitor, and manage research portfolio. The main goal is to unite distributed and complex organizational processes into one application and help alleviate administrative burdens. 

Responsibilities:  

• Serve as the go-to expert for Azure SQL Managed Instance and Azure Data Factory across all production and pre-production environments, keeping things running smoothly and jumping in when they don't. 
• Provide Tier 2/3 troubleshooting support, diagnosing and resolving database and application issues in real time so the team and end users aren't left waiting. 
• Own query optimization and index tuning/maintenance to keep database performance tight, including proactive analysis to catch problems before they become incidents. 
• Manage and maintain high-availability configurations including Log Shipping, Always-On Availability Groups, and Backup/Restore with Point-in-Time Recovery (PITR). 
• Design and maintain ADF pipelines for ETL data integration, working toward modern, cloud-first patterns and phasing out legacy SSIS where possible. 
• Grow into adjacent areas like Azure DevOps pipeline management, release management, and repo management — this role has room to expand well beyond traditional DBA work. 
• Research and evaluate new technologies and approaches for building highly available data persistence systems, and bring those ideas back to the team. 

Skills & Experience: 

• Azure SQL Managed Instance: Good understanding of its architecture, management, and key differences from standard SQL Server
• SQL Server & T-SQL: Solid working knowledge of relational databases, query writing, and performance basics
• Azure Data Factory / SSIS: Experience with ETL processes and data integration workflows
• General Azure Knowledge: Familiarity with Azure application resources and best practices
• Troubleshooting: Ability to analyze and resolve database and application issues in a structured way
• Communication: Comfortable working with English-speaking teams
• Work Schedule: Willingness to participate in a rotating shift model

Nice to have: 

• Experience with performance tuning tools (Query Store, Extended Events, indexing, etc.)
• Familiarity with Azure DevOps pipelines and release processes (at a working level)
• Basic scripting skills (PowerShell, JSON)
• Experience with Git or code management practices