Job Description

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 .
• 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.

Job Tags

Similar Jobs