Job Detail

Database Administrator

Experience : Minimum 7 Years

Yahoo
Bangalore
Full Time
ABOUT COMPANY

The Advertising and Data team builds the large-scale platforms and products that enable selling, targeting, serving, understanding, and optimizing display and video advertising across Yahoo sites and other web properties and apps. We live and breathe “big data” and deep science, delivering results for advertisers, revenue for publishers, and relevant, engaging experiences for consumers. 

 
 
JOB ROLE:

Job Description:

  • Undergraduate degree (Graduate degree preferred) in computer science, engineering, or related field, and 7+ years of experience in building and maintaining Oracle on Unix/Linux OS platform.
     
  • Strong understanding of RDBMS Concepts; knowledge in Oracle architecture, optimizer and performance tuning; familiar with different backup and recovery methods and security best practices. 

 

  •  Proficiency in one of the scripting languages "Perl/Python/Unix Shell" for monitoring and automation tasks.
     
  • Knowledge in tuning the database schema design and SQLs; knowledge in table storage space management techniques for large tables.
     
  • Expertise in Analyzing Oracle RAC wait events and taking necessary actions to resolve wait events and ensure database stability at scale.
     
  •  Exposure in High Availability features such as Real Application Cluster and Dataguard; exposure to managing large scale  production Oracle databases. 
     
  • Experience working with Oracle 11g/12c including database upgrade from 11g to 12c.
     
  • Experience with tuning and optimizing large data migration using core utilities like sqlldr, data pump, and transportable tablespace · Good understanding of Data warehouse / Data marts systems concepts and experience in star schema design, partitioning, and data archiving procedures. 
     
  • Good understanding of Oracle Partitioning mechanisms, and Parallel queries / Parallel DMLs, Optimizer stats collection and loading /exchanging of data to Oracle tables in an efficient manner.
     
  • Expertise in collaborating with Oracle support team on triaging high severity Oracle errors.
     
  • Exposure to system administration and troubleshooting skills on Linux, and also network with Oracle community / users group about industry best practices is a plus.
     
  • DevOps experience is a plus.

    Apply Here
 
SALARY:
Not Disclosed by Recruiter
 
ADDRESS:
Yahoo, Torrey Pines, EGL Business Park, Intermediate Ring Road, Bengaluru, Karnataka .
 

RELATED JOBS

 
 

Call Us: +91 984 811 1981