PostgreSQL Database Administrator

Description :

We are seeking a skilled PostgreSQL Database Administrator to manage our hybrid database infrastructure at Apollo IT. This role focuses on managing Azure Database for PostgreSQL (Flexible Server) instances alongside on-premises clusters. You will be responsible for provisioning, securing, and optimizing high-performance databases that support our critical Hospital Information Systems (HIS) and digital health platforms, ensuring compliance with strict healthcare data standards.

Key Responsibilities :

Azure PaaS Management & Administration :

- Provision, scale, and manage Azure Database for PostgreSQL - Flexible Server instances using the Azure Portal and CLI.

- Configure compute and storage scaling (Burstable, General Purpose, Memory Optimized tiers) to meet fluctuating application demands while optimizing costs.

- Manage automated maintenance windows and minor version upgrades to ensure instance stability with minimal impact on clinical operations.

High Availability (HA) & Disaster Recovery (DR) on Cloud :

- Implement Zone-Redundant High Availability to ensure zero data loss and automatic failover across Availability Zones (AZs).

- Configure and test Geo-Redundant backups and Point-in-Time Restore (PITR) capabilities for disaster recovery scenarios.

- Manage Read Replicas to offload read-heavy reporting workloads from the primary transactional database.

Performance Tuning & Monitoring :

- Utilize Azure Monitor and Log Analytics to track key metrics (CPU, IOPS, active connections) and set up proactive alerts.

- Leverage Query Performance Insight and Query Store to identify and tune long-running queries and optimize resource consumption.

- Analyze wait statistics and autovacuum activities specific to the PaaS environment to prevent table bloat.

Security & Compliance (Healthcare Focus) :

- Implement VNet Integration and Private Link to isolate database traffic within the Azure virtual network, ensuring no public internet exposure.

- Enforce Azure Active Directory (Entra ID) authentication for centralized and secure database access control.

- Ensure configuration compliance with HIPAA and HITRUST standards using Azure Policy and Defender for Cloud.

Automation & Infrastructure as Code (IaC) :

- Automate database provisioning and configuration changes using Terraform, Bicep, or ARM templates.

- Develop PowerShell or Azure CLI scripts for routine operational tasks such as scaling and backup verification.

Required Qualifications :

Education :

- B.Tech/B.E. in Computer Science, IT, or MCA.

Technical Skills :

- Deep expertise in PostgreSQL 12/13/14+ architecture and internals (Vacuuming, Indexing, Locking).

- Hands-on experience with Azure Database for PostgreSQL (Flexible Server) administration.

- Proficiency in Infrastructure as Code (IaC) tools like Terraform or Bicep.

- Knowledge of PgBouncer for connection pooling in a cloud environment.

Soft Skills :

- Ability to troubleshoot complex performance issues in distributed cloud environments.

- Strong collaboration skills to work with Cloud Architects and DevOps engineers.

Preferred (Bonus) Skills :

- Experience migrating on-premises databases to Azure using Azure Database Migration Service (DMS).

- Knowledge of Azure Cosmos DB for PostgreSQL (Citus) for distributed scale-out workloads.

- Microsoft Certified : Azure Database Administrator Associate (DP-300) or similar cloud certification.