Job Description :
Job Title : Mainframe Database Administrator (DBA)
Duration : 3 month plus project with extensions.
Please provide current location, availability and hourly pay rate expectations.
Job Description :
The mainframe database administrator (DBA) will be part of a team of mainframe modernization and optimization assessment team.
DBA will provide critical support to understand their current database landscape for mainframe applications and future needs.
Assess current mainframe IMS /DB2 / IDMS database administration, supporting key business initiatives, using the full suite of BMC and IBM tools and utilities.
Works with customer database personnel to understand their current database platform and future needs.
DB2/IMS/IDMS Database administration experience, experience with mission critical, OLTP applications preferred, including performance tuning, migrations, backup and recovery methods.
Minimum 5-7 Years experience administering Db2 /IMS/IDMS for z/OS databases in an enterprise environment
Hands-on expertise in Database design, build, change and implementation
Experience with BMC DB2 tools
Working experience with Batch/Online IDMS programs.
Experience in Teradata on z/OS
Work experience on IDAA - IBM Db2 Analytics Accelerator
Work experience in performing IDMS DBA management functions
Experience in converting non-relational DB like VSAM, IMS, IDMS to relational DB like Db2, Oracle etc.
DB2/IDMS /IMS Database administration experience, experience with mission critical, OLTP applications preferred, including performance tuning, backup and recovery methods.
Familiarity with IMS access via CICS, MQ and open system ODBC, JDBC drivers.
Experience with IBM and BMC IMS utilities
Experience of working with big COBOL programs that read and update large mainframe IDMS databases.
Database performance monitoring and recommendations for improvement.
Experience supporting a multi-terabyte environment.
Experience supporting high throughput OLTP applications.
Experience supporting applications within a DB2 data sharing environment
Works with customer database personnel to understand their current database platform and future needs
Experience with cross platform data movement and integration.
Application database backups, monitoring, recovery, utilities and security.
Provide performance, capacity and utilization reporting