Hi, Please let me know if you have someone available for the below mentioned position of Oracle DBA at Trenton, NJ
*Position Title* – Oracle DBA *Location *– Trenton, NJ *Duration* – 6 Months *Pay Rate* – $50/hour (All Inclusive on C2C) *Description* The DBA provides on-site programming, analytical and technical support for NJIIS Oracle databases according to Vaccine Preventable Disease Program (VPDP) requirements to fulfill the VPDP regulatory obligations and federal funding mandates. Complete Description: The New Jersey Immunization Information System (NJIIS) is the official immunization registry (NJ A.B. 2240 Chapter No. 138) for the state of NJ and is in use in all 21 counties. It was created in 1997 and has been web-enabled since May 2002.The Registry designed to capture immunization histories of all New Jersey children, regardless of where they receive their vaccinations and help healthcare providers to ensure that all children within the state are protected against vaccine preventable diseases. The immunization data collection is done via on-line interface and number of interfaces with heterogeneous systems such as commercial insurance companies and electronic medical record vendors. The Department of Health and Senior Services (DHSS) is planning to expand existing NJIIS and Inventory Management, Order and Distribution System (IMODS). The consultant must possess strong experience in Oracle 10g, developing store procedures, queries, PL/SQL, ERD’s, DDL’s. Experience with developing DHSS web enterprise applications and understanding of object-oriented architecture a strong plus. Years of Experience: 5 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 Skills Status Required Present Oracle 10g Required 5 Years PL/SQL, Stored Procedures Required 5 Years Toad 7.x, Erwin 4.x Required 5 Years JDK for complicated PL Java oracle stored procedures development Required 4 Years Experience with public health related web enterprise applications Highly desired UML Modeling Required 3 Years DB Troubleshooting, performance and tuning Required 5 Years Crystal Reports 10+, OLTP Required 5 Years DDL Required 4 Years -- Thanks Shivendra iBusiness Solution LLC Phone: 412-894-1929 Email: shiven...@ibusinesssolution.com -- You received this message because you are subscribed to the Google Groups "REQSRESUMES" group. To post to this group, send email to reqsresu...@googlegroups.com. To unsubscribe from this group, send email to reqsresumes+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/reqsresumes?hl=en.
