Teradata - Database Administrator Iii

**Become a better developer by building things that help local businesses around the world thrive** 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. "The Teradata Operation Team's mission is to deliver reliable, secure, and high-performing Teradata systems, providing users with the tools and support they need to harness the power of data and drive business outcomes. Their expertise and dedication contribute to the efficient utilization of Teradata platforms and the success of data-driven initiatives within organizations. Our Team is making sure of the smooth operation and optimal performance of Teradata systems and platforms, enabling organizations to harness the power of data and drive business success. This Team provides technical support and assistance to users who interact with Teradata systems. They help troubleshoot issues, resolve user queries, and provide guidance on best practices for utilizing the platform effectively. Their expertise ensures that users can leverage Teradata's capabilities to their fullest potential. The team actively collaborates with other teams and stakeholders to understand their requirements and provide tailored solutions. They stay updated on the latest Teradata features, enhancements, and best practices, and share their knowledge with users and colleagues. This fosters a culture of continuous learning and enables the organization to extract maximum value from Teradata technology." 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**: - Take on responsibilities as a Teradata engineer with good knowledge on Teradata administration; coordinates upgrades with the vendors and participates in disaster recovery exercises. - You will support configuring solution requirements on the products; understand if any issues, diagnose the root-cause of such issues, seek clarifications, and then identify and shortlist solution alternatives Exposure and Knowledge on Hadoop, and Big Query, Snowflake are a plus. - You will explore the alternatives to the recommended solutions based on research that includes literature surveys, information available in public domains, vendor evaluation information, etc. and build POCs - Perform security audits and develop a framework, which includes designing and implementing roles, profiles, and accounts. - 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 - 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 recommendations 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. - Conduct training and handling meetings with users, analysts, developers-preferred - You will create requirement specifications from the business needs, define the to-be-processes and detailed functional designs based on requirements. **We’re excited about you if you have**: - 7-12 years total experience; with 5-8 years of experience in Teradata Administration. - Ability to adopt the new technology quickly like Snowflake, Big Query - Experience in performance tuning-required - Ability to take on responsibilities as a Teradata engineer with good knowledge on Teradata administration - Ability to find the opportu