Job Description :
Pay Range : $65hr - $70hr
Responsibilities :
Database Management And 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 And 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 And 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 Amf 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 And 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 And 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 And Qualifications :
Bachelor’s degree in Computer Science, Information Technology, or related field.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.Must Have Experience :
12+ years of experience with at least 7 years of hands-on experience in Teradata database administrationStrong 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 plusExperience with Data governance, data security, data quality, data lineage, data catalog and compliance practicesExcellent problem-solving, communication and collaboration skills.