SUMMARY:

A senior IT professional with 9 years of experience in Teradata Performance and Operations DBA activities. Currently designated as Technical Consultant at Confidential. Expertise in Performance Tuning, Query optimization, Work load mgmt. Hands on experience on Teradata’s load and unload utilities and other Database Management utilities, TASM, Viewpoint. Trained on Big - data Aster Data basic administration, Unix Shell scripting, ITIL certified. I have a very good understanding of Teradata’s parallel architecture, SQL and physical implementation.

• Currently working as a Lead Teradata performance DBA for one of the largest data warehouse customer Confidential .
• Worked as a Teradata DBA in Confidential in-house project.
• Tuning poorly performing Batch and User queries which impact the system badly. Analyzing Explain Plan, DBQL and PDCR information for providing the tuning recommendations. Providing the technical guidance to Ad-hoc users and Development team for writing better performing queries (High Parallel Efficiency & Low skew).
• Participated in Teradata Database upgrades and Teradata Node level expansion activities, doing benchmarking before-after these upgrades to check the improvement/degradation of system performance. Measuring spool/perm space requirement after upgrade. Taking DDL back up of all JOIN Index/Secondary Index and creating back once upgrade is done.
• Running Packdisk, Scandisk, Checktable, Recovery manager, Showlocks, Updatespace and various System and Maintenance utilities.
• Setting-up Unix Alert policy to send notifications to the respective users/team/business owners, DBA team and client in case of any unforeseen scenarios or issues.
• Experienced in Archive, Restore utility, Net-backup and Tara GUI interface.
• Data movement activity using archive-restore script across different Teradata system.
• Monitoring Viewpoint, maintaining workload mgmt. using TASM and identifying performance and resource bottlenecks.
• Analyzing daily performance report for the overall system status such as CPU usage, Space usage, Gating, AWT usage, Parallel Efficiency, finding out top 10 skewed users and batches, High-CPU Users/Batches & Applications.
• Handling P1 issues like production ETL job failure with Spool out error, TASM abort, query running slow, delay and blocking issues.
• Implementing Block Level Compression (BLC/TBLC), Multi Value Compression (MVC) to reduce IO.
• PI & PPI revision, Secondary Index and Join Index creation to reduce CPU and response time of poorly performing queries.
• Performing SOX audit activity every quarter to find out non-compliance accounts present in the system and guide them about the rules & requirements for compliance.
• Efficiently handling client related meetings and effectively coordinating the tasks with other teams.
• User mgmt., Database mgmt., Space mgmt. (Creating Databases/Users, Roles/Profiles, Granting Access and password reset, allocating space).
• Experienced in latest Teradata versions 14.10, 14.00 & 13.10.

PROFESSIONAL EXPERIENCE:

Confidential

Environment: Teradata 14.10

Technical Consultant

Responsibilities:

• Analyzing and optimizing the system resource usage (CPU, Impact CPU, IO, Impact IO and Physical IO, AWT). Tuning expensive, skewed queries for Ad-hoc business users, ETL, Semantic Users. Finding Skewed objects and tune them accordingly.
• Working closely with the Teradata development team for code design, review and sing-off for production deployment. And also help the Semantic/ETL jobs meet the SLA during peak usage hours.
• Participating in Teradata Database upgrades and Teradata Node level expansion activities, doing benchmarking before and after these upgrades to check the improvement/degradation of system performance. Measuring spool/perm space requirement after upgrade. Taking DDL back up of all JOIN Index/Secondary Index and creating back once upgrade is done.
• Implementing the Teradata best practices across the system.
• Implementing MVC/BLC/Join Index/Secondary Index/PPI to reduce IO usage.
• Maintaining/Synching the STATISTICS up to date to avoid unwanted system performance issue during system upgrade/expansion.
• Handling severity1/P1 issues in case of Batch job failure due to TASM/Spool abort, TPT Load/Export failure, high delay, long running query, space outage, access issue etc.
• Handling workload management/TASM to give a fare share of system resources to every business vertical/ad-hoc users.

Environment: Teradata 13.10 & 14.10

Technical Consultant

