Senior Database Administrator
Key Responsibilities
Database Administration & Support
- Build, configure, and manage MongoDB Replica Sets and Sharding environments.
- Build and maintain PostgreSQL database clusters and replication solutions.
- Configure and maintain Barman backup servers for PostgreSQL environments.
- Install and manage PostgreSQL extensions such as PostGIS, pgAudit, and other required modules.
- Monitor database performance, availability, and uptime across production environments.
- Perform database capacity planning and utilization monitoring.
- Execute regular database maintenance activities including:
- Vacuuming
- Reindexing
- Archiving
- Performance tuning
Performance Optimization & Reliability
- Fine-tune MongoDB, PostgreSQL, and server configurations to improve performance.
- Develop and enhance automated monitoring and proactive alerting mechanisms.
- Manage database backup and recovery procedures.
- Design and implement Disaster Recovery (DR) and High Availability (HA) solutions.
- Support database upgrades, migrations, and patching activities.
Collaboration & Continuous Improvement
- Work closely with application teams to assess the impact of software releases, patches, and hotfixes.
- Analyze and optimize database queries and performance bottlenecks.
- Participate in continuous improvement initiatives and recommend operational enhancements.
- Maintain database security, authentication mechanisms, and LDAP integrations.
Requirements
Technical Requirements
- Bachelor's Degree in Computer Science, Information Technology, Engineering, or a related field.
- Minimum 3+ years of experience in a Database Administrator role.
- Strong hands-on experience with:
- MongoDB
- MongoDB Atlas
- PostgreSQL
- Experience with:
- Replication
- Sharding
- MongoDB Ops Manager
- Docker / Containerized environments
- Experience performing MongoDB and PostgreSQL database upgrades.
- Strong SQL and query optimization skills.
- Scripting experience in:
- Unix Shell Scripting
- Python
- Strong understanding of Linux and Windows server environments.
- Experience with LDAP authentication configuration.
Preferred Skills
- Experience managing PostgreSQL in Cloud environments (IaaS/PaaS).
- Experience managing PostgreSQL in Docker or containerized platforms.
- Understanding of enterprise technology architecture, networking, infrastructure, and Infrastructure as Code (IaC).
- Experience designing High Availability and Disaster Recovery solutions.
Pay: RM13,000.00 - RM14,000.00 per month
Education:
Experience:
- Unix/Shell Scripting, Python: 2 years (Preferred)
- Linux & Windows-based platforms: 2 years (Preferred)
- Database Admin: 2 years (Preferred)
- MongoDB: 1 year (Required)
- Docker, Replication, Sharding, Ops Manager: 2 years (Preferred)
- MongoDB and/or PostGreSQL db upgrade.: 2 years (Preferred)
- managing PostGreSQL on Cloud (PAAS/IAAS) : 2 years (Preferred)
Work Location: In person