Senior Project Consultant - Technology Strategy & Transformation (New Delhi)

Senior Project Consultant - Technology Strategy & Transformation (New Delhi)

19 Nov
|
EY
|
New Delhi

19 Nov

EY

New Delhi

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

📌 Senior Project Consultant - Technology Strategy & Transformation (New Delhi)
🏢 EY
📍 New Delhi

Reply to this offer

Impress this employer describing Your skills and abilities, fill out the form below and leave Your personal touch in the presentation letter.

Subscribe to this job alert:

Get the latest job offers by email for: senior project consultant - technology strategy & transformation (new delhi) / new delhi

Subscribe to this job alert:

Get the latest job offers by email for: senior project consultant - technology strategy & transformation (new delhi) / new delhi