Find Jobs
Find Jobs Near You – Available Work in Your Location
Senior Teradata DBA
Career Insights for Systems Administrator
See where this job fits in the broader career landscape. Knowing your career path helps you see what's possible from here.
Scorecard
Based on Texas data
Review key factors to help you decide if this role fits your goals. How is this calculated?
What they do
A Systems Administrator manages the day-to-day operations of an organization's computer networks, including the systems that connect computers and other technology to each other and to outside networks. Installs, organizes, and supports the hardware and software of these systems.
$98,862 / year median in Texas
-7% projected decline
Job Description
Senior Teradata DBA Plano, Texas Ideal Candidate:
Senior Teradata DBA with: 10+ years Teradata DBA experience Strong Teradata RDBMS physical and logical administration Hands-on Teradata V17.20+ Expertise in BTEQ, TPT, MLOAD, TPUMP, FASTLOAD and ARCMAIN Strong TDWM/TASM, DBQL, Viewpoint and performance tuning Unix/Linux scripting with KSH, BASH and PERL Mainframe experience with
JCL, TSO, ISPF, TDP
Backup, archive, restore and disaster recovery using BAR/Data Mover Enterprise production support, change deployments and on-call support Best fit: Teradata DBA
+ V17.20+
+ Teradata Utilities
+ Unix/Linux
+ Mainframe
+ Performance/Production Support.
Overview of Job Responsibilities:
The individual in this role will be part of the DBA team that supports all Teradata databases for multiple AITs across all lines of business on the Teradata Data Warehouse (The "W"). Responsible for working with Teradata technology stakeholders and technical partners to design/implement changes and provide ongoing support for Teradata application database environments. Provide consulting services, support change implementations, and fulfill work requests from application and operational support teams. Provide on call support for Teradata production environments. Create and maintain internal team documentation related to our processes, tools, and problem resolution techniques. Required Actions/Expectations for Success in the Position DBAs holding this position will be expected to successfully perform the following: 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 bi-weekly status report to manager. Work independently with minimal supervision, with general guidance from more seasoned DBA team members or managers. Skill Requirements for
Job Candidates:
Job candidates should be Teradata DBAs with 10+ years' experience including some experience with Teradata V17.20 or higher. The following technical skills are required for job candidates: 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). The following technical skills would be helpful, but not required: 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. Shivangi Ojha Technical Recruiter
Benefits
- Dental Insurance