DBA | Mumbai | Engineering

• Job requisition ID : 105050 

• Location: Hyderabad

• Entity: Deloitte Touche Tohmatsu India LLP 

Delivery Manager | Engineering, AI & Data – Engineering | Database Management

Location:  Mumbai/Hyderabad

The team

Engineering helps Reimagine and re-engineer mission-critical operations and processes; Leverage engineering-led design, deep industry knowledge, and AI and data-driven insights to transform the technology platforms at the heart of business.  

Working alongside team, we empower and drive mission-critical solutions whether we need to modernize existing systems or implement new technology products and platforms. Through innovation, we improve financial performance, accelerate new digital businesses and fuel growth. Learn more about Engineering, AI and Data

Your work profile

We are looking for a skilled Database Administrator (DBA) to manage and support enterprise-grade database platforms in on-premises environments. The candidate should have hands-on expertise in one or more of the following technologies: PostgreSQL (EDB), MongoDB (Enterprise), or Redis (Enterprise).

The role requires strong experience in clustering, High Availability (HA), and Disaster Recovery (DR), along with the ability to manage mission-critical production databases.

1.      General (Applicable to All DB Technologies)

Install, configure, and administer databases in on-premises data centers.

Ensure high availability, reliability, and performance of databases.

Implement and manage backup and recovery strategies.

Perform patching, upgrades, and lifecycle management.

Monitor database health, performance, and capacity planning.

Troubleshoot production issues and provide root cause analysis (RCA).

Implement and maintain security controls and access management.

Document SOPs, architecture diagrams, and operational procedures.

Collaborate with application, infrastructure, and DevOps teams.

2.      PostgreSQL Responsibilities

Manage PostgreSQL enterprise environments (community or enterprise variants).

Configure and support:

Streaming Replication

Logical Replication

Connection pooling (PgBouncer/Pgpool)

Implement HA solutions using tools such as:

EDB Cluster

RepMgr

Perform performance tuning (query optimization, indexing, vacuum tuning).

Manage large-scale databases with partitioning and advanced configurations.

3.      MongoDB Responsibilities

Administer MongoDB Enterprise deployments in on-prem setups.

Configure and manage:

Replica Sets (HA)

Sharded clusters (scalability)

Handle backup and recovery using MongoDB tools (Ops Manager/Cloud Manager or native tools).

Perform query optimization and indexing strategies.

Monitor cluster performance and manage balancer operations.

4.      Redis Responsibilities

Manage Redis Enterprise / Redis Cluster deployments.

Configure and maintain:

Redis Cluster (sharding)

Redis Sentinel (HA and failover)

Optimize Redis for low latency and high throughput workloads.

Manage persistence mechanisms (RDB, AOF).

Handle use cases like caching, session storage, and real-time data processing.

5.      HA / DR / Clustering Responsibilities (All Technologies)

Design and implement High Availability architectures for each database type.

Configure automatic failover and redundancy mechanisms.

Develop and maintain Disaster Recovery (DR) strategies:

Backup validation

DR drills and failover testing

Ensure compliance with RTO / RPO objectives.

Maintain multi-node clustered environments.

Key Skills Required

Education-Any Bachelors

General Requirements

4–10 years of DBA experience in on-premises environments.

Strong expertise in at least one of the following:

PostgreSQL

MongoDB (Enterprise)

Redis (Enterprise)

Solid understanding of:

Database architecture & internals

Performance tuning

Backup & recovery strategies

Experience in Linux/Unix environments.

Scripting/automation skills (Shell / Python).

Experience with monitoring tools (Prometheus, Grafana, etc.).

PostgreSQL Skill Requirements

Strong knowledge of:

Replication (Streaming & Logical)

HA tools (EDB Cluster, RepMgr, EFM etc.)

Experience in:

Query tuning and execution plans

Vacuum, autovacuum tuning

Partitioning and indexing strategies

MongoDB Skill Requirements

Hands-on experience with:

Replica Sets and Sharding

MongoDB Enterprise features

Knowledge of:

BSON structure and schema design

Performance tuning and indexing

Experience with MongoDB backup and monitoring tools

Redis Skill Requirements

Strong understanding of:

Redis Cluster and Sentinel

Data structures (key-value, hashes, lists, sets, etc.)

Experience with:

Persistence (RDB/AOF)

Memory management and eviction policies

Knowledge of Redis performance optimization techniques

HA / DR / Clustering Skills

Proven experience in:

Designing HA architectures

Implementing multi-node clusters

Managing failover and replication

Experience in DR planning, testing, and execution

Strong understanding of RTO, RPO, and business continuity