Diverse Lynx
Teradata DBA
Diverse Lynx, Pittsburgh, Pennsylvania, us, 15289
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. Diverse Lynx LLC is an Equal Employment Opportunity employer. All qualified applicants will receive due consideration for employment without any discrimination. All applicants will be evaluated solely on the basis of their ability, competence and their proven capability to perform the functions outlined in the corresponding role. We promote and support a diverse workforce across all levels in the company.
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. Diverse Lynx LLC is an Equal Employment Opportunity employer. All qualified applicants will receive due consideration for employment without any discrimination. All applicants will be evaluated solely on the basis of their ability, competence and their proven capability to perform the functions outlined in the corresponding role. We promote and support a diverse workforce across all levels in the company.