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

At EY, you’ll have the chance to build a career as unique as you are, with the global scale, support, inclusive culture and technology to become the best version of you. And we’re counting on your unique voice and perspective to help EY become even better, too. Join us and build an exceptional experience for yourself, and a better working world for all.

EY-Advisory - Data and Analytics – Senior Technology Consultant.

EY's Advisory Services is a unique, industry-focused business unit that provides a broad range of integrated services that leverage deep industry experience with strong functional and technical capabilities and product knowledge. EY’s financial services practice provides integrated advisory services to financial institutions and other capital markets participants, including commercial banks, retail banks, investment banks, broker-dealers & asset management firms, and insurance firms from leading Fortune 500 Companies. Within EY’s Advisory Practice, Data and Analytics team solves big, complex issues and capitalize on opportunities to deliver better working outcomes that help expand and safeguard the businesses, now and in the future. This way we help create a compelling business case for embedding the right analytical practice at the heart of client’s decision-making.

The opportunity

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

What working at EY offers

At EY, we’re dedicated to helping our clients, from startups to Fortune 500 companies — and the work we do with them is as varied as they are.

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 | Building a better working world

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.

Enabled by data and technology, diverse EY teams in over 150 countries provide trust through assurance and help clients grow, transform and operate.

Working across assurance, consulting, law, strategy, tax and transactions, EY teams ask better questions to find new answers for the complex issues facing our world today.