Senior Lead Teradata Database Administrator (DBA)

Gilder Search Group; Springfield (IL); On-site; USD 90,000 - 120,000; Full time

Job summary

Gilder Search Group is seeking a Teradata Operations Manager in Springfield, Illinois. This role is crucial for managing, monitoring, and maintaining OnPrem Teradata hardware/software, including crucial database operations and user support. Key responsibilities involve executing maintenance tasks, supporting data governance, and coordinating with teams for database needs while ensuring system performance and audit compliance. Candidates should have experience in database operations and troubleshooting user issues. This is an onsite position that plays a vital role in the smooth operation of Teradata systems.

Qualifications

• Experience managing OnPrem Teradata hardware/software.
• Knowledge of database backup and recovery operations.
• Ability to provide support for EDW users.

Responsibilities

• Manage, monitor, and maintain OnPrem Teradata systems.
• Support data governance and system administration.
• Develop proactive monitoring processes.

Job description

Responsibilities

• 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 and approval of database components such as tables, views, SQL code, and stored procedures.
• Perform database backup and recovery operations using the BAR DSA and NetBackup.
• Develop proactive processes for monitoring capacity and performance tuning.
• Provide day‑to‑day support for EDW users with issues such as job hangs, slowdowns, inconsistent rows, re‑validating headers for tables with RI constraints, PPIs, and configuration.
• Maintain rules set in the Teradata Active System Management (TASM) and support workload management.
• Maintain the Teradata Workload Manager with proper partitions and workloads based on service levels.
• Support the database system and application server for disaster recovery (DR) build/test, annual drill, and quarterly maintenance as needed.
• Actively monitor the health of the Teradata system and Teradata Managed Servers (TMS) using Viewpoint and other tools, making preventive or corrective actions as needed.
• Maintain 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.
• Coordinate with the team and customers to support database needs and make necessary changes to meet business, contractual, security, performance, and reporting needs.
• Support internal or external audit processes, addressing vulnerabilities or risks proactively.
• Prepare and support IRS and internal audit.
• Coordinate with Teradata to perform system hardening and deliver Safeguard Computer Security Evaluation Matrix (SCSEM) reports, addressing issues from hardening and vulnerability scan reports.
• Generate and maintain capacity management, space, and CPU reports on analyzing spool, CPU, I/O, usage, and storage resources and proactive monitoring to meet performance and growth requirements.
• Review and resolve Teradata alerts and communicate any risk, issue, or impact to management, the team, and business users through appropriate communication.
• Effectively report status, future roadmap, proactive process improvements, automation, mitigation strategies, and compensating controls to management and clients.
• Lead database or data‑related meetings and projects/activities, delivering quality deliverables with minimal supervision or direction.
• Share knowledge and coach or mentor team members in backup procedures.
• Perform additional duties that are normally associated with this position, as assigned.
• Be responsible for front‑end tool (OpenText Bi‑Query) and model maintenance and administration.