JPS Tech Solutions ยท 2 days ago
Database developer
Atlanta, GA
Full-time
Onsite
Senior Level, Lead/Staff
10+ years expJPS Tech Solutions is seeking an experienced Database Developer to support their onsite operations in Atlanta, Georgia. The role involves environmental setup, data cleansing, and documentation for database systems to ensure data integrity and security.
Information TechnologyIT InfrastructureSoftware Engineering
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
Qualification
Required
10 plus years experience: LIMS SQL Oracle
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
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)
Preferred
Experience with Jasper Reports is a plus
Company
JPS Tech Solutions
JPS Tech Solutions offers software engineering, cloud, mobile development, and IT infrastructure solutions.
201-500 employees
H1B Sponsorship
JPS Tech Solutions has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (7)
2024 (17)
2023 (9)
2022 (5)
Funding
Current Stage
Growth StageCompany data provided by crunchbase