Teradata Database Administrator

Strategic Staffing Solutions is currently looking for a Teradata Application DBAa W2 contract opportunity with one of our largest clients! This is a W2 contract opportunity, and the candidates should be willing to work on our W2 ONLY, NO C2C. Teradata Application DBA Location: Charlotte, NC Type: W2 Contract – 12-month contract Hybrid-3 days in office Top Skills:The ideal candidate will have strong Teradata DBA fundamentals, hands-on experience with object storage, OTF (Open Table Format), and Python for automation, monitoring, and operational efficiency. Work Location & Schedule: Hybrid work model required.A minimum of 3 days per week in the office is required, with the remaining days worked remotely.Candidate must be able to work onsite at the assigned office location and collaborate in person with delivery teams and stakeholders as needed. Job Description: The Teradata Application DBA is responsible for providing end-to-end administration, engineering, and operational support for Teradata database platforms supporting enterprise data warehouse and application workloads. This role focuses on application onboarding, performance optimization, capacity planning, security, and platform modernization, while partnering closely with application, ETL, and platform engineering teams. Key Responsibilities: Teradata Application DBA Operations Administer and support multiple Teradata environments (development, test, and production) including enterprise data warehouses and application-specific marts. Perform database provisioning, space management, user/role administration, and profile management. Ensure high availability, stability, and operational excellence across Teradata platforms. Provide operational support, incident triage, and root cause analysis in partnership with infrastructure and application teams Performance, Capacity & Optimization Conduct capacity planning, workload analysis, and proactive performance tuning. Analyze query performance using Teradata tools and system views; identify and remediate bottlenecks. Optimize physical database design including primary indexes, partitioning, compression, and statistics strategies. Support benchmark testing and validation for new workloads and platform changes. Python & Automation Use Python to automate routine DBA tasks such as health checks, monitoring, reporting, and operational workflows. Develop Python scripts to integrate Teradata metadata, system metrics, and logs with monitoring or alerting solutions. Support automation around object storage, OTF workflows, and operational runbooks. Collaborate with platform engineering teams to improve reliability and reduce manual operational effort through scripting and automation. Object Storage & OTF Design and support Teradata integrations with object storage platforms (e.g., cloud or on-prem object storage solutions). Implement and manage OTF-based data movement for backup, restore, archival, and data lifecycle use cases. Partner with platform and security teams to ensure object storage integrations meet enterprise security and compliance standards. Support modernization initiatives leveraging object storage for cost efficiency and scalability. Data Movement & Utilities (Application-Aligned) Support application teams with Teradata utilities such as FastLoad, MultiLoad, FastExport, TPT, and BTEQ for performance-efficient data access. Ensure adherence to separation-of-duties and approved data movement SOPs for production environments. Provide guidance and oversight rather than direct production data manipulation, aligned with enterprise policies. Security, Risk & Compliance Implement and maintain database security controls, including roles, privileges, and access models. Ensure compliance with enterprise data protection, audit, and regulatory requirements. Partner with risk, security, and audit teams to support reviews, remediation, and privileged access controls. Platform Modernization & Migration Participate in Teradata platform upgrades, patching, and migration initiatives. Support data center exit, cloud alignment, or hybrid modernization efforts involving Teradata and object storage. Contribute to documentation, standards, and operational best practices. Required Qualifications 6+ years of hands-on experience as a Teradata Application DBA or Teradata Database Engineer. Proven experience supporting large-scale Teradata environments in enterprise settings. Prior hands-on exposure to object storage technologies and OTF. Technical Skills Deep knowledge of Teradata architecture, MPP concepts, and database internals. Strong proficiency in Teradata SQL, BTEQ, and Teradata utilities (FastLoad, MultiLoad, TPT, FastExport). Experience with performance tuning, workload management, and capacity planning. Working knowledge of object storage integrations, backup/restore, and data archival strategies. Familiarity with scripting (Shell, Python preferred) for automation and operational efficiency. Soft Skills Strong troubleshooting and analytical skills with the ability to diagnose complex performance and stability issues. Excellent communication skills to collaborate with application teams, ETL developers, and platform engineers. Ability to work independently. Comfortable operating in regulated, security-focused enterprise environments. Preferred / Nice-to-Have Experience supporting Teradata modernization or cloud-adjacent initiatives. Exposure to hybrid data architectures and data platform engineering teams. Prior experience in financial services or other highly regulated industries. Education Bachelor’s degree in Computer Science, Information Systems, Engineering, or equivalent practical experience. “Beware of scams. S3 never asks for money during its onboarding process.” Benefits: Health insurance Application Question(s): Are you willing to work on our W2? Are you on OPT/CPT/H1b visa type? Education: Bachelor's (Required) Experience: Teradata: 5 years (Required) Location: Charlotte, NC 28216 (Required) Work Location: Hybrid remote in Charlotte, NC 28216