Senior Teradata Database Administrator (DBA)

Springfield - USA

Monthly Salary: Not Disclosed

Posted on: 30+ days ago

Vacancies: 1 Vacancy

Job Summary

System Administration & Maintenance

Manage and maintain OnPrem Teradata systems including patches upgrades and hardware replacements.
Monitor system health using Viewpoint and other tools; perform preventive and corrective actions.
Support disaster recovery (DR) planning testing and quarterly maintenance.
Coordinate with Teradata and subcontractors for system hardening and vulnerability remediation.

Database Operations & Optimization

Perform backup and recovery operations using BAR DSA and NetBackup.
Monitor and tune performance capacity and resource usage (CPU I/O Spool Storage).
Maintain workload management using TASM and Workload Manager partitions.
Administer access rights role rights priority scheduling and security reporting.

Development Support & Governance

Guide developers on design and implementation best practices; review/approve database components.
Support EDW users with query optimization job handling and data integrity issues.
Maintain and administer OpenText BI-Query models and front-end tools.
Lead database-related meetings and deliverables with minimal supervision.

Reporting & Compliance

Generate and maintain capacity and performance reports.
Support internal and IRS audits; address risks and vulnerabilities proactively.
Communicate system alerts risks and status updates to stakeholders.
Ensure compliance with SCSEM and other security evaluation frameworks.

Collaboration & Leadership

Coordinate with teams and customers to meet business security and reporting needs.
Mentor team members and share knowledge on backup and database operations.
Participate in agile development environments and large-scale DDI projects.

Required Qualifications:

Bachelors degree or equivalent experience.
7 years as a lead Teradata DBA (Version 15).
Experience with on premises Teradata 6800/1800 or IntelliFlex systems.
Expert in SQL skills and Teradata utilities (FastLoad Multiload FastExport BTEQ TPT).
Proven performance tuning experience in large databases (>5TB).
Experience in database specification development and issue resolution.
Excellent communication client-facing and mentoring skills.

Preferred Qualifications:

Teradata Vantage Certified Master.
Experience upgrading to IntelliFlex.
Data modeling experience (Erwin or similar).
Experience with OpenText BI-Query metadata management and data governance.
Familiarity with Medicaid/Medicare/Healthcare applications.
Experience in agile environments (Scrum DevOps GitHub).
Application server administration (Windows/Linux).

System Administration & Maintenance Manage and maintain OnPrem Teradata systems including patches upgrades and hardware replacements. Monitor system health using Viewpoint and other tools; perform preventive and corrective actions. Support disaster recovery (DR) planning testing and quarterly...