Current Openings

Oracle Database developer

Trenton, NEW JERSEY | Contract
Post Date: 09/18/20
Job ID: 20-00900
Job Type: Contract

Job Description

Job Title: Oracle Database developer
Duration: 11 months
Location: Trenton, NJ

Description:
  • This DBMA4 is an Oracle Database Develper/Designer with a priority on performance tuning of Oracle 19c

Complete Description:
  • Candidate must possess strong experience in Oracle 19c, 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. Understand government business process and operations, including familiarity with HIPPA and NJAC regulations is desired. Prior knowledge of health-related data concerns in order to transition business processes into technical requirements is also desired.
  • 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. -Monitoring and resolving data lock issues. -Check all statistics related to memory, locks, I/O, database response time, wait events, top sessions and background processes using Performance Manger -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 Please note, this position could convert to a full time role after 6 months without fee, so candidates should be US Citizens or possess a valid Green Card to be considered for the role.

Required:
  • Database design and development in Oracle 19c
  • Database design and development in Oracle 12c
  • Prior expertise in performance tuning of existing databases
  • PL/SQL Stored Procedure Development
  • Developing using JDK for complicated PL/SQL,Java, Oracle Stored procedures
  • Hands on experience with Oracle Linux
  • Excellent written and verbal communication
  • Experience with public health related web enable applications
  • Prior hands on work using Toad 7.x
  • Prior hands on work using Erwin 4.x
  • US Citizen or Green Card holder