Database Administrator

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 as well as other health-related entities across the United States. The Insight Research Portal — one of the client’s internal products — is a web-based application with more than 10,000 active users. It was developed for the entire research community to review, monitor, and manage the organization’s research portfolio. The main goal of Insight is to bring together distributed and complex organizational processes within a single application and help reduce administrative workload.

Who are we looking for?

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 Expertise: Strong understanding of the specifics, advantages, and operational differences between Azure SQL Managed Instance and standard SQL Server, including provisioning, management, and securing SQL Managed Iinstance environments. 
• Azure Data Factory Experience: Hands-on experience with Azure Data Factory in designing and implementing ETL processes.Familiarity with using ADF for data integration tasks, alongside or as an alternative to traditional SSIS, is desirable.
• SQL Server & Database Knowledge: Solid working knowledge of MS SQL Server and relational database concepts, with practical experience in T-SQL. Familiarity with SQL Server 2016 and 2019 is beneficial, while exposure to SQL Server 2022 is a plus. Includes experience supporting database design, development, maintenance, and troubleshooting performance-related issues.

• SSIS Expertise: Hands-on experience with SQL Server Integration Services, including a deep understanding of its capabilities and practical application in ETL processes within data integration workflows. 

• Familiarity with Azure DevOps Tools: Working knowledge of Azure Pipelines and Azure DevOps Releases, including how builds and deployments are orchestrated across environments. You don't need to be building pipelines from scratch here, but you should be comfortable navigating and understanding them. 

• General Azure Application Resources Knowledge: Understanding of provisioning, managing, and securing Azure application resources, with a focus on best practices for cloud-based applications. 

• Problem-Solving and Troubleshooting Skills: Strong ability to troubleshoot and resolve complex problems across database and application layers, with a methodical approach to issue resolution. 

• Experience in day-to-day communication with English speaking customers.
• Work Schedule Flexibility: Willingness to work in a rotating shift model,
• Including: 1st shift: 07:00 AM – 04:00 PM (EET), 2nd shift: 02:00 PM – 11:00 PM (EET), 3rd shift: 06:00 PM – 01:00 AM (EET). 

Nice to have: 

• Git and Code Management: Knowledge of Git for version control and experience with code management practices to ensure clean and maintainable codebases. 

• Additional Database Optimization: Experience with Query Store, Extended Events, and in-depth understanding of query optimization, procedure tuning, and index management for performance improvements. 

• Familiarity with Azure DevOps Tools: Working knowledge of Azure Pipelines and Azure DevOps Releases, including how builds and deployments are orchestrated across environments. You don’t need to be building pipelines from scratch here, but you should be comfortable navigating and understanding them.
• Azure DevOps Pipeline and Release Creation: Hands-on experience building and maintaining CI/CD pipelines in Azure DevOps, including application builds, pipeline security, and deployment strategies. Bonus points for experience with infrastructure as code using ARM templates or Terraform for Azure resource deployment. This goes beyond general familiarity — we're talking about actually creating and owning pipelines end to end. 

• Scripting and Automation Skills: Familiarity with PowerShell and JSON for scripting and automation tasks within Azure environments. 

What we offer

Work:

• Flexible working hours;
• Collaborative, friendly team environment;
• Remote/Hybrid work;

Life:

• Company social events;
• Annual corporate parties;

Health:

• Comprehensive medical insurance;

Education:

• Allowances for professional education;
• English language courses with native speakers;
• Internal knowledge-sharing sessions.