Senior Project Consultant-Tech Consulting-GOV-CNS-TC-Technology Strategy & Transformation-New Delhi

Requisition Id: 1700925

As a global leader in assurance, tax, transaction and advisory services, we hire and develop the most passionate people in their field to help build a better working world. This starts with a culture that believes in giving you the training, opportunities and creative freedom. At EY, we don't just focus on who you are now, but who you can become. We believe that it’s your career and ‘It’s yours to build’ which means potential here is limitless and we'll provide you with motivating and fulfilling experiences throughout your career to help you on the path to becoming your best professional self.

The opportunity : Senior Project Consultant-GOV-Tech Consulting-CNS - TC - Technology Strategy & Transformation - New Delhi

GOV :

Our Global Government & Public Sector (GPS) is a network of highly skilled professionals dedicated to serving our clients by bringing best-in-class international experience and insight combined with local knowledge to solve the most critical problems facing governments today. We actively focus on building solutions that help public sector entities face the challenges of the future and reinvent themselves.

Digital transformation is not just about new technologies; it involves an overhaul of organizational structures, governance, work processes, culture and mindset. It also means realizing a wider vision of relationships and business models that will redesign how public services function.

To achieve this vision, we help clients balance strategic choices to re-ignite performance. We have developed a suite of cross-service line strategic solutions that align with our client priorities.

We have a proud record of helping governments meet their challenges head-on, and we work closely with them to build a world that works better for all citizens.

CNS - TC - Technology Strategy & Transformation :

EY Consulting is building a better working world by transforming businesses through the power of people, technology and innovation. Our client-centric approach focuses on driving long-term value for our clients by solving their most strategic problems. EY Consulting is made up of three sub-service lines: Business Consulting (including Performance Improvement and Risk Consulting), Technology Consulting and People Advisory Services.

In Tech Consulting, we are transforming businesses through the power of people, technology and innovation. It places humans@center, leverages technology@speed and enables innovation@scale.

Your key responsibilities :-

We are seeking a highly skilled Senior PostgreSQL Database Administrator with 6–10 years of strong experience in architecting, implementing, and optimizing PostgreSQL databases in large-scale, mission‑critical environments. The ideal candidate will serve as a subject matter expert for PostgreSQL, lead database initiatives, ensure high availability, and collaborate with engineering, architecture, DevOps, and product teams.

Key Responsibilities

Database Architecture & Design

• Lead the design and implementation of high-performance PostgreSQL database architectures.
• Define standards for schema design, indexing strategy, data partitioning, sharding, and storage optimization.
• Provide technical guidance for database scalability, capacity planning, and data growth strategy.

Administration & Operations

• Install, configure, patch, and maintain PostgreSQL instances across production and non-production environments.
• Set up and manage replication architectures (streaming, logical, cascading, synchronous/asynchronous).
• Implement and manage robust backup and disaster recovery strategies using pgBackRest, Barman, or enterprise tools.
• Ensure database security, compliance, auditing, and encryption best practices.

Performance Tuning & Troubleshooting

• Lead deep‑dive analysis of performance issues using EXPLAIN/ANALYZE, pg_stat views, auto‑vacuum tuning, and indexing improvements.
• Investigate and resolve locking issues, deadlocks, replication lag, and query bottlenecks.
• Drive proactive database health checks and optimization strategies.

Automation & DevOps Integration

• Build automation for database provisioning, monitoring, backup, failover, and upgrades using Ansible, Python, Shell, etc.
• Collaborate with DevOps teams to integrate PostgreSQL into CI/CD pipelines and Infrastructure‑as‑Code frameworks.
• Create scripts and tools to streamline operations in large, distributed environments.

Monitoring & Observability

• Implement enterprise-grade monitoring using Prometheus/Grafana, pgAdmin, Nagios, or equivalent.
• Define alerting, dashboards, and audit logging for runtime health, anomalies, and capacity usage.

Collaboration & Leadership

• Partner with development teams for query optimization, schema changes, and data modeling.
• Mentor junior DBAs and guide cross-functional teams on best practices.
• Participate in on-call rotations, incident management, and root cause analysis.
• Drive PostgreSQL roadmap discussions, version upgrades, and technology evaluations.

Required Skills

• 6–10 years of solid hands-on experience as a PostgreSQL DBA in production environments.
• Strong expertise in PostgreSQL internals, architecture, WAL, MVCC, autovacuum, and checkpoint tuning.
• Deep knowledge of performance tuning, index optimization, and query execution plans.
• Proven experience with HA/DR solutions, replication topologies, and failover strategies.
• Strong command of Linux administration (RHEL/Ubuntu).
• Excellent scripting in Shell, Python, or Bash.
• Knowledge of security practices, SSL/TLS, IAM, roles/privileges, and encryption mechanisms.

Good-to-Have Skills

• Experience with PostgreSQL extensions: PostGIS, pgPool-II, TimescaleDB, Citus, FDWs.
• Exposure to Kubernetes, Helm, Operators, and containerized database deployments.

What we look for

People with the ability to work in a collaborative manner to provide services across multiple client departments while following the commercial and legal requirements. You will need a practical approach to solving issues and complex problems with the ability to deliver insightful and practical solutions. We look for people who are agile, curious, mindful, and able to sustain positive energy, while being adaptable and creative in their approach.

What we offer

Fuelled by the brilliance of our people, EY has emerged as the strongest brand and the most attractive employer in our field, with market-leading growth over competitors. Our people work side-by-side with market-leading entrepreneurs, game-changers, disruptors, and visionaries. As an organization, we are investing more time, technology, and money than ever before in skills and learning for our people. At EY, you will have a personalized Career Journey and also the chance to tap into the resources of our career frameworks to better know about your roles, skills, and opportunities.

EY is equally committed to being an inclusive employer, and we strive to achieve the right balance for our people—enabling us to deliver excellent client service while allowing our people to build their careers as well as focus on their wellbeing.

If you can confidently demonstrate that you meet the criteria above, please contact us as soon as possible.

Join us in shaping the future with confidence. Apply Now