Teradata Infrastructure DBA

Required Skills:

Infrastructure DBA experience and Backup and Recovery experienceTeradata latest version Backup and RecoveryManaging security policies and complianceSystem Monitoring and MaintenanceTroubleshooting and Problem ResolutionPerformance TuningAutomationCapacity PlanningIncident ManagementDocumentationRelease ManagementInstalls, configures and upgrades Teradata software and related products.Backup, restore, migrate Teradata data and objectsEstablish and maintain backup and recovery policies and procedures;Manages and monitor system performance. proactively monitor the database systems to ensure secure services with minimum downtime• Implements and maintains database security;Sets up and maintains documentation and standards.Supports multiple Teradata Systems including independent marts/ enterprise warehouse.Work with the team to ensure that the associated hardware resources allocated to the databases and to ensure high availability and optimum performance.Responsible for improvement and maintenance of the databases to include rollout and upgrades.Responsible for implementation and release of database changes as submitted by the development teamWork with end customerTeradata , customer , datacenter, vendor co-ordinationsForecast data, security auditsUser account and access managementTeradata active system management and customer requests and system allocationBackup and recoverySOX compliance and auditsDB support from 3rd party vendorsProduct evaluationsOn call support and major incidentsBackup restore , frequency and retentionDisaster recoveryCreate long range disaster recoveryCustomer feedback surveyExperienced in performance optimization techniques and Structured Query Language (SQL) tuning.Demonstrated knowledge of Performance Data Collection and Reporting (PDCR) and Database Query Logging (DBQL)Ability to write complex Teradata SQL queries, stored procedures, triggers, functions Practical experience in managing the internal and external Teradata database security