GOUSE BASHA SHAIK

813-***-**** / addlb0@r.postjobfree.com

www.linkedin.com/in/gouse-basha-b8a8901b

PROFILE SUMMARY:

Having 13+ years of IT experience in Administering Teradata databases in Production and Non-Production environments.

Provided 24X7 support services to all Teradata RDBMS customers across the world.

Experienced working with a complex system of size more than 1 Petabyte having 57 nodes with 1482 AMP’s.

Extensive experience on performance tuning of SQL’s using various tuning methods like, analyzing the explain plan, analyzing skews, working with Statistics collection, working with indexes (PI, SI, JI, PPI, MLPPI), to use temp tables like Volatile/Global Temp Tables, applying Compression, etc

Implemented various Teradata recommended best practices in Optimization & Performance Tuning.

Used Data Dictionary tables and views to manage the system.

Extensive knowledge in Teradata Architecture, Design, Development and Optimization of applications.

Worked on BAR (Backup, Archive and Recovery) Activities using the Data Streaming Architecture (DSA), TARA GUI and VERITAS Net backup.

Extensive knowledge in Teradata Utilities: Multi Load, Fast Load, TPT, Fast Export, TPUMP, BTEQ, Data Mover and Teradata SQL Assistant.

Proficient in using Teradata Administrator for managing Databases, Users, Tables, Indexes, statistics, managing permissions (Roles & Profiles), addressing the user issues such as resetting passwords, unlocking user ID’s etc.

Hands on working with Teradata Viewpoint as a part of eyes on glass activity monitoring and aborting bad queries, looking for blocked sessions and working with development teams to resolve blocked sessions.

Work with Developers & DM on troubleshooting and fine tuning of scripts.

Worked with DM team to review the Data models and finalize the objects.

Worked on PDCR to generate performance related reports.

Knowledge on Data Modeling tool Erwin7.

Have knowledge on Bigdata/Hadoop Architecture and knowledge on Bigdata tools Hive, Pig, Sqoop and Hadoop MapReduce.

Migration of database objects across different environments.

Worked Extensively in Query Processing, Query Tuning and Administration activities of Teradata.

Experienced working as on-call/production support DBA.

Good Experience in Creating and managing user accounts.

Proficient in Server tools Teradata Manager, Teradata Administrator and PMON.

Worked on Denodo Data Virtualization application as a Denodo Administrator.

Involving in Software and hardware Install, Upgrade and Maintain Denodo Platform and apply patches to Denodo Platforms periodically.

Good communication skills combined with patience and determination to troubleshoot complex multi-system issues

CERTIFICATIONS:

Teradata 12 certified professional (TE0-121).

EDUCATION:

Master of Computer Applications (MCA) from Anna University, India.

Bachelor of Computer Science (B.Sc) from Nagarjuna University, India.

SKILLS:

Operating Systems Unix, Windows 95/98/NT/2000/XP

Programming languages C, C++, java

Query languages SQL, PL/SQL, Teradata SQL

Databases TD16.20/TD 15.10/TD14.10/TD13.10/TD12/V2R6,

Oracle 9i/8i, SQL Server 2005/2008

Backup tools DSA, Net Backup, ARC, TARA GUI, ABU GUI

Teradata Utilities BTEQ, Fast Load, Multi Load, TPT, FEXP,

TPUMP, Data Mover

Query tools SQL Assistant, Teradata Studio and Toad

Modeling tools Erwin 7

ETL tools Teradata Decision Expert (TDE)

System monitoring View Point, Performance Monitor (PMON),

Teradata Manager

Database Administration Teradata Administrator, Teradata manager, DBQL,

PDCR, TSET

Web Servers Weblogic Server 8.1, Tomcat Server 6.x

Data Virtualization Denodo 7.0/6.0

EXPERIENCE:

Dec’18 to Till Date Sr. Teradata & Denodo Admin, Gilead Science, Foster City, CA

Gilead Sciences, Inc. is an American biotechnology company that researches, develops and commercializes drugs. The company focuses primarily on antiviral drugs used in the treatment of HIV, hepatitis B, hepatitis C, and influenza, including Harvoni and Sovaldi. There are multiple source systems from which patient prescription data is coming and loading to Teradata warehouse. The final reporting’s done from Teradata database. The primary objective of this project is to manage the administration of Teradata Database and data virtualization Denodo application on daily basis. Admin support handles activities such as server administration, application maintenance, security implementation, application code issues and code migration across the production and non-production environments.

