Senior Mainframe Systems Programmer - DB2 Physical

whether it's public, multi or hybrid cloud, or mainframe. And because we span across all mission-critical platforms, we can meet you wherever you are in your digital transformation journey, with 24/7 support when you need it. We are your relentless ally, flexing with you when challenges emerge so you don't feel stuck in place. With cross-platform certifications and decades of experience, our technology experts have become an extension of your team so you're continuously innovating - doing more with less while remaining secure. And that's just the beginning.

About Role

• Fulfill customer service requests for mainframe z/OS customers in a timely manner as they pertain to Mainframe DB2 database and related products

• Provide primary support for reported problems related to DB2 and related software products

• Provide key support for customer migration services (new customer transitions) as they pertain to DB2 and related OEM software products.

• Provide primary support for reported problems related to DB2 tables spaces

• Communicate to both customer and management the status of issues at intervals during resolution process.

Responsibilities

• Maintain documentation of issue cause, action, and resolution in the designated problem tracking system.

• Assist the assigned project manager in the migration of newly acquired customers such that all technical hurdles are addressed in a timely manner and do not impede the expected progress of the transition nor the targeted migration date.

• In joint co-operation with the Disaster Recovery Services and other technical teams, successfully execute tasks associated with any given customer's disaster recovery plans.

• Adhere to a schedule that efficiently manages resources and allows timely implementations.

• Follow ITSM change control procedures

Experience level - 5 to 8 yrs

Mandatory Skills

• Bachelor's degree required and/or equivalent work experience.

• 8+ years of professional experience in DB2 for administration and systems programming support. CA and IBM tools for DB2 a plus

• Experience in building new DB2 subsystem environment

• Experience with configuring and managing DB2 in a parallel sysplex, DB2 Datasharing environments

• Ability to develop innovation, strategies, processes, and best practices in software management

• Experience with reviewing new versions of DB2 for functionality, advising how they benefit the client

• Ability to review DB2 security to find potential risks

• Experience with reorganization of application data

• Experience with reviewing, tuning of internal DB2 buffer pools and SQL code

• Experience with supporting DB2 security requests

• Support planned (disaster recovery) and unplanned (emergency) database recovery activities

• Knowledgeable in best practices of software management, maintenance, and documentation

• Experience with establishing policies and procedures pertaining to database management, DR, security, maintenance, and utilization

• Ability to evaluate change requests and determine impact to assigned clients and troubleshooting and solving production database issues.

• System programming knowledge of multiple Mainframe Database Management Systems is a bonus.

Good to have skills

• Self-motivated and able to work independently.

• Demonstrated ability to respond quickly and effectively to support requests from multiple clients

• Must be able to multi-task and work under short deadlines and in high pressure situations.

• Excellent communication skills (written, verbal and presentations)

• Ability to work as part of a team, as well as independently.

• Experience in installation/upgrade/customization of DB2 subsystem & related ISV software products

• SMPE Knowledge and experience

JR012518