Systems Programmer (DB2 and IMS Database)

Job description

**Job Description**

Hybrid: This role is categorized as hybrid.

This means the successful candidate is expected to report to the office three times per week, at minimum.

This role may be eligible for relocation benefits.

The Mainframe Systems Database Systems Programmer will work with other organizations in the deployment, management, and support of all mainframe databases worldwide.

This includes but is not limited to: working closely with database vendors, infrastructure groups, DBAs, and application teams to proactively install database software (Db2 and IMS), monitor, manage, control, and upgrade (configuration, patching, refresh) consistently across GM’s mainframe database landscape.

This individual will be responsible for performance optimization, capacity management, master scheduling, resolving production control issues and DBMS problems, implementation of global monitoring and automation solutions driving best-in-class availability across GM’s mainframe database platforms.

**Minimum Qualifications:**

+ 3+ years of professional experience in this specific role and a Bachelor of Engineering/Arts/Science or equivalent degree in computer science or related area of study.

Without a degree or professional experience in this specific role/area will require 3 additional years of relevant professional experience.
+ Provides global support for Db2 and or IMS (Transaction and Database) products and Level 3/4 support for software delivery teams.

Responsible for implementing part or all of the technical solution in accordance with an agreed technical design.

Provides technical support and input on the application of technology to a defined business segment.

Ensures project learning’s are documented and shared.

Solves assorted and involved IMS issues.

Experienced in troubleshooting, researching, and resolving multipart issues.
+ Minimum 3 years experience as a Db2 and or IMS Systems Programmer
+ Owns and produces documentation.

Ability to translate technical details into concise and easy to understand written form.
+ Ability to support systems in a 24x7 on-call rotation.
+ Knowledge of and experience with using Db2 and or IMS commands to start and stop Db2 and or IMS , alter buffer pools, perform recovery, list threads and determine their status, manipulate Db2 and or IMS connections with other subsystems (including CICS, Db2 , other IMS systems).
+ Past experience having demonstrated Db2 and or IMS and associated product system installs, upgrades, de-installs, application of maintenance.
+ Knowledge of Db2 and or IMS security.
+ Working knowledge of Db2 and or IMS system internals and configuration.
+ Working knowledge of IBM Db2 SQL Performance Analyzer and IBM Query Monitor.

Demonstrable via past experience ability to utilize to inspect the performance of a Db2 and or IMS subsystem and determine where tuning is needed and the type of tuning needed.
+ Experienced with Disaster Recovery (system backup and restore, DR plan creation and maintenance).

Knowledge of how to prepare Db2 and or IMS for disaster recovery and specific steps needed to recover a Db2 and or IMS subsystem at an alternate site.
+ Vendor interaction experience (including experienced in searching their knowledge databases).

Knowledge of and experience with IBMLINK.

**Preferred Qualifications:**

+ Highly skilled with the standard z/OS tools: TSO/ISPF, JCL, VSAM Utilities, SDSF, SYSLOG, IEBCOPY, DFSMS, etc.

Specific skills are ability to code JCL, ability to use TSO/ISPF panels to edit and maintain PDS libraries, prepare JCL, submit JCL and examine results.

Db2 and or IMS knowledge and experience with: recover, back up, diagnostic, and other utilities.
+ Experience with defining, deleting, and managing VSAM datasets.
+ Proficient with SMP/E (commands, terminology, problem determination).

Ability to use SMP/E to apply maintenance, perform installs, and maintain SMP/E environments.
+ Experienced with REXX and CLIST programming with examples of code available on request.
+ Skilled with security package (and RACF).
+ In depth understanding of the z/OS subsystems, JES2, FTP, SDSF, CA-1 (or equivalent), DASD Storage concepts and the command usage relating to these system components.

Includes knowledge of job submission, priority, and performance with WLM in a z/OS system.

Utilization of tape and virtual tape and DASD including coding of necessary JCL.
+ Working knowledge of IBM Z Workload Scheduler.

Ability to manipulate scheduling tool using commands to place jobs in the schedule and maintain changes to the job schedule.
+ Batch ABEND resolution: problem determination using SYSLOG and job output, ability to look up ABEND codes and determine corrective action, job restart experience, and preventive action to eliminate future re-occurrence.
+ Subsystem Problem Determination (identify, escalate and diagnose).

Demonstrated skills in diagnosis of problems: where to look, how to determine root cause, how to correct specific problems, preventive action.

All demonstrable via examples of having done so in the past.
+ z/OS terminology & concepts: For example: Linklst, APFlist, Paging, Virtual storage, SMF
+ Strong ability to utilize system diagnostics to arrive at problem solutions (Messages and Codes, dumps, console messages, etc.)
+ System Console skills – understanding of what they’re seeing in SYSLOG and what it means.