Responsibilities:

Playing a role of Senior Administrator and Technology Specialist in the project

implementations to integrate with clients Enterprise Data warehouse.

Responsible for day to day administration of Teradata database.

Participating as a key player while Teradata version upgrade activities.

Monitoring of all systems using Viewpoint and addressing the issues with application

teams.

Working closely with TD-GSC team during hardware and software upgrades.

Setting Up Teradata Viewpoint Alerts for Space Usage, CPU, Session, System Status etc.

Reviewing the projects in all the phases and migrating the database objects.

Defined a backup strategy for handling all Ad-hoc & scheduled backups.

Managing the Backup/Restore through DSA and TARA applications.

Granting & Revoking Object Rights, System Rights on Databases/ Users/ Roles.

Having good exposure in DBQL and PDCR.

Resolving spool & Perm space issues.

Monitoring database, identifying highly skewed tables, managing space.

Performing peer review & sign-off from the DBA side for any changes getting

implemented on the warehouse.

Monitoring space of critical databases and moving space from Space Reserve.

Checking for blockages and abort the culprit sessions

Analyzing performance of long running queries.

Pumping up the priority of certain critical sessions when client requests, by modifying

their workload.

Checking Skewed tables and do PI revision.

Creating objects in different environments.

Checking/Granting access rights and role rights.

Applying compression on tables.

Analyzing system metrics and Generating PDCR reports to the business users.

Sending the Daily/Weekly reports like Node Usage, Space Usage, AWT, Memory

Utilization etc.

Responsible for Denodo Administration activities like Create Users, manage user

authentication, resource authorization and setup DR for Denodo Platform. Other

responsibilities include Backup & Archival of Metadata/Review Changes and

deployments.

Involving in Software and hardware Install, Upgrade and Maintain Denodo Platform

and apply patches to Denodo Platforms periodically.

Analyze and troubleshoot Denodo issues raised by users or application and assist User

community and enforce best Practices.

Responsible for Monitoring Denodo Platform and manage High availability of Denodo

Platform and also responsible for migrating the views, databases, schedules from one

environment to another.

Environment: TD 16.20, Teradata Viewpoint 16.20, NetBackp 7.7, DSA 16.20, Tara 16.20, DSA, Teradata Studio, Teradata Administrator, Denodo 7.0, Teradata SQL Assistant, Data mover and Teradata utilities like Bteq, Fastexport, Fastload, Mload, Arcmain, TPT etc.,

Jan’16 to Dec ’18 Sr. Teradata DBA, Cummins, Columbus, IN

Cummins Teradata Support engagement is about Database Administration, Enhancements, Maintenance of Teradata Database and ETL (Teradata Decision Expert & Informatica) applications in Cummins EDW environment. The environment hosts multiple ETL and BI servers to cater the need of Cummins business units such as Corporate Operations (CORP), DBU Financial Controls (DBU) and Inventory Quality Ratio (IQR) etc. The ETL and reporting applications cater to the global user community supporting them in a variety of functionalities – Sales, Finance, and Distributions, Inventory and Order Management, etc. There are multiple source systems from which data is coming and loading to Teradata warehouse. The final reporting’s done from Teradata database. The primary objective of this project is to manage the administration of Teradata Database and ETL applications on daily basis. Admin support handles activities such as server administration, application maintenance, security implementation, application code issues and code migration across the production and non-production environments.

Responsibilities:

• Teradata Production DBA support.

• Participating as a key player while Teradata version upgrade activities.

• Maintaining the EDW compliance standards as per client requirement.

• Working closely with TD-GSC team during BAR hardware and software upgrades.

Monitoring of all systems using Viewpoint and addressing the issues with application teams.

Granting & Revoking Object Rights, System Rights on Databases/ Users/ Roles.

Reviewing the projects in all the phases and migrating the database objects.

Defined a backup strategy for handling all adhoc & scheduled backups.

Managing the Backup/Restore through DSA (DATA Streaming Architecture) application.

