Get new jobs for this search by email

Mainframe DB2 System DBA 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 the customer. Ensure completion of authorized Service Requests, Changes, and Problem tickets. Manage escalations and track Service Delivery to ensure SLA compliance, including with vendors. Review and update SOP documents regularly. Support all ongoing 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 of ACF2/RACF, CICS v5.5, Mainframe MQ v9. Experience with 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). Experience with Database ISV Tools and Products like OmegaMon and AdminTool. Application performance tuning; writing, modifying, and debugging SQL queries. DBA utilities like Unload, Load, DSNJU003, DSNJU004, Reorg, Runstats, image copy. Knowledge of REXX, CLIST, JCL, JES, and Assembler. DB2 keywords: 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, DSNJU003, DSN1LOGP, DSN1SDMP. Diverse Lynx LLC is an Equal Employment Opportunity employer. All qualified applicants will receive due consideration for employment without discrimination. We promote and support a diverse workforce across all levels in the company.

#J-18808-Ljbffr