Senior Teradata Database Administrator

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:

• Bachelor’s 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).