Marsh McLennan (MMC) Database Services are growing at fast pace and currently have an opportunity for a creative and inquisitive MongoDB Database Administrator. This role could be based remotely, out of Canada office locations, with a degree of remote working also available.

Assigning, directs and evaluating work, conducting performance evaluations, progressive counseling and career development discussions.

Provides critical input in to hiring, discipline and termination decisions as well as salary and bonus actions.

Leads a team which provides support 24/7 to global users.

Directs staff to modify database structures using database administration tools and programming as needed.

Directs and troubleshoots database issues to keep existing databases running efficiently.

Troubleshoots a wide range of issues including server availability and coding issues for database configurations.

Directs, plans and executes strategic database activities including installation, configuration and upgrading of Oracle server software and products.

Creates and sizes database storage structures and objects.

Plans for and backup and recovery of database information.

Supports strategic direction for database platforms by evaluating and making recommendations for new platforms.

What can you expect?

• We are a large team who together, across the AUS, UK, Canada & US, are responsible for significant databases & projects related to our MongoDB environment.
• We are offering an emerging and varied role, with a stimulating range of duties and responsibilities, designing strategies for our Enterprise Database Systems and setting standards for operations, programming, and security, using ETL architecture standards.
• We are moving to an automation first approach, so welcome your entrepreneurial, inquisitive nature, to research & present new, replacement tech that will contribute to defining, maintaining, and strengthening the database strategy, service offerings and support of this critical department.
• Our Database Services team are Global, this role could be based remotely, out of any of our Canada office locations, with a degree of remote working also available.

What is in it for you?

• A company with a strong Brand and strong results to match
• Marsh Canada offers competitive employee benefits and a thriving culture to bring your authentic self to work
• Culture of internal mobility, collaboration and valued partnership with HR from the business.
• Employee Resource Groups which provide access to leaders, relevant volunteer and mentoring opportunities and interactions with counterparts in industry groups and client organizations.
• Competitive pay (salary and bonus potential), Full benefits package – starting day one (medical, dental, vision, STI/LTI, life insurance, RSP (Retirement Savings Plan or TSFA (tax free savings account.) (regional specificity required)
• Parental Leave and Tuition Reimbursement plan per year and participation in our Employee Stock Purchase Plan (regional specificity required)
• Entitled to vacation, floating holidays, time off to give back to your community, 10 sick days, and company holidays (with early dismissal).
• Flexible Remote Working & Workplace Schedules (Remote work only during Covid-19 pandemic).

We will rely on you to:

• Design and construct large non-relational databases.
• Integrate new systems with existing structure and refine system performance and functionality.
• Manage data integration and train users on effective implementation of database practices
• Take complex codes and break them down logically for end-user understanding
• Compute solutions to data problems in a timely manner with techniques that offer long-term success
• Transmit information feedback between end-users and data specialists to ensure high-quality programs
• Research industry best practices in emerging technologies and implement into database design
• Maintain an open and optimistic point of view to build broad systems that provide dependable and customized usage to multiple end-users
• Provide support with continuing maintenance, updates and upgrades; identifying and fixing problems as they arise
• Provide recommendations for performance tuning and improvements to existing databases

What you need to have:

• 10+ years of database experience or other related computer science experience
• Bachelor's degree preferred or equivalent work experience
• Sound knowledge of Relational DBMS (Database Management Systems)
• Talented in Database and cloud computing design, architectures, and data lakes

MongoDB Skills

• Build/Configure Mongo RS and shard
• Implement appropriate indexes for performance improvement.
• Fine-tune configurations – MongoDB and servers for performance improvement.
• Implement optimal backup and recovery.
• Understand and optimize query performance.
• Create and publish database health checks to monitoring systems for the following:
• Identify slow queries
• Replication lags
• Node failures
• Index usage patterns
• CPU usage
• Memory usage
• Locks
• Number of connections
• Any other relevant params
• Evaluate, plan and perform the DB upgrades.
• Maintenance – during release/outage etc.
• Implementing best practices for backups, replication, and health checks.
• Database hardening – implement best practices.
• 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.
• Automate the database repetitive tasks.
• Perform other duties as assigned.

Required Skills:

• 10+ year’s hands-on experience as DBA and 4+ years on MongoDB.
• Understanding of enterprise application technology architecture, components, databases, networking, and infrastructure as code.
• Encryption(TLS 2)
• Strong DBA Experience – MongoDB.
• 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

Desired Skills:

Hands-on experience in AWS

Disaster Recovery and Business continuity

What makes you stand out?

• Experience or interest in NoSQL and/or MongoDB Atlas
• Familiarity with data visualization, data migration and data modelling tools
• Be a strategic thinker
• Experience in applied mathematics and statistics

Marsh McLennan (NYSE: MMC) is the world’s leading professional services firm in the areas of risk, strategy and people. The Company’s 83,000 colleagues advise clients in 130 countries. With annual revenue of nearly $20 billion, Marsh McLennan helps clients navigate an increasingly dynamic and complex environment through four market-leading businesses. Marsh advises individual and commercial clients of all sizes on insurance broking and innovative risk management solutions. Guy Carpenter develops advanced risk, reinsurance and capital strategies that help clients grow profitably and pursue emerging opportunities. Mercer delivers advice and technology-driven solutions that help organizations redefine the world of work, reshape retirement and investment outcomes, and unlock health and wellbeing for a changing workforce. Oliver Wyman serves as a critical strategic, economic and brand advisor to private sector and governmental clients. For more information, visit mmc.com, follow us on LinkedIn and Twitter or subscribe to BRINK.

Marsh McLennan is committed to embracing a diverse, inclusive and flexible work environment. We aim to attract and retain the best people regardless of their sex/gender, marital or parental status, ethnic origin, nationality, age, background, disability, sexual orientation, gender identity or any other characteristic protected by applicable law.

In accordance with the Accessibility for Ontarians with Disabilities Act, 2005, Mercer 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 individual’s particular restrictions and limitations. If you require a specific accommodation because of a disability or medical need please contact TANA@mmc.com.