What are the responsibilities and job description for the Database developer position at Expert Technology Services?
Description: 5 plus years experience: LIMS SQL OracleHours are flexibleRemotePrimary 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 upQualifications: • 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 : NoDrug Screen : No