Mainframe DB2 System DBA
jconnect infotechSalt Lake City (UT)
Mainframe DB2 System DBA
Posted 9 days ago
jconnect infotechSalt Lake City (UT)
SENIORITY
Senior
About the role
Mainframe DB2 System DBADefine 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 DB2 keywords:
Before you apply
Applying takes about a minute. These four things decide how fast it moves after that.
Your profile is current
It's what we read first. Occupations, seniority and locations matter more than a long history.
Two examples you can talk through
Not a portfolio — just two pieces of work where you can explain the decisions and what you'd change.
A number in mind
What you're on now and what would make you move. We negotiate better when we know both.
Your notice period
Employers plan around it, and it's the question that stalls offers most often.
Once you apply, someone reads it and calls you before anything reaches the employer — usually within two working days.