The Department of General Services (DGS) is seeking an IT professional to support enterprise-level applications and provide technical expertise for critical state procurement systems, specifically focusing on the eVA platform's core components, including invoice processing, dashboards, data warehouse systems, and customer support services.
Requirements
- High-level experience writing SQL queries using both Oracle PL/SQL and Microsoft SQL Server T-SQL
- Deep understanding of database design, data mapping, and data mining concepts
- Strong background in developing, testing, and debugging stored procedures and views
- Demonstrated ability to analyze and troubleshoot data abnormalities across systems
- Experience with application programming and debugging for both Oracle and SQL Server environments
- Skilled in developing user documentation, workflows, and technical system guides
- Experience with Business Intelligence tools such as Power BI, Crystal Reports, and Logi Info Studio
Responsibilities
- Provide ongoing support for strategic eVA projects, including invoice process completion and dashboard/data warehouse enhancements.
- Deliver technical guidance to internal teams and business units on eVA applications and services.
- Monitor and coordinate project schedules, define requirements, and ensure timely task completion.
- Develop and implement support plans for new and existing eVA enhancements.
- Lead testing activities and ensure thorough validation of application upgrades and fixes.
- Troubleshoot and resolve application issues and provide timely customer service.
- Write and debug complex SQL queries in Oracle PL/SQL and Microsoft SQL Server T-SQL environments.
Other
- This position will be located in Richmond, Virginia and must report on-site.
- This position is eligible for a hybrid telework schedule (telework up to 2 days/week) upon completion of an approved telework agreement.
- Proven ability to communicate and collaborate effectively with stakeholders at all organizational levels
- Strong organizational skills and the ability to manage priorities in a technical environment
- The selected candidate must pass a [fingerprint-based] criminal background check.
