Database Administrator (MongoDB/PostGreSQL)

Location: Kuala Lumpur - Corporate

Remote Type: Hybrid

Time Type: Full time

Job Description

Company:

Marsh Corporate

Description:

We are seeking a talented individual to join our DBA team at Marsh. 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 three days in office.

Senior Database Administrator (MongoDB/PostGreSQL)

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 Mongo RS and shard
• 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.

What you need to have:

• 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 MongoDB, MongoDB Atlas or 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
• 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
• 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.

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 Risk is a business of Marsh (NYSE: MRSH), a global leader in risk, reinsurance and capital, people and investments, and management consulting, advising clients in 130 countries. With annual revenue of over $24 billion and more than 90,000 colleagues, Marsh helps build the confidence to thrive through the power of perspective. For more information about Marsh Risk, visit marsh.com, or follow us on LinkedIn and X.

Marsh 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 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 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.