Mid-Level Software and Database Developer (Secret Clearance)
Soilair Selection
An application made for this job — a tailored resume and cover letter that speak straight to the posting.
Benefits offered by this job
Job summary
Solerity is seeking a Mid-Level Software and Database Developer to support IGC software development, modernization, and database activities with emphasis on SQL, design, integration, performance tuning, and data-modeling. You will participate in Agile ceremonies, code reviews, and documentation to ensure secure, high-quality deliverables.
Responsibilities include API and microservice development, complex SQL optimization, data modeling, and DoD security practices within Git/GitLab CI/CD
Qualifications
- Secret Clearance required
- 4+ years in software or database development
- Experience building RESTful APIs or microservices
- Strong SQL development and query optimization skills
- Experience relational data modeling and database integration
- Experience with CI/CD and Git workflows
- Familiarity with secure coding, DevSecOps and RMF/ STIG
Responsibilities
- Develop, enhance, test, deploy, and maintain enterprise application and database components (APIs, microservices, integrations).
- Create and optimize complex SQL queries, schemas, views, indexes, functions, and stored procedures.
- Design logical/physical data models for analytics and integration needs.
- Troubleshoot connectivity, data quality, performance, and integration issues; perform query tuning.
- Develop data loading, transformation, validation, and deployment scripts.
- Support database modernization including Amazon Aurora and target platforms.
- Collaborate in Agile ceremonies and perform code/database-design reviews and documentation.
Skills
Education
Tools
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. Participate in Agile ceremonies, code and database-design reviews, sprint demonstrations, testing, release activities, and technical documentation.
- Develop, enhance, 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.
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. Participate in Agile ceremonies, code and database-design reviews, sprint demonstrations, testing, release activities, and technical documentation.
- Develop, enhance, 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.
- Secret Clearance Required
- Four or more years of professional software-development, database-development, or closely related technical experience.
- Proficiency in one or more programming languages such as Java, C#, Python, JavaScript, TypeScript, or comparable languages.
- Experience developing RESTful APIs, web services, microservices, or enterprise applications.
- Strong SQL development skills, including complex queries, joins, views, stored procedures, functions, indexes, and query optimization.
- Experience with relational database design, data modeling, database integration, and application-to-database connectivity.
- Experience with one or more enterprise relational database platforms such as Oracle, PostgreSQL, MySQL, Amazon Aurora/RDS, SQL Server, or comparable technologies.
- Experience using Git and working within established CI/CD and software-release processes.
- Understanding of Agile software development, automated testing, secure coding, DevSecOps, and continuous delivery practices.
- Experience modernizing legacy application and database components for AWS or another approved cloud environment.
- Experience supporting Amazon Aurora PostgreSQL, Aurora MySQL, Amazon RDS, or comparable managed relational database services.
- Familiarity with containerized application environments such as Docker, Kubernetes, Amazon ECS, or Amazon EKS.
- Familiarity with Apache Superset or another business-intelligence platform from a database/data-layer perspective.
- Familiarity with infrastructure-as-code or configuration-automation tools such as Terraform, AWS CloudFormation, or Ansible.
- Experience supporting Department of Defense, transportation, logistics, or other mission‑critical enterprise systems.
- A bachelor’s degree in Computer Science, Cybersecurity, Data Science, Software Engineering, Information Technology, Information Systems, or a related software‑engineering discipline; or
- One of the following current certifications: Certified Cloud Security Professional (CCSP), CyberSec First Responder (CFR), Federal IT Security Professional–Manager (FITSP‑M), GIAC Security Essentials Certification (GSEC), CompTIA Security+, or Systems Security Certified Practitioner (SSCP).
- Medical, dental and vision coverage
- Health Savings Accounts and Flexible Spending Accounts for healthcare and dependent care
- 401(k) and company‑funded life insurance
- Generous Paid Time Off (PTO)
- Tuition and training assistance
- Financial rewards for employee referrals.
- Pet insurance
- Employee discount program
Solerity is committed to the range of perspectives we bring to the marketplace by being an employer dedicated to hiring a highly qualified team of professionals, providing world class services and products aimed at exceeding our customer’s expectations. Solerity is an equal opportunity employer as to all protected groups, including protected veterans and individuals with disabilities. Solerity is a VEVRAA Federal Contractor.
'/%3e%3cpath%20d='M101.744%2012.4726L102.894%2016.1947L99.0021%2013.2201L101.744%2012.4726ZM105.3%208.40937H100.488L99.0026%203.59473L97.5116%208.41047L92.7%208.40385L96.5965%2011.3834L95.1055%2016.1942L99.0021%2013.2196L101.408%2011.3834L105.3%208.40992V8.40937Z'%20fill='white'/%3e%3cdefs%3e%3clinearGradient%20id='paint0_linear_5593_1381'%20x1='90'%20y1='9.44471'%20x2='99'%20y2='9.44471'%20gradientUnits='userSpaceOnUse'%3e%3cstop%20stop-color='%2300AD70'/%3e%3cstop%20offset='0.998594'%20stop-color='%2300B67A'/%3e%3cstop%20offset='1'%20stop-color='%23DCDCE6'/%3e%3c/linearGradient%3e%3c/defs%3e%3c/svg%3e){kind=small}
