Teradata Application DBA
Company: S3
Location: Charlotte
Posted on: April 1, 2026
|
|
|
Job Description:
Job Description Strategic Staffing Solutions is currently
looking for a T eradata Application DBA a 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. Minimum 3
days per week in the office is required, with 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.”
Keywords: S3, Greensboro , Teradata Application DBA, IT / Software / Systems , Charlotte, North Carolina