Lead PostgreSQL Database Specialist

Senior PostgreSQL DB Admin

About the Role :

We are seeking a highly skilled Senior PostgreSQL Database Administrator to setup, manage, optimize, and support our PostgreSQL databases in a mission-critical, high-performance environment. The ideal candidate will have deep expertise in database tuning, backups, high availability, monitoring and automation.

As a key member of the data team, you will collaborate closely with business stakeholders, cross-functional data teams, and subject matter experts (SMEs) to implement data solutions that support data-driven decision-making at scale.

Key Responsibilities :

PostgreSQL Management :

Work with very large datasets (hundreds of millions of records) efficiently and reliably.

Expertise in PostgreSQL clustering, replication and high-availability configurations

Familiarity with PostgreSQL backups, recovery procedures and disaster recovery strategies.

Experience in managing and optimizing PostgreSQL database performance, including query optimization, indexing and partitioning.

Lead efforts to harden PostgreSQL environments against internal and external threats

Define and enforce database security policies, including role-based access control, encryption, and auditing

Governance & Standards :

Promote and enforce Data Governance , Data Quality , and Model Governance practices across critical data projects.

Work with stakeholders to ensure the application of Data Architecture Policies , Standards , and Guiding Principles in all data-related projects.

Ensure the Reference Architecture is adhered to by all teams.

Collaboration & Consultation :

Act as a Data and Model Governance Consultant , educating internal teams on data governance, architecture principles, and best practices.

Provide technical guidance and support to data engineering teams to ensure compliance with Data & Analytics Principles in areas like new dataset creation, pipeline design, and data integration.

Technical Documentation :

Write detailed design specifications and documentation to clearly communicate architectural and modelling decisions.

Demonstrate design and technology approaches through prototypes and proofs of concept.

Continuously assess and recommend opportunities for Database Optimization to Ensure Low Latency

Work closely with cross-functional data owners, SMEs, and teams to monitor and manage Data Health .

Cloud and AI / ML Exposure (Nice to Have) :

Work on cloud-based data architectures, ensuring integration and alignment with modern cloud technologies (AWS, Azure, or GCP).

Exposure to AI / ML frameworks and support integration of advanced analytics into the data platform.

Experience with Modern data platforms such as Databricks, Snowflake.

Stakeholder Management :

Strong Communication skills and ability to Build strong relationships with business and technical stakeholders to understand business needs and deliver data solutions that support organizational goals.

Communicate complex data architecture concepts clearly and effectively to both technical and non-technical stakeholders.

About Candidate :

You are an experienced PostgreSQL Database Administrator with a proven track record of designing implementing, maintaining and optimising data solutions at an enterprise scale. You are a problem solver who thrives in a collaborative environment and can effectively manage multiple stakeholders across the organization.

Qualifications : Experience :

Minimum of 10+ years of experience in data, digital, technology or analytical roles.

Expertise in installing, configuring, securing and maintaining PostgreSQL databases.

Deep understanding of networking concepts, including setting up PostgreSQL replication (master-slave, master-master), failover and clustering.

Expertise in query performance tuning, using tools like pg_stat_statements, EXPLAIN ANALYZE and server settings to optimize database performance. Experience with PostgreSQL-specific tools such as pgAdmin, pgBouncer, pgBadger, pg_repack etc.

Install and configure new database servers using best practices. Knowledge of High Availability (HA) and Disaster Recovery (DR). Upgrade minor and major versions.

DB Backup and Recovery Activities such as Ensure all database servers are backed up. Perform restoration testing. Follow Industry Best Practices.

Define and implement maintenance plans for database systems. Standardize maintenance approaches across systems. Index and statistics maintenance.

Proactively identify, troubleshoot, and resolve live database system issues. Capacity planning and forecasting. Creating and reviewing data access audits. Tracking and reporting on Recovery Point Objectives (RPO) metrics.

Identification of queries having the largest performance impact.

Improvements to indexes and execution plans. Troubleshoot transaction and concurrency issues. Assist developers with query optimization.

Create documentation on processes and procedures. Providing training for developers and other technical resources.

Collaborate with DevOps and application teams to optimize query performance and database architecture

Conduct regular security assessments, patching, and vulnerability remediation

Provide expert-level troubleshooting and root cause analysis for database-related incidents

Experience in Cloud Architecture (Azure)

Technical Skills :

Strong knowledge of Database Administration, Governance a nd Data Modelling best practices.

Hands-on expertise in Cloud-based Architecture on Azure.

Experience in integrating AI / ML frameworks into data platforms. (Good to have)

Ability to write clear design specifications and technical documentation.

Proven ability to mentor and guide teams on Data Architecture Principles .

Certifications :

Relevant certifications in Cloud-based Architecture (Azure) are a plus.