IBM I DBA Consultant

Company: K-Tek Resourcing LLC
Location: Framingham
Posted on: March 28, 2020

Job Description:

Position - IBM I DBA Consultant Location - Framingham, MA Mode - Contract Qualification 7+ years of iSeries experience is required, along with 7+ years of Database Administration experience on the IBM iSeries Platform. Knowledge of different iSeries query engines AS400 Benchmark testing 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 Strong iSeries OS skills Good concepts on database architecture and internals A self-motivator that plans and manages time well ability to manage and coordinate multiple projects concurrently Responsibilities Database administration tasks including but not limited to setup of new databases and database objects. Manage database objects in the development, test, and production environments, index analysis, performance monitoring, maintain database logs and transaction log backups, perform database backup and restores. 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, OS and Database upgrade. Troubleshoot application level performance and optimize database application performance. DesignImplement database security. Create and maintain usersroles 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 during non-business hours. Monitor and optimize system performance using index tuning, disk capacity management and optimization, and other methods Troubleshoot application level performance and optimize database application performance. Perform regular reviews of the database to identify performance problems SQL programming and providing guidance to developers on writing efficient SQL. Maintain logical and physical database model ensure the necessary referential integrity constraints are in place. Participate in hardware, technology architecture amp layout. Participate in the evaluation of the appropriate use of technologies, including hardware, utilities, purchased software and data access. Establish and enforce policies and procedures pertaining to database security, maintenance, and use. Take part in analysis and design sessions, provide technical feedback. Assist the Developers in reengineering the native IO to SQL IO Create and maintain data models and data dictionaries.

Keywords: K-Tek Resourcing LLC, Framingham , IBM I DBA Consultant, IT / Software / Systems , Framingham, Massachusetts