EY - GDS Consulting - AI And DATA -Database Administrators -Teradata - Senior
EY - GDS Consulting - AI And DATA -Database Administrators -Teradata - Senior
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Job Description
At EY youll 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 were 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.
EYs 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. EYs 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 EYs 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 clients 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 Teradatas 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 youll 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 were 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 thats 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.
Required Experience:
Unclear Seniority
Employment Type
Full Time
