Job Description
Role - Teradata DBA (V17.20 or higher)
Charlotte, NC/Kennesaw, GA/ Jacksonville, FL (Only Local profiles)
Hybrid(3 days a week Onsite)
Job Description:
Position Summary
- Teradata DBA with more than 10 years experience including some experience with Teradata V17.20 or higher.
- Support Application DBA functions including DDL creation, SQL scripting, problem research, change deployments, on call rotation support, etc.
- Assist with design, development, implementation, documentation, and support of automated DBA processes using Teradata and Unix/Linux scripting.
- Support multiple Teradata systems including development/UAT, disaster recovery, and the enterprise warehouse production environments.
- Implement and administer access policies in conjunction with corporate standards.
- Support some Mainframe administrative functions including archive processing and job scheduling.
- Manage, design, support, document, and consult on practices of storage management, archive, restore, and disaster recovery.
- Work closely with Application projects teams on implementation of database changes to support large project initiatives and BAU work.
- Complete any assigned training courses and attend any required team meetings/calls to learn about and stay up to date on internal DBA team processes and tools. Provide high level weekly written status report to manager.
- Work independently with minimal supervision, with general guidance from more seasoned DBA team members or managers
Required Qualifications
- Advanced working knowledge of Teradata RDBMS at both physical and logical levels.
- Advanced working knowledge of Teradata suite of tools: Teradata Studio, TDWM, BTEQ, ARCMAIN, FASTOAD, 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, Teradata BAR technology.
- Working knowledge of Unix/Linux scripting (KSH, BASH, PERL).
Qualifications
- Familiar with Teradata Systems setup, GDO, DBSControl, Multitool, etc.
- Working knowledge of QueryGrid, DSA, Taraserver, NPARC, TASM
- Working knowledge of job schedulers: CA-7, AutoSys, etc. Replication technologies, Golden Gate.
- Familiar with REXX scripting.
- Familiar with Hadoop and Cloud concepts and technologies