SUMMARY

• Result oriented, smart working skilled professional with over 14+ Years of software industry experience on Teradata data warehousing platforms, seeking to expand competence, strengthen the skills acquired and exhibit talent and creative skills to excel in a highly competitive environment.
• Specialize in data migration from one Teradata server to another and have experience in Development, Support, Maintenance, Migration projects.

TECHNICAL SKILLS

Operating System: Windows, Unix and Linux

Languages: PL/SQL, IBM Mainframes

Databases: Teradata, Aster

Tools: /Utilities: Teradata Utilities (FLoad, Mload, BTEQ, FExport, TPump)Informatica 8.6/9.5, BMS Remedy (CM, TM), Crontab, HP Quality Center, ServiceNow.

Special Packages/Tools: Teradata SQL Assistant, Teradata Viewpoint, TD Administrator, DSA, Veritas Netbackup, TD Studio, TARA GUI, VNC Viewer

PROFESSIONAL EXPERIENCE

TERADATA Database Administrator

Confidential

Responsibilities:

• Proficient in Teradata Database Administration
• Responsible for maintaining all DBA operations (development, test, production) in operation 24×7.
• Good exposure on Teradata tools and utilities like Teradata SQL Assistant, Teradata Administrator, Teradata Viewpoint, Teradata Studio, TARA Backup server, DSA, Veritas Net backup.
• Expertise in migrating the data from one database to another.
• Supporting different application development teams, production support, query performance tuning, system monitoring, database needs and guidance.
• Controlled and tracked access to Teradata Database by granting and revoking privileges.
• Created automation scripts to perform the objects creation, drop objects in specific databases.
• Granted & Revoked Object privileges to the Databases Users / Roles.
• Worked with ETL users to provide access and creating the objects on Production environment.
• Support Teradata patches/firmware upgrades/Major upgrades and any hardware/media tape failures.
• Planned the releases, monitored performance and reported to Teradata for further technical issues.
• Analyze performance trends and project future capacity needs and Identify bottlenecks to improve query performance.
• Perform Aster data copy from Aster to Teradata environment.
• Supporting code deployment activities.
• Proficient in Teradata Query optimization, Performance Tuning.
• Creation of automation scripts to reduce the DBA routine activities.

Confidential

Senior Teradata DBA

Responsibilities:

• Responsible for supporting all DBA operations in operation 24×7.
• Strong experience Teradata tools like SQL Assistant, Teradata Administrator, Viewpoint and DSA and Net Backup Archive and Recovery.
• Supporting different application development teams, production support, query performance tuning, system monitoring, database needs and guidance.
• Controlled and tracked access to Teradata Database by granting and revoking privileges.
• Created automation scripts on overall TD system health check report, Password reset automation, password expiring user’s notification and other.
• Granted & Revoked Object privileges to the Databases Users / Roles.
• Worked with ETL users to provide access and creating the objects on Production environment.
• Planned the releases, monitored performance and reported to Teradata for further technical issues.
• Supporting jobs running in production for failure resolution with tracking failure reasons and providing best resolution in timely manner.
• Analyze performance trends and project future capacity needs and Identify bottlenecks to improve query performance.
• Performed the Aster data copy from Aster to Teradata environment.
• Supporting code deployment activities, Teradata patches/firmware upgrades/Major upgrades and any hardware/media tape failures.
• Automate the Teradata routine DBA activities.

Confidential

Senior Teradata DBA

Responsibilities:

• Responsible for supporting all DBA operations in operation 24×7.
• Strong experience Teradata tools like SQL Assistant, Teradata Administrator, Viewpoint and TARA Backup server, Net Backup Archive and Recovery.
• Supporting different application development teams, production support, query performance tuning, system monitoring, database needs and guidance.
• Created Teradata standards and best practices document for the EDW and TD DBA teams to follow.
• Controlled and tracked access to Teradata Database by granting and revoking privileges.
• Created automation scripts on overall TD system health check report, Password reset automation, password expiring user’s notification and other.
• Granted & Revoked Object privileges to the Databases Users / Roles.
• Worked with ETL users to provide access and creating the objects on Production environment.
• Planned the releases, monitored performance and reported to Teradata for further technical issues.
• Supporting jobs running in production for failure resolution with tracking failure reasons and providing best resolution in timely manner.
• Analyze performance trends and project future capacity needs and Identify bottlenecks to improve query performance.
• Creation of new environments in non - production regions.
• Performed the Aster data copy from Aster to Teradata environment.
• Supporting code deployment activities, Teradata patches/firmware upgrades/Major upgrades and any hardware/media tape failures.
• Create automation scripts