Copart
Junior Software Engineer
Copart, Dallas, Texas, United States, 75215
Posted Wednesday, July 10, 2024 at 6:00 AMCopart is seeking candidates eager to begin a career in the database engineering team. The position will be focused on database modeling, development, maintenance, and automation. The candidate will build a physical database model and develop queries, stored procedures, views, triggers, and other database objects to support the business requirements. Additionally, this individual will troubleshoot data issues reported by business and resolve complex process problems requiring SQL logic rewrites.Responsibilities:Work closely with our business analyst to translate/validate business requirements into
Jira
stories.Design, enhance & draw conceptual model in
Visio , publish on
Confluence , and review with application & business team to confirm requirements.Develop physical data model and build DDL ( Data Definition Language ) script to be deployed to target database such as
MySQL ,
MariaDB ,
PostGreSQL , and DB2 (LUW) using
LiquiBase .Maintain versioning of
GitHub
to allow parallel development efforts.Develop
ETL
(Extract, Transform, Load) jobs to update
SOLR
(NoSQL) Data store with the latest lot data from the inventory database using ETL tools like
Pentaho Data Integration
(PDI) and SQL stored procedures that transform the data and index it to
SOLR
via a Java application.Work with business analyst to keep the reference data as per industry standard.Develop automation scripts for reference data maintenance and database maintenance activities using
Python .Work closely with the DBA team to set up databases in Copart’s different data centers to support operations in multiple countries.Work with application teams to identify ways to
optimize
the database tier and implement improvements for future releases.Ensure model and structure are kept in sync between different tracks created within the same database instance to support parallel development for different releases.Plan and coordinate with DBA team and DevOps team for promoting models from DEV to QA, QA to Stage, and Stage to production environment.Review deployment plans with the application team to ensure application configuration data is kept in sync within different environments.Ability to be flexible and work well with changing priorities.Time management skills with the ability to participate in multiple projects/work streams simultaneously, as well as strong analytical/problem-solving skills.A self-starter who thrives with minimal supervision.Ability to express yourself well, verbally and in writing.Required Experience:BS, BA in Computer Science, Computer Information Systems, MIS, or relevant technology degree.Minimum 2 years previous related experience with RDBMS systems.
#J-18808-Ljbffr
Jira
stories.Design, enhance & draw conceptual model in
Visio , publish on
Confluence , and review with application & business team to confirm requirements.Develop physical data model and build DDL ( Data Definition Language ) script to be deployed to target database such as
MySQL ,
MariaDB ,
PostGreSQL , and DB2 (LUW) using
LiquiBase .Maintain versioning of
GitHub
to allow parallel development efforts.Develop
ETL
(Extract, Transform, Load) jobs to update
SOLR
(NoSQL) Data store with the latest lot data from the inventory database using ETL tools like
Pentaho Data Integration
(PDI) and SQL stored procedures that transform the data and index it to
SOLR
via a Java application.Work with business analyst to keep the reference data as per industry standard.Develop automation scripts for reference data maintenance and database maintenance activities using
Python .Work closely with the DBA team to set up databases in Copart’s different data centers to support operations in multiple countries.Work with application teams to identify ways to
optimize
the database tier and implement improvements for future releases.Ensure model and structure are kept in sync between different tracks created within the same database instance to support parallel development for different releases.Plan and coordinate with DBA team and DevOps team for promoting models from DEV to QA, QA to Stage, and Stage to production environment.Review deployment plans with the application team to ensure application configuration data is kept in sync within different environments.Ability to be flexible and work well with changing priorities.Time management skills with the ability to participate in multiple projects/work streams simultaneously, as well as strong analytical/problem-solving skills.A self-starter who thrives with minimal supervision.Ability to express yourself well, verbally and in writing.Required Experience:BS, BA in Computer Science, Computer Information Systems, MIS, or relevant technology degree.Minimum 2 years previous related experience with RDBMS systems.
#J-18808-Ljbffr