Senior Teradata DBA / Teradata Database Administrator

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

Location: Jacksonville, FL or Charlotte, NC

Duration: Contract - 12 months

Pay Range: $53.40/hr (W2)

Job ID: 407971

About BCforward

BCforward is a leading global IT consulting and workforce solutions firm providing services and support to Fortune 500 and government clients. Founded in 1998, BCforward has grown with our customers needs into a full-service business solutions provider. With delivery centers and offices across North America and India, we take pride in building long-term relationships and delivering excellence through innovation, collaboration, and integrity.

Job Description

We are seeking a Teradata Database Administrator to join our dynamic team. The ideal candidate will have strong experience in Teradata administration, automation with Unix/Linux scripting, and mainframe integration and a proven ability to design, implement, and support scalable, secure, and resilient enterprise data environments.

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.

Required Skills & Qualifications:

• 10+ years of Teradata DBA experience with exposure to Teradata V17.20 or higher.
• Advanced knowledge of Teradata RDBMS 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.

Preferred Skills:

• REXX scripting exposure.
• Familiarity with Hadoop and cloud concepts and technologies.
• Experience with project and change management solutions and automation tools such as Agile, Remedy, and Ansible.

Why BCforward?

At BCforward, we believe in advancing lives and careers. When you join our team, you gain access to:

• Competitive compensation and benefits.
• Opportunities for growth with global clients.
• A supportive, inclusive culture that values innovation and people.
• Exposure to cutting-edge technologies and projects.

About Our Commitment

BCforward is an equal opportunity employer. We value diversity and are committed to creating an inclusive environment for all employees. All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, sexual orientation, gender identity, national origin, age, disability, or veteran status.

Interested? Apply Now!

If this sounds like the right opportunity for you, please apply with your most recent resume.