Senior Database Administrator

International Catalyst Services, LLC; Kuala Lumpur; Hybrid; MYR 72,000 - 90,000; Full time

Job summary

An opportunity exists for a Senior Database Administrator in a hybrid work environment within a top-tier global consulting firm. The role demands strong skills in MongoDB and PostgreSQL. You will be responsible for database configurations, performance tuning, monitoring, and ensuring uptime of databases while working collaboratively with application teams.

Qualifications

• 2-4 years working experience in database administration.
• Experience with MongoDB or PostgreSQL databases.

Responsibilities

• Build/configure PostgreSQL database cluster and replication.
• Monitor and ensure uptime of all production databases.
• Install necessary extensions like PostGIS/pgAudit.

Skills

Strong DBA Experience

Unix/Shell Scripting

Python

Analytical and problem-solving skills

Education

Bachelor’s degree

Job description

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.

Senior Database Administrator ( MongoDB/ PostgreSQL/ MySQL)

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

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 (NYSE: MMC) is a global leader in risk, strategy and people, advising clients in 130 countries across four businesses: Marsh, Guy Carpenter, Mercer and Oliver Wyman. With annual revenue of $24 billion and more than 90,000 colleagues, Marsh McLennan helps build the confidence to thrive through the power of perspective. For more information, visit marshmclennan.com, or follow on LinkedIn and X.

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.