Radiant Digital, Inc. delivers comprehensive Program Management, Science, Engineering, and Technology solutions to federal, commercial, state, and local agencies. We are a subsidiary of Radiant Digital Services and maintain a diverse portfolio of clients nationwide. Our technology support spans numerous organizations, including the U.S. Department of Defence, NASA, Voice of America, the FDA, and multiple state agencies such as Florida, Rhode Island, Mississippi, North Dakota, Virginia, and West Virginia-extending our global delivery of innovative solutions.

 

Position Title

Senior SQL Developer / Tester

 

Duration

6+ Months

 

Location

Richmond, VA
(Local candidates only)

 

Work Mode

Hybrid

 

Interview Mode

Web Cam Interview

 

Role Overview

The Virginia Retirement System (VRS) Investment Decision Support (IDS) team are the primary data stewards for the Investments Department. IDS connects data to investment analysis by overseeing all aspects of the data management life cycle. They work closely with investment programs to understand their business data and decision support requirements, develop tools to extract valuable and timely information, and continuously improve processes and systems to ensure high levels of data integrity and availability. The IDS team is seeking seasoned SQL development and testing expertise to successfully assist with ongoing business initiatives.

 

Scope 

The Investment Decision Support (IDS) team is seeking an experienced SQL Developer / Tester with strong database, programming, and analytical skills to actively participate in the following scope of work:

• Assist with overall SQL support (development, performance tuning, testing, and documentation) related to quarterly projects and other initiatives as needed.

 

Scope Activities Include:

• Development
• Provide SQL development support including the creation of stored procedures and underlying SQL queries.
• ETL / SSIS
• Support the design, development, and implementation of ETL packages using SQL Server Integration Services (SSIS).
• Performance Tuning
• Review existing SQL queries, execution plans, and related components to identify and implement performance improvements for long-running queries.
• Data Manipulation
• Provide alternative approaches to existing data manipulation techniques.
• Convert Excel-based data manipulation activities into SSIS packages to reduce data preparation process and cycle time.
• SQL Development Processes
• Review existing SQL development processes.
• Provide recommendations to enhance core development activities such as code promotion and code reviews.
• Testing
• Develop test plans and test cases.
• Thoroughly test reports and workflows to ensure accuracy, performance, and reliability.

 

Required Skills

• 5+ years of experience in SQL database development and programming
• 3+ years in a QA/testing role
• Experience with SQL Server Integration Services
• Experience writing technical documentation (requirements, process maps, etc.)
• Excellent communicator and ability to produce clear and concise documentation
• Demonstrated experience working in a team environment
• Demonstrated experience working independently with only high-level guidance

 

 

Must Have :

• 5 years of experience with SQL database development and programming
• 3 years of experience with QA/testing
• 3 years of experience with SSIS
• 3 years of experience with writing technical documentation
• 1 year experience with automation tools such as Power Automate

5 years of experience with SQL database development and programming 3 years of experience with QA/testing 3 years of experience with SSIS