Senior Teradata Database Administrator-Complete Remote
Role details
Job location
Tech stack
Job description
-
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.
Requirements
Do you have experience in Teradata?, Do you have a Bachelor's degree?, * 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).