Database Administrator (PostgreSQL)
Summary
Maintain and optimize PostgreSQL and MongoDB databases, set up replication, backups, and DR plans, and tune performance for high availability.
Build/Configure PostgreSQL database cluster and replication
Fine-tune configurations MongoDB and servers for performance improvement.
Configure Barman server for new database cluster
Install PostGIS/ pgAudit and other required extension
Responsible for the monitoring and uptime of all production databases.
Estimate database capacities; develop methods for monitoring database capacity and usage.
Lead efforts to develop and improve procedures for automated monitoring and proactive intervention, reducing any need downtime.
Responsible for regular backups and recovery of databases.
Responsible for regular maintenance on databases (e.g., Vacuum, Reindexing, Archiving).
Design and implement DR plans & HA solutions and recommendations.
Work closely with the application team to understand what changes are coming in a build/patch/hotfix, do an impact analysis, fine-tune the queries if any.
Requirements
At least a Bachelor’s degree with minimum 3 to 5 years’ support and/or project experience in a Database Administrator role
Good DBA Experience and knowledge in PostgreSQL
Good knowledge in Docker, Replication, Sharding, Ops Manager
Experience in MongoDB and/or PostGreSQL db upgrade.
Having experience in managing PostGreSQL on Cloud (PAAS/IAAS) is an added advantage.
Having experience in managing PostGreSQL via Docker/Container is an added advantage.
Understanding of enterprise application technology architecture, components, databases, networking, and infrastructure as code
Strong scripting experience - Unix/Shell Scripting, Python
Technical knowledge of Linux & Windows-based platforms
Strong analytical and problem-solving skills
LDAPs configuration for authentication
Good analytical and problem-solving skills and the ability to work under pressure
Good communication and interpersonal skills.
Can demonstrate experience in suggesting an improvement idea or working on a continuous improvement initiative.
Ability to work collaboratively in a fast-paced, dynamic environment.
Committed to learning new technologies and effectively applying them in daily work activities.
Flexible to provide support after working hours, weekends and/or Wilayah Persekutuan public holidays when required
Work shifts will align to the Pacific region, hence business support hours will start at 7am KL
Able to commit to hybrid working arrangement, with a minimum of 3 days in office.
Candidate should have available transport to commute to office for the expected business support hours.