REI Systems’ mission is to deliver reliable, innovative technology solutions that advance Federal clients' missions and exceed their expectations. Our technologists and consultants are passionate about solving complex challenges that impact millions of lives. We take a Mindful Modernization® approach in delivering our services, including application modernization, grants management, case management systems, government data analytics, and advisory services. This approach, the REI Way, ensures mission impact by aligning our clients' strategic objectives with measurable outcomes through people, processes, and technology. We offer the same commitment to our employees by providing professional development, meaningful projects, and flexibility to spend time with family and friends. We believe employees are at their best when fulfilled in both their professional careers and their personal lives. Learn more at www.REIsystems.com Employees voted REI Systems a Washington Post Top Workplace in 2015, 2016, 2018, 2020, 2021, 2022, 2023, 2024, and 2025!
ResponsibilitiesWe are looking for a highly skilled SQL Developer who can independently lead and execute the full transition of the application from SQL Anywhere to SQL Server, including Web Services and other related components. The ideal candidate should also bring solid Oracle knowledge, with the ability to handle the end-to-end migration with minimal oversight and maximum ownership.
Responsibilities
- Design and develop complex SQL queries, stored procedures, functions, views, triggers, and database objects.
- Develop scalable database solutions supporting enterprise applications.
- Perform SQL query tuning and database performance optimization.
- Analyze execution plans and identify performance bottlenecks.
- Support data migration, transformation, cleansing, validation, and reconciliation.
- Develop ETL/data integration processes.
- Collaborate with application developers, DBAs, analysts, and QA engineers.
- Troubleshoot production data and application issues.
- Develop scripts supporting automated database deployments.
- Ensure database solutions follow security, data integrity, and coding standards.
- Assist with data modeling and database design.
- Use AI-assisted development tools to accelerate query development, documentation, troubleshooting, and performance analysis while validating generated code.
- Support data structures and pipelines required for AI-enabled features, analytics, semantic search, or machine learning applications where applicable.
Required Qualifications
- 7+ years of SQL/database development experience.
- Advanced SQL development skills.
- Strong experience with SQL Server and/or Oracle.
- Experience with stored procedures, functions, views, triggers, indexing, and query optimization.
- Knowledge of relational database design and data modeling.
- Experience troubleshooting high-volume enterprise databases.
- Familiarity with ETL and data integration.
- Understanding of source control and CI/CD practices.
- Familiarity with AI-assisted software development and modern data platforms.
Preferred QualificationsFederal/FDA/HHS experience.Experience with Azure SQL/AWS database services.Python or scripting experience.Experience supporting AI/ML data workloads.
Education: Bachelor’s degree in Business, Engineering, Computer Science, or related field. Masters degree preferred.
Clearance: Ability to obtain and maintain a clearance is preferred.
Location: Hybrid: 2 days per week at REI Systems’ Sterling, VA office.
EEO Statement: REI Systems is an Equal Opportunity Employer
#LI-HYBRID
#LI-TK1
Skills Required
- 7+ years of SQL or database development experience
- Advanced SQL development skills
- Strong experience with SQL Server and/or Oracle
- Experience with stored procedures, functions, views, triggers, indexing, and query optimization
- Knowledge of relational database design and data modeling
- Experience troubleshooting high-volume enterprise databases
- Familiarity with ETL and data integration
- Understanding of source control and CI/CD practices
- Familiarity with AI-assisted software development and modern data platforms
- Federal, FDA, or HHS experience
- Experience with Azure SQL or AWS database services
- Python or scripting experience
- Experience supporting AI/ML data workloads
- Bachelor's degree in Business, Engineering, Computer Science, or a related field
- Master's degree
- Ability to obtain and maintain a security clearance
What We Do
REI Systems has delivered innovative solutions that empower people and impact millions of lives since 1989. Our 700 problem-solving technologists and consultants are passionate about modernizing the government to fulfill its missions more effectively. Our customers include healthcare, national security, science and technology, and government operations in the federal, state, local, and nonprofit sectors. We take a Mindful Modernization® approach in providing Application Modernization, Government Data Analytics, Grants Management Systems and Products, and Advisory Services. Delivering domain expertise, best-fit technologies through agile execution, and a commitment to customer service is the REI Way. To learn more, visit www.reisystems.com
