Overview
On Site
Contract - W2
Skills
Insurance
z/OS
Software Design
Performance Tuning
Storage
CPU
Problem Solving
Technical Support
ROOT
Recovery
Disaster Recovery
ServiceNow
WLM
SMF
Database
Stored Procedures
Writing
Rexx
SQL
Distribution
IBM
Project Planning
Management
SMP/E
Documentation
Change Control
XML
Problem Analysis
BMC
DS
DirectShow
IBM InfoSphere
Replication
Informatica PowerExchange
Mainframe
IBM DB2
MEAN Stack
Customer Service
Training And Development
SAP BASIS
Job Details
Software Guidance & Assistance, Inc., (SGA), is searching for a Mainframe zOS DB2 Systems Programmer for a CONTRACT assignment with one of our premier Insurance Services clients. This role will be hybrid out of Bethlehem, PA, Stamford, CT, Holmdel, NJ, or New York, NY.
The main responsibilities of a Mainframe zOS DB2 Systems Programmer is to ensure subsystem reliability, availability, and serviceability; to provide technical expertise and guidance for both infrastructure and application design, supporting, installing/upgrades and diagnosing all DB2 and DB2-related OEM products, and performance tuning.
Responsibilities:
5+ Years of experience supporting the following products:
SGA is an Equal Opportunity Employer and does not discriminate on the basis of Race, Color, Sex, Sexual Orientation, Gender Identity, Religion, National Origin, Disability, Veteran Status, Age, Marital Status, Pregnancy, Genetic Information, or Other Legally Protected Status. We are committed to providing access, equal opportunity, and reasonable accommodation for individuals with disabilities in employment, and our services, programs, and activities. Please visit our company to request an accommodation or assistance regarding our policy.
#LI-NK1
The main responsibilities of a Mainframe zOS DB2 Systems Programmer is to ensure subsystem reliability, availability, and serviceability; to provide technical expertise and guidance for both infrastructure and application design, supporting, installing/upgrades and diagnosing all DB2 and DB2-related OEM products, and performance tuning.
Responsibilities:
- Monitor DB2 system storage, memory, I/O and CPU resources, design performance improvements.
- Evaluate and recommend innovative technological solutions to meet new/existing business requirements.
- Perform daily checklists, review daily Db2 reports for anomalies, open service now tickets to application groups for problem resolution.
- Provide timely resolution to DB2 software related problems. Work with the IBM and ISV vendor Level 2 and technical support teams to identify DB2 software related problems.
- Respond to S1 calls. Evaluate all components within DB2 for stability or errors. Drive problem source identification to root cause, provide workarounds, and design preventive measures.
- Create and maintain DB2 Systems SOPs and Runbooks according to the provided format.
- Participate in the planning and recovery of the DB2 subsystems as part of Disaster Recovery.
- Utilize ServiceNow ticketing process for change control. Complete checklists for systems tasks and submit change controls for review in a timely manner.
- Manage DB2 Catalog/directory, WLM, bufferpools, zparms, PROCS, RLF, RTS. Build new subsystems or relocate existing ones upon request.
- Assist in the implementation of Data Studio + debugger.
- Provide technical expertise and guidance to the internal DB2 community.
- Contribute to the on-going development of monitoring and trending metrics for DB2 using MainView shipped SMF database.
- Manage DB2 reorgs, runstats, rebinds, PROCS, RTS, RLF, stored procedures.
- Participation in writing REXX for automation/autonomics for preventative, corrective, and predictive measures for outage avoidance.
- Performance tune tablespaces, partitions, indexes. Assist the application staff in preparing well-tuned SQL for the business. Understand the difference between Explain, and run-time access path determination.
- Diagnose performance issues, considering data distribution, cardinality, join structures, bufferpools, and data sharing members.
- Using SMPE, IBMLINK, and ShopZSeries, upgrade and apply maintenance to IBM and BMC DB2 products.
- Perform project planning and management of software upgrades & product implementation to support DB2 environments. Install, support and customize licensed DB2 software and related tools (client & 3rd party vendors).
- Upgrade DB2 subsystem environments to newly released versions. Receive, apply and propagate software fixes across supported DB2 platforms, using SMP/E, etc.
- Coordinate maintenance and upgrades implementation with affected applications. Perform OEM problem analysis and resolution. Maintain OEM documentation
- Create and maintain documentation in support of the DB2 environments. (E.g. Procedures, SOPs, Change Control, etc.). Implement advanced features/function of DB2 software (e.g. DB2 Data Sharing, native XML, etc.)
- Maintain DB2 at optimal maintenance levels, apply PTFs as needed. Coordinate maintenance and upgrades implementation with affected applications. Perform DB2 problem analysis and resolution.
5+ Years of experience supporting the following products:
- BMC Catalog Mgr(ACT), Change Mgr(ACM), Log Master(ALP), MainView for DB2, Query Manager
- Compuware File-Aid for DB2, IMS; RDX, DS
- IBM InfoSphere Replication Server (Data Propagator)
- DB2 Query Monitor (formerly Rocket - CQM)
- DB2 for LUW
- High Performance Unload (formerly Infotel)
- Informatica Power Exchange
- IBM DB2 Connect
- DB2 data sharing environment
- Mainframe / DB2 secure transfers
SGA is an Equal Opportunity Employer and does not discriminate on the basis of Race, Color, Sex, Sexual Orientation, Gender Identity, Religion, National Origin, Disability, Veteran Status, Age, Marital Status, Pregnancy, Genetic Information, or Other Legally Protected Status. We are committed to providing access, equal opportunity, and reasonable accommodation for individuals with disabilities in employment, and our services, programs, and activities. Please visit our company to request an accommodation or assistance regarding our policy.
#LI-NK1
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.