Database Platform Engineer

Hyderabad, Telangana, India
Software and Services

Summary

Posted: 20 Nov 2018
Weekly Hours: 40
Role Number: 200014540
Would you like to be a part of one of the world’s fastest growing data warehouses for the world’s largest company? Does the prospect of being challenged with complex database design and optimization problems excite you? 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. This is a great opportunity for a smart, experienced and results-oriented data-warehousing Architect to work on our EDW platform to provide a scalable, high-performance and active data-warehousing platform . The candidate should be self-driven, highly motivated, innovative, have a strong work ethic and have a proven track record of designing and managing large, complex data warehouses. The position will involve close interaction with development, data modeling, database administrators and support teams. This person will review database designs to ensure that they are optimized for performance and scalability, and work with DBAs to monitor the health of the database and jointly engineer configuration changes to manage the workload efficiently. This role provides second-level support to ensure that production issues pertaining to performance and stability are immediately resolved.

Key Qualifications

  • 10+ years experience in data-warehousing/ETL/Analytics working with multi-terabyte data sets in Hands-on Technical roles
  • Good understanding of EDW Design principles and methodologies
  • Experience in Performance Tuning and Architecture across multiple projects
  • Strong analytical and problem solving skills
  • Strong SQL Skills and experience in designing complex solutions
  • Experience with database utilities
  • Experience with Infrastructure design (Racking, Network, etc)
  • Experience with integrating Vertica, Teradata, HDFS, Kafka
  • Good written and verbal skills
  • Demonstrated experience of collaboration in fast paced environment
  • Proactive results oriented attitude
  • Familiarity with backup and restore options
  • Knowledge of BI tools like Business Objects, Tableau
  • Programming skills in Unix Shell and Java

Description

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 Benchmarks: Design and execution of multiple performance benchmarks, each focusing on the benefits/trade-offs of a database feature. Presentation of benchmark results to the application teams. Performance optimization of resource intensive ETL and individual user queries Perform detailed analysis of the new database versions and come up with Detailed migration plan. Performance Tickets : Analysis of user-created trouble tickets related to database performance. Workload Management- Continuous monitoring of Apple's workloads- ETL, Adhoc Users, Business Objects, BO Dashboards and other analytical applications. Providing suggestions to DBA's on optimal workload management settings to be able to meet response-time SLA's as well as optimize resource consumption

Education & Experience

BS in Computer Science

Additional Requirements