Teradata Administrator - Python/SQL

Description :

Role : Teradata Admin.

Exp : 8-10yrs.

Location : Bangalore.

Imm-30 days Notice Period.

Desired Competencies (Technical/Behavioral Competency) :

- 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, analyzing 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 : Analyzing 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.

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