*Hello,* *Hope you are doing well…..*
*Please send resumes to r...@hclglobal.com <r...@hclglobal.com>* *ROLE* *Sr Oracle Developer* *LOCATION* *Richmond VA* *DURATION* *LONG TERM* *CLIENT* *DIRECT* *INTERVIEW TYPE* *In-Person only* *Local candidates strongly preferred* *ALL candidates MUST be able to attend a personal interview, NO Phone, NO Skype, NO exceptions* *State Experience Highly Preferred* *U.S. Citizens and those authorized to work in the U.S. are encouraged to apply* *Note: For H1 While submitting I need consultant I 797 OR ID Proof.* *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) *Special Instructions to Applicants* This position requires a fingerprint-based background check. The Virginia Department of Transportation (VDOT) Information Technology Division is seeking an PL/SQL Developer to join the Roadway Network System (RNS) and Geographical Information Systems (GIS) teams in EDM (Enterprise Data Management). The Information Technology Division meets VDOT's critical business needs by improving agency responsiveness, effectiveness and efficiency, through innovative research, defined architectures, planning, and optimal use of technology. RNS provides universal enterprise data access by linking geospatial and business attributes to roadway centrelines via a web-based application. *Resource Need* The Virginia Department of Transportation (VDOT) Information Technology Division is seeking an PL/SQL Developer to join the Roadway Network System (RNS) and Geographical Information Systems (GIS) teams in EDM (Enterprise Data Management). 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. 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 RNS 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. *Skills* *Required* *Years used* *Last Used* Write and maintain/extend existing PL/SQL code to convert initial data sets, system enhancements, reports production, and improved transaction editing *5 Years* Strong development experience and/or equivalent development skills, knowledge and work history *5 Years* Bachelor’s Degree in Computer Science or Information Systems *Required* Oracle 11g/12c *5 Years* PL/SQL, Toad, SQL, *5 Years* SQL Developer *5 Years* SQL Loader *5 Years* Source Code and Team Management software (TFS preferred) *5 Years* *Thanks,* *Mani* *Technical Recruiter* *HCL Global Systems, Inc* *24543 Indoplex Circle| Suite 220 |* *|Farmington MI |* *r...@hclglobal.com )248-473-0720 EXT 157 *Certified Minority Business Enterprise (MBE)* -- You received this message because you are subscribed to the Google Groups "Oracle-Projects" group. To unsubscribe from this group and stop receiving emails from it, send an email to oracle-projects+unsubscr...@googlegroups.com. To post to this group, send email to oracle-projects@googlegroups.com. Visit this group at https://groups.google.com/group/oracle-projects. For more options, visit https://groups.google.com/d/optout.