MMC is seeking candidate for SQL Server Database Administrator to be in Liverpool office or in any other local UK offices on a hybrid schedule of 3 days a week in office
* Able to work Independently with least supervision
* Work closely with offshore team to ensure smooth transition of work handover if required
* Hands on experience in resolving configuration / performance issues.
* Understanding of active-active cluster
* DR Failover knowledge.
* Knowledge of T-SQL & PowerShell scripting is an asset
What you need to have :
* Previous DBA experience working with SQL Server versions 2016 and above.
* Experience in Installation and configuration of SQL server, SSRS, SSIS & SSAS of SQL Version 2016 and higher
* Involvement in making recommendations involving capacity planning
* Planning for backup and recovery of databases
* Configure LogShipping, Mirroring, Clustering
* Hands on experience with Implementation of TDE. Knowledge or experience with Azure Key Vault will be an asset
* Experience in index tuning, performance counters and query store
* T-SQL & PowerShell scripting is an asset
* Good knowledge of active-active cluster, data partitioning, multi-thread environment
* Troubleshooting DB related alerts
* Role requires to be on a On-call rotation over the weekend.
What will make you stand out :
* Disaster Recovery and Business continuity tooling and processes knowledge
* Can work on complex problems that require conceptualizing & reasoning.
* Good communication and writing skills.
* Enjoys working in fast pace ever changing work environment.
* Troubleshooting Always On issues
Marsh McLennan (NYSE : MMC) is the world's leading professional services firm in the areas of risk, strategy and people.
The Company's 85,000 colleagues advise clients in 130 countries. With annual revenue of over $20 billion, Marsh McLennan helps clients navigate an increasingly dynamic and complex environment through four market-leading businesses. Marsh provides data-driven risk advisory services and insurance solutions to commercial and consumer clients. 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 well being 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 marshmclennan.
* This position is for an established and productive professional individual contributor in Information Technology, who works independently with minimal supervision.
* We are a large team who together, across the AUS, UK, Canada & US are responsible for significant databases & project related to our Oracle environment.
* We are offering an emerging and varied role, with a stimulating range of duties and responsibilities.
* A hybrid work environment that includes 3 days in office and 2 days work from home.
What is in it for you :
* A company with a strong Brand and strong results to match.
* A competitive compensation package, full benefits package starting on day one including medical, dental, vision, STI, LTI, life insurance and a generous employer matched pension plan.
We also allow staff the ability to participate in our employee stock purchase plan.
* Generous time off allowances including vacation days, floating holidays and personal days. We also allow colleagues the ability to get a jump start on their long weekends with early close days.
* Access to our employee resource groups which provides career growth and mentoring opportunities with counterparts in industry groups and client organizations.
You can be assured that there is always an opportunity to learn and grow with Marsh. Hybrid positions which provide the opportunity to work from both in the office and your home.