Database developer

Job Category: Developer

Job Type: Onsite

Job Location: Deerfield Illinois

Compensation: Depends on Experience

W2: W2-Contract Only;
Kindly note that applications on a C2C basis will not be considered for this role.

• Environmental setup & system Cloning
• Set up the environment/DB required to perform the cleansing in Baxter DMZ and validate the same with complete readiness
• Set up data filtration scripts to filter Baxter and Vantive data excluding SIMTRA data and continuous replication
• Remove security groups, permissions, or security keys from the cloned system (in the DMZ infrastructure environment) Data Cleansing
• Analyze database structure and create data cleansing scripts for all database tables to clean SIMTRA data (Both Bloomington and Halle Data)
• Remove all SIMTRA data associated with SIMTRA Manufacturing sites, SIMTRA Product Codes, documents (files/attachments) including SIMTRA PII data from the cloned system Testing and Validation
• Draft data verification scripts to ensure no SIMTRA data is being shared with Vantive
• Perform regression testing to ensure system accuracy Documentation
• Prepare documentation that Vantive will need to clone the application on their end to enable system access
• Provide specific instructions for Vantive to complete the integrations and complete system set up

• LIMS development and configuration skills
• Solid understanding of Build/ Deployment Process
• Strong experience of Labvantage LIMS version 8 and above
• Strong analytical, communication, interpersonal and organization skills required
• Ability to work independently, under minimal direct supervision
• Advanced technical knowledge of Java modules and frameworks including web services, hibernate, and JMS
• Experience with Jasper Reports is a plus
• Should have good command on SQL Queries (able to write complex queries) either in Oracle or MS SQL.
• Experience of Java EE server (Oracle Web Logic Server, Red Hat JBoss Enterprise Application Platform, or IBM Web Sphere Application Server)

Job
-5015

Entry level

Full-time

Information Technology

IT Services and IT Consulting

Referrals increase your chances of interviewing at JPS Tech Solutions by 2x