Korn Ferry
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
#J-18808-Ljbffr
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
#J-18808-Ljbffr