Job ID :
3514
Company :
State of Florida
Location :
tallahassee, FL
Type :
Hire
Duration :
6 Months
Status :
Active
Openings :
1
Posted :
5 years ago
Job Seekers, Please send resumes to resumes@hireitpeople.com or Call: (202) 719-0200 Ext: 127

 

Description: Our client, a government agency is looking for a Database Administrator.
 


 

Responsibilities:

•   Install, configure, upgrade, patch the database;

•   Setup, automate, document and troubleshoot the Streams Replication at schema level and table level  to capture, propagate and apply the DML, DDL changes to the replicated database;

•   Automate error checking, document and troubleshoot and resolve problems in Oracle streams;

•   Monitor and manage Production and Development databases and also monitor instances locks, long running queries, listener, free space, extents growth and space management etc;

•   Clone databases;

•   Monitor and manage Production and Development databases and also monitor instances locks, long running queries, listener, free space, extents growth and space management etc;

•   Troubleshoot database issues/error;

•   Maintain database 24x7;

•   Backup and recovery strategy and insure recoverability of Oracle databases;

•   Use DATA PUMP/export import to instantiate SCN to avoid conflict at destination;

•   Administering and enforcing database and user security policies and standards including privacy regulations;

•   Scheduling jobs and Automating tasks.

 
 

Requirements:

•   Experience with building and automating scripts in a UNIX environment for streams on Oracle 11g at a table level and schema level;

•   Experience with SQL and PL/SQL, UNIX shell scripting;

•   Experience with Automatic Workload Repository (AWR), Automatic Database Diagnostic Monitor (ADDM), Active Session History (ASH);

•   Experience with Tuning - SGA, Monitoring and Detecting Locks;

•   Experience with using Data Pump, export, import;

•   Experience with deploying and managing fault-tolerance and high-availability and DR (Disaster Recovery) solutions including Oracle Streams and others;

•   Experience with IBM/AIX platforms. (Preferred)

 

Knowledge/Skill/Ability/ Experience

Years of Experience

Last Applied

Oracle Database Administration

 

 

Experience with building and automating scripts in a UNIX environment for streams on Oracle 11g

 

 

PL/SQL

 

 

UNIX Shell Scripting

 

 

Automatic Workload Repository (AWR)

 

 

Automatic Database Diagnostic Monitor (ADDM)

 

 

Active Session History (ASH)

 

 

Experience with using Data Pump, export, import

 

 

Experience with deploying and managing fault-tolerance and high-availability and DR (Disaster Recovery) solutions including Oracle Streams and others

 

 

Experience with IBM/AIX platforms

 

 

Education and certifications