Database Administrator Teradata

Job Summary :

We are seeking for skilled and experienced

Teradata Administrator

and with a strong background on

Teradata and ETL / ELT process.

A Teradata Administrator will be responsible for managing and maintaining Teradata database systems to ensure optimal performance, security, and availability. This role involves working closely with database developers, system administrators, and business analysts to support enterprise data needs.

Key Responsibilities :

Database Management & Maintenance

Install, configure, and upgrade Teradata database software and associated tools.

Monitor database health and performance using Teradata Viewpoint and other monitoring tools.

Perform routine maintenance tasks including space management, statistics collection, and system housekeeping.

Performance Tuning & Optimization

Analyze and optimize SQL queries for performance improvements.

Implement indexing strategies and partitioning to enhance query efficiency.

Collaborate with developers and data engineers to design scalable data models.

Security & Compliance

Manage user access, roles, and privileges in accordance with organizational policies.

Ensure compliance with data governance and security standards.

Monitor and audit database activities to detect and prevent unauthorized access.

Backup & Recovery

Design and implement backup strategies using Teradata tools (e.g., ARC).

Perform recovery operations in case of system failures or data corruption.

Test disaster recovery procedures regularly to ensure readiness.

Capacity Planning & System Scaling

Forecast storage and compute requirements based on usage trends.

Plan and execute system scaling activities to support growing data volumes.

Coordinate with infrastructure teams for hardware and resource provisioning.

Troubleshooting & Support

Investigate and resolve database-related issues and incidents.

Provide support during system outages and performance degradation.

Maintain documentation for configurations, procedures, and troubleshooting steps.

Required Skills & Qualifications :

Bachelor’s degree in Computer Science, Information Technology, or related field

12+ years

of experience with at least

7 years

of hands-on experience in

Teradata database administration

Strong hands-on experience with

Teradata SQL, Teradata utilities .

Hands-on with other Databases like

CosmosDB / Oracle / Postgres

Administrative activities

Proficient with scripting language

Python, PowerShell

for automation.

Understanding of

data modeling, ETL / ELT processes , and data warehousing concepts.

Experience working with

Azure cloud -based environment is a plus

Experience with

Data governance, data security, data quality, data lineage, data catalog

and compliance practices

Excellent problem-solving, communication and collaboration skills

Preferred Qualifications :

Teradata certifications (e.g.,

Teradata Certified Professional, Teradata Administrator)

Exposure to DevOps practices and CI / CD pipelines for database deployments.

Exposure to

Agile / Scrum methodologies

and collaborative development environments.

Work Location - Hyderabad & Noida

Interested candidates please share your profile at manjula.venka@hcltech.com