SUMMARY

• Over 15 years of work experience in IT Industry in the Teradata DBA/performance Tuning/ Teradata Developer / Generating Looker Reports /DBA Activities with Unix scripting in Data warehousing stream
• Worked in full DBA/Development Life Cycle for different applications in different environments.
• Experience on space management (Allocations), user access managements (Roles and profiles).
• Experienced in Teradata performance tuning in all areas.
• Teradata Client Installations in different environments.
• Viewpoint monitoring, change workloads, monitor/abort blocking or blocked jobs
• Experienced in TD utilities like TPT, BTEQ, Fast Load, Multi Load, Tpump, Fast Export, SQL Asst
• Thorough understanding of BI & Data Warehousing Concepts with emphasis on Full ETL Life Cycle.
• ESP Job preparation and ETL implementation using python frame work.
• Active Batch Job scheduling and monitoring and preparing SSIS packages for ETL frame work.
• Experienced with Teradata Tools like SQL Assistant, Teradata View Point, Teradata Manager
• Experienced in Administrative activities like creating users, roles and performance monitoring
• Working Knowledge on backup and recovery operations using Tera - Gui, Netback, Net volt.
• Working Knowledge on Dimensional Modeling Concepts Star Schema and Snow Flake Schema
• Experienced in using Erwin for the data models (FSLDM / BDW )
• Experienced with UNIX shell scripting and processing files
• Generating Looker Dash Boards using Look ML Code and Teradata database as back end
• Domain knowledge like (Banking, Insurance, Retailer, Health care and Tele Communications)
• Excellent skills in delivering the projects on time to ensure customer satisfaction
• Possess leadership and managerial qualities along with problem-solving skills and can-do-attitude

PROFESSIONAL EXPERIENCE

Confidential

Lead Teradata DBA

Responsibilities:

• Performance Tuning for long running queries and failed queries.
• Creating Databases, Users and Other database objects.
• Working on failed jobs during loads, data movement between environments.
• Working on spool space issues and Stats recommendation and re defining if required.
• Space moving and recovering by cleanup unwanted tables all the time.
• Access Managements for all level of users and granting access accordingly.
• Create and grant ROLES to the users as per the requirement.
• Reviewed DDL and migrations till production.
• Reviewed Objects and code as per the Teradata Best Practices.
• Performance improvement suggestions and implementation
• Attended the calls with data Architect to get the knowledge on data models.
• Building the views in semantic layer.
• Created the Teradata bteq scripts, TPT Scripts, Fastload, Multiload and Fastexport scripts.
• Written the complex sqls for reporting.
• Created and defined DDL’s for the tables at staging area.

Environment: Teradata 15.00, TD16.20, UNIX, Linux,SSIS, ActiveBatch and Windows

Confidential, Maryland heights, MO

Teradata DBA

Responsibilities:

• Load monitoring using dash board, and working on failed loads (Tables for reports)
• Fine tuning queries before deploy in production
• Moving Space according to requirement within the environment.
• Moving data between environments according to the requirements.
• Worked closely with Architects/Modelers for launching new tables
• Identified key areas in the ETL frame work where performance improvement needed.
• Identifying the highly skewed tables and worked with modelers to redefine Indices
• Working on JIRA Tickets and adhoc requests through e-mails.
• Used Teradata Administrator and View Point Tools for monitoring and control the system.
• Involved in DDLs migrations between environments.
• Performance tuning, monitoring and reporting review system utilization by user.
• Break fixes, table fixes, monitor on load failures, backup and archive activities on demand.
• Created and granted ROLES to the users as per the requirement.

Environment: Teradata TD16.00, UNIX, Linux, and Windows

Confidential, Bloomfield, CT

Teradata DBA

Responsibilities:

• Code review for ESP jobs for ad-hoc loads which are failed in regular jobs.
• Performance improvements for reporting views (reporting view layer).
• Creating tickets for any code changes, migrations and, code enhancements.
• Fine tuning queries before deploy in production.
• Looker dash Board creation for different reports and managing.
• User story requests solving.
• ETL code migration between environments till production implementation.
• Involved in DDLs migrations, space requests and DDLs Version implementations.
• Used Teradata Administrator and View Point Tools for monitoring and control the system.
• Attending release management meetings and working with them till production deployment.
• Performance tuning, monitoring and reporting review Looker Dash board utilization by users.

