Apply Now    

MS SQL Database Manager

Req #: 170105744
Location: Bournemouth, ENG, UK
Job Category: Technology
Potential Referral Amount: 3500 Pound Sterling (GBP)
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.  Further information about J.P. Morgan is available at http://www.jpmorgan.com/.
 
Role
 
This position is for an experienced Microsoft SQL Server database administrator (DBA).  The candidate must have the ability to configure and maintain large, complex databases with replication and high-availability on the most current MSSQL versions.  The candidate must also have the ability to translate logical to physical designs, develop comprehensive DB architectures, implementation and upgrade plans, and assist in defining database standards, policies, and procedures. 
 
This position will be responsible to resolve all database related issues and work closely with the Application Support, Development and Project Management teams. The successful candidate will be able to diagnose and complex technical and procedural database issues, and then deploy solutions at scale across a large portfolio of MSSQL instances.
 
Responsibilities
 
• Support production systems as part of a 24/7 follow-the-sun support team
• Deliver high quality solutions to incidents that involve full diagnosis, understanding of root cause and quality implementation of fixes
• 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 Support teams to drive improvement in the processes and tools used
• Upgrades of existing deployments to the latest MSSQL versions
• Writing Tools and Utilities to eliminate repeatable manual processes
Essential skills 
 
• Significant experience supporting MS SQL Server environments.
• Strong experience in Database Administration in SQL Server ( 2005, 2008, 2012, 2014 )
• Strong knowledge of backups, restores, recovery models, database shrink operations, DBCC commands, Clustering, Database mirroring, Replication.
• Good understanding of SSRS, SSIS & SSAS
• In-depth Transact-SQL & Stored Procedure Development
• Good understanding of Powershell Scripting.
• Query/Index Performance Tuning
• Physical Data Modelling
• Windows NT/XP, and Office products (Word, Excel, Notes)
• Good communication skills
• Database Release Management techniques
 
Preferable Skills
 
• Knowledge of Python.
• Understanding of APIs and API development
• Understanding of Agile and it’s concepts
• Web development - basic HTML/XML, CGI, VBscript, JavaScript
 
 
Apply Now    

Join our Talent Community

Not ready to apply? Leave your information with us and we will keep you up to date with new career opportunities.

Things to note

Sign in to our application system to continue your job search or update your profile.

Current employees sign in here. Contractors sign in here.

Any information you provide is confidential and will only be viewed by our recruiters in an effort to fill open positions. In addition, the information you provide is subject to our privacy policy practices.

Please note that J.P. Morgan will not accept unsolicited approaches or speculative CVs, nor will J.P. Morgan be responsible for any related fees, from Third Party Firms who are not preferred suppliers.

The firm invites all interested and qualified candidates to apply for employment opportunities.

Need disability related assistance?

If you are a US or Canadian applicant with a disability who is unable to use our online tools to search and apply for jobs, please click here.

Important links

Click here to view the "EEO is the Law" poster.

Click here to view the "EEO is the Law" supplemental poster.

Click here to view our U.S. Pay Transparency Policy.

JPMorgan Chase is an equal opportunity and affirmative action employer Disability/Veteran.