Apply Now    

Database Management

Req #: 180017317
Location: New York, NY, US
Job Category: Technology
Potential Referral Amount: 0 US Dollar (USD)
 
As a DBA, the ideal candidate would be responsible for installing DB2 software and maintenance of enterprise databases; testing and applying DB2 fixpack updates; monitoring, managing, and maintaining backup and recovery schedules for database servers; and design and maintain data access control policies and ensure compliance with company audit policies.  The job also entails monitoring database performance and working with other team members to remove bottlenecks and improve overall performance, enforcing database policies and procedures, providing database administration for developers and team members.
 
Duties and Responsibilities:
  • Install ibm db2 software.
  • Assist in performing data migration from oracle platform to DB2 platform.
  • Create practice and maintain standard installation and setup procedures for database servers.
  • Maintain and facilitate standard backup procedures, retention plans, and restore testing.
  • Assist with data migration between systems including regular data refreshes and making production data anonymous for use in testing environments
  • Work pro-actively to gauge the performance of the application & database and provide recommendations to achieve the optimal architecture
  • Assess impact on performance with different changes and review scalability of the infrastructure.
  • Maintain standard procedural documentation related to all aspects of operating the database platforms.
  • Participate in incident resolution as an escalation point for database incidents.
  • Document known errors or workarounds in the shared Knowledge Base.
  • Consult with vendors & other teams to recommend best practices and tune software during the development cycle.
  • Recommend and maintain standards for monitoring and event management to be used in production databases.
  • Assist in tuning SQL in stored procedures.
  • Perform testing and production builds involving data changes and stored procedure building while following established change management procedures
  • Assume all DBA duties in testing and development environments, maintaining design and data consistency throughout
Qualifications
 
  • Computer Science degree or equivalent experience.
  • Proven 5+ years of DB2 Database Administration experience out of which minimum 1+ should be on DB2 10.x versions.
  • Some practical experience on Oracle Databases is desired (though not required).
  • Strong knowledge and hand-on experience on Q-replication is required.
  • Must know AIX versions 5.x and 6.x and specifics of DB2 operations on AIX.
  • History of managing multiple RDBMS in large environments in AIX environments.
  • Experience with redundancy and resiliency applied to create a high availability service.
  • Practical experience in monitoring and tuning a database.
  • Experience in working in a 24X7 environments and on-call support.
  • Strong interpersonal skills.
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.