Senior PostgreSQL Database Administrator

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:

PostgreSQL Database Administrator

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

Cloud-based Architecture