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 DatabaseOptimization 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 and 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.
