SQL Server DBA – Level 2 Milgard Services

4.0 - 6.0 years

5 - 9 Lacs

Pune

Work from Office

Department: IT Infrastructure / Database Administration Reports To: Lead System Administrator / IT Manager Job Summary: We are looking for an experienced SQL Server DBA Level 2 who will be responsible for managing, monitoring, maintaining, and supporting our SQL Server infrastructure, including high-availability environments, SQL OS-level setups, patching, and Azure Synapse workloads. The ideal candidate should also be proficient with Rubrik backup solutions, have a strong grasp of database performance monitoring, and be capable of operating independently in critical environments. Key Responsibilities: Database Administration: Install, configure, and maintain SQL Server instances across production, QA, and development. Manage database objects (schemas, indexes, views, stored procedures). Perform root cause analysis and troubleshoot incidents. SQL Server OS Installation & Patching: Perform Windows Server installation and configuration specific to SQL Server needs. Carry out SQL Server installation, instance setup, and feature configuration. Plan and apply SQL Server Cumulative Updates and Service Packs in accordance with compliance and change control. High Availability & Disaster Recovery: Configure and maintain Always On Availability Groups, Failover Cluster Instances (FCI), Log Shipping, and Database Mirroring. Regular testing and documentation of DR strategy and recovery procedures. Cloud & Azure Synapse: Manage and support Azure Synapse Analytics, Azure SQL Databases, and integration pipelines. Work with Azure Monitor, Alerts, and Performance Tuning in Synapse and SQL PaaS. Backup & Restore: Manage backups using Rubrik and native SQL Server tools. Perform scheduled restore tests and ensure backup compliance with RTO/RPO targets. Monitoring & Maintenance: Proactively monitor databases for performance, space, blocking, deadlocks, and long-running queries. Use tools like SentryOne, SolarWinds, SQL native DMVs, or equivalent. Automate maintenance tasks: index rebuilds, statistics updates, integrity checks. Security & Compliance: Maintain database security: roles, permissions, encryption, auditing. Ensure adherence to internal compliance and external audit requirements. Collaboration: Work closely with application and infra teams during releases, upgrades, and maintenance. Participate in on-call rotation and handle after-hours emergencies or patch windows. Required Skills & Experience: 5+ years of hands-on SQL Server DBA experience. Strong in SQL Server 2016/2019/2022 administration. Proven experience with OS-level installation and SQL Server patching. Working knowledge of Azure Synapse Analytics, Azure SQL services. Experience with Rubrik or other enterprise backup tools. Knowledge of PowerShell and T-SQL for automation and maintenance. Practical experience in HA/DR implementation. Exposure to performance tuning, database health checks, and space management. Preferred Qualifications: Microsoft Certified: Azure Database Administrator Associate or equivalent. Experience in hybrid cloud environments (on-prem + Azure). Knowledge of scripting in CI/CD environments using Git, DevOps, or Azure Repos. Work Conditions: Should Available during 2PM IST to 10PM IST and On-call rotation support as per schedule. Available for off-hours patching, upgrades, and DR testing as required The requirement is really very urgent. Please mark for immediate joiners

Posted 1 day ago

Apply

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.