• Worked with Teradata GSC /DBS engineer to resolve the Teradata Database error, Utility error, providing them the system level information, TSET pack file, Utility log etc., testing the suggestions given by GSC on UAT and implement the same on production system.
• Carried out Unix Alert setup that sends the notifications to the DBA group and to the respective business group in case of any unforeseen scenarios or issues.
• Actively involved in different Teradata Database upgrade activities, running benchmarking before and after these upgrades to check the improvement/degradation in system performance as whole after these activities are completed, also monitor performance and test and correct errors after such upgrades.
• Analyzed daily performance report to analyze the overall system status such as CPU usage, Space usage, Gating, AWT usage, PE, finding out top 10 skewed users and batches, High-CPU Users/Batches & Applications.
• Worked on tuning poorly performing queries of worse Batches and Users, which affects the system badly. Analyzing Explain Plan, DBQL and PDCR information for providing them the tuning solutions, recommendations & technical guidance to increase the query performance.
• Applying hard-cap and Penalty profile enhancement to the business verticals to limit the CPU usage.
• Performed cost profile testing on production queries and seen significant amount of CPU savings per day.
• Worked on Monitoring Teradata performance and active workloads using Viewpoint Workload monitor, Workload Health Portlets. Changing the system workload using viewpoint TASM & changing the User/Batch workload using Profile, based on current status and load on the system.
• Worked on maintaining the production STATS job (Daily/Weekly/Monthly) to keep the STATS updated. Collecting/Dropping Statistics based on the requirement.
• Developed a tool called Table-Performance-Delta to do the pre and post-performance analysis of any physical change happened in the database.
• Developed a Macro for DB owners for monitoring space usage to find out skewed tables.
• Performed SOX audit activity every quarter to find out non-compliance accounts present in the system and guide them about the rules & requirements for compliance.
• SQL Code review and planning the Deployment & Rebuild. Has done PPI revision and MVC implementation successfully as year ending activity every year.
• User mgmt. such as creating users, password reset and granting access/privileges based on requirement without impacting the Security policies.
• Roles & Profile mgmt. creating roles and profiles according to the user groups.
• Space Mgmt., monitoring space usage, adding space, Housekeeping activities (Purging of DB objects according to the company policies).
• Coordinating with Backup Administration Team for taking backup based on the requirement.

Environment: Teradata 13.10

Associate Technical Consultant

• Database management such as creating Database, Objects, Roles and Profiles according to the business requirement.
• User management, such as user creation, assigning and switching profile, granting access, password reset.
• Space management, allocating space to databases, Implemented Block Level Compression (BLC). MVC analysis for large tables for saving space and IO usage.
• Running Packdisk, Scandisk, Checktable, Recovery manager, Showlocks, Updatespace and various System and Maintenance utilities.
• Managing Archive-Restore operations using Net backup, TARA GUI.
• Deploying DDLs into PROD/DEV/QA.
• Analyzing Explain statement and giving suggestions to increase the query performance.
• Monitoring CPU utilization, blocking, aborting queries when deadlock occurs through View Point.

Environment: Teradata 13.10

Technical Consultant

• Worked on tuning poorly performing queries of worse Batches and Users, which affects the system badly. Analyzing explain Plan, DBQL and PDCR information for providing them the tuning solutions, recommendations & technical guidance to increase the query performance (High Parallel Efficiency & Low skew).
• Worked on analyzing daily performance report to analyze the overall system status such as CPU usage, Space usage, Gating, AWT usage, PE, finding out top 10 skewed users and batches, High-CPU Users/Batches & Applications.
• SQL code review before deployment.
• MVC analysis & PPI recommendation for objects involved in high I/O queries.
• Suggesting better Primary index, Secondary index, Join index for tactical queries that has very less SLA time.
• Query re-writing such as creating derived table, volatile table and work table for better query performance.
• Materialization for complex views with complex joins, case statement, UNION operations and check the dependencies of related queries.

Environment: Teradata V2R5

Teradata DBA

• Creating Users, Databases and granting access/privileges based on requirement.
• Creating Roles and Profiles according to the user groups.
• Analyzing Explain statement and giving suggestions to increase the query performance.
• Monitoring CPU utilization, blocking, aborting queries when deadlock occurs through PMON.
• SQL Code reviewing.
• Worked on Archive-restore activities using Netback-up and Tara-GUI.
• Providing CPU Utilization, Database Space and Database Performance information.

Environment: Teradata V2R5

Teradata DBA

• Database management such as creating Database, Objects, Roles and Profiles according to the business requirement.
• User management, such as user creation, assigning profile, granting access, password reset.
• Looking into Explain statement and giving suggestions to increase the query performance.
• Monitoring CPU utilization, blocking, aborting queries when deadlock occurs through PMON.
• Providing CPU Utilization, Database Space and Database Performance information.
• Coordinating with Backup Administration Team for taking regular Full backup based on the requirement.