1

Intern Db2 Systems Programmer Jobs in New York (NOW HIRING)

Mainframe DB2 Systems Programmer Phoenix, AZ (Hybrid) Plano, TX Charlotte, NC Richmond, VA Jacksonville Beach, FL Pennington, NJ Chicago, IL The Role: We are seeking a highly skilled Mainframe DB2 ...

Senior DB2 Engineer Client - Morgan stainley Location : NY city Hybrid -- 3 days office DB2 ... UNIX System Engineering Strong hands-on experience in UNIX environments (AIX/Linux/Solaris). Shell ...

SYSTEMS PROGRAMMER ANALYST

Manhattan, NY ยท On-site

$100K - $125K/yr

... a Systems Programmer Analyst, who will: -Design, develop and maintain new software applications ... SQL, Oracle, DB2). These datasets may need to be imported into the user application database or ...

S. Bank is seeking a z/OS Systems Programmer that has extensive experience in mainframe ... Administer and support critical mainframe subsystems including JES2, CICS, IMS, MQ, and Db2

next page

Showing results 1-20

Intern Db2 Systems Programmer information

What are some common challenges faced by an Intern Db2 Systems Programmer and how can they be addressed?

As an Intern Db2 Systems Programmer, you may encounter challenges such as understanding the complexity of mainframe environments, navigating Db2's extensive configuration options, and troubleshooting performance issues. To address these, it's helpful to actively seek guidance from experienced team members, make use of available documentation, and participate in training sessions. Regular communication with your team and asking questions during meetings can also accelerate your learning and help you adapt more quickly to the technical environment.

What are the key skills and qualifications needed to thrive as an Intern Db2 Systems Programmer?

To thrive as an Intern Db2 Systems Programmer, you need a solid understanding of computer science fundamentals, database concepts, and preferably some coursework or experience with IBM Db2 or similar relational database systems. Familiarity with mainframe environments, SQL, JCL, and basic scripting, along with knowledge of Db2 utilities and monitoring tools, is highly valuable. Strong analytical thinking, attention to detail, and a willingness to learn from senior team members are important soft skills. These competencies ensure efficient database management, effective troubleshooting, and a smooth adoption of best practices in enterprise database environments.

What does an Intern Db2 Systems Programmer do?

An Intern Db2 Systems Programmer assists in maintaining and supporting IBM's Db2 database systems, typically on mainframe platforms. Their responsibilities often include monitoring database performance, helping with upgrades or installations, applying patches, and troubleshooting issues under the guidance of senior staff. They may also assist in scripting, automating routine tasks, and learning best practices for database security and backup. This role provides hands-on experience with enterprise database administration and exposes interns to the fundamentals of mainframe computing.
What are popular job titles related to Intern Db2 Systems Programmer jobs in New York? For Intern Db2 Systems Programmer jobs in New York, the most frequently searched job titles are:
What cities in New York are hiring for Intern Db2 Systems Programmer jobs? Cities in New York with the most Intern Db2 Systems Programmer job openings:

Mainframe DB2 System Programmer SME

The AES Group

New York, NY โ€ข Remote

Contractor

Posted 2 days ago

New


Job description

Role: Mainframe DB2 System Programmer SME
Location: Remote

Let's create our future together at The AES Group!

About The AES Group

The AES Group is a premier technology and engineering consulting company that has been bringing businesses and talent together for over 20 years to deliver innovative solutions that make a positive impact. We help organizations modernize their technology through cloud, data, AI, engineering, cybersecurity, and emerging technologies.
Why This Opportunity

Join a leading enterprise technology environment as a Mainframe DB2 System Programmer SME and work on highly complex, business-critical mainframe systems. This is a hands-on opportunity for an experienced DB2 infrastructure specialist who enjoys solving challenging technical problems, improving system reliability, and supporting large-scale DB2 environments.

What You’ll Gain

  • Fully remote work environment.
  • Opportunity to work on enterprise-scale DB2 and z/OS infrastructure.
  • Hands-on involvement with DB2 Data Sharing and SYSPLEX architectures.
  • Exposure to complex system migrations, performance tuning, recovery, and high-availability initiatives.
  • Opportunity to serve as a technical SME and influence infrastructure best practices.

Role Overview

We are seeking an experienced Mainframe DB2 System Programmer SME with deep expertise in IBM DB2 infrastructure, z/OS environments, Data Sharing, and SYSPLEX architecture.

In this role, you will provide technical analysis, troubleshooting, documentation, system configuration, performance optimization, and infrastructure support across mission-critical DB2 environments. You will work closely with application, infrastructure, operations, and engineering teams to identify issues, implement solutions, and ensure stable and high-performing DB2 systems.

The ideal candidate is highly analytical, customer-focused, comfortable working independently, and capable of handling complex infrastructure challenges from initial investigation through resolution and handoff.

Key Responsibilities

  • Install, configure, customize, maintain, and support DB2 subsystems in standalone and Data Sharing environments.
  • Manage and support Monoplex, SYSPLEX, and DB2 Data Sharing architectures.
  • Perform DB2 subsystem setup, configuration, upgrades, migrations, maintenance, and backout activities.
  • Support DB2 backup and recovery strategies using image copies, FLASH technologies, mirroring, and related methodologies.
  • Configure and troubleshoot DB2 Data Sharing components, including DB2 structures, CFRM policies, coupling facilities, locking mechanisms, and CF recovery.
  • Perform DB2 health checks, security administration, patch management, and infrastructure maintenance.
  • Analyze DB2 traces and system data using SMF, RMF, and WLM.
  • Conduct DB2 and z/OS system performance analysis, tuning, and capacity optimization.
  • Develop and maintain automation using REXX, CLIST, and ISPF.
  • Support DB2 integrations with transactional platforms including CICS and IMS.
  • Perform software installation and maintenance using SMP/E.
  • Troubleshoot complex system issues and coordinate with software vendors through PMR or equivalent support processes.
  • Prepare technical documentation, diagrams, procedures, and operational handoff materials.

Required Qualifications

  • 14+ years of experience in Mainframe DB2 System Programming.
  • Strong hands-on expertise with IBM DB2 on z/OS.
  • Extensive experience with SYSPLEX, Monoplex, and DB2 Data Sharing environments.
  • Strong knowledge of DB2 subsystem installation, configuration, administration, maintenance, and recovery.
  • Experience with DB2 backup and recovery methodologies.
  • Strong programming and automation skills using REXX, CLIST, and ISPF.
  • Solid understanding of CICS and IMS architectures and their integration with DB2.
  • Experience with DB2 software migrations, maintenance, installation, backout, and re-migration procedures.
  • Strong working knowledge of SMP/E.
  • Experience with DB2 security, health checks, patch management, traces, SMF, RMF, and WLM.
  • Strong knowledge of z/OS and DB2 performance tuning.
  • Proven troubleshooting, debugging, and distributed problem-solving skills.

Preferred Qualifications

  • Bachelor’s degree in Computer Science, Information Technology, Engineering, or a related discipline.
  • Experience with DB2 Connect and IBM Data Studio.
  • Experience with DB2 cloning using IBM DB2 Cloning Tool or comparable enterprise cloning solutions.
  • Previous experience supporting large, highly available enterprise mainframe environments.

Ready to make an impact? Apply now and join us on our journey!