Teradata Admin

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

We are looking for a Teradata Administrator with hands-on experience in administering and supporting Teradata environments. The ideal candidate should have strong practical experience in workload management, security management, and user/role administration, along with database performance monitoring and production support.

Responsibilities

• Administer and support Teradata database environments across development, testing, and production.
• Perform hands-on workload management using Teradata Workload Management (TASM/TASM-related capabilities), including workload classification, prioritization, throttling, and resource allocation.
• Monitor and optimize workload performance, identify resource-intensive queries, and troubleshoot performance bottlenecks.
• Manage Teradata security, including roles, profiles, privileges, access controls, and security policies.
• Perform user management, including user creation, modification, deactivation, password/profile management, and access provisioning.
• Implement and maintain role-based access control (RBAC) and least-privilege access.
• Monitor database health, capacity, space utilization, sessions, locks, and system performance.
• Troubleshoot database, workload, session, locking, and performance-related issues.
• Manage database objects, permissions, and administrative configurations.
• Support backup, restore, recovery, and disaster recovery activities.
• Perform database capacity planning and proactively identify infrastructure and storage requirements.
• Monitor and manage system resources including CPU, memory, AMP utilization, spool, and disk space.
• Support database upgrades, patches, migrations, and environment changes.
• Develop and maintain operational procedures, documentation, and runbooks.
• Work closely with Data Engineers, Developers, Security, Infrastructure, and Application teams to resolve production issues.
• Participate in incident, problem, and change management processes.
• Ensure Teradata environments comply with organizational security and operational standards.

Requirements

• 4-7 years of hands-on experience in Teradata Administration.
• Strong practical experience with Teradata Workload Management / TASM.
• Hands-on experience in Teradata Security Management.
• Strong experience in Teradata User and Role Management.
• Good understanding of Teradata architecture, AMPs, BYNET, PE, and system components.
• Strong knowledge of Teradata SQL and database administration.
• Experience with performance monitoring and troubleshooting.
• Experience managing sessions, locks, workloads, spool, CPU, and disk utilization.
• Experience with database backup, restore, recovery, and DR processes.
• Experience with Teradata utilities and administration tools.Good understanding of database security concepts, access controls, roles, profiles, and privileges.
• Experience working in large-scale enterprise/production Teradata environments.
• Strong analytical and troubleshooting skills.
• Good communication and stakeholder-management skills.