Senior Teradata DBA

Database AdministratorPrincipal Duties And Responsibilities:Installs, upgrades, and maintains database systems. Supports system storage for the databases and applications.Installs and maintains database server, replication, and client environments. Develops, reviews, and tunes scripts, triggers, and store procedures. Provides production and project support.Assists with production incidents and resolutions, including root cause analysis and recommendations. Implements database reporting and continuous improvement.Executes performance monitoring, reporting, and tuning of database systems. Supports and maintains back?ups and recovery process and procedures.Assists in the design of database structures, packages, and procedures. Manages security access and controls.Minimum Requirements:Bachelor’s degree in Computer Science, Engineering or related field or experience.Min 7-8 years of database administration experience in a commercial environment, or prior relevant experience.Experience in Teradata is mustPreferred:Experience in Teradata logging configuration (DBQL, PDCR, etc.)Experience in Teradata User, Objects and Security access management.Experience in usage of Teradata Data Dictionary objects.Experience in analyzing data objects as well as system objects.Experience in system performance monitoring using Teradata Viewpoint.Experience in backup and recovery of database systems.Experience in T-SQL stored procedures & exposure to query tuning.Experience with the following: Golden Gate Software; MS Clustering or Oracle RAC; SAN Tech; AD Security; Data Warehousing / Data Replication; Microsoft SSIS; Microsoft Terminal Server; AS400.Experience of working in an environment where an ETL tool, preferably DataStage, is used to load TeradataExperience with Teradata in a cloud environment.Knowledge, Skills, And Abilities:Ability and knowledge with relational database and data storage concepts.Knowledge of Teradata Tools and Utilities like BTEQ, TPT, Tpump, FastLoad, MultiLoad and exposure to Teradata Utilities.Good working knowledge on UNIX shell scripting.Knowledge of Teradata, Microsoft SQL Server or Oracle.Knowledge of Microsoft Transact?SQL, PL/SQL, or Teradata SQL.Knowledge of Microsoft SQL Server Management Studio 2012/2014/2016 and above, Oracle 11g/12c, or Teradata Studio.Knowledge of Microsoft Windows Server 2012 and above, UNIX, Oracle Exadata, or AIX.