PROFESSIONAL SUMMARY:

• Over the past 10+ years I have been able to establish myself as a proficient Software Professional. I have extensive experience working as Teradata DBA. Also, worked as Hadoop Admin, Datalake engineer, implemented Cloud and Devops Concepts. Currently working at Wells Fargo, earlier, worked for Confidential, Confidential and CGI to lead, design, implement, administer & support Teradata Database/Datalake Platforms. Extensive working experience on Enterprise & Appliance Platforms. Have experience as operations & support engineer working on Hadoop platforms such as Hortonworks & Cloudera Distributions,
• Experienced working on end - to-end Teradata Database activities for Setup, Plan, Implement, Configure Users, Databases, Space, Roles, Profiles, Access, Tools and Utilities (TTU), Workload, TASM, Performance management, Capacity Planning, Database Design and indexing, Back-up & Recovery, Retention, Security Management and Auditing
• Hands on experience on Query Tuning and Optimization, handling Database Performance Issues
• Experience in resolving Spool space issues, long running jobs & optimizing product join queries
• Designed/Planned and Created database hierarchy, manage space, set up users, roles, profiles, and general security rules based on the customer's requirements
• Experienced in Data Modeling Techniques, Conceptual, Physical & Logical Data modeling.
• Expertise with Teradata capacity planning and performance tuning.
• Hands on experience to Tune and optimize Teradata Applications. Implement Multi-Value compression (MVC), BLC
• Experience with Tuning for Performance improvements on Database and to provide recommendations for Statistics, Primary, Secondary and Partitioned indexes, PPI.
• Expertise in fixing issues faced on Database Performance related to PJI, UII, Impact CPU, skewness, High CPU, High IO.
• Well-Versed using Teradata utilities such as Check Table, Lock Display, Gateway Global, Recovery Manger, Show Locks, Update Space
• Provided recommendation and design for TASM rulesets. Experienced in Maintaining rules set in the Teradata Active System Management (TASM) and supporting workload management
• Experience in extracting, loading, and transforming (ETL) structured/unstructured data using Teradata Utilities (FastLoad, Multiload, FastExport, BTEQ, TPT)
• Exposure in using load utilities for loading small/medium/large amounts of data by using tools such as Fast load (Fload), Multi load (Mload), TPT, Tpump, Fast Export
• Experienced with planning and execution of Teradata tasks like Major Upgrades, Minor Upgrades, Patch implementation, Floor Sweep, Hardware changes etc.
• Setup/Configured, Supported the database systems and application servers for the Disaster Recovery (DR) build/test, annual drill, and quarterly maintenance
• Planned, Managed, monitored, and maintained Teradata hardware/software for patches, replacements, and upgrades and coordinated activities with Teradata
• Extensive experience in PDCR, DBQL and Teradata Active System Management (TASM)
• Expertise in identifying, analyzing, and resolving job abends independently
• Experience performance tuning on large databases or data warehouse environment, using advanced SQL, DBQL and Explain plans
• Experienced with Data Modeling, expertise using Erwin Tool. well-versed in working with console utilities.
• Experience working Teradata Datamover Jobs creation, troubleshooting & fixing issues.
• Expertise working in Teradata Intelliflex environment and upgrading/migrating the Teradata Database systems.
• Provided signoffs to developers on Operational and Design, Development, and Implementation of projects to ensure best use of the Teradata system including review/approval of database components such as tables, views, SQL code, stored procedures, and macros.
• Maintained the Teradata Workload Manager with the proper partitions and workloads based on Service Levels Goals.
• Generated and maintained capacity management, Space, and CPU reports, CPU, I/O, Usage, and Storage resources and proactive monitored to meet performance and growth requirements.
• Experienced working in Data warehousing ETL development and establishing the pipeline projects in Teradata and Informatica PowerCenter.
• Expertise and Experience of creating Teradata Stored Procedures, Functions, Triggers, Views, and Exception handling.
• Written different stored procedure to handle the requirements and to automate the manual efforts.
• Experience in Granting & Revoking of Object Rights, System Rights on Databases / Users / Roles.
• Expertise establishing Security through Roles, Profiles and Views.
• Monitoring Database / Table Space Usage, Sessions, Nodes, CPU, IO Information
• Executing change requests for DDL & DML statements from the users
• Handling the Change Management and incident management for the production issues using Remedy
• Configuring/adding Teradata system to Viewpoint, exposure to Viewpoint alert setup according to the requirements, monitoring database performance using viewpoint
• Experience with High availability disaster recovery in a Teradata environment using Unity and Data Mover.
• Experience in Backup and Restore (BAR) methodologies. Design, implement and co-ordinate all back-up and restore strategies.
• Well versed with Backup and Recovery (BAR) using Netvault as well as Netbackup, DSA and Arcmain.
• Experienced with Tableau for reporting/visualization and decision-making.
• Performing the changes in Production through specific Change control tasks.
• Well versed working on access rights issues, troubleshooting user/database connectivity
• Hands on experience in working on linux, unix servers & exposure to Shell Scripting.
• Experienced working in project teams in metadata management, data/IT governance, business continuity plan, data security
• Experienced in providing technology to team members and maintaining, updating, runbooks and shared data resources.
• Experience with Jira (Scrum/Kanban), Service Now, ITSM, BMC Remedy
• Good at Understanding business area and business requirements & experience with Agile & Operations

