DATABASES-Architecture & Design-Azure SQL
Posted
Summary
A technical lead role owning Microsoft SQL Server / Azure SQL databases in Pune: administering instances across Dev, QA, UAT and Production, handling installs, patching, backups and disaster recovery, and tuning performance with Always On Availability Groups, replication, clustering and log shipping.
The candidate will serve as the technical lead for database services, ensuring high availability, performance, security, and reliability of mission-critical applications and databases.
The ideal candidate should possess strong experience in enterprise SQL database environments, working closely with application teams, infrastructure teams, architects, and business stakeholders to deliver scalable and efficient database solutions.
- Manage and administer Microsoft SQL Server databases across Development, QA, UAT, and Production environments.
- Ensure database availability, performance, integrity, and security.
- Perform installation, configuration, upgrades, and patching of SQL Server instances.
- Monitor database health and proactively address capacity and performance issues.
- Implement and maintain backup, recovery, and disaster recovery solutions.
- Analyze and optimize complex SQL queries, stored procedures, functions, and triggers.
- Identify performance bottlenecks using execution plans, indexing strategies, and SQL Profiler
- Manage SQL Server Always On Availability Groups.
- Configure and support database replication, clustering, and log shipping.
- Ensure business continuity and database resiliency.
- Incident & Problem Management
- Automation & Process Improvement
- Governance & Security
BE/B Tech