Environment: Teradata 15.00, UNIX, Linux, python, Informatica and Windows

Confidential

Teradata DBA

Responsibilities:

• Load monitor from dash board, csv file loads and data loads for common tables (Maintenance tables).
• TPT preparations for ad-hoc loads which are failed in regular jobs.
• Worked on reporting views (aggregated view layer).
• Creating tickets for any code changes, code enhancements.
• Fine tuning queries before deploy in production.
• As a Teradata DBA involved full support in different environments like DEV, TEST,UST and PROD.
• Database creation for different purposes. Creating and managing user profiles and accounts.
• Ticket solving using HPALM and HPSM.
• Moving Space according to requirement with in the environment.
• Moving data between environments according to the requirements.
• Involved in DDLs migrations, space allocations and DDLs Version implementations.
• Used Teradata Administrator and View Point Tools for monitoring and control the system.
• Data movement and implementation of database and table-level security, setting up access rights for various Teradata environments.
• Performance tuning, monitoring and reporting review system utilization by user.
• Involved in end to end DBA activities Life Cycle of different applications.

Environment: Teradata 14.00, UNIX, Linux and Windows

Confidential, Dublin, OH

Teradata DBA

Responsibilities:

• Performance tuning of Teradata code, analyzing the explain plan and determining which column/index/table needed to collect statistics, improved the performance up to 40%-50%.
• Analyzed the skew ness and suggested the changes to Primary Index at the time of development to resolve the performance bottle necks.
• Involved in preparing Physical Data Model (PDM).
• Worked closely with Modelers while creating physical tables.
• Capacity planning based on project planning.
• Analyzed the space requirement and assigning and recovering.
• Database / Users / Other objects creations.
• Space assignment and recovering.
• Granted Access Rights between databases.
• Created and granted ROLES to the users as per the requirement.
• Reviewed DDL for the objects.
• Published the DDLs into repository.
• Reviewed Objects and code as per the Teradata Best Practices.
• Stats recommendation and defining.
• Performance improvement suggestions and implementation.
• System monitoring completing daily basis incidents from multiple application teams.
• Designed and Developed Informatica mappings, mapplets, sessions and workflows for data Loads.
• Did migration of the code between environments having all the components in sync.

Environment: Teradata 14.0, unix, Control-M

Confidential, Phoenix, AZ

Lead Teradata DBA

Responsibilities:

• Database / Users / Other objects creations.
• Space assignment and recovering.
• Granted Access Rights between databases.
• Created and granted ROLES to the users as per the requirement.
• Reviewed DDL for the objects.
• PI Selection attributes.
• Published the DDLs into repository.
• Reviewed Objects and code as per the Teradata Best Practices.
• Stats recommendation and defining.
• Performance improvement suggestions and implementation
• Discussed the requirements with client.
• Attended the calls with data Architect to get the knowledge on data models.
• Involved in preparing the low-level technical design documents.
• Building the views in semantic layer.
• Created the Teradata bteq scripts, Fastload, Multiload and Fastexport scripts.
• Written the complex sqls using OLAP functions.
• Created and defined DDL’s for the tables at staging area.

Environment: Teradata 12, TD13.0, TD 13.10, UNIX, Linux and Windows

Confidential, Virginia, VA

Lead Teradata DBA

Responsibilities:

• As a Teradata DBA involved in user creations, DDL implementation, code migration, scheduling and monitoring load jobs.
• Implementation of database and table-level security, setting up access rights for Teradata environments.
• Performance tuning, monitoring and reporting review system utilization by user.
• Involved in work load management by balancing workloads for optimal performance.
• Space management, capacity planning for feature trends based on existing trends.
• Scheduling backups and other database maintenance activities.
• View point monitoring, alerting Outages during patch-ups, upgrades
• Creating and managing user profiles and accounts.
• Granting privileges and access rights according to requirements.
• Monitoring and controlling the system using Teradata Administrator and View point Tools.
• Database clean ups and production implementations during project releases.

Environment: Teradata 13.0, TD 13.10, UNIX, Linux and Windows