TECHNICAL SKILLS:

TOOLS: /Others:Teradata SQL, TASM, Teradata Studio, BTEQ, Multiload (Mload), FastLoad (Fload), Teradata parallel transporter (TPT), Tpump, Fast Export, Teradata SQL Assistant, Teradata Administrator, Teradata Viewpoint, Console Utilities, TSET, Netvault, Netbackup, Backup and Recovery (BAR), Teradata Manager, Datamover, Teradata Unity, Teradata Ecosystem Manager, Check Table, Lock Display, Gateway Global, Recovery Manger, Show Locks, Update Space. DBS Control Parameters, PerflookHadoop, HDFS, Cloudera Manager, Map-Reduce, Pig, Hive, HBase, Sqoop, Oozie, Flume, Ambari,, Hue, Ranger, Impala, Spark,, zookeeper, Linux, Unix

PROFESSIONAL EXPERIENCE:

Confidential

Teradata Product Support Engineer

Responsibilities:

• Teradata databases activities included creation and configuration, Space management, User management, data synchronization across systems, monitoring sessions and resolving session conflicts, performance analysis and reporting, Backup and Recovery, query tuning and optimization, MVC, migrating and upgrading databases, UNIX shell-scripting, developing & scheduling batch jobs, Service management. Create and maintain user, role, database objects, Analyze and research database-related issues, grant and revoke object/system rights on databases, users, roles, Monitor session, nodes, and virtual processes through Viewpoint, Reallocate disk space, Perform back-up job scripting and monitoring through TARA GUI, NetBackup, DSA(Data Stream Architecture), Investigate space usage and monitor growth of the databases, Release HUT Locks and M-Load, and resolve spool out issues. PDCR installation and configuration
• Datalake Operations/Support and Administration. Datalake activities include, User Home directory Management, Space/quota Management, Capacity Planning, Hardware/Software upgrades, Monitoring, Alerting, Logging the Cluster to Ensure the High Availability of Datalake platforms. Troubleshoot to mitigate the Datalake issues to ensure Performance is optimal. Ensure the onboarding new apps to the platforms are seamless. Migrate and move the from Data sources to Target zones such as raw, sanitized, conformed and curated zones, involving several tools from source to destination, such as Teradata, Datalake, Hadoop, Talend, Ab-nitio, Informatica, ETL,
• Datastage. Experienced using suite of tools to bring data from data source for ingestion, real-time ingestion & data load, transform, standardize and move data between data zones and export data to downstream system, Data to be ingested from source of record (SOR) to enterprise Datalake

