DB2 DBA

• Pursuing a database migration and queries Subject Matter Expert for contract work in Peapack, NJ.
• Responsibilities would include, but are not limited to, migration of databases from AS400 DB2 to MS SQL. Altering DB2 queries to run under MS SQL.
• Developing associated documentation and test protocols.

• Understanding DB2 database design and MS SQL functions
• Proficient in migrating DB2 databases to MS SQL
• Proficient in adapting DB2 queries to either MS SQL systems
• Verification of migration of data over LAN/WAN
• Supporting data request from the archival environment
• Developing queries from data dictionary
• Working with remote SMEs located in International (DB2 SME’s)
• Early morning meeting will be required as needed
• Develop, write and execute procedural protocols and test scripts
• Recommend and implement improvements to the existing Database procedures
• Communicate to various levels of technical skill sets in an effective manner
• Communicate across all levels of staff and management
• Work independently as well as in a team environment
• Accurately track and report project hours
• Work with GMP and validated systems
• Follow Standard Operation Procedures
• Comply with corporate processes

• Experience converting AS400 DB2 databases queries to MS SQL

• Demonstrated ability to communicate across all levels of staff and management

• Proficient in adapting DB2 queries to either MS SQL systems

• Experience migrating from AS400 DB2 databases to MS SQL
• Experience converting AS400 DB2 databases queries to MS SQL

If you are interested then reply me back with the below information: