Job Description
Company: EY
Location: Bengaluru, Karnataka, India
Workplace Type: On-site
Employment Type: Full-time
About the Role
As part of the EY-GDS Data and Analytics team, this role focuses on defining, designing, and architecting enterprise-scale, highly available, and secure PostgreSQL solutions for complex client business challenges across various industries.
What You’ll Do / Key Responsibilities
- Define enterprise PostgreSQL architecture, standards, and reference patterns.
- Design database topology, including clusters, partitioning, replication, and workload isolation.
- Establish HA/DR architecture, replication strategy, failover patterns, and RTO/RPO targets.
- Define security standards, including RBAC and Row-Level Security (RLS).
- Establish standards for query optimization, indexing, connection management, and performance tuning.
- Drive Infrastructure-as-Code and automated database deployment practices integrated with CI/CD.
- Define enterprise monitoring for database availability, replication, and resource utilization.
Requirements & Qualifications
- 10+ years of database engineering/architecture experience with significant PostgreSQL experience.
- Strong hands-on expertise with PostgreSQL architecture and internals.
- Experience designing enterprise-scale, highly available PostgreSQL environments (HA/DR).
- Deep understanding of PostgreSQL roles and privileges, RLS, Indexing, and Execution plans.
- Knowledge of cloud-hosted PostgreSQL platforms (Azure Database for PostgreSQL, AWS RDS/Aurora PostgreSQL).
- Experience with CI/CD, Infrastructure-as-Code, and automated database migrations.
- Experience implementing enterprise RBAC/RLS authorization models and managing encryption/secrets.
Preferred / Bonus Qualifications (if applicable)
- Client management skills
- Experience with Kafka/event streaming and event-driven data synchronization.
Benefits & Perks (if applicable)
- Support, coaching and feedback from engaging colleagues.
- Opportunities to develop new skills and progress career.
- Freedom and flexibility in handling the role.
EY is committed to the principle of equal employment opportunity for all employees and to providing employees with a work environment free of discrimination and harassment. Diversity, inclusiveness and respect for all employees form the basis of our culture.