MS SQL Server

Required Skills Strong hands-on experience in Microsoft SQL Server Administration. Experience with SQL Server 2016/2019/2022 environments. Expertise in: Database Installation & Configuration Backup & Recovery Database Performance Tuning Query Optimization Index Management High Availability & Disaster Recovery Security Management Capacity Planning Strong knowledge of T-SQL scripting and troubleshooting. Experience with SQL Server Agent, SSMS, Profiler, Extended Events, and Performance Monitoring tools. Knowledge of Windows Server administration fundamentals. Experience in incident, problem, and change management processes. Preferred Skills Exposure to Azure SQL Database, Azure Managed Instance, or cloud database platforms. Experience with database monitoring tools such as Redgate, SolarWinds DPA, SentryOne, or similar solutions. Knowledge of PowerShell scripting and automation. Understanding of DevOps and CI/CD database deployment practices. ITIL Foundation certification (preferred).

Key Responsibilities Administer, monitor, and maintain Microsoft SQL Server databases across development, test, and production environments. Perform database installation, configuration, upgrades, patching, and migrations. Implement and manage backup, recovery, and disaster recovery procedures. Monitor database health, performance, and availability and proactively address issues. Optimize database performance through query tuning, indexing, and resource management. Configure and manage High Availability (HA) and Disaster Recovery (DR) solutions such as: Always On Availability Groups Database Mirroring Log Shipping Replication Failover Clustering Manage database security, user access, roles, permissions, and compliance requirements. Troubleshoot database-related incidents and provide L2/L3 support. Support application teams during deployments, releases, and database changes. Automate routine administrative tasks using PowerShell, T-SQL, or SQL Agent Jobs. Create and maintain operational documentation, SOPs, and knowledge articles.

Experience 2-4 years of relevant experience in MS SQL Server Database Administration. Experience supporting production database environments with high availability requirements. Educational Qualification Bachelor's Degree in Computer Science, Information Technology, Engineering, or related field. Soft Skills Strong analytical and troubleshooting abilities. Good communication and stakeholder management skills. Ability to work in a fast-paced production support environment. Strong ownership and customer-centric mindset. Ability to work in shifts and participate in on-call support when required. Primary Skill: Technology | Database Administration | MS SQL Server Job Level: JL3 Locations: Bangalore (BLR), Chennai (CHN), Pune (PUNE) Experience Range: 2–4 Years