Talent.com
E-Solutions
DB2 Systems ProgrammerE-Solutions • Frisco, TX, United States
DB2 Systems Programmer

DB2 Systems Programmer

E-Solutions • Frisco, TX, United States
3 days ago
Job type
  • Full-time
Job description
Role :- DB2 Systems Programmer

Location :- Salisbury, NC/Boston, MA/Frisco, TX

Note :- please submit senior profiles minimum experience 15+yrs.

Please focus on the Highlighted points & share only senior profiles.

DB2 Systems programmer: L3

Job Summary: We are seeking a highly skilled and dedicated Mainframe DB2 Systems Programmer to join our core infrastructure team. This critical role involves the installation, maintenance, and upgrade of IBM DB2 for z/OS subsystems, ensuring their optimal performance, availability, and stability. The successful candidate will work closely with DB2 DBAs, z/OS Systems Programmers, application development teams, and operations staff to provide expert-level support for our enterprise-wide DB2 environment.

Key Responsibilities:
  • DB2 Subsystem Management:
  • Plan, prepare, and execute DB2 for z/OS subsystem installations, upgrades, and migrations (e.g., from DB2 12 to DB2 13, or between Function Levels).
  • Apply IBM DB2 maintenance (PTFs, APARs, SPEs) regularly using SMP/E to ensure system integrity, resolve issues, and enhance functionality.
  • Configure and maintain DB2 PARMLIB, DSNZPARM, and other critical DB2 initialization parameters.
  • Perform DB2 subsystem restarts (IPLs, Quiesce/Start) as required for maintenance and configuration changes.
  • DB2 Tool and Utility Support:
  • Install, configure, upgrade, and maintain IBM DB2 utilities (e.g., REORG, RUNSTATS, COPY, LOAD, UNLOAD).
  • Install and support various Independent Software Vendor (ISV) tools for DB2 (e.g., BMC DB2 tools, Broadcom/CA DB2 tools, IBM DB2 Admin Tool, IBM Data Studio, etc.) used for performance monitoring, backup/recovery, administration, and development.
  • Troubleshoot issues related to DB2 utilities and ISV tools.
  • Performance Monitoring and Tuning:
  • Monitor DB2 subsystem health, performance, and resource utilization using tools like Omegamon for DB2, DB2 PM, SMF, RMF, and other performance monitors.
  • Analyze performance data to identify bottlenecks within DB2 and recommend tuning improvements at the subsystem, buffer pool, and thread level.
  • Assist DBAs and application teams in optimizing SQL queries and application performance.
  • Problem Diagnosis and Resolution:
  • Provide expert-level support for DB2 incidents, including problem determination, diagnosis (e.g., analyzing dumps, logs, traces), and resolution in a timely manner.
  • Collaborate with IBM support and ISV vendors to resolve complex issues.
  • Participate in on-call rotation for 24/7 support of critical DB2 environments.
  • Collaboration and Coordination:
  • Work closely with DB2 DBAs to understand their requirements, provide technical guidance, and ensure the smooth operation of database environments.
  • Collaborate with z/OS Systems Programmers on shared resources, system-level issues, and overall mainframe health.
  • Liaise with application development teams for DB2-related changes, new application deployments, and problem resolution.
  • Coordinate with mainframe operations for scheduled maintenance and incident response.
  • Automation and Scripting:
  • Develop and maintain JCL, REXX, CLISTs, and other scripts for DB2 administration, monitoring, and automation tasks.
  • Disaster Recovery and Business Continuity:
  • Assist in the planning, testing, and execution of disaster recovery procedures for DB2 subsystems.
  • Ensure the high availability and recoverability of critical DB2 environments.
  • Documentation and Best Practices:
  • Create and maintain comprehensive documentation for DB2 installations, configurations, operational procedures, and troubleshooting guides.
  • Adhere to ITIL best practices for change management, incident management, and problem management within the DB2 domain.
  • Security and Compliance:
  • Implement and enforce security best practices within DB2, working with security administrators (RACF/ACF2/Top Secret) to define and manage DB2 security profiles.
  • Ensure compliance with internal security policies and external regulatory requirements for DB2 data.
