EY EY - GDS Consulting AI DATA -Database Administrators -Teradata Senior 

India, Telangana, Hyderabad 

69790123

We are looking for a proficient Teradata Database Administrator with over 6 years of hands-on experience in managing, tuning, and supporting large-scale, mission-critical Teradata systems. Candidate will be an expert in the full lifecycle of Teradata administration, from architecture and installation to performance optimization and troubleshooting. Candidate requires deep technical knowledge, a proactive mindset, and a strong focus on stability and performance.

Your key responsibilities

• Experience of 6+ years of dedicated experience as a Teradata DBA, managing large, multi-terabyte to petabyte-scale systems in a production environment.
• Experience in Teradata RDBMS about Teradata architecture, including parsing engines, AMPs, nodes, and the BYNET.
• Experience in performance monitoring and tuning using Teradata Viewpoint, DBQL, and Explain. Must be adept at analysing and optimizing complex SQL.
• Proficiency with Teradata utilities (BTEQ, FastLoad, MultiLoad, TPT, FastExport, ARC).
• Mastery of Teradata SQL and experience with Teradata Active System Management (TASM) for workload management.
• Hands-on experience with Teradata backup and recovery processes and tools.
• Strong familiarity with Unix/Linux operating systems and shell scripting.
• Excellent analytical and complex problem-solving skills for troubleshooting and resolving database issues.
• Perform day-to-day administration of Teradata systems, including installation, configuration, upgrades, and patching in a multi-node environment.
• Proactively monitor and tune system performance. Analyze and optimize complex SQL queries, identify and resolve resource contention issues, and manage skew data and statistics. Utilize tools like Teradata Viewpoint, DBQL, and Explain.
• Monitor database growth and forecast future capacity needs for CPU, memory, and storage. Manage space allocation across databases, users, and tables.
• Implement and enforce robust security policies. Manage user profiles, roles, and authentication. Conduct regular access reviews and ensure compliance with data governance standards (e.g., SOX, GDPR).
• Develop, test, and maintain reliable backup and disaster recovery strategies using tools like ARC and NetBackup. Ensure Recovery Time Objective (RTO) and Recovery Point Objective (RPO) can be met.
• Administer and support Teradata's fallback and clonal capabilities. Manage system outages and execute recovery procedures to ensure high availability.
• Develop and maintain automated scripts (BTEQ, SQL, Shell, Python) for routine DBA tasks, monitoring, and reporting.
• Experience in supporting for production issues, Work closely with data architects, ETL developers, and business analysts to support their data needs and guide best practices.
• Create and maintain detailed documentation of system architecture, configurations, procedures, and operational runbooks.
• Strong verbal and written communication skills to interact with technical and non-technical teams.

Skills and attributes for success

• Use an issue-based approach to deliver growth, market and portfolio strategy engagements for corporates
• Strong communication, presentation and team building skills and experience in producing high quality reports, papers, and presentations.
• Experience in executing and managing research and analysis of companies and markets, preferably from a commercial due diligence standpoint.

Ideally, you’ll also have

• Experience with Teradata on cloud platforms (AWS, Azure, Google Cloud).
• Experience with other database technologies (Oracle, SQL Server, Snowflake).
• Teradata certifications (e.g., Teradata Certified Master, Teradata Certified Professional).

What we look for

• A Team of people with commercial acumen, technical experience and enthusiasm to learn new things in this fast-moving environment
• An opportunity to be a part of market-leading, multi-disciplinary team of 1400 + professionals, in the only integrated global transaction business worldwide.
• Opportunities to work with EY Advisory practices globally with leading businesses across a range of industries

You get to work with inspiring and meaningful projects. Our focus is education and coaching alongside practical experience to ensure your personal development. We value our employees, and you will be able to control your own development with an individual progression plan. You will quickly grow into a responsible role with challenging and stimulating assignments. Moreover, you will be part of an interdisciplinary environment that emphasizes high quality and knowledge exchange. Plus, we offer:

• Support, coaching and feedback from some of the most engaging colleagues around
• Opportunities to develop new skills and progress your career
• The freedom and flexibility to handle your role in a way that’s right for you

EY exists to build a better working world, helping to create long-term value for clients, people and society and build trust in the capital markets.