
EY - GDS Consulting - AI And DATA -Postgress Architect- Gig
Ernst and Young23 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.
Tech Stack
Categories
BackendData Engineering
About Ernst and Young
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.