Senior Teradata Database Administrator-Complete Remote
CLOUDSCOUTS SOFTWARE SOLUTIONS LLC · Topeka, Shawnee County ·
- Seniority
- Senior
- Category
- Devops
Senior Teradata database administrator managing on-premises Teradata systems for an enterprise data warehouse — handling patching/upgrades, backup and recovery (BAR DSA, NetBackup), performance and capacity tuning, workload management (TASM), and security/audit compliance, while mentoring developers. Core tech: Teradata 15+, SQL, Viewpoint, Teradata utilities, OpenText BI-Query.
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).
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).