MS SQL Server

Responsibilities

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.

Additional Responsibilities

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

Technical and Professional Requirements

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).

Preferred Skills

• Azure Managed Instance for Apache Cassandra
• Microsoft SQL Server
• DevOps Architecture Consultancy
• CICS

Educational Requirements

Bachelor of Engineering