Ms Sql Database Administrator

Idbi Intech; Navi Mumbai; On-site; INR 800,000 - 1,400,000; Full time

Job summary

Idbi Intech is seeking a skilled MSSQL DBA (L2) to manage and maintain MSSQL databases in a banking environment. This role is based in Belapur and requires on-site work.

You will install, configure, monitor, and optimize SQL Server instances, implement High Availability, and manage backups. Candidates should have 3+ years of experience with SQL Server, strong T-SQL skills, and a focus on security, performance, and reliability.

Qualifications

• 3+ years of experience as MSSQL DBA in a banking domain.
• Experience installing, configuring and managing SQL Server instances.
• Strong knowledge of High Availability and backup strategies.
• Good understanding of security, auditing and compliance requirements.

Responsibilities

• Install and configure SQL Server instances across environments.
• Set up clustering, replication and Always On availability groups.
• Perform routine health checks, index maintenance and statistics updates.
• Monitor growth, manage storage and optimize performance.
• Manage user accounts, roles and permissions; implement encryption and auditing.
• Design and implement backup strategies and DR drills.
• Troubleshoot blocking, deadlocks and failed jobs with developers.
• Plan upgrades and migrations to newer SQL Server versions.
• Work with SSIS/SSRS/SSAS for reporting and analytics.

Skills

MSSQL

SQL Server

T-SQL

AlwaysOn/HA

Index Maintenance

Education

Any IT Graduate

Tools

SSIS

SSRS

SSAS

Azure SQL

AWS RDS

Job description

Dear candidates,

We are looking for a skilled MSSQL DBA (L2) with a strong background in managing and maintaining MSSQL databases in a banking domain.

Location: Belapur (WFO)
Experience: 3+ Years
Qualification: ANY IT Graduate

Job Description:

Installation & Configuration

• Install and configure SQL Server instances across environments (development, test, production).
• Set up clustering, replication, and Always On availability groups for high availability.

Database Maintenance

• Perform routine health checks, index maintenance, and statistics updates.
• Monitor database growth and manage storage effectively.

Performance Tuning

• Analyze query execution plans and optimize SQL queries.
• Configure server settings and indexes to improve performance.

Security & Compliance

• Manage user accounts, roles, and permissions.
• Implement encryption, auditing, and compliance policies (GDPR, HIPAA, etc.).

Backup & Recovery

• Design and implement backup strategies (full, differential, transaction log).
• Perform disaster recovery drills and ensure recovery time objectives (RTO) are met.

Troubleshooting

• Diagnose and resolve blocking, deadlocks, and failed jobs.
• Work with developers to debug stored procedures and optimize schema design.

Upgrades & Migrations

• Plan and execute upgrades to newer SQL Server versions.
• Migrate databases between servers or cloud platforms (Azure SQL, AWS RDS).

SSRS & SSIS

• Strong knowledge of T-SQL, SSIS, SSRS, SSAS.
• Problem-solving and analytical thinking.

Risks & Challenges

• Communication and collaboration with cross-functional teams.
• Ability to work under pressure during outages or performance issues.