Mainframe DB2 systems programmer

Info-Ways; Frisco (TX); On-site; USD 100,000 - 120,000; Full time

Job summary

A technology solutions company is seeking a Mainframe DB2 systems programmer in Frisco, TX. The ideal candidate will possess a minimum of 10 to 20 years of experience working with Mainframe Database systems, specifically DB2. Responsibilities include driving architecture roadmaps, managing DB2 performance tuning, and upgrading systems as necessary. This position requires a strong knowledge of DB2 administration, security management, and database optimization techniques. The role offers a full-time position with a comprehensive scope of work to support critical projects.

Qualifications

• Minimum of 10 to 20 years of experience in DB2 systems programming.
• Functional experience with DB2 database management and upgrades.
• Proficient in SQL creation and execution.

Responsibilities

• Drive architecture roadmap and lead technical efforts.
• Manage DB2 IVS products and upgrade versions as needed.
• Monitor database performance and optimize configurations.

Skills

Mainframe DB2 knowledge

Performance tuning

Database security management

DB2 administration on z/OS

Job description

Overview

Role: Mainframe DB2 systems programmer

Location: Frisco, TX

Duration: Fulltime

Background check (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 should have a good level working knowledge of the Mainframe Database (DB2) identified within. The candidate shall perform activities described below in support of the task.

• 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 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 resolutions
• Performance tuning – database and SQL tuning
• DB2 recycle
• DB2 image copy (full/incremental)
• Database creation
• Grant/revoke of authorities
• DB2 archive logs
• Experience with DR setup through various synchronization methods
• Build and maintenance of database and related objects (table space, tables, indexes, views, triggers, etc.)
• Online utilities - CHECKDATA, COPY, QUIESCE, REPAIR, REORG, LOAD, UNLOAD etc.

Application Details

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

Additional Information

All your information will be kept confidential according to EEO guidelines.