Looking for Teradata Administrator contract C2C role

Tech Mirrors; San Jose (CA); On-site; USD 100,000 - 130,000; Full time

Job summary

Tech Mirrors is looking for a Teradata Administrator in San Jose, CA, to manage installations, configurations, and upgrades of Teradata database systems.

The ideal candidate will have a strong background in performance tuning, backup, recovery operations, and disaster recovery planning. A bachelor's degree in Computer Science or a related field is required.

Qualifications

• At least a bachelor's degree (or equivalent experience) in Computer Science, Software/Electronics Engineering, Information Systems, or a closely related field.
• Experience in database installation, configuration, and management.
• Proficient in performance tuning, security compliance, and disaster recovery.

Responsibilities

• Install, configure, and upgrade Teradata database systems.
• Manage user accounts and control database access.
• Perform data backups and ensure data integrity.
• Monitor database health and performance metrics.
• Diagnose and resolve database-related issues.
• Optimize SQL queries and implement advanced techniques.
• Design and manage Teradata Workload Manager rules.
• Develop disaster recovery strategies.
• Implement advanced security features.

Skills

Database Installation and Configuration

User and Security Management

Backup and Recovery Operations

System Monitoring and Alerting

Basic Troubleshooting

Performance Tuning and Optimization

Workload Management (TWM/TDWM)

Capacity Planning and Growth Management

Disaster Recovery Planning and Testing

Advanced Security and Compliance

Proficiency in Scripting Languages (e.g., Python, Shell Scripting)

Cloud Platform Familiarity (e.g., AWS, Azure, Google Cloud)

Strong Data Warehousing and ETL Concepts

Excellent Communication and Collaboration Skills

Version Control System Experience (e.g., Git)

Education

Bachelor's degree in Computer Science or related field

Job description

Position: Teradata Administrator

Location: San Jose CA (Onsite)

Duration: 8+ months

Must-Have

• Database Installation and Configuration: Installing, configuring, and upgrading Teradata database systems, including software and utilities.
• User and Security Management: Creating and managing user accounts, roles, profiles, and basic access privileges to control database access.
• Backup and Recovery Operations: Performing routine data backups, managing recovery processes, and ensuring data integrity and availability.
• System Monitoring and Alerting: Monitoring database health, performance metrics (CPU, I/O, space), and setting up alerts for potential issues.
• Basic Troubleshooting: Diagnosing and resolving common database-related problems, such as connectivity issues, space constraints, or failed jobs.

Advanced Responsibilities

• Performance Tuning and Optimization: Deep diving into SQL query optimization, analysing explain plans, and implementing advanced techniques (e.g., join indexes, partitioning) to enhance system performance.
• Workload Management (TWM/TDWM): Designing, configuring, and managing Teradata Workload Manager rules to prioritize queries, manage concurrency, and ensure service level agreements (SLAs).
• Capacity Planning and Growth Management: Analysing historical usage patterns, forecasting future growth, and planning for hardware and software upgrades to meet evolving business needs.
• Disaster Recovery Planning and Testing: Developing, documenting, and regularly testing comprehensive disaster recovery strategies to ensure business continuity in the event of a major outage.
• Advanced Security and Compliance: Implementing advanced security features (e.g., encryption, auditing, row-level security), ensuring compliance with data governance policies, and conducting security audits.

Good-to-Have

• Proficiency in Scripting Languages (e.g., Python, Shell Scripting): While automation was mentioned, advanced scripting skills allow for more sophisticated custom monitoring, reporting, and proactive problem-solving beyond standard tools.
• Cloud Platform Familiarity (e.g., AWS, Azure, Google Cloud): With Teradata Vantage often deployed on cloud platforms, understanding cloud infrastructure, networking, and security concepts within these environments is increasingly valuable.
• Strong Data Warehousing and ETL Concepts: A deeper understanding of the entire data lifecycle, including data ingestion (ETL/ELT processes), data modeling methodologies (e.g., Dimensional Modeling), and data governance, helps in optimizing the database for its intended use.
• Excellent Communication and Collaboration Skills: The ability to effectively communicate complex technical issues to non-technical stakeholders, work seamlessly with development teams, and provide clear documentation is crucial for project success.
• Version Control System Experience (e.g., Git): Managing database scripts, configuration files, and automation code using version control systems ensures proper tracking, collaboration, and rollback capabilities for changes.

Education: At least a bachelor’s degree (or equivalent experience) in Computer Science, Software/Electronics Engineering, Information Systems, or closely related field is required.