NJTreasury Database Administrator - Oracle

Oracle DB administrator with minimum 5 years exerience including experience migrating from Oracle 12c 19c.

Note: Position is remote but local candidates are still preferred. There will be an extension for an additional 6 months.

The purpose of this request is to augment and support the Database staff in the daily database administration and assist in the migration and upgrade of Oracle and SQL Server databases. The candidate will also support and assist in all aspects of the Treasury database tasks including but not limited to:

• Managing clients requirements
• Writing shell scripts for automation of backup scripts
• Testing and validating
• Documentation

tasks including but not limited to:

• Managing clients requirements
• Writing shell scripts for automation of backup scripts
• Testing and validating
• Documentation

migration and upgrade of Oracle and SQL Server databases. The candidate will also support and assist in all aspects of the Treasury database tasks including but not limited to:

• Managing clients requirements
• Writing shell scripts for automation of backup scripts
• Testing and validating
• Documentation

Qualifications
Experience in various technologies and roles including

• Oracle
• SQL Server
• Unix

The Database Administrator is responsible for data analysis and database management. Involved in maintenance enhancement designing of data dictionaries physical and logical database models and performance tuning. Knowledge of the utilities and production tools used for data storage management to support the Application Team. Coordinates physical changes to computer databases; codes tests and implements physical database applying knowledge of data base management system. Designs logical and physical databases reviews description of changes to database design to understand how changes to be made affect physical data base. Establishes physical database parameters. Uses structured query language (SQL) to define database objects using database definition language (DDL) and control access to database objects using data control language (DCL). Calculates optimum values for database parameters such as amount of computer memory to be used by database following manuals and using calculator. Specifies user access level for each segment of one or more data items such as insert replace retrieve or delete data. Specifies which users can access data bases and what data can be accessed by user. Tests and corrects errors and refines changes to database. Uses database utility programs and 3rd party utilities to monitor database performance such as distribution of records and amount of available memory. Modifies data base programs to increase processing performance referred to as performance tuning.




Required/Desired Skills Skill Required /Desired Amount Candidate Experience Consultant Last Used Experience managing Oracle DB and client requirements as an Admin Required 5 Experience Migrating Oracle 12c Oracle 19c Required 3 Experience writing shell scripts for automation of backup scripts Required 3 Experience with Oracle 12 c and Oracle 19c archive scripting Required 3 Experience Oracle 19c migration testing Required 3 Experience Documenting Database migration activities Required 3 Managing Database on Unix Operating System Required 4 Managing Database on Windows Operating System Required 4 Experience Migrating sql server database 2014 to SQL Server 2019 database Highly desired 2 Experience Testing and validating Always on migration 2014 to Always on 2022 Highly desired 2 Experience with SQL Server Administration Highly desired 2 Bachelors Degree Required 0 Questions No. Question Consultant Answer Question1 Absences greater than two weeks MUST be approved by CAI management in advance and contact information must be provided to CAI so that the resource can be reached during his or her absence. The Client has the right to dismiss the resource if he or she does not return to work by the agreed upon date. Do you agree to this requirement Question2 What is your candidates email address Question3 Where does your candidate currently reside (City & State) Question4 Please provide link to LinkedIn profile if available.