In this role you will:
• Manage, monitor, and maintain OnPrem Teradata hardware/software including patches,
replacements, and upgrades with support from Teradata.
• Support data governance, metadata management, and system administration
• Plan and execute tasks required to ensure the Teradata system is operational including
occasional evening and weekend support for Teradata maintenance.
• Provide direction to developers on Operational, Design, Development, and Implementation
projects to ensure best use of the Teradata system including review/approval of database
components (such as tables, views, SQL code, stored procedures).
• Performing database backup and recovery operations - using the BAR DSA and NetBackup.
• Developing proactive processes for monitoring capacity and performance tuning.
• Providing day-to-day support for the EDW users problems like job hands, slowdowns,
inconsistent rows, re-validating headers for tables with RI constraints, PPIs, and configuration.
• Maintaining rules set in the Teradata Active System Management (TASM) and supporting
workload management.
• Maintaining the Teradata Workload Manager with the proper partitions and workloads based
on Service Levels.
• Supporting the database system and application server support for the Disaster Recovery (DR)
build/test, annual drill, and quarterly maintenance as needed.
• Actively monitoring the health of the Teradata system and Teradata Managed Servers (TMS)
using Viewpoint and other tools and application servers and make preventive or corrective
actions as needed.
• Maintaining access rights, role rights, priority scheduling, and reporting using dynamic workload
manager, Database Query Log (DBQL), usage collections and reporting of ResUsage, AmpUsage,
and security administration etc.
• Coordinating with the team and customers in supporting database needs and making necessary
changes to meet the business, contractual, security, performance, and reporting needs.
• Supporting internal or external audit process and address vulnerabilities or risk proactively.
• Prepare and support IRS and internal audit.
• Coordinating with Teradata to perform Teradata system hardening and delivery of Safeguard
Computer Security Evaluation Matrix (SCSEM) Reports as needed, addressing issues in the
hardening and vulnerability scan report.
• Generating and maintaining capacity management, Space, and CPU reports on analyzing the
Spool, CPU, I/O, Usage, and Storage resources and proactive monitoring to meet performance
and growth requirements.
• Reviewing and resolving Teradata alerts and communicating any risk / issues or impact to the
management, team, and business users through appropriate communication strategy.
• Effectively reporting status, future roadmap, proactive process improvements, automation,
mitigation strategies, and compensating controls to the management and clients.
• Leading database or data related meetings and projects/activities delivering quality deliverables
with minimal supervision/direction.
• Sharing knowledge, coaching/mentoring other members in the team for backups.
• Performing additional duties that are normally associated with this position, as assigned.
• Responsible for front-end tool (OpenText Bi-Query) and model maintenance and administration