Teradata – Database Administrator II

Bangalore, IN

Job Description / Skills Required

4-7 years total experience; with 2-3 years of experience on Teradata Administration.
Ability to take on responsibilities as a Teradata engineer with good knowledge
on Teradata administration; coordinates upgrades with the vendors and 
participates in the disaster recovery exercises.
Able to perform security audits and develop framework, which includes 
designing and implementing roles, profiles and accounts.
Able to create stored procedures to support the continued functioning of the 
Teradata data warehouse.
Work collaboratively with the database operations team and the vendor to 
resolve incidents and mitigate risks.
Manages and monitor system performance, Proactively monitor the database 
systems to ensure and secure services with minimum downtime
Demonstrated knowledge of Performance Data Collection and Reporting (PDCR) 
and Database Query Logging (DBQL)
Expertise with installing, maintaining, using all the Teradata tools (ex BTEQ, SQL 
Assistant, TPUMP, TD Administrator, ODBC, MLOAD, Fast load, etc.)
Expertise in Space management: setup the purging policy, implementing 
compression techniques.
Experience in performance tuning-required.
Provide recommendations for tuning including statistics optimization, sampled 
statistics, stats recollection, data distribution, indexes, PPI, join optimization. 
Performance optimization of resource intensive ETL and individual user 
queries.  Work with others as a team and provide recommendation for process 
improvement.
Providing suggestions to DBA's on optimal workload management settings in 
TASM to be able to meet response-time SLA's as well as optimize resource 
consumption.
Ability to conduct trainings and handling meetings with users, analysts, 
developers-preferred
Exposure and Knowledge on Hadoop is a plus.
Groupon provides a global marketplace where people can buy just about anything, anywhere, anytime. We’re enabling real-time commerce across an expanding range of categories including local businesses, travel destinations, consumer products, and live or lively events. At the same time, we are providing advertising options and tools that merchants can use to grow and manage their businesses. Culturally, we believe that great people make great companies and that starting with the customer and working backward moves us forward. Community matters to us on an internal, local and global scale—it’s fundamental to our company’s growth and to the well-being of the world at large. We also value self-awareness, candor, lunch and WiFi. If we match with you, please apply to join us.