Database Platform Engineer

Hyderabad, Telangana, India
Software and Services

Summary

Posted: 2 Jul 2019
Weekly Hours: 40
Role Number: 200068529
The people here at Apple don’t just build products — they build the kind of wonder that’s revolutionized entire industries. It’s the diversity of those people and their ideas that inspires the innovation that runs through everything we do, from amazing technology to industry-leading environmental efforts. Join Apple, and help us leave the world better than we found it. The Global Business Intelligence (GBI) team within Apple's IS&T organization has a very large Enterprise Data Warehouse (EDW) to support analytical and reporting needs of hundreds of global Apple users. We are looking for a results-oriented data-warehousing Architect to work on our EDW platform to provide a scalable, high-performance and active data-warehousing platform. We seek a driven, highly motivated, innovative individual with a track record of designing and running large, complex data warehouses. As a Database Platform Engineer, you will have close interaction with development, data modeling, database administrators and support teams. You will review database designs to make sure that they are optimized for performance and scalability, and work with DBAs to monitor the health of the DB. You will jointly engineer configuration changes to handle the workload.

Key Qualifications

  • 10+ years’ experience in databases like Teradata, Druid, Vertica and Oracle
  • Experience in building and managing Database Data Warehouses.
  • Good understanding of EDW Design principles and methodologies
  • 5 Years’ Experience in Performance Tuning and Architecture across multiple projects
  • Strong analytical and problem-solving skills
  • 2 years’ experience in open source tool like Kafka and Casandra
  • Knowledge of Hadoop and Spark is plus
  • Good written and verbal skills
  • Demonstrated experience of collaboration in fast paced environment
  • Programming skills in Unix Shell and Java
  • Knowledge of BI tools like Business Objects, Tableau
  • Enthusiastic results oriented attitude

Description

As Database Platform Engineer you will also provide second-level support to ensure that production issues pertaining to performance and stability are immediately resolved. Your key responsibilities include: - Participation in Physical Model reviews with the development teams to provide inputs on improving performance - Design & implement all POC’s by clearly understanding the objectives - Continuous analysis of the database environment to capitalize on system-wide tuning opportunities. - Provide recommendations for tuning - Act as a thought leader and conduct brown bag lunch sessions for development teams to create awareness regarding the value proposition of new and upcoming features. - Performance optimization of resource intensive ETL and individual user queries - Data Warehouse Expansion planning and Software upgrades - New Features testing and adoption - Analysis of user-created trouble tickets related to database performance. - Workload Management analysis and improvement to meet response-time SLA's as well as optimize resource consumption

Education & Experience

Bachelor's or Masters Degree in Computer Science

Additional Requirements

  • Keywords:
  • Platform Team Experience
  • Performance Tuning
  • RDBMS Teradata , Vertica, Druid ,
  • Knowledge of Hadoop, Kafka
  • Data Warehousing
  • Strong in SQL
  • Infrastructure Architecture
  • Platform
  • EDW Design Principles