Best Remote Jobs

By | June 28, 2022

Job Responsibilities : Database Administrator (MSSQL/MongoDB)

Salary : $67000 Per Year

Company : MMC Corporate

Location : Temporarily remote CA

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

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

  • 5+ 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

MSSQL Skills

  • Experience with SQL Server installations and configuration of SQL Server 2014/ 2016/ 2019 products
  • Expertise in SQL Server AlwaysOn Cluster and Availability groups technology for HA/ DR methodologies and planning
  • Proven experience in setting up of database clustering availability groups active/ passive failover configuration availability groups and load balancing
  • Competency in performance tuning and optimization techniques
  • Expertise with SQL patching such as applying service packs security patches and Hotfixes.
  • Experience with scripting via PowerShell with a focus on automation of repetitive tasks
  • Configuration of SQL Server Replication topologies
  • Proficiency in SSRS configuration and maintenance
  • Diagnosing the database issues and taking corrective actions to ensure database availability
  • Database capacity planning upgrades and database migration
  • Proficiency in database security and audit requirements
  • Proficiency in Business continuity strategy and exercise

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.

What makes you stand out?

  • Experience of 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

In accordance with applicable legislation Marsh 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.

Marsh is the world’s leading insurance broker and risk adviser. With over 35000 colleagues operating in more than 130 countries Marsh serves commercial and individual clients with data driven risk solutions and advisory services. Marsh is a business of Marsh McLennan (NYSE: MMC) the leading global professional services firm in the areas of risk strategy and people. With annual revenue approaching US $17 billion and 76000 colleagues worldwide MMC helps clients navigate an increasingly dynamic and complex environment through four market-leading businesses: Marsh Guy Carpenter Mercer and Oliver Wyman. Follow Marsh on Twitter @MarshGlobal; LinkedIn; Facebook; and YouTube 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 and gender identity.

Click Here : Apply Now