ZipRecruiter

Log In

1

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

IPolarity LLC

Mainframe Administrator

Whippany, NJ · On-site

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

Sidram Technologies

DB2 Engineer - w2

New York, NY · On-site

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

City of New York

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

US Bank

z/OS Systems Engineer

New York, NY · On-site

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

All JobsIntern Db2 Systems Programmer JobsIntern Db2 Systems Programmer Jobs in New York

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 job categories do people searching Intern Db2 Systems Programmer jobs in New York look for? The top searched job categories for Intern Db2 Systems Programmer jobs in New York 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:
Intern Db2 Systems Programmer jobs near you

Mainframe Administrator

IPolarity LLC

Whippany, NJ • On-site

Part-time

Posted 23 days ago

Job description

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 Systems Administrator to manage and support DB2 for z/OS subsystems in a mission-critical enterprise environment. This role is responsible for installation, configuration, performance tuning, and overall health of DB2 subsystems, ensuring high availability, security, and optimal performance.
Responsibilities:

DB2 Installation & Configuration

  • Install, configure, and maintain DB2 for z/OS subsystems
  • Perform version upgrades, patching (PTFs/APARs), and system maintenance 
  • Manage subsystem configuration and initialization parameters
  • Maintain core DB2 components: 
    • ZPARMs (DSNZPARM)
    • Buffer pools
    • Logs and BSDS
    • Catalog and directory 

Performance & Capacity Management

  • Monitor and tune DB2 system-level performance (CPU, memory, I/O) 
  • Optimize: 
    • Buffer pools
    • Locking and concurrency
    • Thread and connection performance
  • Support capacity planning and performance analysis using DB2 and system tools

High Availability & Data Sharing

  • Manage and support: 
    • DB2 Data Sharing environments (Sysplex)
    • Coupling Facility integration
    • Workload balancing and failover
  • Ensure DB2 availability and resilience through DR strategies

System Maintenance & Troubleshooting

  • Analyze and resolve:
    • Subsystem failures
    • Dumps, logs, and abends
    • Connectivity issues affecting DB2 operations
  • Perform root cause analysis and implement preventive actions
  • Support interaction with:
    • Batch (JCL)
    • CICS
    • IMS
    • MQ and distributed systems 
Required Qualifications:
  • 7–12+ years of mainframe experience
  • 3–5+ years in DB2 Systems Programming / Administration
  • Experience with IBM DB2 for z/OS and Replication products (Qrep, SQLrep and CDC) - software installation, version upgrades and maintenance, certification testing, documentation of operational procedures, disaster recovery testing
  • Deep knowledge of:
    • ZPARMs and subsystem configuration
    • Buffer pools, logs, BSDS, catalog/directory
  • Strong troubleshooting skills for:
    • System-level DB2 issues
    • Performance and connectivity problems
  • Proficiency in:
    • JCL, TSO/ISPF, SDSF
    • SMP/E (preferred)
Preferred Qualifications:
  • Familiarity with: 
    • DB2 utilities and performance tools
    • Monitoring tools (OMEGAMON, MainView)
  • Knowledge of: 
    • DevOps tools for mainframe (Endevor, ISPW, etc.)
  • Exposure to: 
    • Cloud integration or hybrid architectures
  • Experience with: 
    • Large-scale DB2 upgrades or migrations
    • Performance optimization initiatives
  • Knowledge of: 
    • Modernization tools (z/OS Connect, APIs)
  • Experience with software support for BMC for DB2 Tools, IBM z/OS Connect, Software AG ADABAS and Natural products
  • Programming experience with REXX
  • Working knowledge of SQL, JIRA, SMP/E, RACF, TCP/IP, Network certificates, Splunk
  • Working knowledge of other Mainframe Subsystems (CICS, IMS, MQ)

Best Regards,
Naresh J | Team Lead
M 732 640 5076 | Jnaresh@ipolarityllc.com
https://www.linkedin.com/in/naresh-janapati-53ab8576/
200 Centennial Ave, Suite 204, Piscataway, NJ 08854

Flexible work from home options available.