Skip to main content
Groupon Tech and Product Team
R26942

Database Engineer III - Teradata

Description

Groupon is an experiences marketplace that brings people more ways to get the most out of their city or wherever they may be. By enabling real-time mobile commerce across local businesses, live events and travel destinations, Groupon helps people find and discover experiences––big and small, new and familiar––that make for a full, fun and rewarding life. Groupon helps local businesses grow and strengthen customer relationships––resulting in strong, vibrant communities. Even with thousands of employees spread across multiple continents, we still maintain a culture that inspires innovation, rewards risk-taking and celebrates success.

Do you have an interest in managing the database end to end? Do you eager to look at what is happening behind the scene? then you are the right person for this role. We are looking for a candidate who is passionate about Databases and makes sure it always available for the customers.

We're a "best of both worlds" kind of company. We're big enough to have resources and scale, but small enough that a single person has a surprising amount of autonomy and can make a meaningful impact. We're curious, fun, a little intense, and kind of obsessed with helping local businesses thrive. Does that sound like a great way to grow your career? Let's get into the details:

You’ll spend time on the following:

  • Managing the Teradata clusters end to end

  • Understand the business users need and resolve their day to day issues

  • Make sure that the system is available for the business round the clock

  • Plan the maintenance at a suitable window whenever it requires

Roles and Responsibilities:

  • Ability to take on responsibilities as a Teradata engineer with good knowledge on Teradata administration; coordinates upgrades with the vendors and participates in disaster recovery exercises.

  • Able to perform security audits and develop a 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 training and handling meetings with users, analysts, developers-preferred

  • Exposure and Knowledge of Hadoop is a plus.

We’re excited about you if you have:

  • 5+ 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.

We value engineers who are:

  • Customer-focused: We believe that doing what’s right for the customer is ultimately what will drive our business forward.

  • Obsessed with Quality: Your production code just works & scales linearly

  • Team players. You believe that more can be achiers desire. You know when it’s appropriate to take shortcuts that don’t sacrifice quality or maintainability.

  • Owners: Engineers at Groupon know how to positively impact the business.


Groupon’s purpose is to build strong communities through thriving small businesses. To learn more about the world’s largest local ecommerce marketplace, click here for the latest Groupon news. Plus, be sure to check out the values that shape our culture, guide our strategy and make our company a great place to work. And just don’t take our word for it. Hear from real Groupon team members, learn more about our inclusive employee groups, and check out our benefits. If all of this sounds like something that’s a great fit for you, then click apply and let’s see where this takes us.

Groupon is an Equal Opportunity Employer

Qualifications for employment, promotion, and other terms and conditions of employment are based upon the ability to perform the job. Equal-employment opportunities are provided to all applicants and employees without regard to race, creed, religion, color, age, national origin, sex, disability, medical condition, sexual orientation, gender identity or expression, genetic information, ancestry, marital status, military discharge status (excluding dishonorable discharge), veteran status, citizenship status, or other legally protected status. We are all responsible for maintaining this policy. Groupon is committed to providing reasonable accommodations for qualified individuals with disabilities and disabled veterans in our job application procedures. If you need assistance or an accommodation due to a disability, you may email us at hraccommodations at groupon.com. If you have concerns related to Groupon’s equal employment opportunities, you may contact Groupon’s Ethics Reporting Service Ethicspoint.

Stay in the Group

Not seeing your next role, or not the right time to apply? Sign up for our talent community and stay up to date with careers at Groupon.

Join Now