$120K - 180K a year
Manage and maintain on-premises Teradata systems, optimize database performance, support development and governance, ensure compliance and reporting, and lead collaboration and mentoring efforts.
7+ years as lead Teradata DBA with expertise in Teradata 6800/1800 or IntelliFlex, advanced SQL and Teradata utilities skills, performance tuning, excellent communication, and preferably Teradata Vantage certification and agile experience.
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).
This job posting was last updated on 10/1/2025