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!
Responsibilities:
We 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.
Qualifications:
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 Qualifications
Federal/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
