Senior Teradata DBA / Teradata Database Administrator

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.

About the role

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.

Requirements

• 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.

Benefits

• 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.

Pay

$53.40/hr (W2)

Schedule

Contract – 12 months