Mainframe DB2 DBA

• Administer DB2 database and subsystems.
  • Monitor storage, support capacity planning, support securing ZOS resources, perform routine maintenance tasks, assist with data migration tasks, troubleshoot and resolve issues.
• Provide status reports as required by CLIENT personnel.
• Log activity and time using DMV time tracking software (Jira) daily.
• Follow guidelines established by CLIENT.
• Support CLIENT IT teams as needed.
• Document changes and follow protocols established by CLIENT.

• Manage, monitor, and tune DB2 subsystems and application environments.
• Clone databases and establish additional application environments.
• DB2 database and dataset backup and recovery.
• Refresh data, as needed.
• Clone and establish additional application environments, as needed.
• Aid in data conversion projects and extract data to staging environments, as needed.
• Maintain privacy and security of data.
• Support Application Lifecycle, application development tools, as needed.
• Migrate database changes.
• Document and update procedures and check list.

• Coordinate upgrades to ZOS, CICS, DB2, Administration tools, and application development tools.
• Coordinate DR testing and support data conversion and migration.
• Help IT teams with SQL review and tuning.
• Discuss business requirements and help with application and database design.
• Support CICS environments.

• Complete work and project tasks assigned.
• Consultant must provide daily / weekly status reports of the project with details on tasks and hours spent on each task, as well as:
  • Overall completion status of the project in terms of the approved project plan and schedule.
  • Document problems that were encountered and proposed/actual resolution.
  • Document issues that need to be addressed.
  • Document accomplishments during the period.
  • Document activities to be accomplished during the next reporting period.

• Have the capability to perform the functions described in Scope of Work section.
• Have a bachelor's degree in computer science, or any other equivalent degree or equivalent years of relevant experience, with a minimum of seven (7) years of DB2 DBA experience in ZOS platform.
• Have experience administering complex DB2 environments with multiple subsystems.
• Be experienced working on ZOS tools and utilities - TSO, ISPF, SDSF, JCL, DFSORT, ICETOOL, DFDSS, DFSMS, DFHSM, OMVS, RACF, REXX/CLIST.
• Be experienced with using DB2 tools - SPUFI, QMF, DB2 Admin Tool or equivalent, DB2 Object Compare or equivalent, IBM Data Studio, OMEGAMON or equivalent, Query Monitor or equivalent.
• Be proficient with DB2 utilities and DB2 backup and recovery.
• Be able to work with the IT teams to understand the requirements and design databases.
• Be able to implement and migrate database changes.
• Have experience securing database objects.
• Have expertise in evaluating and tuning SQL and experience tuning DB2 subsystem.
• Have knowledge of DB2 Attachment facilities.
• Have good knowledge of COBOL/CICS/DB2 application programming environment.
• Have good communication, documentation and user requirement gathering skills.
• Be proficient in analyzing, debugging, and troubleshooting issues and ABENDs.
• Be a team player who can work with other contractors/consultants and permanent employees under a complex team structure.

• Experience installing and configuring DB2 Connect.
• Experience working with Application Lifecycle Management tools like LCM, CHANGEMAN, ENDEVOR, SCLM, RTC, or similar.
• Experience working with data modeler tools like ERWIN or similar.

• Personal computer equipment for any potential remote work that meets State security standards.

• 100% remote (or on site)
• Must be able to pass Crimininal background check before starting work.
• 40 hrs a week (Weekend work will be rare, but times when the mainframe maintenance will be done outside of normal business hours. No overtime work will be required. 
• Possible extension past 12/31/2026.

• Comprehensive medical benefits
• Competitive pay
• 401(k) retirement plan
• …and much more! 

About INSPYR Solutions
Technology is our focus and quality is our commitment. As a national expert in delivering flexible technology and talent solutions, we strategically align industry and technical expertise with our clients' business objectives and cultural needs. Our solutions are tailored to each client and include a wide variety of professional services, project, and talent solutions. By always striving for excellence and focusing on the human aspect of our business, we work seamlessly with our talent and clients to match the right solutions to the right opportunities. Learn more about us at inspyrsolutions.com.
INSPYR Solutions provides Equal Employment Opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, sex, national origin, age, disability, or genetics. In addition to federal law requirements, INSPYR Solutions complies with applicable state and local laws governing nondiscrimination in employment in every location in which the company has facilities.

Information collected and processed through your application with INSPYR Solutions (including any job applications you choose to submit) is subject to INSPYR Solutions’ Privacy Policy and INSPYR Solutions’ AI and Automated Employment Decision Tool Policy: https://www.inspyrsolutions.com/policies/. By submitting an application, you are consenting to being contacted by INSPYR Solutions through phone, email, or text.