Space management and Data roll-offs based on pre-defined retentions.

Managing the memory resources such as Spool, Temp Space and Perm Space effectively.

Setting-up and monitoring of viewpoint alerts.

Setting-up and implemented Stats manager feature in Viewpoint.

Regular administration tasks on Teradata Database Servers – Production, UAT & Development:

Monitoring space of critical databases and moving space from Space Reserve.

Checking for blockages and abort the culprit sessions

Analyzing performance of long running queries.

Pumping up the priority of certain critical sessions when client requests, by modifying their workload.

Checking Skewed tables and do PI revision.

Creating objects in different environments

Checking/Granting access rights and role rights

Applying compression on tables

Backup and Recovery – Arcmain, DSA and NetBackup, which includes:

Monitoring daily backups.

Manually running Arcmain scripts to copy the data.

Adhoc requests for backup and restore.

Scheduling the backups through DSA and NetBackup.

Sending weekly reports to the client which includes:

Space detailed and summary reports

Added & Dropped Databases and users list compared to previous week

Providing probable candidate tables for dropping.

CPU, I/O and AWT utilization reports.

Loading the LIV data from Oracle to Teradata by using TDE (Teradata Decision Expert).

Scheduling the ETL jobs and run the jobs using TDE.

Having good exposure in DBQL and PDCR.

Performance tuning of issued queries.

Working on incidents (Remedy Tool) that are assigned by client.

User administration by creating and managing privileges of user.

Creating and managing databases.

Setting up roles and profiles.

Yearly PPI extensions.

Resolving spool & Perm space issues.

Reviewing code before migration to higher environments.

Implement structural changes as per the process.

Coordinate with TD CSR on hardware maintenance (replace failed disks, network failures, battery changes and other online operations).

Environment: TD 15.10, Teradata Viewpoint 16.10, NetBackp 7.7, DSA 16.20, Teradata Studio, Teradata Administrator, TDE 12.1, Teradata SQL Assistant, Data mover and Teradata utilities like Bteq, Fastexport, Fastload, Mload, Arcmain, TPT etc.,

June’15 to Jan’16 Sr. Teradata DBA, Bright House Networks, Riverview, FL

The Goal of the project was to implement new warehouse for US region in Enterprise Data warehouse. Bright House Networks' primary service offerings included digital television, high-speed internet, home security and automation and voice services. As part of this system, new warehouse was designed in US to maintain all the Customer, Finance, Billing etc., details to serve the customers. In Bright house there are multiple source systems from which data is coming and loading to Teradata warehouse and build the reports on top of this Data warehouse.

Responsibilities:

• Responsible for day to day administration of Teradata database.

Monitoring of all systems using Viewpoint and addressing the issues with application teams.

Worked on Stats Manager to Analyze and automate the statistics collection.

Setting Up Teradata Viewpoint Alerts for Space Usage.

Loading the history data from Oracle to Teradata by using OLE DB utility.

New schema setups from lower environments to higher environments.

Having good exposure in DBQL and PDCR.

Managing the Backup/Restore through TARA application.

Performance tuning of issued queries.

Working on Data refreshes through Data mover.

Working on various ticketing tools (i.e. JIRA, Peregrine).

User administration by creating and managing privileges of user.

Creating and managing databases.

Setting up roles and profiles.

Object migrations to across the environments.

Managing and allocating space for the databases.

Resolving spool & Perm space issues.

Reviewing code before migration to higher environments.

• Monitoring bad queries, aborting bad queries using Teradata Viewpoint, looking for

blocked sessions and working with dev teams to resolve blocked sessions.

• Very good knowledge in Data mover, Load/Unload Utilities like Mload, Fast load,

Fast Export.

• Monitoring database, identifying highly skewed tables, managing space.

Performing peer review & sign-off from the DBA side for any changes getting

implemented on the warehouse.

• Did performance tuning, analyzing explain plan, DBQL/PDCR data and recommending

additional statistics.

Recommendation of Primary Indexes for better distribution during migration

Perform Compression Analysis on Database Objects and provide Recommendations on

Multivalue compression Values.

