Performance DBA

California  ‐ Onsite
This project has been archived and is not accepting more applications.
Browse open projects on our job board.

Keywords

Description

Position: Performance DBA

Location: Sunnyvale CA

Duration: Up to 6 months

Start: 2 weeks

It is very specific to database performance tuning, architecture, schema designing and debugging.

Description

This position requires a passionate individual who likes performance challenges. Who has the ability to think out of the box creatively to come up with different technology solutions or architectures to meet business requirement. This role requires ability to work independently on live production performance issues working with multiple teams. Deep understanding of various oracle tuning areas (SGA, PGA, SQLs, IO, Latches, Lock) is a must. Experience with replication technologies like Oracle Streams, Golden Gate and Oracle Data integrator Understanding Data caching technologies based on Object, Unstructured or Structured using RDBMS Understanding of Vertica and MongoDB is a plus Programming in Java is a plus Work with various experts in Network, System and Application to drive an issue to a closer. Actively create and manage the Technology strategy by exploring, accessing and piloting new technologies and frameworks so that where applicable, processes and deliveries to meet business objectives are optimized. Expert level contribution in the development of Applications Architecture. Must have gone through at least 2 large scale project implementation involving business critical, web customer facing applications.

Key Qualifications

The Database Performance team is looking for a creative individual with following skill set:

- Deep understanding of Oracle Performance debugging features/tools

- Expertise in SQL tuning using tracing, execution plans, wait events, 11G advisors etc.

- Detailed DB performance analysis using various tools OEM, AWR, ASH, OS monitoring tools

- OS Tuning using Kernel parameters

- Understanding of Physical and logical Schema designs to drive scalability and performance requirements

- Good understanding of various system components including CPU, RAM, IOs and SAN

- Excellent understanding of various architectures for supporting Active-Active, HA, DR Solutions

- Basic understanding on NoSQL architectures, Advance understanding is a plus

- Understanding of OS debugging tools Dtrace, Strace, Vmstat, Top, Netstat etc.

- 8-10 Years of experience as Database Administrator, Architect or Developer

Required Technical Skills :

RDBMS: Oracle, MySQL, Timesten

NoSQL DB: MongoDB

Columnar DB: Vertica

Data Caching: Timesten

OS: AIX, Linux, Solaris

Replication: Streams, Golden Gate

Languages: Java, Python, PL/SQL, SQL and Shell Scripting

Tools: OEM, AWR, ASH, SQL Advisors, Various Oracle tracing, OS Tools/Tracing

Please send in your updated resume in Word format along with rate expected/hour, contact and availability status.

Start date
2 weeks
Duration
up to 6 months
From
DG Business Solutions Inc
Published at
13.11.2014
Project ID:
807141
Contract type
Freelance
To apply to this project you must log in.
Register