IMS Mainframe Database Systems Programmer

Descripción

The Role

As an IMS Mainframe Database Systems Programmer , you will play a critical role in the deployment, management, and support of GM's global mainframe database infrastructure. Collaborating with database vendors, infrastructure teams, DBAs, and application developers, you will ensure the reliability, performance, and scalability of our mainframe database systems, including Db2 and IMS. This position involves implementing best practices, optimizing performance, and maintaining consistency across GM’s enterprise-wide mainframe database landscape.

Hybrid:   This position will be located onsite a minimum of three days per week in our Limerick office and 2 days from home.

Minimum Qualifications:

• 2 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.
• Provide 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 DBMS issues.  Experienced in troubleshooting, researching, and resolving multipart issues.
• Experienced in troubleshooting, researching, and resolving multipart issues.

• Owns and produces documentation. Ability to translate technical details into concise and easy to understand written form.
• Ability to translate technical details into work tasks.

• Ability to support systems in a 24x7 on-call rotation.
• Knowledge of using Db2 and or IMS commands to start and stop Db2 and or IMS, and manipulate Db2 and or IMS connections with other subsystems (including CICS, Db2, other IMS systems).

• Past experience having demonstrated zOS and associated product system installs, upgrades, de-installs, application of maintenance.

• Working knowledge of Db2 and or IMS system internals and configuration.

• Vendor interaction experience (including experienced in searching their knowledge databases).  Knowledge of and experience with IBMLINK.

General 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.

• Proven experience 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.

Preferred Qualifications:

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!

[Additional Description]

Información sobre diversidad

General Motors se compromete a ser un lugar de trabajo en el cual no solo no haya discriminación indebida, sino que fomente con sinceridad la inclusión y el sentido de pertenencia. Creemos firmemente que la diversidad del personal crea un entorno en el cual nuestros empleados pueden prosperar y desarrollar mejores productos para nuestros clientes. Instamos a los candidatos interesados a que revisen las responsabilidades y aptitudes clave para cada puesto y se postulen para los puestos que coincidan con sus habilidades y capacidades. Es posible que, cuando corresponda, se les pida a los solicitantes que están en el proceso de contratación que completen satisfactoriamente una o más evaluaciones relacionadas con su función y/o una evaluación previa al empleo antes de comenzar a trabajar.  Para obtener más información, visite Cómo contratamos.

Declaración de igualdad de oportunidades en el empleo (EE.UU.)

General Motors se enorgullece de ser un empleador que ofrece igualdad de oportunidades.  Todos los solicitantes calificados serán tenidos en cuenta para el empleo sin distinción de raza, color, religión, sexo, orientación sexual, identidad de género, nacionalidad, discapacidad o condición de veterano protegido. 

Adecuaciones (EE.UU. y Canadá)

General Motors ofrece oportunidades a todos los solicitantes de empleo, incluyendo las personas con discapacidades. Si necesita una adecuación razonable para ayudarle con su búsqueda o solicitud de empleo, envíenos un correo electrónico a Careers.Accommodations@GM.com o llámenos al 800-865-7580. En su correo electrónico, incluya una descripción del puesto específico que está solicitando, así como el título del empleo y el número de solicitud del puesto que está solicitando.