Environment: TD 14.10, Teradata Viewpoint, TARA GUI, Teradata Studio, Teradata Administrator, Teradata SQL Assistant, Data mover and Teradata utilities like Bteq, Fastexport, Fastload, Mload, Arcmain, TPT etc.,

Aug’12 to Apr’15 Sr. Teradata DBA, JPMorgan Chase & Co, India

JPMorgan Chase & Co. is an American multinational banking and financial services holding company headquartered in New York City. It is the largest bank in the United States, the world's sixth largest bank by total assets, with total assets of US$2.5 trillion, and the world's second most valuable bank by market capitalization, after the Industrial and Commercial Bank of China. The project was to build up ICDW environment with integrating different Line of Business data. As part of this system, JPMC migrating all the data from existing DB2 database to Teradata database to integrate and maintain in a single database and it will be available to all the stake holders and customers across the globe.

Responsibilities:

Building up ICDW environment with integrating of Business data.

Working with different development teams for the migration of data from existing DB2 database to Teradata database.

Very good knowledge in Data mover, Load/Unload Utilities like Mload, Fast load, FastExport, TPT

Monitoring of all systems using Viewpoint and addressing the issues with application teams

Used Data Dictionary tables and views to manage the system.

Teradata Administrator – graphical Windows tool to assist in administration

Having good exposure in PDCR

Managing the Backup/Restore through TARA application

Performance tuning of issued queries.

Working on Data refreshes through Data mover.

Working on various ticketing tools (i.e. EURC, Peregrine and ITSM)

User administration by creating and managing privileges of user

Creating and managing databases.

Setting up roles and profiles.

Object migrations.

Space Management.

Resolving spool & Perm space issues.

Reviewing code before migration to higher environments.

Performing peer review & sign-off from the DBA side for any changes getting implemented on the warehouse.

Did performance tuning, analyzing explain plan, DBQL/PDCR data and recommending additional statistics.

Recommendation of Primary Indexes for better distribution during migration

Perform Compression Analysis on Database Objects and provide Recommendations on Multivalue compression Values.

Performance monitoring, investigating long running queries and Tuning them.

Generating PDCR reports and analyzing system metrics.

UAT issues using PEREGRINE system.

Environment: TD 14.10/13.10, Teradata Viewpoint, TARA, Teradata Administrator, Teradata Index wizard, Teradata SQL Assistant, Data mover, Control-m scheduler and Teradata utilities like Bteq, Fastexport, Fastload, Mload, Arcmain, TPT, etc.,

Feb’12 to Jul’12 Teradata DBA, CITI Bank, India

Citibank is the consumer division of financial services multinational Citigroup. Citibank was founded in 1812 as the City Bank of New York, later First National City Bank of New York. Citibank provides credit cards, mortgages, personal loans, commercial loans, and lines of credit. The bank has 2,649 branches in 19 countries, including 723 branches in the United States and 1,494 branches in Mexico. This project was to analyze the business in Sales area and to provide solutions to improve the business by implementing the projects and BI reports. In CITI bank there are multiple source systems from which data is coming and loading to Teradata warehouse and build the reports on top of this Data warehouse.

Responsibilities:

Managing database space, allocating new space to database, moving space between databases as need basis.

Monitor workloads and suggest best practices

Worked on Teradata administrator for creating users and also did cleanup activities through the tools.

Interpret Explain Plans and collect statistics to improve performance of long running queries

Usage of DBQL and PDCR for qry logs access and see how the query performed historically

Recommendation on collect statistics to make the optimizer confident

Made recommendations to make sure the PPI's get used when reports are designed

Got involved and made recommendations at the design level to avoid last minute tuning or surprises on the database

Identifying the data for Purging and Archiving on regular basis.

Validate PI/UPI/USI and also check whether they are used in frequent join columns.

Have hands on experience in generating SQL scripts from the model using Erwin.

Worked on 'Complete Compare' to compare the Logical and Physical models and generating the reports in different formats.

Have worked on creating reports using Report builder.

Worked on reverse engineering a model from Physical Database.

Prepared the SQL scripts for SIT, UAT and Prod changes.

Environment: Teradata 12, TD Admin, Teradata Manager, PMON, Teradata Viewpoint,

Teradata SQL Assistant, Multiload, FastLoad, FastExport, BTEQ, DBQL, Erwin 7.

