Teradata DBA (Closed)
SkillStorm is seeking a Teradata DBA for our client in Charlotte, NC OR Richardson, TX OR Richmond, VA. Candidates must be able to work on SkillStorm's W2; not a C2C position. EOE, including disability/vets.
Job Description:
- The individual needs to be part of the DBA team that supports Teradata databases for multiple AITs on the Teradata data warehouse. This is to provide the continued support while a resource is out on medical leave.
- Senior DBA with more than 10 years’ experience including some experience with Teradata V16.20 or higher.
- Support Application DBA functions including DDL creation, SQL scripting, problem research, change deployments, oncall support, etc.
- Assist with 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 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, 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.
- Work independently with minimal supervision, with general guidance from more seasoned DBA team members or managers
Required Skills:
- 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.
- Familiar with Unix/Linux and KSH, BASH, and PERL scripting.
Desired Skills:
- 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
- Familiar with project and change management solutions and automation software, such as Agile, Remedy, Ansible.
- Replication technologies, Golden Gate.
- Familiar with REXX scripting.
- Familiar with Hadoop and Cloud concepts and technologies
- Familiar with project and change management solutions and automation software, such as Agile, Remedy, Ansible.
#LI-DNI
Similar Jobs
Entry Level Software Developer
Contract job in Charlotte