
Open for applications
EY - GDS Consulting - AI And DATA -Postgress Architect- Gig
- Pay
- Not stated in the adSee EY pay
- Job type
- Not stated
- Work mode
- Not stated
- Experience
- 10+ years
About the job
At EY, you’ll have the chance to build a career as unique as you are, with the global scale, support, inclusive culture and technology to become the best version of you. And we’re counting on your unique voice and perspective to help EY become even better, too. Join us and build an exceptional experience for yourself, and a better working world for all.
EY GDS – Data and Analytics (D&A) – Manager- Postgress Architect
As part of our EY-GDS D&A (Data and Analytics) team, we help our clients solve complex business challenges with the help of data and technology. We dive deep into data to extract the greatest value and discover opportunities in key business and functions like Banking, Insurance, Manufacturing, Healthcare, Retail, Manufacturing and Auto, Supply Chain, and Finance.
The opportunity
We’re looking for candidates with strong technology and data understanding in big data engineering space, having proven delivery capability. This is a fantastic opportunity to be part of a leading firm as well as a part of a growing Data and Analytics team.
Your key responsibilities
PostgreSQL Architecture & Design
- Define enterprise PostgreSQL architecture, standards, reference patterns, and design principles.
- Design database topology, including clusters, instances, databases, schemas, partitioning, replication, and workload isolation.
- Establish patterns for transactional workloads, CQRS/read models, reporting, API-facing databases, and integration workloads.
- Evaluate database designs for scalability, reliability, maintainability, and operational resilience.
- Provide architecture guidance for capacity planning and future growth.
High Availability & Disaster Recovery
- Define HA/DR architecture, replication strategy, failover patterns, backup/recovery, and recovery procedures.
- Establish appropriate RTO/RPO targets with application and business teams.
- Design failure-domain and workload-isolation strategies to reduce blast radius.
- Define and validate database resilience, failover, restoration, and disaster-recovery testing practices.
Security, RBAC & Data Protection
- Define the PostgreSQL authentication, authorization, RBAC, and Row-Level Security (RLS) strategy.
- Establish patterns for application identities, service accounts, database roles, privileged access, and least-privilege controls.
- Define the boundary between enterprise/application authorization and database-enforced authorization.
- Establish standards for encryption, secrets management, auditing, sensitive-data protection, and database access.
- Partner with cybersecurity and identity teams to integrate PostgreSQL with enterprise IAM and security controls.
Performance & Scalability
- Establish standards for query optimization, indexing, partitioning, connection management, memory configuration, and database statistics.
- Review execution plans and identify database and query performance bottlenecks.
- Define performance baselines, monitoring thresholds, and capacity-management practices.
- Guide application teams on efficient PostgreSQL access patterns and SQL design.
- Establish strategies for high-volume reads, writes, concurrent access, and large datasets.
Data Architecture & Modeling
- Review and guide logical and physical data models.
- Define standards for schemas, naming, keys, constraints, indexes, data types, and referential integrity.
- Guide modeling for enterprise read models and CQRS/event-driven architectures.
- Define strategies for historical data, retention, archival, partitioning, and lifecycle management.
- Ensure database designs maintain appropriate data integrity while meeting performance requirements.
Platform Engineering & Automation
- Establish standards for PostgreSQL provisioning, configuration, upgrades, patching, and lifecycle management.
- Drive Infrastructure-as-Code and automated database deployment practices.
- Define database migration and schema-versioning standards integrated with CI/CD.
- Establish configuration baselines and environment consistency across development, test, staging, and production.
- Evaluate and recommend PostgreSQL extensions and platform capabilities based on enterprise requirements.
Observability & Operations
- Define enterprise monitoring for database availability, replication, connections, locks, storage, query performance, and resource utilization.
- Establish database health metrics, dashboards, alerts, and operational thresholds.
- Define standards for logging, auditing, troubleshooting, and production support.
- Support root-cause analysis for complex database incidents and identify architectural remediation.
- Develop operational runbooks and production-readiness criteria.
Architecture Governance & Technical Leadership
- Lead PostgreSQL architecture and design reviews for major applications and programs.
- Define reusable reference architectures, patterns, guardrails, and engineering standards.
- Review proposed database solutions and identify architectural, performance, security, and operational risks.
- Partner with application architects and engineers to ensure database decisions align with overall solution architecture.
- Mentor PostgreSQL engineers/DBAs and provide technical direction on complex database issues.
- Support architecture governance and Design Authority reviews.
Required Skills & Experience
- Strong hands-on expertise with PostgreSQL architecture and internals.
- Experience designing enterprise-scale, highly available PostgreSQL environments.
- Deep understanding of:
- PostgreSQL roles and privileges
- Row-Level Security
- Indexing and query optimization
- Execution plans
- Partitioning
- Replication
- Backup and recovery
- Connection management
- Vacuum/autovacuum and database maintenance
- Performance tuning
- Strong SQL and relational database design experience.
- Experience designing HA/DR and multi-environment production architectures.
- Knowledge of cloud-hosted PostgreSQL platforms, preferably Azure Database for PostgreSQL, AWS RDS/Aurora PostgreSQL, or equivalent managed PostgreSQL services.
- Experience with CI/CD, Infrastructure-as-Code, database migrations, and automated deployments.
- Experience with enterprise identity, security, encryption, secrets management, and audit requirements.
- Understanding of microservices, APIs, event-driven architecture, and CQRS/read-model patterns.
- Ability to translate business and non-functional requirements into practical database architecture.
- Strong communication skills with the ability to work across architecture, engineering, security, infrastructure, and application teams.
To qualify for the role, you must have
- 10+ years of database engineering/architecture experience with significant PostgreSQL experience.
- Experience supporting PostgreSQL in large-scale enterprise production environments.
- Experience architecting databases for high-volume API and read-intensive workloads.
- Experience with Kafka/event streaming and event-driven data synchronization.
- Experience implementing enterprise RBAC/RLS authorization models.
- Experience with PostgreSQL monitoring and observability platforms.
- Experience leading architecture reviews and establishing organization-wide database engineering standards.
<span style="font-family:arial, helvetica, sans-serif;font-size:10
Skills in this ad
More like this
EY
Technology
EY provides consulting, assurance, tax and transaction services that help solve our client’s toughest challenges and build a better working world for all.
Similar jobs
All jobsEY payCareer pathCheck my market payJobs by degreeRoles in demandTailor your CV for this job
About this listing
- First seen by Jobiba 21 Nov 2026
Jobiba never charges you to apply. Never pay to apply or share OTPs, card or bank details.