*Note: Inperson Interview is required...* Required Oracle DBA in Trenton, NJ
*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:* Oracle 10gRequired5 YearsPL/SQL, Stored ProceduresRequired5 YearsToad 7.x, Erwin 4.xRequired5 YearsJDK for complicated PL Java oracle stored procedures developmentRequired4 YearsExperience with public health related web enterprise applicationsHighly desired UML ModelingRequired3 YearsDB Troubleshooting, performance and tuningRequired5 YearsCrystal Reports 10+, OLTPRequired5 YearsDDLRequired4 YearsExcellent written and verbal communication skillsRequired To unsubscribe from this group, send email to tek-professionals+unsubscribegooglegroups.com or reply to this email with the words "REMOVE ME" as the subject.
