Company:
MMC CorporateDescription:
We are seeking a talented individual to join our DBA team at Marsh & McLennan Asia Business Services (MMABS). This role will be based in our Pavilion Damansara Corporate Towers, Kuala Lumpur office. This is a hybrid role that has a requirement of working as per respective team's arrangement.
Database Administrator
An excellent opportunity for a Database Administrator, looking for a long-term opportunity, growth and flexible work environment within the Database Services team. In this capacity, the responsibilities will include creating, supporting and maintaining MongoDB , PostgreSQL and other databases managed by the Database Services team
We will count on you to:
- 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.
What you need to have:
- At least a Bachelor’s degree with 2 – 4 years working experience
- Strong DBA Experience MongoDB and 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
What makes you stand out:
- 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
Marsh McLennan is committed to creating a diverse, inclusive and flexible work environment. We aim to attract and retain the best people and embrace diversity of age, background, disability, ethnic origin, family duties, gender orientation or expression, marital status, nationality, parental status, personal or social status, political affiliation, race, religion and beliefs, sex/gender, sexual orientation or expression, skin color, or any other characteristic protected by applicable law.
Marsh McLennan is committed to hybrid work, which includes the flexibility of working remotely and the collaboration, connections and professional development benefits of working together in the office. All Marsh McLennan colleagues are expected to be in their local office or working onsite with clients at least three days per week. Office-based teams will identify at least one “anchor day” per week on which their full team will be together in person.