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
What We Do
At Johnson Controls, we transform the environments where people live, work, learn and play. From optimizing building performance to improving safety and enhancing comfort, we drive the outcomes that matter most. Dedicated to protecting the environment, we deliver our promise in industries such as healthcare, education, data centers and manufacturing. With a global team of 100,000 experts in more than 150 countries and over 130 years of innovation, we are the power behind our customers’ mission.
Our leading portfolio of building technology and solutions includes some of the most trusted names in the industry, such as Tyco®, York®, Metasys®, Ruskin®, Titus®, Frick®, Penn®, Sabroe®, Simplex®, Ansul® and Grinnell®.
