Insight Global is seeking an experienced Senior SQL DBA to support a large-scale data migration initiative. The company is currently transitioning its data platform from Microsoft SQL Server to Azure Databricks, consolidating Microsoft-based databases to a cloud-native environment. This role will focus on managing, optimizing, and ensuring the overall health, performance, and security of SQL databases.
As a Senior SQL DBA, you will play a critical role in maintaining high availability (HA) and disaster recovery (DR) solutions, tuning SQL performance, and implementing ETL workflows using SSIS. The ideal candidate should have a strong hands-on background in SQL Server administration and experience working with cloud environments, particularly Azure Virtual Machines. You will also contribute to scripting and automation efforts using PowerShell and Python.
This is a highly technical and strategic position that will require collaboration with data engineers, developers, and cloud architects to ensure database integrity, performance, and security. If you're looking for a challenging role where you can make an impact while working remotely, this opportunity is for you!
Key Responsibilities
Database Administration & Optimization
- Manage and optimize SQL Server databases to ensure high availability, security, and peak performance.
- Implement Query Optimization & Index Management strategies for Online Transaction Processing (OLTP) systems.
- Monitor database performance using SolarWinds, proactively identifying and resolving bottlenecks.
ETL & Reporting
- Design, develop, and maintain ETL workflows using SQL Server Integration Services (SSIS) to streamline data ingestion and transformation processes.
- Utilize SQL Server Reporting Services (SSRS) to generate and manage business-critical reports.
Automation & Scripting
- Develop PowerShell and/or Python scripts to automate routine database administration tasks.
- Implement process improvements and workflow automation to enhance operational efficiency.
High Availability & Disaster Recovery (HA/DR)
- Configure and maintain SQL Server Failover Clustering and Always On Availability Groups for HA/DR solutions.
- Develop backup and recovery strategies to prevent data loss and ensure business continuity.
Cloud Database Administration (Azure)
- Manage SQL Servers running on Azure Virtual Machines, ensuring seamless cloud integration.
- Support the ongoing migration from on-prem SQL databases to Azure Databricks.
Support & Collaboration
- Work closely with data engineers, DevOps teams, and cloud architects to align database strategies with business goals.
- Provide after-hours support when necessary, ensuring uninterrupted database availability.
Required Skills & Experience
- 5+ years of hands-on experience as a SQL Database Administrator (DBA)
- Extensive experience with SQL Server Integration Services (SSIS) for ETL, data cleansing, and workflow automation.
- Strong proficiency in SQL Server Reporting Services (SSRS) for report generation and management.
- Experience using SolarWinds for database monitoring, troubleshooting, and performance tuning.
- Proficiency in PowerShell and/or Python scripting to automate database maintenance and management.
- Hands-on experience managing SQL Servers on Azure Virtual Machines.
- Deep understanding of Online Transaction Processing (OLTP) optimization, including query tuning and indexing strategies.
- Expertise in High Availability & Disaster Recovery solutions, including SQL Server Failover Clustering and Always On Availability Groups.
- Willingness to work PST hours and provide occasional after-hours support when required.
Preferred/Bonus Skills
- Azure Databricks experience. Prior exposure to migrating databases from SQL Server to Azure Databricks is a huge plus.
- NoSQL & Graph Databases. Experience working with MongoDB and Neo4j is beneficial.
- Microsoft Purview. Knowledge of data governance and compliance frameworks using Microsoft Purview.
Why Join Us?
- Exciting Data Migration Project. Be part of a major transformation initiative shifting from SQL Server to Azure Databricks.
- Remote Work Flexibility. Work from anywhere while supporting a high-impact cloud-based database infrastructure.
- Growth & Learning. Work alongside top-tier data engineers, architects, and DevOps teams in a cutting-edge cloud environment.
- Competitive Pay. Earn between ?15-18 LPA with the potential for contract extension based on performance.
If you’re a highly skilled SQL DBA with experience in cloud-based database administration and Azure migration projects, we’d love to hear from you!