Position Title: PostgreSQL Database Administrator (Cloud & On-Premises)

Department: Information Technology / Enterprise Systems 

Experience: 3 – 7 Years

Employment Type: Full-Time

Work Location: Chennai, Work from Office

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.