Senior Application Oracle Database Administrator

Quantum Strides LLC; West Virginia; On-site; USD 100,000 - 130,000; Full time

Job summary

A technology solutions provider is seeking a Senior Application Oracle Database Administrator for a 5 year contract. The role involves the maintenance and management of Oracle database systems, optimizing SQL execution, and programming staff on PL/SQL. Candidates should have extensive experience in Oracle database management, UNIX/LINUX scripting, and data modeling.

Qualifications

• 10 years experience in Maintenance and Management of Oracle database systems.
• 5 years experience in Providing connectivity to an Oracle Database.
• 5 years experience in Debugging triggers, procedures, functions and packages (PL/SQL Code).
• 5 years experience in Optimizing SQL execution for Oracle SQL procedures, functions, packages and triggers.
• 5 years experience in Writing and maintaining UNIX/LINUX shell scripts in HP UNIX and/or RedHat LINUX environment.
• 5 years experience in Data Modeling.
• 5 years experience in Oracle RMAN backup.
• 2 years experience in Fine grain access control in an Oracle database.

Responsibilities

• Maintenance and Management of Oracle database systems.
• Providing connectivity to an Oracle Database.
• Programming staff in debugging triggers, procedures, functions and packages (PL/SQL Code).
• Optimizing SQL execution for Oracle SQL procedures, functions, packages and triggers.
• Writing and maintaining UNIX/LINUX shell scripts in HP UNIX and/or RedHat LINUX environment.
• Data Modeling.
• Performing Oracle RMAN backup including full and incremental backups.

Skills

Maintenance and Management of Oracle database systems

Providing connectivity to an Oracle Database

Debugging triggers, procedures, functions and packages (PL/SQL Code)

Optimizing SQL execution for Oracle SQL procedures, functions, packages and triggers

Writing and maintaining UNIX/LINUX shell scripts

Data Modeling

Oracle RMAN backup

Fine grain access control in an Oracle database

Tools

Oracle Warehouse Builder

Job description

Overview

Senior Application Oracle Database Administrator – 5 year contract.

Responsibilities

• Maintenance and Management of Oracle database systems
• Providing connectivity to an Oracle Database
• Programming staff in debugging triggers, procedures, functions and packages (PL/SQL Code)
• Optimizing SQL execution for Oracle SQL procedures, functions, packages and triggers
• Writing and maintaining UNIX/LINUX shell scripts in HP UNIX and/or RedHat LINUX environment
• Data Modeling
• Oracle RMAN backup to include full and incremental backups and cloning a database
• Fine grain access control in an Oracle database

Qualifications

• 10 years experience: Maintenance and Management of Oracle database systems
• 5 years experience: Providing connectivity to an Oracle Database
• 5 years experience: Programming staff in debugging triggers, procedures, functions and packages (PL/SQL Code)
• 5 years experience: Optimizing SQL execution for Oracle SQL procedures, functions, packages and triggers
• 5 years experience: Writing and maintaining UNIX/LINUX shell scripts in HP UNIX and/or RedHat LINUX environment
• 5 years experience: Data Modeling
• 5 years experience: Oracle RMAN backup to include full and incremental backups and cloning a database
• 2 years experience: Oracle Warehouse Builder
• 2 years experience: Fine grain access control in an Oracle database