Be aware of scams on social media involving phony job postings. Learn more


Technical Consultant

Location: Pune, Maharashtra, India

Notice

This position is no longer open.

Requisition Number: 205129

External Description:

Position Title: Technical Consultant

Role : Teradata DBA

Location: Airoli, Navi Mumbai

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 Performance monitoring and tuning, Strategies defined for backup/recovery techniques, and problem determination and resolution.

General Key Areas of Responsibility

Manage Production/Development databases in the following areas

  • User Management
  • Security Management
  • Space Management
  • Backup and Recovery
  • Workload Management
  • Performance Tuning& Performance Reporting
  • Unix Shell and Batch Scripting

For 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.
  • Exposure to backup and restore process using Veritas netBackup(TARA)/netvault/Tivoli etc.
  • Exposure to manage the Development/QA boxes.
  • Exposure as Development DBA.
  • Well conversant with various ticketing system/production change request/ Teradata Incident management.
  • Exposure to MVC, Capacity planning and performance 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.
  • Exposure to Unix Shell and Batch Scripting.
  • Exposure to PDCR Reporting and Analysis.

Skills & Attributes

  • Full Time Bachelor’s/ Master’s Degree from reputed institute
  • 5-8 years of IT Experience
  • 3+ Years of Teradata 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
  • Should have worked in Unix platforms.
  • Good presentation, communication skills.
  • Good team player and ability to mentor small groups
  • Should be able to lead a small team.

Desirable Skills :-

  • ITIL Foundation Certification
  • 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.
  • Should have good understanding of data archive/restore policies.
  • Should be good at automating various processes.
  • Should be good at users/objects/rights management.
  • Some experience in an environment where ETL/BI tools such as Informatica, DataStage, OWB, Hyperion, Business Objects, SAS, and Microstrategy were an important part of the environment.
  • Experience with Teradata in a cloud environment (public or private) a plus.

CountryEEOText_Description: Why We Think You’ll Love Teradata We prioritize a people-first culture because we know our people are at the very heart of our success. We embrace a flexible work model because we trust our people to make decisions about how, when, and where they work. We focus on well-being because we care about our people and their ability to thrive both personally and professionally. We are an anti-racist company because our dedication to Diversity, Equity, and Inclusion is more than a statement. It is a deep commitment to doing the work to foster an equitable environment that celebrates people for all of who they are.

City: Powai Mumbai

State: Maharashtra

Community / Marketing Title: Technical Consultant

Job Category: Consulting

Company Profile:

Our Company

At Teradata, we believe that people thrive when empowered with better information. That’s why we built the most complete cloud analytics and data platform for AI. By delivering harmonized data, trusted AI, and faster innovation, we uplift and empower our customers—and our customers’ customers—to make better, more confident decisions. The world’s top companies across every major industry trust Teradata to improve business performance, enrich customer experiences, and fully integrate data across the enterprise.

LinkedIn Remote:

Location_formattedLocationLong: Pune, Maharashtra IN

.