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).
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.
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.
Primary Skill: Technology | Database Administration | MS SQL Server
Job Level: JL3
Locations: Bangalore (BLR), Chennai (CHN), Pune (PUNE)
Experience Range: 2–4 Years
Experience 2-4 years of relevant experience in MS SQL Server Database Administration.
Experience supporting production database environments with high availability requirements.