SUMMARY

• IT Professional having 12.7 years of experience in Teradata Environment in developing, administering and providing support to Data Warehousing and Database driven Solutions.
• Managing extract data from many different source environments and validates data warehouse activity, including data extraction, transformation, cleansing, and updating to the Enterprise Data Warehouse (Teradata), and integration test processes.
• Experience in IBM infosphere Datastage tool
• Experience wif Teradata utilities MLOAD, FLOAD, BTEQ,TPUMP etc
• Experience in Teradata DBA functions (creating tables, granting permissions, managing workloads, monitoring the system for performance,) on a large Teradata database.
• Has extensive experience in using NetBackup, Tara, DSA for Backup and restoration activities
• Has Hands on Experience in using Viewpoint for administration and monitoring purpose
• Extensive working experience on Data Mover
• Has experience in multiple migration refresh projects
• Experience in deployment of Teradata Vantage in Azure and AWS cloud platforms

TECHNICAL SKILLS

Tools: & Utilities: BTEQ, Fast Load, MultiLoad, FastExport, Teradata SQL Assistant Viewpoint,TSET,QlikSense

Databases: Teradata,Hadoop,Sqoop,Hive,postgresSQL,SNOWFLAKE,MYSQL

ETL: Informatica, Datastage

Operating systems: Unix,Linux,Windows

Backup and Recovery Software: Netvault, Netbackup,DSC,TARA

Cloud: Microsoft Azure, AWS

PROFESSIONAL EXPERIENCE

Confidential

Database Specialist

Responsibilities:

• Teradata System Monitoring & Administration using Viewpoint
• Create/modify database, provide access rights, perm & spool space to users
• Monitor for Locks and clear Blocking sessions using Viewpoint
• Monitor the Batch jobs, CPU intensive and slow performing queries run by users and suggest changes to improve the performance of the queries
• Restore the production tables onto Dev and Test systems for testing and rebuild by developers
• Investigate skewed queries/tables and perform space allocations
• Resolve any Teradata related inquiries, issues or requests raised by users and different application teams
• Review queries and tables usage on a periodic basis and analyze objects dat can be dropped to free up space in the system
• Generate the utilization statistics - CPU & Space usage trends using system tables in DBC and identify applications wif badly running queries and assist in fine tuning them
• Used Teradata Data Mover to copy data and objects such as tables and statistics from one system to another.
• Develop, build and manage centralized data platform using Snowflake
• Bulk loading from AWS s3 to snowflake tables
• Validation of internal/external stage files and Loading data into snowflake tables.
• Developed snowsql scripts to load data from on-premise files
• Creating cloned copies of tables,views,databases,schemas working wif different data mart user groups from data engineers to data scientists. providing support for production deployment to diagnose,troubleshoot database errors. worked on data migration from Teradata to Snowflake assisting reporting users for setup of accounts to use data visualization tool tableau,power BI
• Create users, database, grant access,privileges to users work wif Snowflake support for raising support tickets and triaging outages. working on data slicing,masking for finance data

Confidential

Teradata SME and Cloud Consultant

Responsibilities:

• Teradata System Monitoring & Administration using Viewpoint
• Create/modify database, provide access rights, perm & spool space to users
• Monitor for Locks and clear Blocking sessions using Viewpoint
• Monitor the Batch jobs, CPU intensive and slow performing queries run by users and suggest changes to improve the performance of the queries
• Restore the production tables onto Dev and Test systems for testing and rebuild by developers
• Investigate skewed queries/tables and perform space allocations
• Resolve any Teradata related inquiries, issues or requests raised by users and different application teams
• Review queries and tables usage on a periodic basis and analyze objects dat can be dropped to free up space in the system
• Generate the utilization statistics - CPU & Space usage trends using system tables in DBC and identify applications wif badly running queries and assist in fine tuning them
• Monitor PROD, TEST and DEV environments of the Teradata Databases to ensure efficient performance and continuous availability of all supported services
• Provide database support, Implementation and Maintenance in a 24X7 On-Call DBA Support environment
• Database Access, Space, User, Security, Sessions, Locks & Workload Management using viewpoint
• Deal wif escalated database issues, analyze and provide solutions to them
• Runtime database Optimization, Service improvements for Space and CPU reclaim and Performance Tuning using DBQL data.
• Perform database Back-ups & Restore of the Teradata Production systems and Administer the jobs using DSA, BAR portlet
• Work wif different support teams to resolve high priority issues like Database restart, AMP/Node or Server down, faulty or loss of network connectivity and provide status updates to all the stake holders
• Plan, schedule and support database outages, node upgrades and certified patch updates
• Involved in setup of viewpoint, alert configuration for US legacy systems for Dev and Prod environment
• Deals wif procurement of nodes and contract renewals wif Teradata vendor
• Deals wif Data Centre’s to resolve hardware issues raised if any
• Teradata auto Alerts and Incidents management - create new incidents for Teradata issues on TAYS site and work wif GSC in resolving them and review the status of pending action items wif Teradata Support Engineers and CSRs in weekly, quarterly review meetings
• Performing Packdisk, Scandisk,checktable activities during database upgrades
• Creating, running, monitoring jobs using Data Mover to refresh data from one system to another system
• Involved in Hardware setup, design, server delivery to DC and consultations wif Teradata CC, GSC, Hardware teams and multiple vendors to setup new systems
• Involved in multiple migration projects of hardware refresh, version upgrades
• Worked on migration of databases like SQL server,MYSQL,PostgreSQL from on-Prem to AWS RDS instances for regional applications