Able to identify error messages and how to look up their meaning.
+ Appetite to embrace AI tools, Slack integration with processes, and progressive outlook for the mainframe platform ecosystem overall.

Expertise in:

+ IBM’s InfoSphere Replication Server for z/OS
+ IBM InfoSphere Data Replication Change Data Capture
+ IBM Data Virtualization Manager
+ IBM Db2 and IMS utilities
+ BMC Db2 and IMS utilities
+ IBM Z Workload Scheduler
+ Experience and familiarity with IT best practices (e.g., CMMI, ISO9000, ITIL, COBIT)

**Why General Motors?**

At GM, we’ve charged ourselves with one mission: to design, build and sell the world’s best vehicles with Zero Crashes, Zero Emissions, and Zero Congestion.

GM IT is a leader in cutting edge technologies such as Mobility, Telematics, Mission-Critical Business Systems, Supercomputing, Vehicle Engineering, and Real-time Computing.

We offer challenging positions for passionate professionals to work in an organization with a laser focus on Innovation, Speed, and Business Value.

Join our team and experience Information Technology at a scale and pace not seen before!



**About GM**

Our vision is a world with Zero Crashes, Zero Emissions and Zero Congestion and we embrace the responsibility to lead the change that will make our world better, safer and more equitable for all.

**Why Join Us**

We believe we all must make a choice every day – individually and collectively – to drive meaningful change through our words, our deeds and our culture.

Every day, we want every employee to feel they belong to one General Motors team.

**Benefits Overview**

From day one, we're looking out for your well-being–at work and at home–so you can focus on realizing your ambitions.

Learn how GM supports a rewarding career that rewards you personally by visiting Total Rewards resources (https://search-careers.gm.com/en/working-at-gm/total-rewards) .

**Non-Discrimination and Equal Employment Opportunities (U.S.)**

General Motors is committed to being a workplace that is not only free of unlawful discrimination, but one that genuinely fosters inclusion and belonging.

We strongly believe that providing an inclusive workplace creates an environment in which our employees can thrive and develop better products for our customers.

All employment decisions are made on a non-discriminatory basis without regard to sex, race, color, national origin, citizenship status, religion, age, disability, pregnancy or maternity status, sexual orientation, gender identity, status as a veteran or protected veteran, or any other similarly protected status in accordance with federal, state and local laws.

We encourage interested candidates to review the key responsibilities and qualifications for each role and apply for any positions that match their skills and capabilities.

Applicants in the recruitment process may be required, where applicable, to successfully complete a role-related assessment(s) and/or a pre-employment screening prior to beginning employment.

To learn more, visit How we Hire (https://search-careers.gm.com/en/how-we-hire) .

**Accommodations**

General Motors offers opportunities to all job seekers including individuals with disabilities.

If you need a reasonable accommodation to assist with your job search or application for employment, email (Careers.Accommodations@GM.com) us or call us at 800-865-7580.

In your email, please include a description of the specific accommodation you are requesting as well as the job title and requisition number of the position for which you are applying.

We are leading the change to make our world better, safer and more equitable for all through our actions and how we behave.

Learn more about:

**Our Company (https://search-careers.gm.com/en/working-at-gm/)**

**Our Culture**

**How we hire​​​​​​​ (https://search-careers.gm.com/en/how-we-hire/)**

Our diverse team of employees bring their collective passion for engineering, technology and design to deliver on our vision of a world with Zero Crashes, Zero Emissions and Zero Congestion.

We are looking for adventure-seekers and imaginative thought leaders to help us transform mobility.

Explore our global locations (https://search-careers.gm.com/en/locations/)

We are determined to lead change for the world through technology, ingenuity and harnessing the creativity of our diverse team.

Join us to help lead the change that will make our world better, safer and more equitable for all by becoming a member of GM’s Talent Community (beamery.com) (https://flows.beamery.com/generalmotors/talcom) .

As a part of our Talent Community, you will receive updates about GM, open roles, career insights and more.

Please note that filling out the form below will not add you to our Talent Community automatically; you will need to use the link above.

If you are seeking to apply to a specific role, we encourage you to click “Apply Now” on the job posting of interest.
The policy of General Motors is to extend opportunities to qualified applicants and employees on an equal basis regardless of an individual's age, race, color, sex, religion, national origin, disability, sexual orientation, gender identity/expression or veteran status.

Additionally, General Motors is committed to being an Equal Employment Opportunity Employer and offers opportunities to all job seekers including individuals with disabilities.

If you need a reasonable accommodation to assist with your job search or application for employment, email us at Careers.Accommodations@GM.com .In your email, please include a description of the specific accommodation you are requesting as well as the job title and requisition number of the position for which you are applying.

Required Skill Profession

Other General