• Teradata Performance DBA/Aster Data DBA, Hortonworks Hadoop Admin, GreenPlum DBA with 10.3 years of experience specializing in activities like database upgrade from Teradata 15 to Teradata 16.10 and Teradata 12 to Teradata13.10, backup and recovery using TARA/NetVault backup, user management, performance tuning, space management, Teradata ETL production support, Teradata Viewpoint/Manager monitoring and configuration.• Expert of NPARC & scalable parallel data migration methods (multi-week data migration efforts for system upgrades reduced to one day, any size system).• Utilized NPARC to copy everything on Test from PROD (DBC tables as well client tables) for initial build out of Test Machine.• Experience working on Teradata 16, 14, Teradata 13, 13.10 and Teradata 12 on Linux Platform.• Experience working on AsterData and hadoop 2.3 Teradata big data appliance• Experience working as Greenplum Admin.• Experience working as Hadoop Admin.• Experience implement Data Governance & Data Protection security controls and policies.• Experience in providing solutions to highly critical Database issues.

Altria Philip Morris -USA(Teradata DBA and ETL support)Responsible for:•Prepared detailed plan for Teradata12 to Teradata13.10 upgrade along with upgrade essentials.•PDCR 13.10 installation and maintenance. •Configuration of Alert policies and working with TASM on viewpoint 13.10.•Backup and recovery using TARA GUI.•Creation and maintenance of users, Databases, roles profiles.•Provided Teradata ETL Production support.• Experience in performing PPI maintenance, multi value compression. Check disk, scandisk and pack disk•Performance tuning of skewed and long running queries. •Built and automated detailed reporting and tracking BTEQ scripts via CRON on the IBM AIX Unix platform.•Automated stats collection on prod,dev and qa for performance improvement.•Developed effective processes, standards for security management, auditing and database administration, Mentored our staff via internal seminars on new processes.•Managed the help desk team for the EDW, building effective written procedures and ensuring that all tickets were documented to meet or exceed audit requirements. .•Work with ETL leads to formulate ETL approach and appropriate use of Teradata Tools and Utilities including Fast load, Multi load, TPump, and SQL Assistant.

Vonage Telecommunications-USA (Teradata DBA )Responsible for:Major responsibilities include the following…Performance monitoring and Space management of around 80TB of data •Identify potential bottlenecks in the applications or infrastructure architecture.•Designing, creating and tuning physical database objects (tables, views, indexes) to support normalized and dimensional models. Maintain and enhance database performance using Teradata Manager/Viewpoint, Maintaining DBQL tables and purging DBQL tables periodically, Performance Monitor, and TASM.•Provide ongoing support of the environment by developing processes and executing object migrations, security and access privilege definition.

Underwent Training and worked as an OJT acquiring the following skills:* Teradata 12 Database Fundamentals* Teradata SQL* Teradata ETL tools & Utilities such as BTEQ,MultiLoad,FastLoad,FastExport,TPT* Teradata Physical Implementation* Teradata Administration