
Senior Database Administrator (MongoDB/ PostgreSQL)
- Malaysia
- Permanent
- Full-time
- Build/Configure PostgreSQL database cluster and replication
- Build/Configure Mongo RS and shard
- 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.
- At least a Bachelor’s degree with 2 – 4 years working experience
- Strong DBA Experience MongoDB or PostgreSQL
- Understanding of enterprise application technology architecture, components, databases, networking, and infrastructure as code
- Write efficient queries.
- Strong scripting experience - Unix/Shell Scripting, Python
- Technical knowledge of Linux & Windows-based platforms
- Strong analytical and problem-solving skills
- LDAPs configuration for authentication
- Experience in providing after hours emergency support
- Working on rotational shifts between 6am - 10pm local time, may include Sat/ Sun
- Willingness to learn, possess a positive attitude and able to work in a fast-paced environment
- Self-motivated, highly organized, resourceful and meticulous
- Ability to multi-task and work well under pressure
- Ability to work independently as well as within a team