REK---Oracle DBA for San Diego, CA - Remote

Hello,

 

Please let me know if you have candidates available for this position. Also, I need their rate, location and availability.

 

Position:  Oracle DBA

 

Start:  ASAP, immediately!!!!! --- "Start yesterday…"

 

Duration:   3-6 months contract, ---- Any status is fine.

 

Location:   San Diego, CA --- Remote 

 

Rate:   DOE

 

 

 

Details:

 

The Oracle database version is 10gR1 Standard Edition running on a Windows Sever operating system.

 

We have some issues with database performance and the stability of the Oracle database listener, which has been crashing periodically. Additionally, we would like assistance in validating the current backup/recovery scheme and creating a maintenance plan.

 

Current pain points:

 

1.       Stabilize current 10G Oracle instances

a.       Problem with Listener going down  (start and stop Oracle service to fix)

b.      Come up with backup and recovery plan

c.       Maximize PGA and SGA memory

d.      Monitor costly queries and use of indexes, recommend optimization

e.      Come up with nightly and weekly maintenance plans

f.        Document all procedures and transfer knowledge to staff

2.       Design migration path from 10G to 11G

3.       Design High Available, High Performance Oracle instances

a.       Observe and benchmark current usage, plan for 3K concurrent users

b.      Infrastructure design -Disk layout, CPU, memory and network  (We're running VMware on EMC SAN)

4.       Design Disaster Recovery plan for Oracle databases through database replication or SAN replication.

 

 

Tasks for the Assessment & Health Check  (#1 above)

·         Analyze system parameters for OS, patches and kernel settings

·         Analyze Oracle database setup (physical and logical) and application implementation for correspondence to business requirements for database functionality

·         Analyze setup for correspondence to accepted industry standards and practices

·         Trace file analysis

·         Analyze table statistics

·         Oracle SGA cache analysis

·         Physical vs. Logical I/O analysis

·         Review error and alert logs including deep analysis on listener instability

·         Review database security including users, passwords and services

·         Generate and analyze ADDM reports and proprietary scripts

·         Investigate and validate existing backup scheme

·         Review current maintenance plan

·         Document the existing configuration and provide written recommendations for improvement and optimization

Tasks for Remediation

·         Prioritize all issues and recommendations along with Customer input and direction

·         Remediate issues and implement agreed-upon changes

·         Perform knowledge transfer to the Customer as required

·         Document all work performed

 

 Thanks,

 

Terry A

terrya@zazatechnologies.com

www.zazatechnologies.com

754-423-0340