Database developer

Description :

5 plus years experience : LIMS SQL Oracle

Hours are flexible

Remote

Primary Tasks and responsibilities

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

Qualifications :

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 WebLogic Server Red Hat JBoss Enterprise Application Platform or IBM WebSphere Application Server)

Supplier Spotlight Call : Monday 12 / 15 at 1 : 30pm CST

Required Skills :

Basic Qualification :

Additional Skills :

Background Check : No

Drug Screen : No

Key Skills

Databases,SQL,Database Development,PL / SQL,Microsoft SQL Server,ssrs,Database Design,SSIS,T Sql,Sybase,Data Warehouse,Oracle

Employment Type : Full Time

Experience : years

Vacancy : 1