Teradata Database Administrator

Apex Systems; Charlotte, Northern (NC, KY); Hybrid; USD 83,000 - 124,000; Full time

Benefits offered by this job

Medical insurance

Dental insurance

Vision insurance

401K match

HSA

ESPP (stock purchase)

Training & certifications

Career coaching

Job summary

Apex Systems in Charlotte, NC is seeking a Teradata Database Administrator with 10+ years of enterprise experience to support our data warehouse environments. The role focuses on Teradata V17.20+ and application DBA functions in a fast-paced setting, with on-call rotation.

You will work with project teams to implement database changes, manage access policies, and support DR/production environments. This onsite contract opportunity spans about 10 months and requires strong scripting in Unix/Linux

Qualifications

• Experience: More than 10 years of experience as a Teradata DBA.
• Advanced working knowledge of Teradata RDBMS at both physical and logical levels.
• Advanced working knowledge of the Teradata suite of tools: Teradata Studio, TDWM, BTEQ, ARCMAIN, FASTLOAD, MLOAD, TPUMP, TPT, DBQL, PDCR.
• Working knowledge of Mainframe interfaces and execution: TDP, JCL, TSO, ISPF, FICON, NDM.
• Working knowledge of Viewpoint, Teradata Data Mover, and Teradata BAR technology.
• Working knowledge of Unix/Linux scripting (KSH, BASH, PERL).
• Working knowledge of job schedulers such as CA-7 and AutoSys, and replication technologies like Golden Gate.

Responsibilities

• Support Application DBA functions including DDL creation, SQL scripting, problem research, and change deployments.
• Assist with the design, development, implementation, and support of automated DBA processes using Teradata and Unix/Linux scripting.
• Support multiple Teradata systems, including development/UAT, disaster recovery, and production environments.
• Implement and administer access policies in conjunction with corporate standards.
• Support Mainframe administrative functions, including archive processing and job scheduling.
• Manage, design, and consult on storage management, archive, restore, and disaster recovery practices.
• Work closely with application project teams on the implementation of database changes.
• Work independently with minimal supervision, receiving general guidance from senior team members or managers.

Skills

Teradata DBA

Teradata RDBMS

Unix/Linux scripting

Viewpoint / Data Mover / BAR

Mainframe interfaces (TDP / JCL / TSO)

Tools

Teradata Studio

TDWM

BTEQ

ARCMAIN

FASTLOAD

MLOAD

TPUMP

TPT

DBQL

PDCR

CA-7

AutoSys

GoldenGate

JCL

Job description

Teradata Database Administrator

Location: Charlotte, NC/Jacksonville, FL (Onsite)

Employment Type: Contract

Contract Duration: 10 Months

Role Overview

We are seeking a Database Administrator with more than 10 years of experience for a key role supporting our enterprise data warehouse environments. The ideal candidate will have experience with Teradata V17.20 or higher and a strong background in application DBA functions. This position involves working with application project teams to implement database changes for large initiatives and providing on-call rotation support.

Key Responsibilities

• Support Application DBA functions including DDL creation, SQL scripting, problem research, and change deployments.
• Assist with the design, development, implementation, and support of automated DBA processes using Teradata and Unix/Linux scripting.
• Support multiple Teradata systems, including development/UAT, disaster recovery, and production environments.
• Implement and administer access policies in conjunction with corporate standards.
• Support Mainframe administrative functions, including archive processing and job scheduling.
• Manage, design, and consult on storage management, archive, restore, and disaster recovery practices.
• Work closely with application project teams on the implementation of database changes.
• Work independently with minimal supervision, receiving general guidance from senior team members or managers.

Required Qualifications

• Experience: More than 10 years of experience as a Teradata DBA.
• Advanced working knowledge of Teradata RDBMS at both physical and logical levels.
• Advanced working knowledge of the Teradata suite of tools: Teradata Studio, TDWM, BTEQ, ARCMAIN, FASTLOAD, MLOAD, TPUMP, TPT, DBQL, PDCR.
• Working knowledge of Mainframe interfaces and execution: TDP, JCL, TSO, ISPF, FICON, NDM.
• Working knowledge of Viewpoint, Teradata Data Mover, and Teradata BAR technology.
• Working knowledge of Unix/Linux scripting (KSH, BASH, PERL).
• Working knowledge of job schedulers such as CA-7 and AutoSys, and replication technologies like Golden Gate.

Preferred Qualifications

• Familiarity with Teradata Systems setup, GDO, DBSControl, and Multitool.
• Working knowledge of QueryGrid, DSA, Taraserver, NPARC, and TASM.
• Familiarity with REXX scripting.
• Familiarity with Hadoop and Cloud concepts and technologies.
• Familiarity with project and change management solutions and automation software, such as Agile, Remedy, and Ansible.

Everforth Apex Benefits Overview

• Medical, dental, vision, life, disability, and other insurance plans that offer an optional layer of financial protection.
• ESPP (employee stock purchase program).
• 401K program allowing contribution typically within 30 days of starting, with a company match after 12 months of tenure.
• HSA (Health Savings Account on the HDHP plan).
• SupportLinc Employee Assistance Program (EAP) with up to 8 free counseling sessions.
• Corporate discount savings program and other discounts.
• On-demand training program, access to certification prep and a library of technical and leadership courses/books/seminars after 6+ months of tenure, certification discounts, and other perks to associations that include CompTIA and IIBA.
• Dedicated customer service team for our Consultants and certified Career Coach.
• Full list of benefits, programs, support teams and resources within the ‘Welcome Packet’ provided by an Everforth Apex team member.

Equal Opportunity Employer

Everforth Apex Systems is an equal opportunity employer. We do not discriminate or allow discrimination on the basis of race, color, religion, creed, sex (including pregnancy, childbirth, breastfeeding, or related medical conditions), age, sexual orientation, gender identity, national origin, ancestry, citizenship, genetic information, registered domestic partner status, marital status, disability, status as a crime victim, protected veteran status, political affiliation, union membership, or any other characteristic protected by law. Everforth Apex will consider qualified applicants with criminal histories in a manner consistent with the requirements of applicable law.