Apply Now    

GTI - GSO DB2 DBA (Bangalore or Hyderabad)

Job Description


 

GTI GSO- MSSQL DBA
         
 
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/.
 
Description
 
Global Services Operations (GSO) - is responsible for service support and delivery for JPMorgan Chase's Global Technology Infrastructure (GTI). Through its Global Service Desk and Infrastructure Operations Centers, GSO provides global, coordinated diagnostic and support services, while Production Assurance and Support functions leverage and execute industry-leading infrastructure management and support processes that are designed to minimize customer outages and impacts.
 
MSSQL Database administrator required to work in a global support team supporting GSO servers. This is a permanent staff position.
 
As a Database Administrator, you will administer, maintain and utilize policies and procedures for ensuring the security and integrity of the databases. Implement data models and database designs, data access and table maintenance codes; resolve database performance issues, database capacity issues, replication, and other distributed data issues. Support production DBA in daily or emergency procedures to resolve issues.
 
You will work with the Information Architect and Database Designer to help implement the physical data model. Help develop and validate the database implementation plan. Create database objects and maintain their physical organization/relationships. Support the data loads into the databases. Ensure that the application, and any enhancements, interact efficiently with the database. Develop and implement database performance monitoring process and analyze monitoring data for performance optimization opportunities. Create/Implement database maintenance plan to ensure data integrity. Manage the on-site backup and recovery process and/or support the off-site backup and recovery teams· Plan for and execute any required database upgrades and migration (patches etc.)
 
 
 
 
 
 
Working Hours
Staff will be required to work 5 days a week (Friday to Tuesday) for 9 hour a day. Staff will be required to work either of ASIA or EMEA shifts including public holidays which will be compensated with days in lieu and weekend support on rotational basis.
 
Scope and Mandatory Technical Skills
 
 
  • Responsible for SQL Database Production and non production database infrastructure and support.
  • Ability to architect, design and configure large, complex databases with replication and high-availability on the most current MSSQL versions.
  • Translate comprehensive DB architecture, implementation and upgrade plans and assists in definition of database standards, policies, and procedures.
  • Lead data requirements, architecture review, and modeling sessions.
  • Primary contact for projects within the team, interfacing with project managers, application development staff and executive management.
  • Project based infrastructure and Execute database software installation (SQL Server 2008 & 2012 cluster), database creations/configurations and loads.
  • Maintenance and support of SQL server Mirroring, Log shipping, Clustering, and other methods of disaster recovery.
  • Day-to-day production operations (incident break/fix, change, service requests, vulnerability management).
  • Production and non production patch/upgrade management.
  • Weekend work will need to be undertaken.
  • Customer support & communications.
  • Minimum of 7 years of experience with a Relational Database Administration in a production environment.
  • Experience with SQL server clusters with multiple nodes on each cluster mirroring and other methods of disaster recovery.
  • Knowledge of advance features of sql server 2008 and working knowledge of SQL 2012
  • Migration of Microsoft SQL databases from one platform to another
  • Solid experience with SQL server 2008 cluster installation and configuration.
  • Experience with SSIS packages, SSRS and SSAS.
  • Knowledge of SAN and Responsible for data loading, security, performance monitoring and tuning, capacity planning, and backup and recovery.
  • Solid skills in database performance fine tuning and optimizing poorly performing queries, stored procedures.
  • Good analytical and problem solving skills
  • Good communication skills for providing documentation to support personnel, customers, and managers
  • Good leadership skills to guide and mentor the work of less experienced personnel
  • Ability to work in a team environment
  • Ability to anticipate problems and take decisive action
   
Experience Required
 
Excellent technical knowledge gained from hands on role within a global organization
 
Qualifications/Education Preferred
 
  • Bachelor’s degree in Computer Science or related discipline.
  • Minimum of degree level education
  • ITIL Knowledge
  
Personal
 
  • Self-starter with ability to acquire new skills autonomously
  • Demonstrate good written and verbal communication skills in English language
 
 
 
 
GTI GSO- MSSQL DBA
         
 
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/.
 
Description
 
