Senior Teradata Database Administrator-Complete Remote

CLOUDSCOUTS SOFTWARE SOLUTIONS LLC
Springfield, United States of America
29 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Senior

Job location

Remote
Springfield, United States of America

Tech stack

Microsoft Windows
Agile Methodologies
Databases
Data Governance
Data Integrity
Data Warehousing
Linux
DevOps
Disaster Recovery
Github
Meta-Data Management
NetBackup
Performance Tuning
Scrum
Query Optimization
SQL Databases
Teradata
Software Vulnerability Management
Backup and Restore
OpenText

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

Apply for this position