Teradata Production DBA: Performance & Security

Systems Limited; Islamabad; On-site; PKR 2,400,000 - 4,200,000; Full time

Job summary

Systems Limited seeks a Teradata Administrator with hands-on experience to administer Teradata environments across development, testing and production. You will implement workload management, security controls, and RBAC while ensuring high availability and performance.

You will monitor capacity, optimize queries, manage backups and DR, and work with data engineers, developers, security and infrastructure teams to resolve production issues in a large enterprise setting.

Qualifications

• 4-7 years hands-on Teradata Administration experience.
• Strong experience with Teradata Workload Management / TASM.
• Experience in Teradata Security Management.
• Experience in Teradata User and Role Management.
• Good understanding of Teradata architecture, AMPs, BYNET, PE.
• Strong SQL and database administration knowledge.
• Experience with performance monitoring and troubleshooting.
• Experience with backups, restore, recovery and DR.
• Experience in large-scale enterprise Teradata environments.

Responsibilities

• Administer and support Teradata database environments across development, testing, and production.
• Perform workload management using TASM: classification, prioritization, throttling, resource allocation.
• Monitor and optimize workload performance and troubleshoot bottlenecks.
• Manage Teradata security, roles, profiles, privileges, and access controls.
• Perform user management: creation, modification, deactivation, password/profile management.
• Implement RBAC and least-privilege access.
• Monitor health, capacity, space, sessions, locks, and system performance.
• Troubleshoot database, workload, session, locking, and performance issues.
• Manage database objects, permissions and configurations.
• Support backup, restore, recovery and DR activities.
• Capacity planning and infrastructure/storage requirements.
• Monitor system resources (CPU, memory, AMP utilization, spool, disk).
• Support upgrades, patches, migrations, environment changes.
• Develop/runbooks and operational procedures.
• Collaborate with Data Engineers, Developers, Security, Infrastructure, and Applications teams to resolve issues.
• Participate in incident/problem/change management; ensure security/compliance.

Skills

Teradata Workload Management (TASM)

Teradata Security Management

Teradata User & Role Management

Teradata SQL

Performance Monitoring

Troubleshooting

DR/Backup & Restore

RBAC / Least Privilege

Teradata Architecture (AMPs/BYNET/PE)

Teradata Utilities & Admin Tools

Tools

Teradata Utilities

Job description

Systems Limited seeks a Teradata Administrator with hands-on experience to administer Teradata environments across development, testing and production. You will implement workload management, security controls, and RBAC while ensuring high availability and performance.

You will monitor capacity, optimize queries, manage backups and DR, and work with data engineers, developers, security and infrastructure teams to resolve production issues in a large enterprise setting.