Global Services Operations (GSO) - is responsible for service support and delivery for JPMorgan Chase's Global Technology Infrastructure (GTI). Through its Global Service Desk and Infrastructure Operations Centers, GSO provides global, coordinated diagnostic and support services, while Production Assurance and Support functions leverage and execute industry-leading infrastructure management and support processes that are designed to minimize customer outages and impacts.
 
MSSQL Database administrator required to work in a global support team supporting GSO servers. This is a permanent staff position.
 
As a Database Administrator, you will administer, maintain and utilize policies and procedures for ensuring the security and integrity of the databases. Implement data models and database designs, data access and table maintenance codes; resolve database performance issues, database capacity issues, replication, and other distributed data issues. Support production DBA in daily or emergency procedures to resolve issues.
 
You will work with the Information Architect and Database Designer to help implement the physical data model. Help develop and validate the database implementation plan. Create database objects and maintain their physical organization/relationships. Support the data loads into the databases. Ensure that the application, and any enhancements, interact efficiently with the database. Develop and implement database performance monitoring process and analyze monitoring data for performance optimization opportunities. Create/Implement database maintenance plan to ensure data integrity. Manage the on-site backup and recovery process and/or support the off-site backup and recovery teams· Plan for and execute any required database upgrades and migration (patches etc.)
 
 
 
 
 
 
Working Hours
Staff will be required to work 5 days a week (Friday to Tuesday) for 9 hour a day. Staff will be required to work either of ASIA or EMEA shifts including public holidays which will be compensated with days in lieu and weekend support on rotational basis.
 
Scope and Mandatory Technical Skills
 
 
  • Responsible for SQL Database Production and non production database infrastructure and support.
  • Ability to architect, design and configure large, complex databases with replication and high-availability on the most current MSSQL versions.
  • Translate comprehensive DB architecture, implementation and upgrade plans and assists in definition of database standards, policies, and procedures.
  • Lead data requirements, architecture review, and modeling sessions.
  • Primary contact for projects within the team, interfacing with project managers, application development staff and executive management.
  • Project based infrastructure and Execute database software installation (SQL Server 2008 & 2012 cluster), database creations/configurations and loads.
  • Maintenance and support of SQL server Mirroring, Log shipping, Clustering, and other methods of disaster recovery.
  • Day-to-day production operations (incident break/fix, change, service requests, vulnerability management).
  • Production and non production patch/upgrade management.
  • Weekend work will need to be undertaken.
  • Customer support & communications.
  • Minimum of 7 years of experience with a Relational Database Administration in a production environment.
  • Experience with SQL server clusters with multiple nodes on each cluster mirroring and other methods of disaster recovery.
  • Knowledge of advance features of sql server 2008 and working knowledge of SQL 2012
  • Migration of Microsoft SQL databases from one platform to another
  • Solid experience with SQL server 2008 cluster installation and configuration.
  • Experience with SSIS packages, SSRS and SSAS.
  • Knowledge of SAN and Responsible for data loading, security, performance monitoring and tuning, capacity planning, and backup and recovery.
  • Solid skills in database performance fine tuning and optimizing poorly performing queries, stored procedures.
  • Good analytical and problem solving skills
  • Good communication skills for providing documentation to support personnel, customers, and managers
  • Good leadership skills to guide and mentor the work of less experienced personnel
  • Ability to work in a team environment
  • Ability to anticipate problems and take decisive action
   
Experience Required
 
Excellent technical knowledge gained from hands on role within a global organization
 
Qualifications/Education Preferred
 
  • Bachelor’s degree in Computer Science or related discipline.
  • Minimum of degree level education
  • ITIL Knowledge
  
Personal
 
  • Self-starter with ability to acquire new skills autonomously
  • Demonstrate good written and verbal communication skills in English language
 
 
 
Req #: 160031267
Location: Bangalore East, KA IN
Job Category: Technology
Employment Type: Full Time
Potential Referral Amount: Indian Rupee (INR)

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.

Join Now

Privacy Statement

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 contact us by calling (US and Canada Only) 1-866-777-4690. Please indicate the specifics of the assistance needed.


Keep in touch

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