
Open since Jun 2017
Mainframe DB2 systems programmer
AI Summary
Architects and maintains mainframe DB2 database environments on z/OS, including upgrades, security, performance tuning, and disaster recovery.
About this role
IT
Role: Mainframe DB2 systems programmer
Location: Frisco, TX
Duration: Fulltime
BGV will be done for the selected candidates.
Qualification
Minimum 10 to 20 Years of Experience.
Scope of Work
The scope of effort includes all items identified below. The candidate needs to have a good level working knowledge of the Mainframe Database (DB2) identified within.
In support of the task, the candidate shall perform the activities such as those described within.
Work Experience Knowledge Skills & Abilities:
Drive architecture roadmap, reference architecture and standard efforts. Provide leadership in all technical aspects of assigned projects, programs and portfolios
Architect complex end-to-end solutions across distributed, host and business intelligence environments
Functional experience is required with the following technologies:
Upgrade/Migrate DB2 Versions to newer versions
Regularly applying PTFS/APARS if required.
Manage DB2 IVS Products and upgrade to supported versions if required.
Managing system catalogs
Manage application data and database environments, performing reorganizations when required to optimize performance
Offline utilities - DSNJLOGF, DSNJU004, DSNJU003 etc.
Database and related object security – manage user ids, rights and privileges
DB2 administration on z/OS, SQL creation, DB2 command line creation and execution, DB2 performance tuning,
Physical database definition (DDL) and understanding of logical database design
Implement DBDC (CICS, DB2, or IMS) base software installs and upgrades
Implement DBDC (CICS, DB2, or IMS) related product installs and upgrades
Implement DBDC (CICS, DB2, or IMS) security compliance corrections
Monitoring – threads, table space and index spaces.
Monitoring instances for events and resolution/escalations
Performance tuning – Database and SQL tuning
DB2 recycle
DB2 Image copy (full/incremental)
Database creation
Grant/revoke of authorities
DB2 archive logs
Having experience of DR setup through various synch methods
Build and maintenance of database and related objects like table space, tables, indexes, views, triggers etc.
Online utilities -CHECKDATA, COPY, QUIESCE, REPAIR, REORG, LOAD, UNLOAD etc.
Please respond with your word resume and requested details:
Full Name :
Work Authorization:
Contact Number :
Email ID :
Skype ID:
Current location:
Willing to relocate :
Salary :
All your information will be kept confidential according to EEO guidelines.
Skills
Explore related jobs
More jobs at Info-Ways
Similar DB2 jobs
- C
Apartment Manager (Coburn Woods Apartments)Cascadia Health · US - OR - Portland - T
Apartment CleanerTarantino Properties · Pittsburgh, Pennsylvania - C
Apartment ManagerCampus Apartments · Statesboro, GA - L
Apartment PorterLyon Management Group · Anaheim Hills, California - L
Director APACLand Life · Kyneton, Victoria - AVermieter - ApartmentsALLPOWER Personalprofis GmbH · Berlin, Germany
Jobs in Frisco
- C
Reporter ICommunity Impact · Frisco, Texas - P
Senior AccountantPublic Storage · Frisco, TX - P
Home Health Occupational Therapist (PRN)-FriscoPARS Therapy · Frisco, TX - C
New Client Services CoordinatorCain Watters & Associates, LLC · Frisco, Texas - C
Estate Planning CoordinatorCain Watters & Associates, LLC · Frisco, Texas - A
Security Officer Access Credential PatrolAllied Universal · Frisco, TX
Browse these categories
Market data for this role
All reports →- SeriesRole reportsOne role family at a time: how many openings, what changed this week, who is hiring, what it pays.
- SeriesSalary reportsWhat employers publish in job postings, by level and workplace. Not self-reported pay.
- Market overviewState of tech hiring, September 2026: up 4.8%Tech hiring rose 4.8% month over month in September 2026, with 411,122 new listings. Customer support and account executive roles led the growth.