Teradata System Engineer

Experience Summary

Rahamatunnisa has been working in the information Technology Industry to 3+ years, Primary working as a Teradata administrator who managed the database platforms and supported the business intelligence deployments across all phases of SDLC. He has proven expertise in Teradata architecture, performance optimization and Teradata utilities.

Professional Summary:

3 + years of experience in IT Professional as extensive Experience with Teradata tools and utilities

Experience in Teradata DBA functions (creating database, user, tables, granting permissions, monitoring the system for performance,) on a large Teradata database.

Development of pro-active processes for monitoring capacity and performance. Perform system level and application level tuning. Perform backup and recovery operations using NETBACKUP/TARA.

Develop and tune database environments to ensure performance and service production processes, end user queries and Database security administration

Responsible for physical database design, implementation, and support on specific database technologies; designs and implements back-up, recovery, archiving and conversion strategies.

I am highly motivated, individual, good team player and having interpersonal skills.

Professional Organization:

Working as Assistant System Engineer with TATA CONSULTANCY SERVICES(TCS), Noida Dec 2018 to till date.

Academic Qualifications:

Bachelor of computer science (B.Sc.) from Acharya Nagarjuna University (ANU).

Software Skills:

Databases : Teradata ( 15 & 16), Oracle.

Utilities : BTEQ, Fast Load, Multiload, Tpump, Fast Export and TPT.

Tools : Teradata (SQL Assistant).

Operating System : Windows Family and UNIX.

Languages : SQL.

1. Project Name : AIM

Client : Standard Bank of South Africa, Johannesburg.

Duration : Dec -2018 to Till Date

Database : Teradata 15 and 16

Applications : SQLA, BTEQ, FLOAD, MLOAD, NETBACKUP and VIEWPOINT

Client O/S : Windows 10

Project Description :

The Standard Bank of South Africa Limited is a major South African bank and financial services group. It is Africa's biggest lender by assets. The company's corporate headquarters, Standard Bank Centre, is situated in Simmonds Street, Johannesburg.

As Teradata DBA, was responsible for overall Development, Test and Production Systems of Teradata, including runtime optimization, capacity management and planning, security, configuration, scheduling and execution of maintenance. Responsibilities include, Weekly planning and Backup of the Production Database, Space Utilization Optimization and Calculations, Index and Statistics Analysis.

Responsibilities:

As Teradata DBA, the responsibilities were to deliver new and complex, high quality solutions to clients in response to varying business requirements. Some of them being

Teradata database administration of 1 production & 1 (QA/DR) development databases.

Implementation of the New Database, including Create database objects for tables, users, roles and Profiles.

Profile, Role management of database users.

Service Now ticket system tool for user request such as user creation, promotion objects from TEST database to INT database, from INT database to QA database & QA database to PROD database, backup & restore activity.

Daily activities like user management, access rights, Space management, releasing lock for MLOAD &FASTLOAD, dropping utility tables.

Monitor user session using viewpoint for CPU& I/O skew and abort the same.

Performance tuning for user queries and schedule load jobs.

Co-ordination with onshore/offshore team and involved in weekly meetings with discussed Issues and for guidelines for proactive support.

Current Space usage analysis and recommendation regarding the utilization of space

Good knowledge on utilities like Viewpoint, BTEQ and SQLA.

Handling issues from different teams like ETL, Reporting and end-user related.

Worked on knowledge acquisition for new project take over.

Teradata Capacity planning and performance tuning.

Data refreshment from production to Development/Test servers.

Handling tickets for user management.

Database space management based on alerts and proactive monitoring.

Database backup management using NETBACKUP/TARA.

HUT locks management.

Monitoring the PDCR jobs.

Periodical space reclaims using PACKDISK.

Raising incidents in TAYS for the assistance of TERADATA GTS.

Working in all three shifts for 24*7 supports including weekend support

Contact this candidate