I have the below positions with my client on an emergency basis.
Role: Database Manager/Administrator
Location: Trenton, NJ
Duration: Long Term
Any visa ok
Short Description
Provides technical leadership for architecture, design, documentation and maintenance of an Oracle databases and related systems integration to CDRSS
Complete Description
Database administrator is needed for CDRSS. The New Jersey Department of Health (NJDOH) is process of integrate child lead to existing disease surveillance and reporting system known as the Communicable Disease Reporting and Surveillance System (CDRSS) . The CDRSS is fully integrated with electronic laboratory reporting (ELR) and is used throughout the state by all the entire public health community including staff from NJDOH Communicable Disease Service (CDS), Sexually Transmitted Disease (STD) and Occupational Health programs; public health nurses, health officers and other staff at all 85 local health departments serving the 565 municipalities in NJ; infection control professionals (ICPs) and laboratory staff at hospitals; commercial laboratory staff from several labs licensed in NJ; and staff from the NJDOH Public Health and Environmental Laboratory (PHEL).
Design and migrate old child data into the existing CDRSS tables.
Create ways to store, organize, and present data.
Work with businesses and managers to identify user needs.
Perform complex technical, analytical and professional services involving program/member services, evaluation, database driven Web sites, office operations.
Maintain and monitor Web server and middleware tools.
Set up new databases.
Integrate old systems data with new system.
Test and coordinate modifications.
Creates and maintains all databases required for development, testing, education and production usage.
Create stored procedures/ functions and triggers using PLSQL ad utilizing advanced techniques like pipeline and analytical functions.
Required / Desired Skills
Skill
Required / Desired
Amount
of Experience
Prior Experience Programming PL/SQL Required 5 Years
Prior experience programming SQL Required 5 Years
Knowledge and experience of Oracle 12c and later edition Required 5 Years
DB Troubleshooting and performance tuning Required 5 Years
Prior experience with APEX in Oracle Nice to have 3 Years