Mainframe DB2 DBA @ Infinity Solutions | Jobright.ai
JOBSarrow
RecommendedLiked
0
Applied
0
External
0
Mainframe DB2 DBA jobs in United States
28 applicantsPosted by Agency
company-logo

Infinity Solutions ยท 1 day ago

Mainframe DB2 DBA

positionUnited States
timeContract
remoteRemote
senioritySenior Level
date5+ years exp
ftfMaximize your interview chances
ConsultingSoftware

Insider Connection @Infinity Solutions

Discover valuable connections within the company who might provide insights and potential referrals.
Get 3x more responses when you reach out via email instead of LinkedIn.

Responsibilities

Administration of databases throughout the development and production lifecycles.
Creation and execution of DDL/DCL for managing DB2 databases.
Maintenance procedures using DB2 Utilities (COPY, REORG, MODIFY, RECOVER)
Conduct performance monitoring and tuning activities on DB2 databases.
Reviewing and maintaining security procedures across the DB2 databases.
Work with DB2 z/OS System support staff on installation/upgrade efforts.
Provide mentorship to group members and help develop and support junior level staff.
Provide advice and support to development resources.
24x7 on-call support rotation.
Application of database changes during non-peak hours as required by applications.
Other duties as directed by management.

Qualification

Find out how your skills align with this job's requirements. If anything seems off, you can easily click on the tags to select or unselect skills to reflect your actual expertise.

DB2SQLMainframe IMSDB2 UtilitiesBMC DB2 toolsREXXCOBOLJavaDB2 11DB2 12BMC Mainview for IMSDelta IMSHALDBPerformance tuningTSO/ISPFQMFTMON for DB2/IMSMulti Logical DatacenterLogical Partition z/OSDB2 Datasharing

Required

5 years mainframe IMS experience (on-line and Batch) from a system and application perspective.
Experience with BMC Mainview for IMS.
Experience with Delta IMS.
Experience with HALDB and fast path database.
5 years mainframe DB2 DBA expertise including experience with DB2 11.
Strong knowledge of SQL and SQL coding for performance on DB2 z/OS.
Experience with basic Explain tool for SQL and understanding of DB2 access paths.
Strong knowledge of DB2 Utilities and JCL.
Experience with BMC DB2 tools.
Experience working in a TSO/ISPF environment.
Ability to independently research problems and provide solutions.
Willing to work a 24/7 on-call rotation.
Availability to provide weekend/off-hours support as needed.
Excellent verbal and written communication skills.

Preferred

Mainframe DB2 DBA experience Version 12.
Prior experience in mainframe application development accessing DB2 databases.
Multi Logical Datacenter(LDC) and Logical Partition(LPAR) z/OS environment experience.
DB2 Datasharing environment.
Experience working with REXX, COBOL, Java programming languages.
Experience with QMF.
Experience with TMON for DB2/IMS.

Company

Infinity Solutions

twittertwitter
company-logo
Infinity Solutions is a staffing company that provides custom software development, consulting, and strategic IT staffing services.
dateFounded in 2017
location
Etobicoke, Ontario, CAN
people-size11-50 employees
web-link
https://infinitysolutions.ca/

Funding

Current Stage
Early Stage
Company data provided by crunchbase
logo

Orion

Your AI Copilot