Teradata – Database Administrator II

Bangalore, IN

Job Description / Skills Required

Requisition ID: R12691
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.