Role: Teradata DBA
Location: Strongsville OH,/Pittsburgh, PA
Description: Fulltime Role with TCS
Skill: Teradata DBA
- The candidate will be responsible for Teradata database administration with duties including performance tuning, collecting statistics, analyzing explains & determining which tables needed statistics.
- Ability to apply government mandated Database IA STIGS to remain compliant and show proof to auditors.
- Support multiple Teradata systems including development, test and production systems.
- Manage/Monitor system performance, including workload management and throttling in TASM, query performance and tuning, physical node behavior, and amp distribution.
- Work with Teradata in resolving RDBMS related incidents.
Other duties include: Collaborates with other teams as needed such as Unix, Windows, Web, Boundary, Citrix, DBA, Engineering, Support Application DBA functions including DDL creation, SQL scripting, problem research, system patching, and change deployments.
- Assist with design, development, implementation, and support of automated DBA processes using Teradata and Unix/Linux scripting.
- Creates, maintains, and implements Backup and Recovery and disaster recovery for a large enterprise data warehouse.
- Implements and administers access policies in compliance with DoD, industry and company standards.
- Manage, design, support, and consult on practices of storage management, archive, restore, and disaster recovery.
- Supports Development teams as needed.
- Mentoring other DBAs as needed.
- Other duties as assigned or required.
Job Types: Full-time, Contract
Pay: $96,497.63 - $116,212.20 per year
Benefits:
- Dental insurance
- Health insurance
- Paid time off
Experience:
- MySQL: 1 year (Preferred)
- Database administration: 8 years (Preferred)
- Teradata: 9 years (Preferred)
Ability to Commute:
- Strongsville, OH (Preferred)
Ability to Relocate:
- Strongsville, OH: Relocate before starting work (Required)
Work Location: In person