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).