*For below direct client requirement, send your consultants resumes to * *[email protected]* <[email protected]>
*Title :* PL/SQL Developer *Location :* Trenton NJ *(**Locals only**)* *Years of Experience:* 7 plus years *Education:* 4 year college degree or equivalent technical study *Role Description: * - Understand government business process and operations, including familiarity with HIPPA and NJAC regulations. - Prior knowledge of health-related data concerns in order to transition business processes into technical requirements. - Excellent communication and presentation skills to review, analyze, and evaluate business systems and user needs by facilitating brainstorming sessions with health professionals. - Highly skilled at database design, installations, conversions - Responsible for database backup and recovery procedures, access security and database integrity, physical data storage design and data storage management - Participates in Database Management System selection and maintains database performance - Engage in ongoing process improvement - Experienced in Database Performance, Maintenance and Development to perform the following: -Database management including backups, recovery and maintenance -Database management for export, import and mass data loads -Analyzes and generation of all tables and index statistics using Data Analyzer - -Monitoring and resolving data lock issues using Lock Manager - -Check all statistics related to memory, locks, I/O, database response time, wait events, top sessions and background processes using Performance Manger - -On-Line Transaction Processing (OLTP) to capture, validate and store large amounts of transactions - -Use Explain Plan & TKPROF utility for Sql query to improve response time for all reports - -Create a gamut of indexes to achieve critical dataset response time for time sensitive reports. - Experienced in Database Design and Development to perform the following: - -New projects database design utilizing Erwin 4.x - -Various objects development such as Packages, Procedures, Functions, Triggers for business logic implementation - -PL/SQL procedures development, compilation and debugging using Toad 7.x - -Utilizing JDK for complicated PL Java oracle stored procedures development *Required / Desired Skills* *Skills* *Required / Desired* *Amount of Experience* Oracle 11g Required 7 Years Oracle 12.x Highly Desired 2 Years PL/SQL Required 7 Years Writing and modifying Oracle Stored Procedures Required 7 Years Toad 10.x and above Required 4 Years JDK for complicated PL Java Oracle store procedures Required 5 Years DB Troubleshooting AND performance tuning Nice to have 5 Years Excellent written and verbal communication Highly Desired Experience with public health related web enable applications Desired 1 Years Prior NJ DHSS Experience Nice to have *Thanks & Regards* *Monika * Param Consulting Services Inc. [email protected] | http://www.pcsionweb.com *Gtalk :* monikaparam | *Yahoo IM :* monika.param Save resources: Think before you print. -- You received this message because you are subscribed to the Google Groups "Open Source J2EE frameworks" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/open-source-j2ee-frameworks. For more options, visit https://groups.google.com/d/optout.
