…

MS SQL Server

Infosys · IT Services & Consulting

  • Bangalore, India
  • On-site
  • Posted 13 days ago
  • IT & Infrastructure

About the job

Role: MS SQL Server Database Administrator

Level: JL3

Locations: Bangalore (BLR), Chennai (CHN), Pune (PUNE)

Job Summary

We are looking for a skilled MS SQL Server Database Administrator (DBA) to manage, maintain, optimize, and support mission-critical SQL Server database environments. The ideal candidate should have hands-on experience in database administration, performance tuning, backup and recovery, high availability, and production support in enterprise environments.

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.

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

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

Educational requirements

Bachelor of Engineering

Preferred skills

Technology->Cloud Platform->Databases on Azure->Azure Managed Instance for Apache Cassandra,Technology->Database->Microsoft SQL Server,Technology->DevOps->DevOps Architecture Consultancy,Technology->Mainframe Technologies->CICS

Experience: 2-4 years