Skip To Content

Senior Mainframe Database Administrator

  • Emplacement
    • Limerick, Limerick
    • Warren, Michigan
  • Horaire Full time
  • Posté


About The Role:

From designing and building the next generation of electric and other vehicles to developing a world-class GM experience for our dealers and customers, GM IT is driving real change in the most iconic automaker on the planet. Our team delivers unique enterprise-wide IT solutions in cutting-edge technologies such as mobility, telematics, mission-critical business systems, supercomputing, cloud, vehicle engineering and real-time computing. We offer challenging positions for passionate professionals looking to advance their careers and be a part of an IT organization focused on innovation, speed, and business value.

GM Information Technology is seeking to attract experienced and proven technical experts in various Mainframe technology areas that support our long-term strategic plans to further leverage the efficiencies possible with IBM Parallel Sysplex. The team is responsible for maintenance, performance optimization, capacity management, master scheduling, service continuity, implementation of global monitoring and automation solutions, and driving best-in-class availability across GM’s mainframe platforms.

In recent years, GM Information Technology has successfully executed the largest IT transformation in the history of the automotive industry, fully insourcing what once was a nearly completely outsourced IT function. The GM Mainframe team have re-platformed all Mainframe applications from the insourced lpars to new data sharing Sysplex environments.

Mainframe Database Administrators will work with other organizations in the deployment, management, and support of all mainframe Db2 for z/OS and IMS databases world-wide. This includes but is not limited to working closely with database vendors, infrastructure groups, other DBAs, and application teams to proactively install, monitor, manage, control, and upgrade consistently across GM’s mainframe database landscape. This individual will be responsible for understanding capacity requirements, implementation of global monitoring and automation solutions, providing DBMS expertise to application teams, implementing SOX controls, measuring performance, and driving best-in-class availability across GM’s mainframe database platforms.

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!

Ideal Candidate:

  • Leader in the mainframe space.  Ability to articulate and document mainframe product roadmap and bring a team on that journey.
  • Provides thought leadership and Technical Architect support for HW and SW solutions
  • Experience in the wider IT infrastructure and the interfaces with the z/OS platform (e.g. APIs/CICD software development pipelines/Linux)
  • The ability to translate product roadmaps to real business value.

Preferred Attributes:

  • 5+ years’ relevant technical experience
  • An Arts/Science degree or STEM qualification advantageous.
  • Expertise in Db2 for z/OS version 12 and IMS version 15
  • Extensive technical knowledge of Db2 for z/OS including backup; recovery; reorganizations; universal table spaces; performance and tuning; application tuning; SQL tuning; SPUFI; explains; LOBs; DDF; DDL; partitioning / clustering; indexing
  • Extensive technical knowledge of IMS including backup; recovery; reorganizations; performance and tuning; application tuning; DBD, PSB, ACB, and MFS generation; sparse indexing; HALDBs; Dynamic Resource Definition; DBRC, logical relationships
  • Experience in z/OS, TSO, ISPF, JCL, RACF, OMEGAMON, IBM Z Workload Scheduler, RACF, SDSF
  • Experience with data modeling and database design methodologies
  • Excellent analytical, problem solving, written and oral communication skills
  • Knowledge on how to support very large databases with heavy on-line and batch activities
  • Ability to concentrate and pay close attention to detail
  • Great team player

Additional Description

Technical Expectations:

  • Expertise working with application development teams in large, complex organizations
  • Experience and familiarity with IT best practices (e.g., ITIL, CMMI, ISO9000, COBIT)
  • Global Information Tracker
  • IBM Data Studio
  • IBM Data Virtualization Manager
  • IBM Db2 Administration
  • IBM Db2 and IMS Connect
  • IBM Db2 and IMS utilities
  • IBM Db2 Log Analysis Tool
  • IBM Db2 SQL Performance Analyzer
  • IBM Developer for z/OS
  • IBM IMS Performance Analyzer
  • IBM InfoSphere Data Replication Change Data Capture
  • IBM Modernize IT Operations Management
  • IBM Query Monitor
  • IBM UrbanCode Deploy
  • IBM Z Workload Scheduler
  • IBM’s InfoSphere Replication Server for z/OS
  • IMS Explorer
  • InfoSphere Optim for Db2 for z/OS
  • Understanding/experience in an Agile (scrum), and/or iterative development methodology

Hybrid: Position does not require an employee to be on-site full-time but the general expectation is that the  employee be onsite an average of three (3) days each week