DBA

Korn Ferry; Columbus (OH); On-site; USD 75,768 - 89,544; Part time

Job summary

A leading consulting firm in Columbus, OH seeks an Entry Level DBA to administer and support scalable Mainframe DB2 & IMS database solutions. The role includes resolving database performance issues and implementing data models. Ideal candidates will have formal training or certification in software engineering and over 5 years of applied experience. This is a contract position within the Information Technology sector, offering competitive pay ranges at $55 to $65 per hour.

Qualifications

• 5+ years of applied experience in software engineering concepts.

Responsibilities

• Administer, design, implement and support Mainframe DB2 & IMS databases.
• Resolve database performance and capacity issues.
• Work with Information Architects to implement physical data models.
• Develop database performance monitoring processes.

Skills

Database design/development

Integration

Performance monitoring & tuning

Systems re-engineering

Operations support

Knowledge of DB2 for z/OS

Mainframe tools (BMC, CA Platinum)

IMS Full Function/Fast Path implementation

REXX programming

IBM Replication CDC

Roadmap and strategy creation

Atlassian tools (Jira, Confluence)

Database engineering

Automation

Performance engineering design

Distributed and Static SQL workloads

Education

Formal training or certification on software engineering

Job description

Base pay range

$55.00/hr - $65.00/hr

Responsibilities

• Administer, design, implement and support highly available and scalable Mainframe DB2 & IMS database solutions
• Implement data models, database designs, data access and table maintenance codes.
• Implement and maintaining the DB2/IMS Databases with High Availability features using Data Partitioning and Database replications.
• Resolve database performance issues, database capacity issues, replication and other data issues.
• Work with Information Architects and Database Designers to implement the physical data model.
• Develop the database performance monitoring process and analyze data for optimization opportunities.
• Provide up to Level 2 on call support for the 24/7 DB2/IMS database environment.
• Manage on-site backup and recovery process.
• Plan for and execute required database upgrades or migrations.
• Work with database admin tools like CA Platinum/ BMC/ IBM Admin tools, Mainview, IBM Data Studio, BMC Recovery management etc.

Skills Required

• Database design/development, integration, performance monitoring & tuning, systems re-engineering and Operations support.
• Knowledge of DB2 for z/OS along with mainframe related tools such as BMC, CA Platinum for monitoring, SMPE, ISPF, SMS, SMF.
• Expertise with IMS Full Function/Fast Path database implementation, REXX programming and MQ
• Experience in IBM Replication CDC , QREP.
• Capable of creating the roadmap, processes, best practices, standards, and strategies for continuous improvement, resiliency, and scalability.
• Experience with Atlassian tools like Jira, Confluence.
• Proven background on database engineering, automation, monitoring, performance engineering design and implementations.
• Strong execution mind-set to manage and track progress against transformation goals.
• Knowledge of industry-wide technology trends and best practices
• Experience providing 24x7 rotational support.
• Understanding of Distributed and Static SQL workloads
• Familiar with IDAA (Data Analytics Accelerators)

Education & Work Experience

• Formal training or certification on software engineering concepts and 5+ years applied experience

Seniority level

• Entry level

Employment type

• Contract

Job function

• Information Technology

Industries

• Data Infrastructure and Analytics

Title

DBA

Location

Columbus, OH

Client Industry

Fintech

About Korn Ferry

Korn Ferry unleashes potential in people, teams, and organizations. We work with our clients to design optimal organization structures, roles, and responsibilities. We help them hire the right people and advise them on how to reward and motivate their workforce while developing professionals as they navigate and advance their careers. To learn more, please visit Korn Ferry at www.Kornferry.com