Teradata Operations Dba

Who we are

Teradata is a global technology business that empowers clients to achieve high-impact business outcomes through analytics. Harnessing a powerful mix of industry expertise and leading hybrid cloud technologies for data warehousing and big data analytics, Teradata unleashes the potential of great companies.

What we do

Teradata helps companies improve customer experience, mitigate risk, drive product innovation, achieve operational excellence, transform finance, and optimize assets. These customers are leading names in consumer goods, financial services, healthcare, automotive, communications, travel, hospitality, and more. Which ultimately means our work touches millions of lives.

Why Teradata

Joining Teradata is your opportunity to work at the heart of the analytic ecosystem, for the pioneers in big data solutions. What sets us apart as an employer? Our combination of technology expertise and high ethical standards — together with a dynamic, diverse, collaborative culture that brings out the best in our people. The huge growth potential in the business means you’ll find huge opportunities to enhance your career here.

We strive to create an environment of openness and trust. You’ll be a great fit for Teradata if you thrive in a dynamic, diverse, collaborative culture. Our team do great things because we believe in what we’re doing. We roll our sleeves up and solve the biggest, messiest business problems. We consider ourselves the non-conformists who fail fast— to ensure our customers succeed faster.

**Job Role**: Teradata Operations DBA

**Location**: Mumbai/Pune/Bangalore/Hyderabad

**Exp**: 2- 12 Yrs.

Job Summary

Working experience as Teradata Database Administrator (DBA) on Unix Platforms

Incumbent should perform DBA related tasks in key areas of System Administration, Database Administration, Backup, Archive & Restore Management, Performance Management & Reporting

Perform capacity planning, performance monitoring and tuning, Strategies defined for backup/recovery techniques, and problem determination and resolution.
Role involves direct interaction with customer/vendors hence good presentation and communication skill is a must
Should be a good team player and ability to mentor small groups

Basic Qualification

4 Year Engineering Degree or 3 Year Master of Computer Application

3-12 years of experience as Teradata DBA

Excellent oral and written communication skills in English language

Must be willing to provide 24x7 support on a rotational basis

Must be willing to travel - both short-term and long-term if required

Key Responsibilities

User Management

Security Management

Space Management

Workload Management

Backup and Recovery

Unix Shell and Batch Scripting

Project Deliverables

Automations

Follow ITIL processes

Manage Customer Meetings and Co-ordinating with Teradata GSC

Mandatory Skills

System Performance monitoring using Teradata Viewpoint

Proficient in Teradata tools like Teradata Administrator/SQL Assistant /TSET etc.

User, Objects and Security management as per Teradata Best practices

Hands-on experience in Statistics Management

Ability to write efficient SQL & exposure to query tuning

Good at Unix commands and basic scripting

Hands-on experience using DSA

Strong debugging skills

Well versed with ticketing system/production change request/ Incident management

Exposure to backup and restore process using Veritas netBackup(TARA)/netvault/Tivoli etc.

Exposed in managing/maintaining lower environments like Development/QA boxes

Exposure to Teradata Utilities

Exposure to troubleshoot FastLoad / Multiloading/ FastExport/ BTEQ/ TPT and should be good at error handling

Exposure to coordination of Software/Hardware Upgrade Activities

Exposure to TASM/TDWM

Exposure to MVC, Capacity planning and performance Management

Exposure to DWH Env (Knowledge of ETL/DI/BI Reporting)

Exposure to PDCR Reporting and Analysis

Desirable Skills

Experience with Teradata in a cloud environment (public or private) is a plus

Working knowledge on UNIX shell scripting and Python skills

Understanding of data archive/restore policies

Automating various processes

Exposure to environment where ETL/BI tools such as Informatica, DataStage, Business Objects, SAS, Microstrategy, Tableau, Power BI were an important part of the environment

Understanding of Logical Data Model/Physical Data Model

Understanding of Normalization and De-normalization concept