*Please send me suitable profiles for this role to [email protected]* Title/Role: Database Administrator
Duration: 5 Months Location: New Jersey The DBA provides on-site programming, analytical and technical support for NJIIS Oracle databses according to Vaccine Preventable Disease Program (VPDP) requirements to fulfill the VPDP regulatory obligations and federal funding mandates. 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 Required / Desired Skills Skill Required / Desired Amount of Experience 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 Excellent written and verbal communication skills Required Prior NJ DHSS Experience Highly desired 1 Years Best Regards, Amit Kumar XpertTech Inc Email: [email protected] Phone: 781-399-4354 Fax: 978-405-5040 www.xperttech.com 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.
