SQL Dba-ci/cd Pipelining (Pune)

Job Title: SQL DBA Location: Pune Job Description: Key Responsibilities Database Administration - Install, configure, upgrade, and maintain Microsoft SQL Server (On-Prem & Azure). - Manage Azure SQL Database, Azure SQL Managed Instance, and SQL Server on Azure VMs. - Perform backup, restore, disaster recovery, and high availability (Always On, Failover Groups, Log Shipping). - Monitor database health, capacity, and performance. Performance & Optimization - Identify and resolve performance bottlenecks using execution plans, indexing strategies, and query tuning. - Optimize database schemas, stored procedures, and SQL queries. - Implement proactive monitoring and alerting. Azure & Cloud Responsibilities - Manage databases using Azure Portal, Azure Monitor, Log Analytics, and Azure Advisor. - Ensure security best practices using Azure AD authentication, TDE, Key Vault, and firewall rules. - Support scalability, cost optimization, and resource governance in Azure. CI/CD & DevOps Integration - Design and maintain CI/CD pipelines for database deployments using: - Azure DevOps Pipelines / GitHub Actions - PowerShell, T-SQL, Azure Devops, Octopus Deploy. - Automate schema changes, version control, and deployment approvals. - Work closely with development teams to enable Database DevOps (DBOps). - Implement rollback, validation, and release strategies for database changes. Security & Compliance - Manage user access, roles, and permissions. - Implement auditing, encryption, and compliance standards. - Support vulnerability assessments and security reviews. Collaboration & Support - Provide L3 support for production issues and root-cause analysis. - Create and maintain documentation, runbooks, and SOPs.Essentials Skills & Qualifications Technical Skills - Strong experience with Microsoft SQL Server (2016+) - Hands-on experience with Azure SQL services - Robust knowledge of: - T-SQL - Backup & Recovery - HA/DR solutions (Always On Availability Groups, Log Shipping) - In .