Mainframe DB2 System DBA
Longfinch Technologies LLC.
Salt Lake City, UT
Posted On: Nov 10, 2025
Posted On: Nov 10, 2025
Job Overview
Job Type
Full-time
Experience
10 - 20 Years
Salary
Depends on Experience
Work Arrangement
Remote
Travel Requirement
0%
Required Skills
- IBM DB2 system admin
- IBM DB2 v12
- DB2 DBA on z/OS
- Mainframe DB2 system programmer
- IBM DB2 system admin
- IBM DB2 v12
- DB2 DBA on z/OS
- Mainframe DB2 system programmer
- Mainframe DB2 system administrator
- IRLM
- LISTDEF
- REORG
- RECOVER
- RUNSTATS
- QUIESCE
- IRLM
- DSNJU003
- DSN1LOGP
- DSN1SDMP"
Job Description
"Define and provide guidance for database creation, configuration, upgrade, patches and refresh requirements
Recommend operating system and database performance monitoring, tuning and configuration changes
Experience with database physical and logical design, query analysis and optimization
Provide technical assistance and subject matter expertise to applications groups
Provide database storage management and capacity management recommendations
Define and manage database security and access permissions in consultation with customer
Ensure completion of authorized Service Requests, Changes, Problem tickets
Manage escalations and track Service Delivery and ensure SLA compliance including with vendors
Review and update the SOP documents on regular basis
Support on all in-flight and upcoming project activities
Recommend and perform customer-approved database replication procedures
Years of Experience
L3 : 10+ Years of experience in Mainframe z/OS Db2 v13 Database Administration
Technical requirements
Experience in Mainframe Db2 v12/ v13 Database System-Administration on z/OS
DB2 installation, upgrade, patching, configuration and operations
Proficiency in DB2, VSAM Systems Performance Tuning and Capacity Planning
Experience in Data Sharing setup in Parallel Sysplex environment
Knowledge in ACF2/RACF, CICS v5.5, Mainframe MQ v9
Experience in SMPE and ISV tools installation and migration
Create and maintain database entities, including instances, databases, table spaces and tables
Database DR, Cloning, Backup/Recovery, HA and Point In Time Recovery (PITR) expertise
Experience with Database ISV Tools and Products like OmegaMon and AdminTool
Application related performance tuning; Write, modify, and debug database specific SQL queries
DBA related utilities like Unload, Load, DSNJU003, DSNJU004,Reorg, Runstats, image copy
REXX, CLIST, JCL, JES and Assembler knowledge
Job ID: 25000010
Posted By
Shashank Verma
Resource Manager
Related Jobs
- Mainframe DB2 System DBA
Salt Lake City, UT
- Full-time
COMPANY
Longfinch Technologies LLC.
experience
10 - 20 Years
Work Arrangement
Remote
SALARY
Depends on Experience
SKILLS
- IBM DB2 system admin
- IBM DB2 v12
- DB2 DBA on z/OS
- Mainframe DB2 system programmer
- +15 more
Posted On: Nov 10, 2025