Sep’10 to Dec’11 Teradata DBA, Barclays Bank, India

Barclays bank is one of the largest banks in UK. Barclays has its operations distributed across several locations. Barclays is a UK-based financial services group engaged primarily in Personal & Corporate (Personal Banking, Corporate Banking, Wealth and Investment Management), Barclaycard and Investment Banking. The project is to manage the data, users and access rights of the users. There are multiple source systems from which data is coming and loading to Teradata warehouse and build the reports on top of this Data warehouse. It is one of the largest banks in U.K. Here we were given around 100 TB of data. The final reporting’s done from this system.

Responsibilities:

24*7 Production support.

Monitoring database using Viewpoint.

User administration by creating and managing privileges for user

Creating and managing databases.

Data refresh across environments.

Managing and allocating space for the databases.

Managing Backups/Recovery by Teradata application TARAGUI

Code Reviews and Migrations across different environments.

Resolving spool & Perm space issues.

Roles and Profiles Management

Perform Compression Analysis on Database objects and provide recommendations on Multivalue compression values.

Good understanding in analysis of locks, indexing.

Archiving and Purging of Tables.

Tuning the queries having performance issues.

Advice structural changes and gives STATS collection recommendations wherever required.

All DBA related activities through SQL ASSISTANT, Teradata Administrator and Viewpoint.

Sending the Daily DBA reports (Node Usage, user query count, Production space, Memory Utilization...etc.).

Generating reports like: long running queries report, high CPU impact queries report, high spool consuming queries report.

Environment: Teradata 12, TD Admin, Teradata Manager, PMON, Teradata Viewpoint,

Teradata SQL Assistant, Multiload, FastLoad, FastExport, BTEQ, DBQL.

Mar’09 to Aug’10 Teradata DBA, Barclays Bank, India

Barclays bank is one of the largest banks in UK. Barclays has its operations distributed across several locations. Barclays is a UK-based financial services group engaged primarily in Personal & Corporate (Personal Banking, Corporate Banking, Wealth and Investment Management), Barclaycard and Investment Banking. The project is to migrate the data of Barclays Bank from V2R6 and other multiple source system to TD12. It is one of the largest banks in U.K. Here we were given around 100 TB of data. The final reporting’s done from this system.

Responsibilities:

Actively participated in Data migration from V2R6 to TD12.

Recommendation of Primary Indexes for better distribution during migration project

Monitoring the system using PMON

Creating and managing databases.

Creating and managing user accounts with appropriate security.

DBQL Analysis to get more performance impacted queries.

Run and schedule the Teradata scripts through JCL and check whether data has been migrated or not.

Doing space management while the migration is under process to avoid the failure of jobs.

Sending the reports of completed databases for archiving.

Involve in weekly meetings to give updates on the status and to discuss the issues.

Maintaining the issue logs for future reference and to easy the process further.

Maintain Knowledge Repository with current training materials and other documents

Environment: Teradata 12, TD Admin, Teradata Manager, PMON, Teradata SQL Assistant, Multiload, FastLoad, FastExport, BTEQ, DBQL.

Dec’06 to Jan’09 Teradata Developer, CISCO, India

Cisco is the worldwide leader in networking for the Internet and networking equipment’s. They are mainly concentrating on world market, so its invoice is based on shipment transaction. The data mart analyzes sales fact table and various dimensional tables such as Customer, Product, and Time, Deal, Ship and Purchase order. By analyzing sales, product with various combinations and its gross profit, this helps to improve the quality and promotional aspect for each line of item. This gives the management to implement various sales promotional techniques and decision support to improve the market share.

Responsibilities:

Extensively worked in Data Extraction, Transformation and loading from source to target system using Bteq, Fastload, and Tpump.

Involved in writing scripts for loading data to target data warehouse for Bteq, Fastload, TPUMP

Mainly did error handling in ET, UV and Work tables.

Did error handling and performance tuning in Teradata queries and utilities

Did data reconciliation in various source and in Teradata

Scheduling the jobs using Dollar universe.

Conducted Unit testing.

Environment: Teradata 12, Teradata SQL Assistant, Multiload, FastLoad, BTEQ, FastExport, DBQL.

Contact this candidate