Required Skills and Experience:
  • 5-8 years of hands-on experience as a Mainframe DB2 Systems Programmer.
  • In-depth knowledge and hands-on experience with IBM DB2 for z/OS installation, configuration, maintenance, and migration (preferably including recent versions like DB2 12 or 13).
  • Strong proficiency in JCL, TSO/ISPF, and SMP/E.
  • Extensive experience with IBM DB2 utilities (COPY, RECOVER, REORG, RUNSTATS, LOAD, UNLOAD).
  • Proven experience with installation and support of leading DB2 ISV tools (e.g., BMC DB2 tools, Broadcom/CA DB2 tools, IBM DB2 Admin Tool, Omegamon for DB2).
  • Solid understanding of DB2 architecture, data sharing, buffer pool management, and logging.
  • Experience with DB2 performance monitoring, tuning, and problem diagnosis (e.g., reading traces, interpreting DSNZPARM settings).
  • Ability to read and interpret DB2 dumps for problem determination.
  • Proficiency in REXX, CLISTs, or other scripting languages for automation.
  • Familiarity with z/OS operating system fundamentals, including JES2/JES3, SMS, VSAM.
  • Excellent analytical, problem-solving, and troubleshooting skills.
  • Strong communication (written and verbal) and interpersonal skills, with the ability to collaborate effectively with various teams.
  • Ability to work independently and manage multiple priorities in a dynamic environment.
Desired Skills and Experience (Plus Points):
  • Experience with Parallel Sysplex and DB2 Data Sharing environments.
  • Knowledge of IBM MQ for z/OS, IMS, or CICS connectivity with DB2.
  • Experience with DB2 DDF (Distributed Data Facility) and remote connectivity.
  • Certifications related to DB2 for z/OS.
Create a job alert for this search

DB2 Systems Programmer • Frisco, TX, United States

Similar jobs

DB2 Z/OS SYSTEMS PROGRAMMER

Pyramid ConsultingPlano, TX, United States
Temporary

