DB2 DBA
eTeam
Apply to this jobeTeam was formed in 1999 with the goal of becoming the supplier of choice for clients, employees and contingent workers. Today, we’re one of the fastest-growing companies in New Jersey and ranked as one of the best companies to work for by Staffing Industry Analysts and New Jersey Business. We’re also an honored member of Deloitte’s Technology Fast 50
Job Role : DB2 DBA
Location : Peapack, NJ
Duration : 10 months
Job Description
- 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.
Responsibilities:
- 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 migrating from AS400 DB2 databases to MS SQL
- Experience converting AS400 DB2 databases queries to MS SQL
- Experience migrating files from AS400 to MS Windows
- Strong organization skills
- Demonstrated ability to communicate across all levels of staff and management
- Detail oriented
- Excellent interpersonal skills
- Excellent written and oral communication skills
- Solid troubleshooting and problem solving skills
- Experience in the pharmaceutical industry
- Experience with GMP systems
- Please list out the (up to) top three critical sklls
- 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
- Pharma experience is required
- Some travel required
Additional Skills:
- Experience migrating from AS400 DB2 databases to MS SQL
- Experience converting AS400 DB2 databases queries to MS SQL
- Experience migrating files from AS400 to MS Windows
If you are interested then reply me back with the below information:
- Full Name:
- Primary Contact No & Email:
- Work Authorization(US Citizen, GC, EAD, H1B etc.):
- Current Location:
- Pay Rate($XX/hr):
- Updated Resume
Thanks & Regards…..
Saurav Yadav | Sr. Technical Recruiter
eTeam, Inc. “ACCELERATED HIRES”
1001 Durham Avenue, Suite 201, South Plainfield, NJ 07080
Office : 732-318-3865 | Fax : 908-757-0800
Web: www.eteaminc.com
Summary
Migration of DB2 databases to MS SQL, adapting queries, supporting data transfer, documentation, and testing.
Job title
DB2 DBA
Experience level
not specified
Industry
technology
Location requirements
Peapack, NJ; remote work not specified
Salary
Not specified
Visa sponsorship
H-1B sponsor history
Management role
No
Required skills
Preferred skills
Specializations
Structured locations inferred from the posting.
Peapack and Gladstone, NJ, USA