Position Title: PostgreSQL Database Administrator (Cloud & On-Premises)
Department: Information Technology / Enterprise Systems
Experience: 3 7 Years
Employment Type: Full-Time
Job Overview:
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.
