Mainframe DB2 System programmer

TechDigital Group; United States; Remote; USD 80,000 - 100,000; Full time

Job summary

An established industry player is seeking a skilled DB2 Administrator with over 5 years of experience in managing and optimizing DB2 databases on z/OS. In this role, you will be responsible for upgrading and migrating DB2 versions, ensuring database security, and performing performance tuning to maintain optimal functionality. You will also handle database creation, manage user privileges, and implement compliance corrections. Join a dynamic team where your expertise will significantly impact database operations and performance. If you have a passion for database management and a desire to work in a collaborative environment, this opportunity is perfect for you.

Qualifications

• 5+ years of experience in DB2 UDB on z/OS is required.
• Strong skills in DB2 administration and SQL performance tuning.

Responsibilities

• Upgrade and manage DB2 versions and products as needed.
• Optimize database performance through reorganizations and tuning.
• Implement security compliance and manage user privileges.

Skills

DB2 Administration

SQL Creation

Performance Tuning

Database Security Management

Logical Database Design

CICS/IMS Software Installs

Tools

DB2

z/OS

DSNJLOGF

CHECKDATA

LOAD

Job description

Responsibilities:

1. Upgrade/Migrate DB2 Versions to newer versions
2. Regularly applying PTFS/APARS if required
3. Manage DB2 IVS Products and upgrade to supported versions if required
4. Managing system catalogs
5. Manage application data and database environments, performing reorganizations when required to optimize performance
6. Offline utilities - DSNJLOGF, DSNJU004, DSNJU003 etc.
7. Database and related object security manage user ids, rights and privileges
8. DB2 administration on z/OS, SQL creation, DB2 command line creation and execution, DB2 performance tuning
9. Physical database definition (DDL) and understanding of logical database design
10. Implement DBDC (CICS, DB2, or IMS) base software installs and upgrades
11. Implement DBDC (CICS, DB2, or IMS) related product installs and upgrades
12. Implement DBDC (CICS, DB2, or IMS) security compliance corrections
13. Monitoring threads, table space and index spaces
14. Monitoring instances for events and resolution/escalations
15. Performance tuning Database and SQL tuning
16. DB2 recycle
17. DB2 Image copy (full/incremental)
18. Database creation
19. Grant/revoke of authorities
20. DB2 archive logs
21. Having experience of DR setup through various synch methods
22. Build and maintenance of database and related objects like table space, tables, indexes, views, triggers etc.
23. Online utilities - CHECKDATA, COPY, QUIESCE, REPAIR, REORG, LOAD, UNLOAD etc.

Years of Experience:
Total: Above 5+ Years of experience
Relevant: Minimum of 4 yrs in DB2 UDB on z/OS