VDH PLSQL Developer REMOTE

VDH PL/SQL Developer REMOTE

*Candidates MUST be able to come onsite to pick up laptop NO exceptions.
*for this reason local Richmond VA candidates strongly preferred



Seeking PL/SQL resource with object oriented concept to develop and incorporate business processes to produce various reports data extractions interfaces scheduling data analysis writing and tunning PL/SQL programs improve performance.

Develop and incorporate business process to enhance systems. Write and modify pl/sql code based on requirement enhancement and production support with specific emphasis on the development and changes related to data bound queries sql tuning pl/sql enhancements to get improved performance. develop data interfaces data transfer relational diagrams scheduling and application code. Collaborate development activities with other team members. Create technical specification and other documents asrequired.

• Develop and enhance PL/SQL code tune sql code to get better performance.
• Provide emergency release and production support
• Analyze and write data exchange interfaces job scheduling
• Identify issues with the application data analyze and apply fixes.
• Support change management including test steps; code changes to build the knowledge base.
• Developing relational data models and system designs as needed
• Provide support for application implementation.
• Collaborate development and integration activities with other team members and stakeholders.
• Work with business groups internalexternal team to understand requirement and implementation
• Review application server issues analyze and provide resolution as requested.
• Professional experience working with Web based applications using Oracle as the backend is required.
• Indepth knowledge of Oracle Database SQL PL/SQL programming.
• Strong designing development and troubleshooting skills required.
• Knowledge of objectoriented design concepts XML HTML unix scripting web scripting tools Gitlab and CI/CD.
• Knowledge of scheduling data exchange interfaces data analysis and troubleshooting of issues required.
• Working experience with data security data auditing vulnerability scanning and report generation.
• Good oral and written communication skills are required.
• Applicants must have strong multitasking capabilities and the ability to work on multiple projects/issues simultaneously including off hours support as required.
• Applicants must have the ability to assess the impact of software upgrades and other environmental changes.
• Candidate should be able to translate functional requirement build relational model and transfer relational model into technical design and application code.
  
  

Required/Desired Skills

Skill Required /Desired Amount of Experience Consultant Experience Consultant Last used Strong working Experience with Oracle database Required 5 Strong PL/SQL and SQL experience including writing tuning enhancing and improving performance Required 5 Working experience with relational model and translating functional requirement and relational diagram/data model to an application code Required 4 Knowledge of Object Oriented Design concept XML UNIX scripting bidirectional data interfaces Required 2 Scheduling jobs to automate processes implementing and creating data auditing and reporting functionalities Required 2 Reviewing analyzing troubleshooting and resolution of issues related to performance data integrity data interfaces Required 2 Experience with Web Toolkit Web services development and file handling GitLab and CI/CD Desired 2 Questions No. Question Consultant Answer Question1 Commonwealth of Virginia security policies prohibit the use of offshore IT contractors. Do you attest to the fact that your candidate will physically reside within the US for the duration of the assignment Question2 Please list candidates email address. Question3 In what city and state does your candidate PERMANENTLY reside Question4 Is the candidate available to come to Richmond VA to pick up laptop at beginning of assignment This is REQUIRED. Question5 How soon after an offer can your candidate start