The Lead SQL Server DBA Engineer will manage SQL Server databases in both on-premises and Azure environments, focusing on configuration, optimization, security, and performance tuning. Responsibilities include designing automated workflows, ensuring compliance with standards, and providing expert troubleshooting for complex issues.
Job Title: Lead SQL Server with Azure
Location: Pune
Experience: 6+ Years
Type: Full-Time
Job Overview:
We are looking for an experienced and dynamic SQL Server DBA Engineer with Azure cloud technologies to join our team. This will include database management with a strong focus on best practices and process improvements in SQL Server database administration and cloud adoption.
Key Responsibilities:
- Oversee the administration, configuration, optimization, and maintenance of SQL Server databases across on-premises and Azure environments.
- Manage database performance, tuning, query optimization, and capacity planning to ensure top-tier performance across both on-premises and cloud systems.
- Take ownership of database security, including access control, encryption, and compliance with regulatory standards.
- Design and implement automated database management workflows and monitoring solutions using PowerShell, Azure Automation, and third-party tools.
- Perform regular audits and reviews to ensure SQL Server and Azure databases adhere to best practices, security standards, and industry compliance regulations.
- Act as the escalation point for complex technical issues, providing expert-level troubleshooting and resolution for production issues and incidents.
Skills and Qualifications:
- 6+ years of experience in SQL Server database administration or support.
- In-depth expertise with MS SQL Server databases, including performance tuning, optimization, backups, high availability, and disaster recovery.
- Strong hands-on experience with Azure SQL Database, Azure SQL Managed Instance, Azure Virtual Machines (SQL Server on VMs), and Azure Data Services.
- Experience with tools like Dynatrace and Rubrik.
- Experience in DB migration from SQL server 2008/2012 to SQL Server 2022/2019 and Azure PaaS.
- Experience in designing and implementing high-availability and disaster recovery solutions using technologies such as Always On Availability Groups, Log Shipping, and Azure-native, Replication options.
- Strong knowledge of PowerShell and Azure Automation for automating routine DBA tasks, database monitoring, and maintenance.
- Experience in managing and optimizing ETL processes using tools like Azure Data Factory and SSIS.
- Familiarity with Azure DevOps, CI/CD processes for database deployments, and infrastructure as code (IaC).
- Deep understanding of database security, compliance (GDPR, HIPAA, PCI-DSS), and industry best practices.
Preferred Qualifications:
- Microsoft Certified: Azure Database Administrator Associate or similar certifications.
Top Skills
Azure
Azure Automation
Azure Data Factory
Azure Data Services
Azure Devops
Azure Sql Database
Azure Sql Managed Instance
Azure Virtual Machines
Dynatrace
Powershell
Rubrik
SQL Server
Ssis
Similar Jobs
News + Entertainment
As an Angular Tech Lead, you will manage a cross-functional team to deliver high-quality technical solutions. Responsibilities include leading design reviews, tracking delivery metrics, mentoring team members, participating in recruitment, and ensuring alignment with business goals while applying Agile practices.
Top Skills:
.NetAgile DevelopmentAIAngularAPIsCi/CdCloud ComputingJavaMachine LearningMicroservices
Other • Security
Responsible for designing security systems including Access Control, Intruder Alarms, and CCTV, reviewing technical specifications, preparing documentation, coordinating with stakeholders, and ensuring project deliverables meet quality standards and KPIs. Requires strong project ownership and technical knowledge in security system engineering.
Software
The Lead ServiceNow Developer will design and implement ServiceNow solutions, lead development teams, and ensure alignment with business objectives. Responsibilities include creating custom applications, collaborating with clients, providing technical guidance, and assessing existing implementations for improvements.
What you need to know about the Hyderabad Tech Scene
Because of its proximity to leading research institutions and a government committed to the city's growth, Hyderabad's tech scene is booming. With plans to establish India's first "AI city," the city is on track to become one of the world's most anticipated tech hubs, with companies like TransUnion, Schrödinger and Freshworks, among others, already calling the city home.
