Teradata Database Administrator, Managed Services

Job Description

The Database Administrator (DBA) applies comprehensive Teradata database knowledge across key administrative task and high impact assignments. The DBA will function as part of a larger team, and is responsible for all operational aspects associated with supporting multiple Teradata database environments. The ideal candidate will be well-versed in, and have experience in implementing, maintaining, securing, administering, and improving the operations of the Teradata database environment.

The DBA will routinely work with partners, project managers, system administrators, application developers and end users in order to maintain and improve the performance of the Teradata environment.

The DBA must be able to leverage standard IT processes, understand and be able to work with an Agile / DevOps methodology, address business and technical requirements, and have a continuous improvement mindset.

This is a customer facing onsite position based in Fort Worth, Texas.

Roles and Responsibilities:

• Manage Teradata databases in multiple environments (ex: Production/QA/Development) including object, space, security, and performance administration.
• Successfully implement and manage database design, data access, table maintenance, and other database issues
• Ensure optimal configuration and performance of database(s) and environment
• Collaborate with others at the modeling, design, and implementation stages to address business requirements and system capabilities working with internal constituents and other IT resources internally
• Support project teams as needed as new initiatives are planned and rolled-out
• Develop and maintain documentation regarding the operational aspects of database administration
• Analyze long-term database performance trends and proactively identify ongoing optimization, performance enhancement, and best practice opportunities
• Diagnose and troubleshoot database errors.
• Create automation for repeatable database administration tasks
• Ensure timely and accurate delivery of database administration services to meet business objectives and SLAs.
• Take ownership of technical issues to see them through to resolution, performing complex troubleshooting and root cause analysis to prevent issue recurrence.

Qualifications and Experience:

• Teradata Vantage
• Teradata Native Object Store (NOS)
• Teradata QueryGrid
• Teradata database architecture and design
• Teradata Active System Management (TASM)
• Teradata Advanced SQL Engine
• Teradata Performance Tuning
• Teradata Indexes
• Teradata database-level security
• Teradata tools and utilities
• Performance Data Collection and Reporting
• Amazon AWS, S3 buckets, and IAM
• Azure
• Spark HDFS
• Python
• Tableau
• Unix / Linux scripting
• GitHub and Subversion version control tools

Must also have experience:

• 8+ years’ experience in US Travel & Transportation Industry
• Writing Linux / Unix shell scripts and utilizing the cron scheduler
• Applying statistical modeling and machine learning concepts within Teradata VantageCloud.
• Utilizing Native Object Store concepts to move and migrate data from on-premises systems to Cloud-based storage (Amazon S3/Azure Blob)
• Designing and implementing various workload management strategies with Teradata’s TASM to meet customer Service Level Agreements.
• Using Teradata’s Cost Bast Optimizer to ensure the best query execution plans are chosen
• Understanding of how to generate query execution plans and using it to identify potential bottlenecks
• Expertise in multiple performance tuning methodologies on Teradata Vantage (utilizing join indexes, partitioned indexes and elimination, statistics, etc)
• Performing logical database design and based on database modeling
• Applying predictive analysis for capacity planning (system CPU, I/O, and storage) on applications that use Teradata products
• Configuring and deploying instances on Amazon AWS/Microsoft Azure
• Building Amazon S3 buckets and managing associated policies
• Using Teradata SQL to extract, transform, and load data to / from multiple sources and targets
• Proficient in (T-) SQL, including query plan understanding and query tuning
• Experience with the creation/modification of a Data Model and/or Source-to-Target mappings.
• Knowledge and experience of one or more ETL/Integration tool (DataStage/Ab-Initio/Informatica etc)
• Must have hands on experience with Azure Databricks
• Broader technical/programming skillset (Python, Pyspark)
• Understanding and utilization of source code version control tools such as GitHub and Subversion
• Implementing load-balancing and session-routing for Linux server failover