Install, configure, patch, and upgrade PostgreSQL and other open-source/relational database servers across production and non-production environments.
Monitor and optimise database performance, including query optimisation, indexing, vacuum/autovacuum, partitioning, and capacity planning.
Design and manage database backup, restore, point-in-time recovery (PITR), and disaster recovery strategies.
Implement and maintain high availability (HA) and replication using streaming/logical replication, Patroni, repmgr, or pgpool, with connection pooling (PgBouncer).
Manage database security, including role-based access control, encryption, auditing, hardening, and compliance.
Plan and execute database migrations and upgrades, including migration from legacy platforms such as SQL Server, Oracle, and MySQL to PostgreSQL.
Support secure data access and integration for AI workloads running in the cloud while maintaining on-premises databases.
Collaborate with infrastructure and network teams on storage, server sizing, firewalls, and connectivity.
Automate routine database administration tasks using Bash, Python, SQL, or Ansible.
Troubleshoot and resolve database incidents, perform root cause analysis, and participate in change management and maintenance activities.
Requirements:
Minimum 5 years of experience in database administration, with strong hands-on PostgreSQL experience.
Proven experience in on-premises database administration, performance tuning, backup and recovery, HA/DR, and database security.
Experience with database replication, clustering, and failover tools such as Patroni, repmgr, pgpool, or equivalent.
Working knowledge of Linux server administration, storage (SAN/NAS, RAID), and virtualisation (VMware or similar).