Ernst and Young

EY - GDS Consulting - AI And DATA -Postgress Architect- Gig

Ernst and Young
Apply
23 hours ago
Bengaluru, IndiaStaff+

Responsibilities

  • Define enterprise PostgreSQL architecture, standards, reference patterns, database topology, partitioning, replication, and workload-isolation strategies.
  • Design and validate high-availability, disaster-recovery, backup, recovery, failover, RTO/RPO, and resilience practices.
  • Establish PostgreSQL authentication, authorization, RBAC, Row-Level Security, encryption, secrets-management, auditing, and least-privilege standards.
  • Set standards for query optimization, indexing, connection management, memory configuration, database statistics, performance baselines, monitoring, and capacity management.
  • Review logical and physical data models and define standards for schemas, keys, constraints, data types, referential integrity, retention, archival, and lifecycle management.
  • Establish PostgreSQL provisioning, configuration, patching, upgrade, migration, schema-versioning, Infrastructure-as-Code, and automated deployment practices.
  • Define database observability, dashboards, alerts, logging, troubleshooting, production-support, incident analysis, runbooks, and production-readiness criteria.
  • Lead architecture and design reviews, define reusable enterprise patterns and guardrails, identify technical risks, and mentor PostgreSQL engineers and DBAs.

Requirements

  • 10+ years of database engineering or architecture experience with significant PostgreSQL experience.
  • Strong hands-on expertise with PostgreSQL architecture and internals, including roles and privileges, Row-Level Security, indexing, execution plans, partitioning, replication, backup and recovery, connection management, vacuum/autovacuum, maintenance, and performance tuning.
  • Strong SQL and relational database design experience, including enterprise-scale, highly available PostgreSQL environments.
  • Experience with HA/DR, large-scale enterprise production systems, high-volume API and read-intensive workloads, and multi-environment architectures.
  • Experience with Azure Database for PostgreSQL, AWS RDS/Aurora PostgreSQL, or equivalent managed PostgreSQL services.
  • Experience with CI/CD, Infrastructure-as-Code, database migrations, automated deployments, enterprise identity, encryption, secrets management, auditing, and PostgreSQL monitoring or observability platforms.
  • Understanding of microservices, APIs, event-driven architecture, CQRS/read-model patterns, Kafka/event streaming, and event-driven data synchronization.
  • Experience implementing enterprise RBAC/RLS authorization models, leading architecture reviews, and establishing organization-wide database engineering standards.
  • Ability to translate business and non-functional requirements into practical database architecture and collaborate across architecture, engineering, security, infrastructure, and application teams.
  • Client management skills are desirable.

Benefits

  • Support, coaching, and feedback from experienced colleagues.
  • Opportunities to develop new skills and progress your career.
  • Individual progression planning, education, coaching, and practical development experience.
  • Freedom and flexibility to handle the role in a way that suits the employee.
  • Interdisciplinary work focused on high-quality delivery and knowledge exchange.

Categories

BackendData Engineering
Ernst and Young

About Ernst and Young

10,000+ employees

Ernst & Young (EY) provides audit/assurance, tax, consulting, strategy and transactions services to enterprises, financial institutions, and public‑sector clients. Structured as a global network of partner‑owned member firms, it sells professional services on a fee basis, including a dedicated Financial Services Organization for banking, insurance, and capital markets. Headquartered in London, EY was formed in 1989 from the merger of Ernst & Whinney and Arthur Young, and operates in 150+ countries.

Contact me