DataBase Admin ORACLE at NJ - REMOTE - NEED LOCALS at Trenton, New Jersey, USA |
Email: [email protected] |
From: Goutham, Integrated Technology Strategies, Inc. [email protected] Reply to: [email protected] Client is State of NJ Agency is NJ Treasury Role is DataBase Admin ORACLE Work location is Trenton NJ Remote work (Preference will be given to Local candidates ie NJ) Interview is Video Based Start and End date 10/01/24 to 03/30/25 Short Description: Oracle DB administrator with minimum 5 years experience including experience migrating from Oracle 12c - 19c. Complete Description 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 NJ Treasury 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 database. 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 databases 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. Keywords: database New Jersey DataBase Admin ORACLE at NJ - REMOTE - NEED LOCALS [email protected] |
[email protected] View all |
Fri Sep 27 18:13:00 UTC 2024 |