Mainframe Consultant

Capital Technology Alliance; Tallahassee (FL); On-site; USD 80,000 - 100,000; Part time

Job summary

A technology consulting firm is seeking a Database Admin experienced in managing IBM DB2 databases and working in an Azure environment. The role includes responsibilities such as performance tuning of mainframe databases, ensuring data integrity, and collaborating with programming staff. A Bachelor's degree in Computer Science or a related field is required, along with significant experience in database management. This contract position allows you to apply your expertise in an IT Services and Consulting environment in Tallahassee, FL.

Qualifications

• 6+ years of experience with IBM DB2 database.
• 3+ years of experience in an Azure environment.
• Familiarity with Data Warehouse techniques.

Responsibilities

• Establish quality assurance techniques for COBOL development.
• Analyze and monitor existing mainframe environments.
• Conduct performance tuning for DB2 and IBM z/OS.

Skills

IBM DB2 database management

Cloud-native databases

Computer-Aided (CA) database tools

SQL (version 2012 or higher)

Entity-Relationship Diagrams (ERDs)

Education

Bachelor’s degree in Computer Science or related field

Job description

Get AI-powered advice on this job and more exclusive features.

This requirement is for a Database Admin for a Mainframe system with COBOL experience.

Primary Responsibilities:

• Establish, maintain, and apply quality assurance techniques and processes to optimize COBOL application development efforts.
• Analyze and monitor existing mainframe environments for potential improvements and provide technical guidance.
• Conduct performance tuning of mainframe database environments at the system level, specifically for DB2 and IBM z/OS.
• Participate in the annual disaster recovery of the mainframe environment.
• Ensure quality, accuracy, reliability, validity, precision, and integrity of data resources and derived information.
• Develop and maintain metadata for entities and data elements, including relationships, origins, meanings, and uses.
• Create and maintain an enterprise data model for the Offender-Based Information System (OBIS) DB2 database.
• Analyze proposed data elements for addition to database structures and assess impact on size and performance.
• Monitor database operational performance to ensure response time minimums are met and maintain database integrity.
• Collaborate with application programming staff on data element access and ensure adherence to standards.

Minimum Qualifications:

• 6+ years of experience with IBM DB2 database, including creating, maintaining, optimizing, and modifying DB2 databases.
• Proficiency in using Computer-Aided (CA) database tools.
• 3+ years of experience working in an Azure environment and utilizing cloud-native databases.
• Must successfully complete a Level II Background Check.

Preferred Qualifications:

• Knowledge of Azure SQL databases.
• Familiarity with Data Warehouse techniques and processes.
• Ability to create and update Entity-Relationship Diagrams (ERDs).
• Knowledge of DB2 upgrade processes.
• 5+ years of experience with SQL (version 2012 or higher).

Education:

• Bachelor’s degree in Computer Science, Information Systems, MIS, Data Processing, or related field OR four (4) years of equivalent work experience.

Seniority level

Mid-Senior level

Employment type

Contract

Job function

Information Technology

Industries

IT Services and IT Consulting

Referrals increase your chances of interviewing at Capital Technology Alliance by 2x

Get notified about new Mainframe Consultant jobs in Tallahassee, FL.