Database Administrator (Oracle)

Cai - Trenton, NJ

Full-time - Mid Level

Remote - Trenton, NJ

Chemical Manufacturing

About the position

The Database Administrator (Oracle) will be responsible for data analysis and database management, focusing on the maintenance, enhancement, and design of data dictionaries, physical and logical database models, and performance tuning. This full-time, remote position requires a highly skilled individual to join the IT team and manage Oracle and SQL Server databases effectively.

Responsibilities

• Migrate and upgrade Oracle and SQL Server databases
• Coordinate physical changes to computer databases; code, test, and implement physical databases
• Design logical and physical databases, reviewing changes to understand their impact
• Establish physical database parameters and define database objects using SQL
• Calculate optimum values for database parameters
• Specify user access levels for data items
• Test and correct errors in the database
• Monitor database performance using utility programs and third-party tools
• Modify database programs to enhance processing performance

Requirements

• Experience in Oracle, SQL Server, and Unix
• Knowledge of data storage management utilities and production tools
• Experience managing Oracle DB and client requirements as an Admin
• Experience migrating Oracle 12c to Oracle 19c
• Experience writing shell scripts for backup automation
• Experience managing databases on Unix and Windows Operating Systems
• Bachelor's Degree

Nice-to-haves

• Experience migrating SQL Server database 2014 to SQL Server 2019