Chandler AZ / Jacksonville, FL or Plano, TX.Please review the job description below and contact me ASAP if you are interested.Employee benefits include, but are not limited to, health insurance (me... Show more

 • Promoted

DB2 DBA

Purple DrivePlano, TX, United States
Full-time

Transition from previous shift and get familiar with the ongoing things.Monitoring Dashboards and E-mail alerts.Investigating and Troubleshooting any issues or alerts that reports in the dashboards... Show more

 • Promoted

Infrastructure Middleware Specialist

StefaniniDallas, TX, United States
Full-time

Infrastructure Middleware Specialist.For quick apply, please contact Rahul Kumar; Ph: 248 936 5060.Deploys the release of new technologies as well as designs, installs, configures, maintains and pe... Show more

 • Promoted

Senior Engineer, Software Systems

Shield AIDallas, TX, United States
Full-time +1

Founded in 2015, Shield AI is a venture-backed deep-tech company with the mission of protecting service members and civilians with intelligent systems.Its products include the V-BAT and X-BAT aircr... Show more

 • Promoted

Algebra Private Tutoring Jobs McKinney

SuperprofMcKinney, Texas, US
Full-time +1

Superprof is the leading tutoring platform in the USA, connecting passionate individuals with eager learners.We operate in over 41 countries, making education accessible to everyone, everywhere.Sup... Show more

 • Promoted

DB2 Systems Programmer

E-SolutionsFrisco, TX, United States
Full-time

Role :- DB2 Systems Programmer.Location :- Salisbury, NC/Boston, MA/Frisco, TX.Note :- please submit senior profiles minimum experience 15+yrs.Please focus on the Highlighted points & share only se... Show more

 • Promoted

DB2 Systems Programmer / DBA - 100% Remote

Conexess Group, LLCAllen, TX, United States
Remote
Full-time

Job Title :DB Systems Programmer / DBALocation :% Remote (Must reside in one of the eligible states listed below)Eligible States :Alabama, Arkansas, Florida, Georgia, Iowa, Illinois, Indiana, Kentu... Show more

 • Promoted

Embedded Linux Software Engineer

Planmeca USA Inc.Dallas, Texas, United States
Full-time

Embedded Linux Software Engineer / Embedded Software Engineer.Planmeca is one of the largest privately-held dental equipment companies in the industry.Our technology-driven product line includes d... Show more

 • Promoted

Mainframe DB2 Administrator

MDA EdgeDallas, TX, United States
Full-time

Mainframe Architect with expertise in z/OS System Administration, Production Control, Scheduling, Storage, Network, DB2, IMS, CICS, MQ, WAS, RACF, Performance & Capacity Management, and Automation.... Show more

 • Promoted

Mainframe DB2 System DBA

Tata Consultancy ServicesPlano, TX, United States
Full-time

Must Have Technical/Functional Skills.Install, upgrade, maintain and customize DB2 and its associated IBM and 3rd party software.Monitor DB2 on z/OS environment.Create, modify and maintain the DB2 ... Show more

 • Promoted

DB2 DBA

VeracityFrisco, TX, United States
Temporary

Job Location: Omaha, NE, Alpharetta, GA or Berkeley Heights, NJ, Frisco, TX (100% Onsite).Employment Type: FTE / 6 Month Contract to Hire.Key Technology: DB2, AIX, Linux, Windows.One of our major c... Show more

 • Promoted

COBOL IMS/DB2 Programmers

Thinkfind CorporationDallas, TX, United States
Full-time

Thinkfind is seeking a highly experienced Mainframe Programmer to support critical enterprise systems for our prestigious client.In this role, you will be responsible for designing, developing, and... Show more

 • Promoted

Mainframe DB2 Administrator Plano, TX

ESR HealthcarePlano, TX, United States
Full-time

If you post this job on a job board, please do not use company name or salary.Experience level: Mid Level (5-8 yrs exp.Experience required: 5 Years Education level: Bachelors degree Job function: A... Show more

 • Promoted

Mainframe DB2 System DBA

3B Staffing LLCMurphy, TX, United States
Full-time

Below is the requirement with my client.Please let me know if you are available for this role.Title: Mainframe DB2 System DBA.Install, upgrade, maintain and customize DB2 and its associated IBM and... Show more

 • Promoted

Mainframe DB2 Administrator

Macpower Digital Assets EdgePlano, TX, United States
Full-time

Mainframe Architect with expertise in z/OS System Administration, Production Control, Scheduling, Storage, Network, DB2, IMS, CICS, MQ, WAS, RACF, Performance & Capacity Management, and Automation.... Show more

 • Promoted

COBOL Programmer

SelectMindsDallas, TX, United States
Full-time

Job Title: COBOL AS/400 Programmer Location: Remote (Must work PST hours) Travel: Up to 3 days per month onsite (expenses covered) Experience Level: 12+ years required.We are seeking an experienced... Show more

 • Promoted • New!

Mainframe DB2 System DBA

United IT SolutionsMurphy, TX, United States
Full-time

Title: Mainframe DB2 System DBA.Must Have Technical/Functional Skills.Install, upgrade, maintain and customize DB2 and its associated IBM and 3rd party software.Monitor DB2 on z/OS environment.Crea... Show more

 • Promoted

Mainframe DB2 System DBA

Nexiva Incplano, TX, United States
Full-time
Quick Apply

MailAutoSig">Hello There,</a></p> <p> </p> <p>My name is <b>Himanshu</b>, and I serve as the <b>Recruitment Manager</b> at <b>N... Show more

Senior Systems Engineer - Cloud & DevOps

Business Network Consulting, Ltd.Dallas, Texas, United States
$100,000.00 yearly
Full-time

Salary: $100,000 - 130,000 per year.Minimum of 5 years of consulting experience, managing multiple clients, ideally in the SMB sector.At least 5 years working in a senior engineer capacity.Over 5 y... Show more

 • Promoted

Senior Linux Embedded Developer: EPAM Systems

ShiftCode AnalyticsDallas, TX, United States
Full-time

Linux Embedded developer • U-Boot: • Good knowledge of cross compilation.U-Boot build, build setup, ability to configure, bin file size optimization.Knowledge of TFTP, x/y/z modem. Show more