Database Administrator Teradata

Job Summary:

Teradata Administrator

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