Don't wait! First round interviews are being scheduled now.

Experience:
1-3 years of experience
Concerned about your lack of experience? Learn More...
Employment Type:
Full time
Posted:
11/2/2013
Job Category:
Information Services
Database Administrator
(This job is no longer available)
State of Oregon | Portland, OR
loading
loading
School
Major
Grad Date
 
 

Not sure what types of jobs you are interested in?


Explore Jobs
Based on Your Education

Follow This Company
Share

Job Description

David Evans and Associates is currently seeking a Database Administrator to join our project team for our client based in Portland, OR. This position is located in the Business Systems Operations Group located within the IT Department. This position is responsible for migrating the Oracle 10g to Oracle 11g on a Linux/Exadata platform.

Position Responsibilities:

* Assist in the migration of a mature highly automated Oracle 10g on Windows platform to Oracle 11g on a Linux/Exadata platform including migrating from:

* User-managed backups to RMAN backups

* Non-RAC to RAC

* Non-ASM to ASM

* Install, integrate, configure and use Oracle Enterprise Manager (OEM) 12c Grid Control.

* Provide primary responsibility of integrating and/or replacing the Oracle team's existing monitoring processes.

* Conduct performance tuning for Oracle servers, databases, and SQL.

* Provide recommendations for process improvements and technical solutions that can be integrated into existing environments.

* Perform install/patch, troubleshoot connectivity issues, monitor performance and tune when necessary, backup and restore databases in a complex three-tier architecture (client web interface, application engine, database engine).

* Write and debug Perl and shell scripts to automate DBA processes such as monitoring/alarming, performance bottlenecks, batch scheduling, and connectivity failures.

* Utilize Linux based tools and knowledge of Linux internals to troubleshoot, diagnose, and resolve performance and connectivity issues with Oracle on Linux.

* Recommend ASM storage configuration for maximum performance and manageability.

* Perform routine database management from command line without the use of GUI Tools. Use GUI tools for efficiency when appropriate and available.

* Design and implement appropriate database fail-over solutions.

Position Requirements:

* 10+ years experience - Information Technology

* Undergraduate College Degree - Information Technology or equivalent experience

* 10+ years of DBA experience using at least the latest two versions of Oracle including troubleshooting problems, automation through scripting and modifying database structures to ensure performance and data integrity. Candidate's

* Experience should include history supporting operations in a 24x7 environment.

**Position Requirements:*

* 10+ years experience - Information Technology

* Undergraduate College Degree - Information Technology or equivalent experience

* 10+ years of DBA experience using at least the latest two versions of Oracle including troubleshooting problems, automation through scripting and modifying database structures to ensure performance and data integrity. Candidate's

* Experience should include history supporting operations in a 24x7 environment.

### Skill Requirements:

Knowledge of and skills in

* Oracle Enterprise Manager 12c Grid Control

* Oracle 10gR2 and 11gR2

* Scripting languages including Perl and Linux Shells

* Oracle SQL and PL/SQL

* TOAD, DBArtisan or similar tool(s)

* Oracle HA (High Availability) experience with DataGuard

* Exadata and RAC architecture and operations

* Exadata patching process

* Automatic Storage Management (ASM)

* Recovery Manager (RMAN) and DataPump Export

* Oracle Database Resource Manager

* Exadata features such as Hybrid Columnar Compressions, Storage Indexes and Smart Scans including tuning to maximize performance benefits.

* Performance tuning of Oracle servers, databases, and SQL with an emphasis in the use of ADDM and AWR.

* Microsoft Office Suite including Word, Outlook, Excel and Visio

Sufficient to:

* Install, integrate, configure and use Oracle Ente