Teradata DBA
6 months ago
Pittsburgh, United States
Diverse Lynx
Full time
Teradata DBA Skill: Teradata DBA
Strongsville, OH or Pittsburgh, PA
- 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.
-
Enterprise Data Warehouse Administrator
4 weeks ago
Pittsburgh, Pennsylvania, United States Diverse Lynx Full timeAt Diverse Lynx LLC, we are seeking an experienced Enterprise Data Warehouse Administrator to join our team. The ideal candidate will have a strong background in database administration and performance tuning, with a focus on Teradata databases.The estimated salary for this position is $120,000 - $180,000 per year, depending on experience.Job DescriptionThe...