Job Description

Our client is seeking an iSeries / DB2 DBA. This person will be responsible for database administration tasks, including but not limited to setup of new databases and database objects. This person will manage database objects in the development, test, and production environments, index analysis, and performance monitoring; maintain database logs and transaction log backups, and perform database backup and restores.

The responsibilities of this position include the following:

* Day to day database maintenance tasks (Monitoring, Backups, space Management, resource utilization, capacity planning etc.)
* Manage database environment to provide high availability and continuous operation as required
* Responsible for performing object migration between database environments, (e.g., Development, Test, Production)
* Testing of new releases and features for application, O/S and Database upgrade
* Troubleshoot application level performance and optimize database/ application performance
* Design/Implement database security. Create and maintain users/roles and assign privileges
* Assist in developing Disaster Recovery and backup procedures along with the Business Continuity Team
* Work closely with system administrators to assist with successful installation, upgrades, and patches
* Cloning production databases for testing/ stress testing / patch management/ upgrades etc.
* Provide on-call support

The skills and  experience required for this position include the following:

* 5+ years of iSeries experience is required, along with 5+ years of Database Administration experience on the IBM iSeries Platform. Knowledge of different iSeries query engines
* Experience with data modeling, logical and physical database design, internals, performance tuning, strong SQL programming skills as well as SQL tuning and analysis
* Experience with Data Warehousing including conceptual and practical applications is a plus
* Experience Microsoft SQL Server is a plus
* IBM certification is preferred
* Strong iSeries OS skills
* Good concepts on database architecture and internals