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.
What Success Looks Like
The PostgreSQL Architect will ensure that PostgreSQL solutions are
Scalable for enterprise workloads and data growth.
Highly available and recoverable with tested HA/DR capabilities.
Secure by design, with standardized RBAC/RLS and least-privilege access.
Performant, with measurable engineering and operational standards.
Automated and repeatable across environments.
Observable and supportable in production.
Consistent, through reusable enterprise PostgreSQL patterns rather than application-by-application implementations.
Ideally, you’ll also have
Client management skills
What working at EY offers
At EY, we’re dedicated to helping our clients, from start–ups to Fortune 500 companies — and the work we do with them is as varied as they are.
You get to work with inspiring and meaningful projects. Our focus is education and coaching alongside practical experience to ensure your personal development. We value our employees and you will be able to control your own development with an individual progression plan. You will quickly grow into a responsible role with challenging and stimulating assignments. Moreover, you will be part of an interdisciplinary environment that emphasizes high quality and knowledge exchange. Plus, we offer:
Support, coaching and feedback from some of the most engaging colleagues around
Opportunities to develop new skills and progress your career
The freedom and flexibility to handle your role in a way that’s right for you
EY | Building a better working world
EY exists to build a better working world, helping to create long-term value for clients, people and society and build trust in the capital markets.
Enabled by data and technology, diverse EY teams in over 150 countries provide trust through assurance and help clients grow, transform and operate.
Working across assurance, consulting, law, strategy, tax and transactions, EY teams ask better questions to find new answers for the complex issues facing our world today.
Apply now »
Apply now
Start applying with LinkedIn
Apply Now
Start
Please wait...
Find similar jobs
- Consulting DE,
- Consulting CN,
- Consulting CA,
- Consulting BR,
- Consulting
Connect with us
Our locations
My EY
Site map
Legal and privacy
Labor condition applications
Cookie Consent Manager
Opens in a new tab.
Opens in a new tab.
Opens in a new tab.
Opens in a new tab.
Opens in a new tab.
EY refers to the global organization, and may refer to one or more, of the member firms of Ernst & Young Global Limited, each of which is a separate legal entity. Ernst & Young Global Limited, a UK company limited by guarantee, does not provide services to clients.
×
Cookie Consent Manager
When you visit any website, it may store or retrieve information on your browser, mostly in the form of cookies. Because we respect your right to privacy, you can choose not to allow some types of cookies. However, blocking some types of cookies may impact your experience of the site and the services we are able to offer.
Required Cookies
These cookies are required to use this website and can't be turned off.
Required Cookies
Show More Details
Required Cookies
- Provider
- Description
- Enabled
SAP as service provider
We use the following session cookies, which are all required to enable the website to function:
"route" is used for session stickiness
"careerSiteCompanyId" is used to send the request to the correct data center
"JSESSIONID" is placed on the visitor's device during the session so the server can identify the visitor
"Load balancer cookie" (actual cookie name may vary) prevents a visitor from bouncing from one instance to another
Cookies from provider SAPasserviceprovider are required and cannot be turned off
Advertising Cookies
These cookies serve ads that are relevant to your interests. You may freely choose to accept or decline these cookies at any time. Note that certain functionality that these third parties make available may be impacted if you do not accept these cookies.
Consent to all Advertising Cookies
Show More Details
Advertising Cookies
- Provider
- Description
- Enabled
AddThis
Google Analytics is a web analytics service offered by Google that tracks and reports website traffic.
Cookie Information
Privacy Policy
Terms and Conditions
Consent to cookies from provider AddThis
LinkedIn
LinkedIn is an employment-oriented social networking service. We use the Apply with LinkedIn feature to allow you to apply for jobs using your LinkedIn profile. Opting out of LinkedIn cookies will disable your ability to use Apply with LinkedIn.
Cookie Policy
Cookie Table
Privacy Policy
Terms and Conditions
Consent to cookies from provider LinkedIn
Google Analytics
Google Analytics is a web analytics service offered by Google that tracks and reports website traffic.
Cookie Information
Privacy Policy
Terms and Conditions
Consent to cookies from provider GoogleAnalytics
Google Tag Manager
Google Tag Manager is a tag management system for conversion tracking, site analytics, remarketing, and more.
Privacy Policy
Terms and Conditions
Consent to cookies from provider GoogleTagManager
Confirm My Choices
- Reject All Cookies
- Accept All Cookies