Confidential

Responsibilities:

• Monitor PROD, TEST and DEV environments of the Teradata Databases to ensure efficient performance and continuous availability of all supported services
• Provide database support, Implementation and Maintenance in a 24X7 On-Call DBA Support environment
• Database Access, Space, User, Security, Sessions, Locks & Workload Management
• Deal wif escalated database issues, analyze and provide solutions to them
• Runtime database Optimization, Service improvements for Space and CPU reclaim and Performance Tuning using DBQL data and SQL explain plan
• Perform database Back-ups & Restore of the Teradata Production systems and Administer the jobs using NetBackup software on BAR servers
• Work wif different support teams to resolve high priority issues like Database restart, AMP/Node or Server down, faulty or loss of network connectivity and provide status updates to all the stake holders
• Plan for implementation of DBA Tasks which are part of change requests and present them to Change Management Lab for approval
• Teradata auto Alerts and Incidents management - create new incidents for Teradata issues on TAYS site and work wif GSC in resolving them and also review the status of pending action items wif Teradata Support Engineers and CSRs in weekly meetings
• Plan, schedule and support database maintenance/backup during outages, node upgrades and certified patch updates
• Perform day to day Database maintenance and support activities:
• Teradata System Monitoring & Administration using Viewpoint
• Create/modify database & roles, provide access rights, perm & spool space to users
• Monitor for Locks and clear Blocking sessions using Viewpoint
• Prioritize batch sessions or key user queries based on system load using Workload Manager
• Monitor the Batch jobs, CPU intensive and slow performing queries run by users and suggest changes to improve the performance of the queries
• Restore the production tables onto Dev and Test systems for testing and rebuild by developers
• Investigate skewed queries/tables and perform space allocations
• Resolve any Teradata related inquiries, issues or requests raised by users and different application teams
• Review queries and tables usage on a periodic basis and analyze objects dat can be dropped to free up space in the system
• Generate the utilization statistics - CPU & Space usage trends using system tables in DBC and identify applications wif badly running queries and assist in fine tuning them
• Generate TSET for performance issues to provide to GSC

Confidential

Responsibilities:

• Working on 24*7 Support Environment managed by strict Service Level Agreements wif time limits for ticket acnoledging, ticket resolution/Escalation.
• Working towards continuous improvement based on the feedbacks obtained from the Ticket owners.
• Monitoring Resource usage of Development, Test, Production environments using Teradata Manager and PMON.
• Continuous checking of DBQL data to look for bad queries, notify the concerned persons and working on query optimization.
• Proactive resolution and Analysis of job blockings/Long running jobs in Development, Test, Production environments and advising support team about long term fix.
• Creating new user accounts, databases, roles and Space Management.
• Generate and Automate client requested reports like CPU Utilization, Database growth, Query history, Spool utilization and CPU utilization per Profiles etc.
• Monitoring and Maintaining the Teradata Capacity Planning Scripts.
• Conducting training for on SQL coding standards to be followed, Basics of Teradata and Basics of Performance tuning to Developers
• Helping ETL developers in code walk through, project implementation on the Production systems and assuring Standards compliance.
• Performing Weekly, Monthly, Quarterly, Yearly backups, Proactive maintenance of the BAR environment.
• Performing the restore operations whenever requested.
• Work closely wif Teradata GSC team for issue resolution and Incident Management and Coordination of activities during System upgrades.

Confidential

Responsibilities:

• Creating users,roles and profiles and assigning them to users to give access to the system. Used Teradata manager,PMON in monitoring the system.
• Experience in using Net Vault for backup and recovery tasks. Familiar wif TDWM in giving priorities to different load operations. Experience in creating roles and profiles and assigning them to various users.
• Monitor and maintain a production Teradata database environment including runtime optimization capacity management and planning security configuration scheduling and execution of maintenance utilities.
• Exporting the tapes to offsite storage and recalling them. preparing monthly and quarterly leavers sheet as a part of sox compliance
• Validation of backups as a part of sox compliance.
• Support for all the Production issues related to EDW.
• Iremedy Ticketing system.
• Handling source system issue’s and loading files to EDW.
• Handling issue’s wif Production servers wif Third Party vendors
• Supporting FAB,FDM,Hyperion,Proclarity Applications.

Confidential

Responsibilities:

• Written BTEQ scripts to load data from 3nf To star schema
• Involved in calculating measures to load fact data from dimensional tables
• Involved in loading the data using teradata loading utilities i.e Fastload,Mload
• Created Insert scripts for the static data
• Used sql assistant to test the data
• Done Audit and control in unix to test the data accuracy
• Cordinating wif onsite team to analyze the Business process and makes necessary changes to meet accommodate their needs
• Worked wif QA and reporting team for validating the data
• Written unit test cases