Teradata Admin
- San Francisco, CA
- $65.00-70.00 per hour
- Permanent
- Full-time
- 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.
- 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.
- 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.
- 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.
- 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.
- Investigate and resolve database-related issues and incidents.
- Provide support during system outages and performance degradation.
- Maintain documentation for configurations, procedures, and troubleshooting steps.
- Bachelor's degree in Computer Science, Information Technology, or related field.
- 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.
- 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.