We are seeking a skilled Database Administrator (DBA) with hands-on experience in PostgreSQL. The role involves managing databases on cloud-hosted servers, ensuring high performance, availability, and data integrity.
Key Responsibilities:
- Install, configure, and maintain PostgreSQL Server databases
- Monitor database performance and optimize queries
- Perform database backups, restores, and disaster recovery
- Implement and manage database mirroring, replication, and log shipping
- Ensure high availability and data redundancy
- Manage database security, users, roles, and permissions
- Perform database patching, upgrades, and migrations
- Support application deployments and database changes
- Troubleshoot production issues and ensure minimal downtime
- Automate routine DBA tasks
Required Skills:
- Strong experience in PostgreSQL Server administration
- Strong knowledge of backup & recovery strategies
- Experience in query performance tuning and optimization
- Hands-on experience with Linux and Windows servers
- Experience working on cloud-hosted virtual machines (VMs)
Preferred Skills:
- Basic understanding of server environments and deployments
- Experience with monitoring tools
- Exposure to release/deployment processes
- On-call support may be required
- Experience in handling live production databases is mandatory