Database Administrators

6 - 11 years

20 - 25 Lacs

hyderabad

Posted:6 days ago| Platform:

Apply

Skills Required

unix system architecture linux rdbms shell scripting consulting teradata troubleshooting analytics python

Work Mode

Work from Office

Job Type

Full Time

Job Description

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.

More Jobs at EY

Core Audit Manager- Bangalore

Chennai, Bengaluru

5 - 8 yrs

INR 20 - 32 Lacs

UK Payroll - Senior

Bengaluru

4 - 8 yrs

INR 3 - 8 Lacs

UK Payroll- Advanced Analyst

Bengaluru

2 - 4 yrs

INR 1 - 5 Lacs

Associate - SaT - TMT - SaT - TCF - Transaction Diligence - New Delhi

Delhi

Experience: Not specified

Salary: Not disclosed

Executive - Assurance - CHS - ASU - Audit - Audit Services - Ahmedabad

Ahmedabad, Gujarat

Experience: Not specified

Salary: Not disclosed

Mock Interview

Practice Video Interview with JobPe AI

Start Python Interview

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.