DELHI · FULLTIME
Senior Project Consultant - Technology Strategy & Transformation
Ernst Young
Delhi · onsite · Posted 4d ago
Sourced from
Undisclosed4–7 yrsfulltimeDelhi
Your match
?
Sign in to see your match score, skill gaps & tailored resume.
Section · 01
About this role
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.
- 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.
- 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.
- 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.
- Implement enterprise-grade monitoring using Prometheus/Grafana, pgAdmin, Nagios, or equivalent.
- Define alerting, dashboards, and audit logging for runtime health, anomalies, and capacity usage.
- 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.
- 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.
- Experience with PostgreSQL extensions: PostGIS, pgPool-II, TimescaleDB, Citus, FDWs.
- Exposure to Kubernetes, Helm, Operators, and containerized database deployments.
Sourced from naukri
Let the agent run this one for you.
Tailored resume, auto-apply, and referral lookup — in under 2 minutes.
Section · 02
Skills
Business ConsultingAutomationBashAgileAuditingCI/CD Pipelinesbusiness modelscheckpointBuild AutomationDatabase AdministratorDatabase ArchitectureAsynchronousArchitectureAdministrationcomplianceData ModelingAnsible
Section · Company
About Ernst & Young
Ernst Young
Management Consulting
44k+
employees
2002
24 years old
Gurgaon / Gurugram, Haryana
India
₹15.3L PA avg
Avg at Ernst & Young
About
At EY, our purpose is Building a better working world. The insights and quality services we provide help build trust and confidence in the capital markets and in economies the world over.
Industries
Management Consulting
Employee ratings
10 reviews
3.4/ 5
Culture
1.9
Career growth
2.3
Work-life
2.5
Employees rate it well for
Job Security36Skill Development35
Find them on