Job Actions

Job Information

Sr. Database Architect
LOS ANGELES CA 90001
Category: Computing, Publishing
  • Your pay will be discussed at your interview

Job code: lhw-e0-84534677

Company Profile

Apple

Contact Company


Local Information

Laugh while you Look

Sponsored Ads

Summary

  Job posted:   Tue Feb 13, 2018
  Distance to work:   ? miles
       
  1 Views, 0 Applications  
 
Sr. Database Architect

# Sr. Database Architect


Job Number: 113478757

Santa Clara Valley, California, United States

Posted: 09-Feb-2018

Weekly Hours: 40.00


**Job Summary**

This is an exciting opportunity for a passionate Database engineer.

This team is responsible for providing new architectures and scalability solutions to ever growing business and data processing needs.

Individual can go to the depths to solve complex problems and have the curiosity to explore and learn new technologies for innovative solutions.


If you love to solve internet scale challenges then this is the right job for you.


**Key Qualifications**

* The Database Performance team is looking for a creative individual with following skill set:* - Design new Database Architectures for new Business Requirements

* - Deep understanding of Oracle Performance debugging features/tools

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

* - Deep understanding of SQL Execution plan is a must

* - Golden Gate based Active/Active Replication

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

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

* - Good understanding of various system components including CPU, RAM, IO 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 MongoDB or Vertica is a plus

* - OS Tuning using Kernel parameters

* - 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

* NoSQL DB: MongoDB

* Columnar DB: Vertica

* 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


**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.


**Education**

BS/MS Computer Science or equivalent.


**Additional Requirements**

Key Matching Terms


Performance tuning SQL, PLSQL, Partitioning, Database overall, Goldengate, MongoDB, Vertica

Database using tools ASH, AWR, SQL Advisor, OEM, Oracle Wait events

Tracing using 10046, Hang analyze, Oradebug

OS utilities vmstat, mpstat, top,strace, truss, dtrace

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


More Information »