Overview
Remote
$100,000 - $120,000
Full Time
Skills
IBM WebSphere MQ
Database Administration
Database Security
Debugging
High Availability
Assembly Language
Backup
CICS
CLIST
Capacity Management
Database
IBM DB2
JCL
JES
Mainframe
Management
Migration
ACF2
Regulatory Compliance
Replication
SLA
SMP/E
SOP
SQL
Service Delivery
Operating Systems
Performance Monitoring
Performance Tuning
RACF
Recovery
Storage Management
System Administration
VSAM
z/OS
Job Details
Job Role: Mainframe DB2 Database Administrator
Location: Salt Lake City, UT (Remote)
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, 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 Omega Mon and AdminTool
- Application related performance tuning; Write, modify, and debug database specific SQL queries
- DBA related utilities like Unload, Load, DSNJU003, DSNJU004, Reorg, Runstats, and image copy
- REXX, CLIST, JCL, JES and Assembler knowledge
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.