Vacancy expired!
Our Government client is looking for experienced
Oracle PL/SQL Developer’s on a renewable 12 months contract in Richmond, VA.Position – Oracle PL/SQL DeveloperExperience - 6+local candidates strongly preferredinterviews will be conducted via MS Teams or Google Meet candidates will telework now (after coming to office to pick up laptop). Once restrictions are lifted, candidates will be required to work onsite daily M-F 8-5pm, NO exceptionsThe selected candidate will write and maintain/extend existing PL/SQL code to convert initial data sets, system enhancements, reports production, and improved transaction editing. The selected candidate will• Write and maintain/extend existing PL/SQL code to convert initial data sets, system enhancements, reports production, and improved transaction editing.• Relies on experience and judgment to plan and accomplish goals, independently performs a variety of complicated tasks, may lead and direct the work of others, a wide degree of creativity and latitude is expected.• Develop database packages, procedures, functions, and queries to maintain production data and address production support tickets and provide development support. Emphasis on system interoperability, associating road edge vectors with tables defining route/street paths and intersections, and production-quality periodic load/import and problem diagnosis.• Generate edit lists where manual route associations are required.• Archive changes to a historical database.• Archive changes for synchronization with external databases.• Changes in route and street paths will cause cascading changes to events associated with route/street paths. Procedures will be developed to migrate these changes or notify business users based on type of edit and business rules.• Develop procedures to populate and update a separate de-normalized database for reporting purposes from the transaction database.• Use Microsoft Team Foundation Server for source code management and team collaboration• Communicate effectively via email and in person with technical staff, management and business stakeholders as needed in the course of performing job duties.• Participate in code reviews and be familiar with industry best practices coding standards.Qualifications:• 8 to 10 years of experience in the field or in a related area• Bachelor’s Degree in Computer Science, Information Systems with strong development experience or other applicable and/or equivalent development skills, knowledge and work history.• Knowledge of and experience with the following technologies:- Oracle 11g/12c
- PL/SQL
- Toad
- SQL
- SQL Developer
- SQL Loader
- Source Code and Team Management software (TFS preferred)
- IBM Infosphere
- ETL
- Cloud Development
- 5 years of experience to Write and maintain/extend existing PL/SQL code to convert initial data sets, system enhancements, reports production, and improved transaction editing Required
- 5 years of Strong development experience and/or equivalent development skills, knowledge and work history Required
- 5 years of experience with Oracle 11g/12c Required
- 3 years of experience with IBM Infosphere Datastage Required
- 3 years of experience with ETL And Database design Required
- 5 years of experience with SQL Loader Desired
- 5 years of experience with Source Code and Team Management software (TFS preferred) Desired
- 3 years of experience with T-SQL, SSIS Desired
- 5 years of experience with SQL Developer Nice to have
- 5 years of experience with PL/SQL, Toad, SQL, Nice to have
- Bachelor’s Degree in Computer Science or Information Systems Nice to have
Vacancy expired!