Sign up to access all features of our service.
  • Job search
  • Favorites
  • Create a CV
    New
  • Salaries
  • Subscriptions

DB2 Systems programmer

Yochana

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
Vacancy posted 20 hours ago
Similar jobs that could be interesting for youBased on the DB2 Systems programmer in United States vacancy
  • Company DescriptionIDEALFORCE has a Contract-to-Hire positions available immediately for a Mainframe IMS/DB2 System Programmer to join our customer in Phoenix, AZ. Please find below additional details about this job. Kindly respond with your most up to date resume if you... 
    Suggested
    Contract work
    Immediate start
    Flexible hours
    Day shift

    idealforce

    Phoenix, AZ
    1 day ago
  •  ...design, build, manage and modernize the mission-critical technology systems that the world depends on every day. So why work at Kyndryl? We...  ..., our customers and our communities.The RoleResponsibilities:DB2 Installation & ConfigurationInstall, configure, and maintain DB... 
    Suggested
    Full time

    Kyndryl

    Phoenix, AZ
    2 days ago
  •  ...return on investment to shareholders.• To promote employee development. Job DescriptionDB2 Systems Programmer with the skill to perform the following: Assist on implementation of DB2 databases OS staff on DB2 testing and/or migration steps needed.Assist DB2 staff on the... 
    Suggested
    Weekend work

    Xinnovit

    Birmingham, AL
    1 day ago
  •  ...consumer insights, strategy, design, software engineering, and systems integration. We strongly believe: " If something cannot be...  ...2009Job DescriptionCurrently seeking a talented DB2 Z/OS System Programmer for a 1 YEAR projectQualificationsRequired: • Systems Programmer... 
    Suggested

    TekWissen

    Southbury, CT
    1 day ago
  • $95.92k - $222.03k

     ...If you want to be part of an inclusive, adaptable, and forward-thinking organization, apply now.We are currently seeking a DB2 Systems Programmer to join our team in the United States (US).JOB DESCRIPTION - This is a remote position, but you must have the required DB2... 
    Suggested
    Temporary work
    Work at office
    Remote work
    Flexible hours

    NTT DATA

    Buffalo, NY
    2 days ago
  •  ...that seamlessly combines clients insights, strategy, design, software engineering, and systems integration. Job DescriptionWe are currently seeking a talented DB2 Systems Programmer for a 1 YEAR project in Waltham, MA. Required: DB2 z/OS Systems Systems ProgrammerAdditional... 

    TekWissen

    Waltham, MA
    1 day ago
  • $119k - $170k

     ...following ways: Install/configure/upgrade DB2 and related software products. This...  ...Researches and recommends the appropriate system software to meet corporate standards and...  ...communicate effectively with application programmers and DBA’s.Troubleshoot DB2 subsystem problems... 
    Work experience placement
    Work visa
    Weekend work

    Yoh

    New York, NY
    1 day ago
  •  ...Senior Vice President, Mainframe DB2 or IMS Systems Programmer About the Company Large enterprise needing expert DB2 mainframe systems support and 24x7 coverage. Industry Financial Services Type Privately Held About the Role The Company is seeking... 
    Work experience placement
    Weekend work

    Confidential

    Jacksonville, FL
    3 days ago
  •  ...personally, we ensure a bright future for NTT DATA and for the people who work here. NTT DATA is currently looking for a DB2 for z/OS Systems Programmer remote for our growing team in the UK and rest of Europe. About the role We are seeking an experienced  DB2 for... 
    Work at office
    Remote work
    Flexible hours

    NTT DATA, Inc.

    Dublin, CA
    5 days ago
  • $79.92k - $152.16k

     ...modernize the mission-critical technology systems that the world depends on every day. So...  ...communities.The RoleThe Mainframe z/OS System Programmer is responsible for the installation,...  ...coordination with security teams)Work closely with DB2, CICS, IMS, MQ, and Storage teams for... 
    Minimum wage
    Full time
    Part time
    Live in
    Local area
    Worldwide
    Relocation
    Weekend work
    3 days per week

    Kyndryl

    Phoenix, AZ
    20 hours ago
  •  ...has a Contract position available immediately for a Mainframe System Programmer to join our customer in Phoenix, AZ. Please find below additional...  ..., SAS, MXG, HTML, CRplus, BMC’s CONTROL-M, CICS/TS, IMS and DB2. Additionally, UNIX, and/or Linux experience would also be a... 
    Contract work
    Immediate start

    idealforce

    Phoenix, AZ
    1 day ago
  •  ...modernize the mission-critical technology systems that the world depends on every day. So...  ...communities.The RoleMainframe IMS System Programmer:The Role:We are seeking a highly skilled...  ...testingEnsure seamless integration with z/OS, DB2, MQ, CICS, TCP/IP, and Sysplex... 
    Full time

    Kyndryl

    Phoenix, AZ
    2 days ago
  •  ...261Reference Number: 23-00170Title: CICS System programmerLocation: Iselin, NJ, 08830Posted...  ...0Company: HAN Staffing Role: CICS System programmer CICS Systems Programmer is responsible...  ...parallel Sysplex, CICSPlex, MQ sharing and DB2 data sharing environment with skills in... 

    HAN Staffing

    Iselin, NJ
    2 days ago
  •  ...Information Technology, Technical Services is looking for an experienced z/OS Systems Programmer proficient in using IBM SMP/E to install both IBM and ISV products in an IBM z13 SYSPLEX/CICS/DB2 mainframe environment. Additionally, knowledge of IBM RACF Security is an... 

    Sonsoft

    Trenton, NJ
    3 days ago
  • $114.08k - $218.03k

     ...Infrastructure team is looking for Senior level Mainframe CICS Systems Programmer professional responsible for the installation, configuration,...  ...programmers to integrate CICS with other mainframe subsystems, such as DB2 (database management) and MQ (messaging).Security and... 
    Full time
    H1b
    Work at office
    Remote work
    Home office
    Relocation package
    Flexible hours

    USAA - United Services Automobile Association

    San Antonio, TX
    3 days ago
  • $60 - $80 per hour

     ...Join to apply for the Mainframe System Programmer role at Apex Systems 3 days ago Be among the first 25 applicants Join to apply for...  ...experience in a related job. ~ Experience supporting any of DB2, RACF, z/OS, z/VM, Linux, and mainframe networking a strong plus... 
    Full time
    Remote work

    Apex Systems

    Raleigh, NC
    3 days ago
  •  ...Job title: Mainframe Systems Programmer (DB2) Location: Manhattan, NY (100% Remote) Type: Remote – Contract Rate: $80/hour on W2 Must: A minimum of 10 years of experience working with z/OS Position Description We are seeking an experienced Mainframe... 
    Contract work
    Remote work
    Weekend work

    Seneca

    New York, NY
    13 hours ago
  • $60 - $65 per hour

     ...IMS Systems Programmer Immediate need for a talented IMS Systems Programmer. This is a 12+ months contract opportunity with long-term potential...  ...Mainframe modernization initiatives. ~ Knowledge of CICS, DB2, MQ, and TCP/IP. ~ Experience working in large enterprise... 
    Long term contract
    Contract work
    Local area
    Immediate start
    Remote work

    Pyramid Corporation

    United States
    20 hours ago
  •  ...Role: Senior Technical Performance Analyst (Mainframe Systems Programmer) Location - Remote, USA W2 Exp:10+ Visa...  ...Manager (batch priority software) • Knowledge of zVM, CICS, DB2, Strobe, & Mainview Interested candidates, Can send... 
    Immediate start
    Remote work

    Kaav Inc.

    United States
    2 days ago
  •  ...Job Requirements: - BM z/OS Operating System - installation, configuration, customization, and upgrades. - JCL (Job Control...  ...Security management) - VTAM, TCP/IP (Networking) - CICS, IMS, DB2 (middleware/database knowledge a plus) - Storage Management -... 
    Remote work

    Saxon Global

    United States
    2 days ago
  •  ...Mainframe System Programmer Atos is looking for a Mainframe System Programmer to support the installation, maintenance, and administration...  ...service environments System-level experience with CICS, IMS, DB2, Communications, and MQ is a strong plus; candidates with... 
    Remote work

    World Grid

    United States
    10 hours ago
  •  ...Job Title: Mainframe ZOS System Programmer Location: Phoenix, AZ The Mainframe z/OS System Programmer is responsible for the installation...  ...(in coordination with security teams) Work closely with DB2, CICS, IMS, MQ, and Storage teams for integration and support... 
    Temporary work
    Live in
    Relocation
    Weekend work
    3 days per week

    Delan Associates, Inc

    Phoenix, AZ
    a month ago
  •  ...seeking an enthusiastic and detail-oriented Entry-Level Mainframe Systems Programmer to join our infrastructure team. This role provides an...  ...Basic understanding of:JES2SDSFTSO/ISPFTSS/RACFDFSMSSMP/ECICS, DB2, or MQKnowledge of scripting and automation concepts.Understanding... 
    Full time
    Internship

    Fidelity Investments

    Texas
    4 days ago
  •  ...Oversight Services.Job DescriptionThe Subject Matter Expert Mainframe System Programmer provides senior-level technical leadership and specialized...  ...operational support and maintenance activities for z/OS, DB2, and CICS environmentsDesign, implement, and optimize DASD replication... 
    Full time
    Work experience placement

    ANGARAI

    College Park, MD
    1 day ago
  •  ...We are seeking a CICS System Programmer to administer, support, and optimize enterprise IBM CICS environments. This role focuses on CICS platform...  ...CICS resources using RACF. Support CICS integration with DB2, MQ, IMS, TCP/IP, and web services. Support CICS... 
    Temporary work

    Neshent Technologies

    Chandler, AZ
    12 days ago
  • Position: Mainframe IMS System Programmer Duration: 12 months Mainframe IMS DB System Programmer Typical Requirements (Technical) Database...  ...software installation. Ensure compatibility between IMS, z/OS, DB2, CICS, and related products. Performance & Capacity... 

    METRIX IT SOLUTIONS INC

    Plano, TX
    4 days ago
  • $114.08k - $218.03k

     ...deployments and infrastructure management in a systems operations environment or comparable IT...  ...of hands-on experience as a CICS Systems Programmer in a z/OS mainframe environment. We...  ...of related z/OS subsystems, including DB2, MQ, JES2, z/OS Connect, IMS, and TCP/IP... 
    Full time
    Work at office
    Remote work
    Relocation package
    Flexible hours

    USAA

    San Antonio, TX
    2 days ago
  • $63.22k - $94.55k

     ...thinking organization, apply now. We are currently seeking a Lead Systems Programmer to join our team in Alpharetta, Georgia (US-GA), United States...  ...tasks and system monitoring Manage and optimize SQL and DB2 database environments, including stored procedures and... 
    Remote work

    NTT DATA

    Alpharetta, GA
    3 days ago
  • $75 - $100 per hour

     ...applications and next steps. Our partner is looking for a Senior IMS Systems Programmer (IBM IMS Tools & Database Administration) based in United...  ...technologies. The position offers broad exposure to IMS, DB2, CICS, IBM and ISV products, and complex migration initiatives... 
    Hourly pay
    Ongoing contract
    Full time
    Contract work
    Remote work
    Work from home

    jobgether

    United States
    1 day ago
  • $95.92k - $222.03k

     ...want to be part of an inclusive, adaptable, and forward-thinking organization, apply now.We are currently seeking a Mainframe Systems Programmer to join our team in the, United States (US).JOB DESCRIPTION - This is a remote position, but you must have the required... 
    Temporary work
    Work at office
    Remote work
    Flexible hours

    NTT DATA

    Buffalo, NY
    3 days ago

Do you want to receive more vacancies?

Subscribe and receive similar vacancies to DB2 Systems programmer. Be the first to apply!