Job Listing Information
- 22-Jul-2021 to 05-Aug-2021 (UTC)
- Richmond, VA, 23219, USA
- Full Time
- Long Term Contract Length
- 40 Weekly Hours
ABOUT THE ROLE
VDACS is looking for an experienced Oracle PL/SQL developer to write procedures, packages, functions, and SQL to perform ETL, data migration, and reporting functions.
Required:
- Substantial experience as a PL/SQL Developer in an Oracle 12 database environment
- Experience defining Oracle database objects such as tables, triggers, indexes, and other objects using Oracle PL/SQL DDL
- Substantial experience developing Oracle PL/SQL Procedures to perform ETL to reporting data mart tables
- Substantial experience writing data migration stored procedures to move data from legacy tables and data structures into new application data structures
- Experience doing performance tuning of PL/SQL queries and stored procedures
- Experience building efficient and well documented Oracle procedures, functions, and packages
Preferred:
- Experience implementing error handling and logging in PL/SQL scripts
- Experience developing and testing Oracle Forms and Reports applications
DAY TO DAY
- Perform data migration programming to migrate data from previous Oracle application tables into new Oracle tables for a new .Net application under development
- Develop ETL procedures to take data from transactional tables and load into reporting tables for frequent refresh to support efficient use of business data
- Write stored procedures to support reporting and other data query needs
- Perform data updates for Oracle applications as needed
Skill Required / Desired Amount of Experience
Substantial experience as a PL/SQL Developer in an Oracle 12 database environment Required 10 Years
Experience defining Oracle database objects such as tables, triggers, indexes, and other objects using Oracle PL/SQL DDL Required 10 Years
Substantial experience developing Oracle PL/SQL Procedures to perform ETL to reporting data mart tables Required 5 Years
Substantial experience writing data migration stored procedures to move data from legacy tables and data structures into new application data struct Required 5 Years
Experience doing performance tuning of PL/SQL queries and stored procedures Required 10 Years
Experience building efficient and well documented Oracle procedures, functions, and packages Required 10 Years
Experience implementing error handling and logging in PL/SQL scripts Desired 5 Years
Experience developing and testing Oracle Forms and Reports applications Nice to have 5 Years