Contract Senior Teradata DBA – Automation & Mainframe

BCforward; Charlotte (NC); On-site; USD 111,000 - 128,000; Part time

Job summary

BCforward is seeking a Teradata Database Administrator to join our team in a contract role. The ideal candidate will have strong Teradata administration, Unix/Linux scripting, and mainframe integration experience, and will design, implement, and support scalable, secure data environments.

Responsibilities include DBA tasks, automation of processes, managing multiple Teradata environments, and ensuring security and disaster recovery practices are in place.

Qualifications

• 10+ years of Teradata DBA experience (V17.20+).
• Advanced Teradata RDBMS knowledge at physical and logical levels.
• Proficiency with Teradata tools: Teradata Studio, TDWM, BTEQ, ARCMAIN, FASTLOAD, MLOAD, TPUMP, TPT, DBQL, and PDCR.
• Working knowledge of Viewpoint, Teradata Data Mover, and Teradata BAR technology.
• Unix/Linux scripting skills in KSH, Bash, and Perl for automation.
• Experience with mainframe interfaces and execution: TDP, JCL, TSO, ISPF, FICON, and NDM.
• Familiarity with Teradata system setup utilities including GDO, DBSControl, and Multitool.
• Knowledge of QueryGrid, DSA, Teradata Server components, NPARC, and TASM.
• Experience with enterprise schedulers such as CA-7 and AutoSys.
• Understanding of replication technologies including GoldenGate.

Responsibilities

• Perform Application DBA functions including DDL creation, SQL scripting, problem analysis, change deployments, and on-call rotation support.
• Design, develop, implement, document, and support automated DBA processes using Teradata and Unix/Linux scripting.
• Support multiple Teradata environments including development/UAT, disaster recovery, and enterprise data warehouse production.
• Implement and administer access controls aligned with corporate security standards and policies.
• Support mainframe administrative functions including archive processing and job scheduling.
• Manage, design, document, and consult on storage management, archive, restore, backup, and disaster recovery practices.
• Partner with application project teams to implement database changes for large initiatives and BAU work.
• Complete assigned training, attend team meetings, and adhere to internal DBA processes and tools.
• Provide weekly written status reports to management and work independently with minimal supervision.

Skills

Teradata DBA

Unix scripting

Mainframe integration

Data warehouse

Automation

Security access controls

Tools

Teradata Studio

TDWM

BTEQ

ARCMAIN

FASTLOAD

MLOAD

TPUMP

TPT

DBQL

PDCR

Job description

BCforward is seeking a Teradata Database Administrator to join our team in a contract role. The ideal candidate will have strong Teradata administration, Unix/Linux scripting, and mainframe integration experience, and will design, implement, and support scalable, secure data environments.

Responsibilities include DBA tasks, automation of processes, managing multiple Teradata environments, and ensuring security and disaster recovery practices are in place.