Teradata Operations DBA

External Description:
Role: Teradata Operations DBA
Location: Mumbai/Pune/Bangalore/Hyderabad
Exp: 2- 10 Yrs.
Job Summary
• Manage and support 24x7 production databases as well as development databases to ensure maximum availability of database resource for various applications
• He should perform the 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.

Key Areas of Responsibility
Manage Production/Development databases in the following areas
• User Management
• Security Management
• Space Management
• Backup and Recovery
• Workload Management
• Unix Shell and Batch Scripting
• Project Deliverables
• Manage Customer Meetings and Co-ordinating with Teradata GSC

Teradata DBAs
• System Performance monitoring using Teradata Viewpoint.
• Exposure to Teradata tools like Teradata Administrator/SQL Assistant /TSET etc.
• User, Objects and Security management as per Teradata Best practices.
• Hands-on experience in using DSA
• Exposure to other backup and restore process using Veritas netBackup(TARA)/netvault/Tivoli etc.
• Exposure to manage the Development/QA boxes.
• Exposure as an Development DBA.
• Well conversant with various ticketing system/production change request/ Teradata Incident management.
• Exposure to MVC, Capacity planning and performance Management.
• Hands-on experience in Statistics Management
• Exposure to troubleshoot the FastLoad / Multiloading/ FastExport/ BTEQ/ TPT and should be good at error handling.
• Exposure to TASM/TDWM.
• Exposure to DWH Env (Knowledge of ETL/DI/BI Reporting).
• Exposure to Teradata Utilities
• Coordinate Software/Hardware Upgrade Activities.
• Ensure Teradata Polices, Procedures, Customer SLA's are honored.
• Exposure to PDCR Reporting and Analysis.
• Strong debugging skills

Basic Qualifications
• Engineering Graduate
• 2-12 years of DBA experience.
• Excellent oral and written communication skills in the English language.
• Must be willing to provide 24x7 on-call support on a rotational basis with the team.
• Must be willing to travel - both short-term and long-term

Skills & Attributes
• Working experience as an DBA in Teradata or Oracle
• Should have worked in Unix platforms.
• Good presentation, communication skills.
• Good team player and ability to mentor small groups
Desirable Skills :-
• Understanding of Logical Data Model/Physical Data Model.
• Understanding of Normalization and De-normalization concept.
• Ability to write efficient SQL & exposure to query tuning.
• Should have good working knowledge on UNIX shell scripting and Python skills.
• Should have good understanding of data archive/restore policies.
• Should be good at automating various processes.
• Should begood at users/objects/rights management.
• Some experience in an environment where ETL/BI tools such as Informatica, DataStage, Business Objects, SAS, and Microstrategy, Tableau, Power BI were an important part of the environment.
• Experience with Teradata in a cloud environment (public or private) a plus