SUMMARY

• IT Professional wif 7+ years of industry experience as Teradata DBA. Worked mainly in Teradata Performance Optimization/Physical Implementation specialist as well as Ter­adata DBA.
• Worked on Data warehousing projects for Insurance and Manufacturing Do­mains.
• Extensively worked in Performance Optimization, development and DBA roles.
• Experience wif Physical design best practices, PI and SI choices, Statistics au­tomation, Access Rights cleanup, Tuning of queries/business reports, compres­sion
• Developed replication using GlodenGate for semantic tables
• Access Rights, Space Management and Password Reset.
• Hands on Loading Utilities like Multiload, Fastload through Teradata Studio.
• Hands on Shell Scripting through Bteq.
• Experience in Opening and Closing Incidents for changes in production through HPSM and Service Now.
• Optimized bad queries after which there performance Improved by 30 - 40%.
• Used Viewpoint extensively for monitoring purposes.
• Analysed and resolved ETL Issues while loading.

TECHNICAL SKILLS

Operating Systems: Windows Server 2007,2008 r2 and SUSE Linux

Databases: Teradata v12,v13.10, v14.10,Oracle 11g, Hadoop

DBA Tools: SQL Assistant, TARA GUI, Teradata Statistics Wizard, ABU Netbackup, Teradata Administrator, PMON, Viewpoint,Ferret Utilty, Teradata Manager, DBS Con­trol, Priority Scheduler, Teradata Database Query Log and Teradata Studio, PDCR and Tableau.

Teradata Client Tools: MLoad,Fastload, Loading Utilities

Banking Tool: Hogan Parameter Manager

PROFESSIONAL EXPERIENCE

Confidential, Newark, NJ

Environment: Teradata 14.10, GlodenGate Repl Services, TDM 14.0

Responsible for:

• Optimize Long running queries which were performing badly and hampering the per­formance of the system.
• Resolved ETL loading issues on Mload and Fastload pointed out by Informatica Team.
• Worked on Tableau for creating performance reports
• Worked on TDM (Teradata Data Mover) for data movement
• Viewpoint Monitoring and analysis
• Creating new users through the request in Horizon Identity Manager.
• Used GlodenGate Replication Services to setup replication for semantic tables
• Conducted GlodenGate PoC wif 10 tables - Providing performance benchmark sta­tistics.
• Took active part in every month release for Production Code Deployment.
• Configuration of Extract and Replicat .prm files, source and target systems, end-to- end implementation of GG replication for selected tables
• Worked on creating new users, reset passwords and providing roles to the Users.
• Taking backup of Tables and Databases through Data Stream Architecture (DSA).

Confidential, Richmond, VA

Teradata DBA

Responsibilities:

• Worked on Incidents and CO’s on various Issues.
• Provided Space to the particular Database and User through Teradata Adminis­trator.
• Creating Users and giving the Access Rights
• Optimized Bad queries by collecting Multi and Single Columns Stats for the bet­ter Performance of the System.
• Done Optimization on Long Running reports by recommending proper PI and Stats Collection.
• Taken Manual Backups and monitoring them through TARA GUI.
• Taking Backup of Table Manually through Incidents raised by users.
• Worked on TASM related changes.
• Approving Change Orders on regular basis.
• Worked on Loading Utilities like Fastload and Multiload.
• Worked on Shell Scripting through Bteq to implement Change Orders and Inci­dent.
• Hands on Teradata Load Utilities like Fastload and Multiload.
• Used SQL Assistant extensively for pulling data from DBQL and for Performance Tuning as well.
• Used Viewpoint in tracking Bad queries and removing Blockings in the System.
• Hands on TASM for changing the Rulesets through Viewpoint for the better per­formance of the system.
• Creating and Refreshing Views on client requests after new table creation.
• Solved Ad-hoc requests from different users related to their job failures in MLoad.
• Worked on Hogan Parameter Manager for Analyzing PCD data of Confidential Bank and providing a solution to the client.
• Done Analysis and data mining from Hogan Systems Data.
• Worked on maintenance of Hogan PCD on a monthly basis.

Confidential

Teradata DBA

Responsibilities:

• Provided primary Confidential and Confidential Confidential recommendation for sub-optimal Ta­bles.
• Designed process for automated stats collection
• Worked on MVC Analysis to reduce IO consumption for the better perfor­mance of Tables.
• Recommendations for Stats collection for business critical tables
• Viewpoint Monitoring.
• Has taken Backup through ABU Netbackup and TARA Gui Utility.
• Performance tuning of Business Reports.
• Monitored system through Teradata Manager and PMON.
• Providing weekly reports to the client regarding the performance of Teradata System.
• Worked on Access Rights Table to reduce size of the Table.
• Creating and Refreshing Views.
• Tracking Bad Queries and tuning them.
• Changing concurrency of the throttle if there is some delay in that Particular throttle.
• Raising and Monitoring incidents in Teradata At You're Service (TAYS).
• Worked on Ferret Utility and used SHOWSPACE AND SHOWBLOCKS command to find block size and cylinder space.

Confidential

Teradata DBA

Responsibilities:

• Creating and managing Teradata database and environments.
• Managing users, roles and profiles in Teradata database.
• Current Space usage analysis and recommendation regarding the utilization of space.
• Good Knowledge of Teradata SQL Assistant, Teradata Administrator, Teradata Statistics Wizard.
• Monitoring the sessions and their resource usage.
• Checking stale statistics on the table and collected stats where required.
• Generating DDLs through SYBASE for the DDL QA Check process and later on for Migration.
• Used TARA Server for Backup and Recovery of Data