Senior Project Consultant - Technology Strategy & Transformation

EY; New Delhi; On-site; INR 4,000,000 - 7,000,000; Full time

Job summary

EY is seeking a Senior PostgreSQL Database Administrator to architect, implement, and optimize PostgreSQL databases in large-scale production environments. You will lead architectural decisions, define standards for schema, indexing, partitioning, and storage, and guide replication, backups, DR, and security strategies.

Collaboration with DevOps, engineering, and product teams is essential. The role requires deep PostgreSQL expertise, strong Linux skills, and proficiency in scripting and

Qualifications

• 610 years of hands-on PostgreSQL DBA experience in production environments.
• Expertise in PostgreSQL internals, WAL, MVCC, autovacuum, and tuning.
• Experience with high availability, replication, and disaster recovery.
• Strong Linux administration and scripting skills.
• Security, encryption, IAM, and access control knowledge.

Responsibilities

• Lead design and implementation of high-performance PostgreSQL architectures.
• Set standards for schema design, indexing, partitioning, sharding, and storage.
• Manage backup, restore, and DR strategies; ensure security and compliance.
• Monitor, optimize, and troubleshoot performance; resolve locks and lag.
• Collaborate with DevOps to integrate PostgreSQL into CI/CD and IaC.
• Mentor junior DBAs; participate in on-call rotations and RCA.

Skills

PostgreSQL DBA

Database performance tuning

HA/DR architectures

Replication topologies

Linux administration

Scripting (Shell/Python/Bash)

Security & encryption

Query optimization

Monitoring/Observability

Tools

pgBackRest

Barman

Prometheus/Grafana

pgAdmin

Kubernetes/Containers

Job description

Job Summary

We are seeking a highly skilled Senior PostgreSQL Database Administrator with 610 years of strong experience in architecting, implementing, and optimizing PostgreSQL databases in large-scale, mission-critical environments. The ideal candidate will serve as a subject matter expert for PostgreSQL, lead database initiatives, ensure high availability, and collaborate with engineering, architecture, DevOps, and product teams.

Key Responsibilities Database Architecture & Design

• Lead the design and implementation of high-performance PostgreSQL database architectures.
• Define standards for schema design, indexing strategy, data partitioning, sharding, and storage optimization.
• Provide technical guidance for database scalability, capacity planning, and data growth strategy.

Administration & Operations

• Install, configure, patch, and maintain PostgreSQL instances across production and non-production environments.
• Set up and manage replication architectures (streaming, logical, cascading, synchronous/asynchronous).
• Implement and manage robust backup and disaster recovery strategies using pgBackRest, Barman, or enterprise tools.
• Ensure database security, compliance, auditing, and encryption best practices.

Performance Tuning & Troubleshooting

• Lead deepdive analysis of performance issues using EXPLAIN/ANALYZE, pg_stat views, autovacuum tuning, and indexing improvements.
• Investigate and resolve locking issues, deadlocks, replication lag, and query bottlenecks.
• Drive proactive database health checks and optimization strategies.

Automation & DevOps Integration

• Build automation for database provisioning, monitoring, backup, failover, and upgrades using Ansible, Python, Shell, etc.
• Collaborate with DevOps teams to integrate PostgreSQL into CI/CD pipelines and InfrastructureasCode frameworks.
• Create scripts and tools to streamline operations in large, distributed environments.

Monitoring & Observability

• Implement enterprise-grade monitoring using Prometheus/Grafana, pgAdmin, Nagios, or equivalent.
• Define alerting, dashboards, and audit logging for runtime health, anomalies, and capacity usage.

Collaboration & Leadership

• Partner with development teams for query optimization, schema changes, and data modeling.
• Mentor junior DBAs and guide cross-functional teams on best practices.
• Participate in on-call rotations, incident management, and root cause analysis.
• Drive PostgreSQL roadmap discussions, version upgrades, and technology evaluations.

Required Skills

• 610 years of solid hands‑on experience as a PostgreSQL DBA in production environments.
• Strong expertise in PostgreSQL internals, architecture, WAL, MVCC, autovacuum, and checkpoint tuning.
• Deep knowledge of performance tuning, index optimization, and query execution plans.
• Proven experience with HA/DR solutions, replication topologies, and failover strategies.
• Strong command of Linux administration (RHEL/Ubuntu).
• Excellent scripting in Shell, Python, or Bash.
• Knowledge of security practices, SSL/TLS, IAM, roles/privileges, and encryption mechanisms.

Good-to-Have Skills

• Experience with PostgreSQL extensions: PostGIS, pgPool-II, TimescaleDB, Citus, FDWs.
• Exposure to Kubernetes, Helm, Operators, and containerized database deployments.