Us Citizen
Green Card
Corp-Corp
Consulting/Contract
UG :- - Not Required
PG :- - Not Required
No of position :- ( 1 )
Post :- 22nd Mar 2021
Requisition Class: SAAPPS : ERPDEVV2 : ERPDEV3 : Region 1-Virginia
Region Name: Virginia Information Technology Agency
Title/Role: DSS - ERP Developer 3 (648440)
Start Date: 04/12/2021
End Date: 06/30/2021
Worksite Address: 801 E. Main Street, Richmond, VA 23219
Agency Interview Type: Web Cam Interview Only
Candidate is required to go onsite to pick up equipment
Role is remote UNTIL restrictions lift, then it is 100% onsite
Candidates will be forwarded by COB 3/25
Experienced Oracle PL/SQL Developer w/ PERL development expertise.
Develop, update and modify new and existing Oracle PL/SQL code on multiple versions of Oracle backend databases. Tune and troubleshoot PL/SQL and SQL related issues related to performance & functionality. Perform and participate in code reviews, data migrations, database migrations, data masking/scrubbing and numerous other development activities as presented. Integration & execution of PL/SQL code through Linux/Windows scripting and Perl integration. Support development of coding of complex SQL in support of non-oracle-based access requests from PowerBI, PowerBuilder, Perl, Java, Salesforce, Dynamics CRM and PowerApps.
Participate in design & requirements sessions, support creation of test plan, data validation scripting and requests for SQL support. Creation of automation scripts in support of batch processing, QA testing and BOT automation initiatives.
Requires a depth and breadth of database knowledge that shall help with formal design of relational databases and provides insight into strategic data manipulation. Must be able to review/interpret complex PL/SQL and SQL scripts. Must be able to leverage cloud technologies in support of moving database between on-premise and cloud architectures. Must be able to work on windows and Linux servers in support of PL/SQL and SQL support services. Must be able to train/mentor peers on creating analyzing and modifying PL/SQL and SQL elements.
Develop, review and update Perl scripts to support business/customer requests.
Oracle PL/SQL Development
Required
10
Years
Writing, analyzing and debugging complex SQL
Required
10
Years
High-Level of understanding of the Oracle database environment (objects, connectivity, database features)
Required
10
Years
Experience developing Perl scripts
Desired
2
Years
Experience developing in Salesforce Lightning
Nice to have
2
Years
Experience working with PowerBI
Nice to have
10
Years
Experience working with Dynamics CRM (PowerApps)
Nice to have
10
Years
Question 4
Is the candidate aware this position will be 100% onsite once restrictions lift?
Question 5
Is the candidate aware they will have to go onsite to DSS for onboarding?
Question 6
Please confirm that the candidate has not already submitted a RTR - ask them to search their email if they are not sure.