Database Administrator (Oracle)

Cai - Springfield, IL

Full-time

Remote - Springfield, IL

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, as well as physical and logical database models. This role involves performance tuning and ensuring the efficient operation of databases within the organization.

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 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