Job title: Oracle Database Developer Location: Trenton, NJ Duration: 6+ months This position will be remote until the state returns to office-based work. This DBMA4 is an Oracle Database Developer/Designer with a priority on performance tuning of Oracle 19c
Experienced in Database Performance, Maintenance, and Development to perform the following:
Database management including backups,recovery and maintenanceDatabase management for export, import, and mass data loadsAnalyzes and generation of all tables and index statistics.Monitoring and resolving data lock issues.Check all statistics related to memory, locks, I/O, database response time, wait for events, topsessions and background processes using Performance MangerCreate 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.xVarious objects developments such as Packages, Procedures, Functions, Triggers forbusiness logic implementationPL/SQL procedures development, compilation, and debugging using Toad 7.xUtilizing JDK for complicated PL Java oracle stored procedures development
Candidate must possess strong experience in Oracle 19c, developing store procedures, queries, PL/SQL, ERDs, DDLs.Experience with developing DHSS web enterprise applications and understanding of object-orientedarchitecture a strong plus.Understand government business processes and operations, including familiarity with HIPPA and NJAC regulations is desired.Prior knowledge of health-related data concerns in order to transition business processes intoHighly skilled at database design, installations, conversionsResponsible for database backup and recovery procedures, access security and database integrity, physical data storage design, and data storage managementParticipates in Database Management System selection and maintains database performanceEngage in ongoing process improvement