Required Skills

Teradata SQL QA boxes

Work Authorization

  • US Citizen

  • Green Card

  • EAD (OPT/CPT/GC/H4)

Preferred Employment

  • Corp-Corp

Employment Type

  • Consulting/Contract

education qualification

  • UG :- - Not Required

  • PG :- - Not Required

Other Information

  • No of position :- ( 1 )

  • Post :- 26th Jul 2022

JOB DETAIL

Installs, configures, and upgrades Teradata software and related products.  Implements and maintains database security; sets up and maintains documentation and standards.  supports multiple Teradata systems including independent marts/enterprise warehouse.

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

•             Ensure Teradata Polices, Procedures, Customer SLA’s are honored.

•             Exposure to PDCR Reporting and Analysis.

•             String debugging skills

 

 

 

 Basic Qualifications

•             Engineering Graduate

•             8+ 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.

 

 

Skills & Attributes

•             ITIL Foundation certificate and above.

•             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

•             Should be able to lead a large team.

•             Ability to Manage Team Conflicts.

•             Handle Customer Escalation.

•             Transition Management.

 

 

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.

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

 

Company Information