Hybrid Software & Database Developer: REST & SQL Expert

Solerity, Inc.; Shiloh (IL); Hybrid; USD 100,000 - 115,000; Full time

Job summary

Solerity is seeking a Mid-Level Software and Database Developer to support IGC software-development, application modernization, and database-development activities.

The selected candidate will develop, integrate, test, and maintain secure application and database components supporting global transportation and logistics operations, with emphasis on SQL development, relational database design, application-to-database integration, performance tuning, and database modernization support.

Qualifications

• Four or more years of professional software-development or database-development experience.
• Proficiency in Java, C#, Python, JavaScript or TypeScript.
• Experience developing RESTful APIs, web services, microservices, or enterprise applications.
• Strong SQL development and database-design skills.

Responsibilities

• Develop, test, deploy, and maintain enterprise application and database components, including RESTful APIs, microservices, and system integrations.
• Develop and optimize complex SQL queries, schemas, tables, views, indexes, functions, stored procedures, and database scripts.
• Create and maintain logical and physical data models supporting application, reporting, analytics, and integration requirements.
• Troubleshoot application-to-database connectivity, data-quality, query-performance, and integration issues; perform query tuning, indexing, and execution-plan analysis.
• Develop repeatable scripts and processes for data loading, transformation, validation, deployment, and environment support.
• Support database modernization by modifying database objects, SQL, application queries, and data-access components for approved target platforms, including Amazon Aurora where implemented.
• Support schema conversion, data-type mapping, query remediation, data validation, reconciliation, and compatibility testing under senior database or migration engineering direction.
• Use Git and established GitLab CI/CD pipelines to build, test, validate, and deploy application and database changes in accordance with approved release processes.
• Apply secure coding and database-security practices and support applicable DoD cybersecurity, RMF, software-assurance, and STIG requirements.
• Participate in Agile ceremonies, code and database-design reviews, sprint demonstrations, testing, release activities, and technical documentation.

Skills

Java

C#

Python

JavaScript

TypeScript

RESTful APIs

SQL

Data modeling

Git

CI/CD

Agile

Secure coding

Education

Bachelor's degree in Computer Science, Software Engineering, or related field

Tools

Oracle

PostgreSQL

MySQL

Amazon Aurora/RDS

SQL Server

Docker

Kubernetes

Amazon ECS/EKS

AWS

Job description

Solerity is seeking a Mid-Level Software and Database Developer to support IGC software-development, application modernization, and database-development activities.

The selected candidate will develop, integrate, test, and maintain secure application and database components supporting global transportation and logistics operations, with emphasis on SQL development, relational database design, application-to-database integration, performance tuning, and database modernization support.