MSSQL DBA - Associate - Bournemouth or Glasgow - 140113756 - Bournemouth

This job has now expired please search on the home page to find live IT Jobs.

Description

J.P. Morgan's Corporate & Investment Bank is a global leader across banking, markets and investor services. The world's most important corporations, governments and institutions entrust us with their business in more than 100 countries. With $18 trillion of assets under custody and $393 billion in deposits, the Corporate & Investment Bank provides strategic advice, raises capital, manages risk and extends liquidity in markets around the world.

Role

Member of an existing Database Services team who can work with development and Production teams on support of a busy and critical environment involving code reviews, SQL support, change request validation, permissioning analysis, dataserver and SQL performance analysis & tuning, maintenance of monitoring scripts and contribution to projects such as new builds and upgrades.

Responsibilities

- Builds/Upgrades

- Working with the Development teams - Design & Code Reviews, SQL support, Change Request validation

- MSSQL Performance Analysis & Tuning, including maintenance of monitoring scripts and reporting their results

- Work with other team members, Database Administrators and Application Delivery teams to drive improvement in the processes and tools used

- Implementing new upcoming projects.

- Writing Tools and Utilities

- Control-based remediation work e.g. permissioning analysis, new logins

Essential skills

- Significant experience supporting MS SQL Server environments.

- Strong experience in Database Administration in SQL Server ( 2005, 2008 & 2012 )

- Strong knowledge of backups, restores, recovery models, database shrink operations, DBCC commands, Clustering, Database mirroring, Replication.