DATAMAXIS, Inc
Senior Teradata Database Administrator / Remote
DATAMAXIS, Inc, New York, New York, United States
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).
#J-18808-Ljbffr
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).
#J-18808-Ljbffr