PostgreSQL Senior Database Administrator (DBA)

Company:

MMC Corporate

Description:

Marsh McLennans Database Services team is growing rapidly and we have an exciting opportunity for a creative and inquisitive Senior Database Administrator skilled in Postgres and Oracle. This hybrid role requires 3 days in-office in Canada and offers the chance to work on a global team responsible for critical enterprise database systems.

PostgreSQL Senior Database Administrator (DBA)

We will count on you to:

• Manage optimize and ensure the high availability of PostgreSQL databases hosted on Linux and cloud platforms (AWS and Azure).

• Lead complex database migration projects from Oracle to PostgreSQL including performance tuning and high-availability configurations.

• Implement advanced PostgreSQL features such as partitioning indexing strategies query tuning and replication to optimize performance at scale.

• Oversee configuration and management of cloud-based PostgreSQL offerings and maintain disaster recovery solutions with RTO & RPO considerations.

• Utilize PostgreSQL extensions (e.g. PostGIS pgpartman pgstatstatements) and support Oracle DB features like RMAN Export/Import and Triggers.

• Contribute to automation initiatives by researching and presenting new technologies to enhance database strategy and operations.

What you need to have:

• 5 years of PostgreSQL database experience including at least 3 years working in cloud environments.

• Minimum 2 years of hands-on experience migrating Oracle databases to PostgreSQL.

• Bachelors degree preferred or equivalent professional experience.

• Extensive experience as a Senior PostgreSQL/Oracle Database Engineer with a strong focus on migrating Oracle databases to PostgreSQL.

• Solid knowledge of relational database management systems and cloud computing architecture.

• Skilled in database design cloud computing and Data Lake Architecture.

What makes you stand out:

• Advanced expertise in PostgreSQL internals and performance tuning including query execution plans autovacuum settings and complex transaction management.

• Familiarity with infrastructure-as-code tools such as Terraform and Ansible is a plus.

• Entrepreneurial mindset with a passion for automation and continuous improvement in database technologies.

• Experience with Mongo DB or MySQL is preferred

Why join our team:

• We help you be your best through professional development opportunities interesting work and supportive leaders.

• We foster a vibrant and inclusive culture where you can work with talented colleagues to create new solutions and have impact for colleagues clients and communities.

• Our scale enables us to provide a range of career opportunities as well as benefits and rewards to enhance your well-being.

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 90000 colleagues Marsh McLennan helps build the confidence to thrive through the power of perspective. For more information visit or follow on LinkedIn and X.

Marsh McLennan is committed to embracing 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 accordance with the Accessibility for Ontarians with Disabilities Act 2005 Marsh McLennan will provide a reasonable accommodation to employees and prospective employees to the point of undue hardship upon request and as required in respect of the individuals particular restrictions and limitations. If you require a specific accommodation because of a disability or medical need please contact

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.

The applicable base salary range for this role is $96600 to $146600.

The base pay offered will be determined on factors such as experience skills training location certifications education and any applicable minimum wage requirements. Decisions will be determined on a case-by-case addition to the base salary this position may be eligible for performance-based incentives.

We are excited to offer a competitive total rewards package which includes health and welfare benefits tuition assistance retirement programs as well as employee assistance programs.

This is a New position.