PROFESSIONAL SUMMARY:

• I have around 15.5 years of work experience in the IT industry.
• Designing, development,DBAactivities involvingTeradataanddesigning, developing and supporting end - to-end features in Teradata Database Administration namely -
• Database Securities (Via roles, LDAP, Default)
• Expert in Query Tuning related to Spool space error, simplifying long running queries and many others.
• My strength is Performance Tuning of system and queries.
• Teradata AWT and VPROC analysis.
• Teradata integration with Protegrity for data protection.
• Database Failover/Failback (Entire planning and execution)
• Installations of Database patches and TTUs, Troubleshooting.
• Database Object backup and recovery using Teradata DSA.
• Performance Tuning of database using Viewpoint portlets.
• Automated Release management with Teradata using DevOps.
• Troubleshooting database issues and resolving alongside TAYS.
• Database Object, space management.
• Object Compression using MVC and other compression methods.
• Data mart setup within Database.
• Experience in Teradata Datalabs.
• Expertise in Teradata Datamover.
• DevOps (uDeploy) integration with Teradata.
• One of my area of strength is Performance Tuning of Teradata queries, improving overall batch processing, tuning around job scheduling. Performance Tuning involved PDCR data analysis, Viewpoint data analysis, batch job scheduling analysis and sometime rewriting queries along with statistics modification.
• Have good experience inTeradata DBA activitieslike database maintenance activities, Performance Tuning, Teradata user and database creations. Analyzing and tuning complex queries. Full scale database objects management.
• Creating and managing user accounts. Prepared scripts for monitoring the system.
• Installed Teradata drivers for the Teradata utilities. Refreshed the data by using fast export and fastload utilities.
• Used Teradata Administrator and Teradata Manager Tools for monitoring and control the system.
• Good understanding and hands on knowledge of Teradata Data Mover, Teradata Wallet,
• Good knowledge on installing, supporting and problem solving of various Teradata utilities on WINDOWS and Linux platforms.
• Extensively worked in Teradata DBA activities like: Teradata migration from other databases, I have worked along very closely with Enterprise ETL team, Data Scientist group, Data Analysts and solving various performance, connectivity and installation related issue.
• Hands on expertise on DBS installation / upgrading / maintenance, Creating Teradata Users, Teradata Database capacity planning.
• Lead the teams in the usage of mostly all the Teradata Utilities like Fastload,Multiload, Tpump, BTEQ, FastExport. Teradata monitoring using Teradata Viewpoint.
• Worked extensively in C, C++, Shell Scripting, Unix Internals, Teradata and well versed with other RDBMS like Oracle. Strong in developing tools and system applications using Unix Internals. Worked on Windows NT, 95, CE, SUSE Linux.
• Worked extensively in Teradata Manager, PDCR, BTEQ, TDADMIN, VIEWPOINT, DATA MOVER, TERADATA STATS MANAGER, Teradata RDBMS, SQL, Teradata Data Modeling, Teradata Client on SUSE Linux.
• Future Plan - Currently I am working on various machine learning projects. In a very near future I would like to start integrating Teradata with Machine Learning features.

WORK EXPERIENCE:

TERADATA DBA

Confidential, Cleveland, Ohio

Responsibilities:

• Working as TERADATA DATABASE ADMINISTRATOR
• Teradata Performance Improvement for queries and database
• Database securities
• Teradata VIEWPOINT
• Teradata Workload Management
• Automated release management in Teradata
• ATANA Suite
• Database backup and recovery.
• Teradata Unity Data Mover.
• In depth knowledge of Teradata PDCR/DBC metadata to analyze query performance
• Teradata shell scripting.

Tools: Teradata Viewpoint, Teradata Studio, Teradata Administrator, ATANA SUITE, Automated Release management tool, Unity Data Mover, Teradata Statistics manager.

Data Analyst

Confidential

Tools: Inhouse tool

Responsibilities:

• Participated in building an inhouse tool to validate data lineage across the enterprise.
• Data analysis and report preparation of Banking data.
• BASEL analyst.
• Oracle Toad
• Complex query
• Informatica Development and Support

Confidential, Cleveland, Ohio

Lead Teradata DBA

Tools: Informatica/Linux/Oracle/Appfluent support.

Responsibilities:

• Informatica, Oracle, Linux.
• Informatica, Mainframe Development

Confidential

Lead Teradata DBA

Tools: Informatica, Mainframe, Oracle

Responsibilities:

• Mainframe, AS/400 Development