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).
We are an equal opportunity employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability status, protected veteran status, or any other characteristic protected by law.