Job Title: SQL
Developer/Tester (Locals Only)
Location:
Richmond, VA (Hybrid)
Duration: 6+
Months Contract
Note: ****Hybrid Schedule: This is a Hybrid role. Local
candidates are strongly advised.
Interview Process: Virtual & In-person (F2F) Both.
Responsibilities
and Skills:
Job ID: 791261
Location: Richmond, VA (VRS)
Duration: 12+ Months
Skills:
- SQL database development
and programming Required 5 Years
- QA/testing Required 3
Years
- SSIS Required 3 Years
- writing technical
documentation Required 3 Years
- automation tools such as
Power Automate Nice to have 1 Years
Description:
The Investment Decision Support team is seeking an
experienced SQL Developer/Tester.
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 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, documentation) related
to quarterly projects and other efforts as needed. Activities may include:
- Development – SQL
Development support to include creation of stored procedures or underlying
queries. Provide support in the design, development, and implementation of
ETL packages with SQL Server Integration Services (SSIS).
- Performance Tuning –
Review existing SQL Queries, Execution Plans, etc. to determine
performance enhancements for long running queries.
- Data Manipulation –
Provide alternative options to existing data manipulation techniques.
- Examples would be
converting Excel manipulation activities into SSIS packages that reduce
- process/cycle time of
data preparation.
- SQL Development
Processes – Review existing development processes and provide
recommendations on how to enhance core development activities (i.e., Code
Promotion, Code Reviews).
- Testing – Develop test
plans and cases and thoroughly test reports and workflows.
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
- Additional Preferred
Skills
- Experience with
automation tools such as Power Automate
- Experience with data
governance best practices/procedures
- Investment/financial
market industry experience
- This position will be on a contract basis for a period
of approximately 6 months with the potential for an extension.
Kind Regards.
![Untitled]()
Jitendra Upreity
Sr. Technical Recruiter
Techno-craft
Solutions LLC|
E-mail: Jite...@Technocraftsol.com
www.technocraftsol.com
3974 Brown Park Drive, Suite F Hilliard, Ohio-43026