Confidential

Teradata and Hadoop Admin

Responsibilities:

• The Project is to Administrate, Configure Implement and support Teradata Database and Hadoop Platforms, for implementation of innovative Data Warehousing and BI solutions that directly promote business growth. My role is to work on day - to-day activities in the Teradata Database Administration and Cloudera Cluster administration. Teradata Administration activities included, analyze system s existing workloads, re-define, adjust & monitor systems workloads using Teradata tool TASM (Teradata Active System Management) to provide optimal systems performance. Real time query performance monitoring, notifying users to optimize bad queries by providing query tuning tips, and performing the query tuning and performance tuning. Support EDW monthly data load processes, backup requests, data movements requests between development and production systems or vice versa for application testing and production system s data issue resolution. Coordinate and participate in Major, Minor Teradata system and RDBMS upgrade initiatives. Interact with Teradata Global Support Centre for problem analysis and troubleshooting. Support application development timelines by implementing designs as well as incremental changes to database objects according to SLAs both in Development and Production systems.
• Provide DBA support for designing ETL processes to load data into EDW.Hadoop production support activities include, Decommission, and recommission of nodes, creating home directories for users, Configure Hdfs acls, exposure to patch upgrades, Create/restore a snapshot of hdfs directory, Troubleshoot the errors faced, resolve space issues, ensure platforms are highly available. Involved in HDP/CDP upgrades, installation, configuration, supporting and managing Hadoop Clusters using Cloudera. Job scheduling and monitoring tools like Oozie and Zookeeper and Monitoring, Alerting and support through Nagios and Datadog. Cluster setup, cluster performance and monitoring on a daily basis, maintaining cluster on healthy on different Hadoop distributions like (Ambari and Cloudera).

Confidential

Product Support

Responsibilities:

• Worked as a Subject Mater Expert(SME) in Teradata GSC/GSO Team and in Managed support teams. Part of the GSC/GSO Teams worked with Global Customers to ensure the Teradata Database issues are mitigated, troubleshooted and fixed. Performed root - cause analysis to ensure the re-occurring issues are resolved permanently. Performing end to end Teradata Database admin & support activities, expertise with Teradata Database Version 14, 15 & 16. Also, worked on various Client Applications such as Viewpoint, Datamover, Arcmain, Dsa, Teradata Active System Management, Unity Loader, Unity Ecosystem, Teradata Multi-System Manager etc.Ensure platforms are highly available and healthy. Work with Various Application team for having their projects implemented on time by providing them support over User Management, Database Management,
• Configuration, Access rights management, Viewpoint Setup Configuration and Monitoring, Alert setup, Fixing Spool space issues, Query tuning and Performance tuning, Backup and recovery. Perform administration on utilities such as Vproc Manager, DBS Control, DIP Utility, Abort Host, Check Table, Scan Disk, Pack Disk, Update space, Lock Display, Priority Scheduler, Query Session, Show lock, Recovery Manager, Gateway Global. Experience with data modelling techniques for data marts and on prem databases for Teradata Intelliflex, Teradata Vantage systems. Perform daily weekly BAR backup and recovery and maintain retention policies. Plan and participate in system upgrade activities.

Confidential

Database Administrator (Teradata).

Responsibilities:

• The Project was to Administrate, design and implement an Integrated Data Warehouse from which the Business Users would generate reports using Adhoc Queries and Predefined Template of Reports. The motive for this project is to make a platform where business users could generate report on their day today activity in their area of interest. Bell client was of Telecom Domain and they required daily and monthly usage report. I was part of a project where they were finding the users with most interest in each package so that they could sell their products with the maximum accuracy over to find the phone packages for each user. My role there is to administrate the data warehouse backend, which is Teradata.
• Foresters client was of Insurance domain, the project was to implement an integrated data warehouse which was about to provide the edw operations support with the most adequate information required to understand, operate and recover the system in the production environment under normal or abnormal operating conditions