SUMMARY

• 8+ Years of experience in the IT industry, coupled with extensive experience in Data Warehousing, Teradata Administration, Monitoring, Performance Tuning, Capacity Planning and Upgrade/Migration activities and ETL/ELT.
• Have very good experience administering the Teradata database, Data Modelling and ETL.
• Certified Teradata 12 database Administrator and completed 8 Teradata s overall.
• Has solid programming experience in Teradata SQL, UNIX and proficient in using Teradata admin tools Viewpoint, Teradata administrator, Teradata Manager and Performance Monitor.
• Extensive experience in Teradata Database Design, Application Support, Tuning & Optimization, User & Security Administration, Data Administration and Setting up the Test and Development environment.
• Solid knowledge in Teradata Architecture and Query Tuning.
• Good experience in Teradata RDBMS using FASTLOAD, MULTILOAD, TPUMP, FASTEXPORT, Teradata Parallel Transporter and BTEQ Teradata utilities.
• Experience in Backup and Restore (BAR) methodologies. Design, implement and co - ordinate all back-up and restore strategies.
• Worked on Teradata archive/restore and data replications tools- Arcmain, TARAGUI, Netback-up and Data mover.
• Have very good working knowledge on system (dbc) tables, resusage tables, DBQL and PDCR tables.
• Expertise in using Secondary indexes, PPI, Join indexes, hash indexes.
• Expertise in Teradata Parallel Transporter and scripting at Windows/Unix servers/mainframe.
• Expert in Coding Teradata SQL, Teradata Stored Procedures, Macros and Triggers.
• Involved in full lifecycle of various projects, including requirement gathering, system designing, application development, enhancement, deployment, maintenance and support.
• Expertise in Query Analyzing, performance tuning and testing.
• Hands on experience in monitoring and managing varying mixed workload of an active data warehouse using various tools like viewpoint TASM, Teradata Dynamic Workload Manager and Teradata Manager.
• Working experience with CRON TAB scheduling
• Experience in writing UNIX shell scripts to support and automate the ETL process.
• Experience in different database architectures like Shared Nothing and Shared Everything architectures. Very good understanding of SMP and MPP architectures.
• Involved in Unit Testing, Integration Testing and preparing test cases.
• Proficient in analyzing business processes requirements and translating them into technical requirements.
• Knowledge on Teradata Unity system in the environment.
• Involved in production support activities 24/7 during on call and resolved database issues.
• Strong problem solving, analytical, interpersonal skills, communication skills and have the ability to work both independently and as a team.
• Highly enthusiastic, self-motivated and rapidly assimilate new concepts and technologies.
• Good in analyzing the explain plans and tuning the SQL queries
• Have good understanding on the ETL tools like Informatica, Datastage, Mainframe and BI tool Tableau.
• Worked in Financial and healthcare domains.

PROFESSIONAL EXPERIENCE

Confidential, OR

Teradata DBA

Responsibilities:

• Supporting the Teradata Enterprise Data and Analytics platform including mentoring, implementing best practice recommendations, and participating in the DBA day-to-day activities.
• Producing the Capacity Planning reports for the management and as well doing the Capacity Forecasting in order to plan for the upgrades.
• Provide exceptional Teradata Database Administration, Monitoring and Maintenance services for the customer's production environments.
• Planning, coordinating and executing the System up gradation/Migration activities with ETL/BI teams and Teradata GSC teams.
• Participating in the Client interactions, meetings, presentations on databases performances in regard to the Teradata platform.
• User and Access Management: Creation of Databases, Users, Account, Roles, Profiles and Access Rights.
• Participate in the database change control process.
• Proficient in installation and troubleshooting the TTUs on client workstations.
• Proficient on writing and troubleshooting the Teradata utilities (FLOAD, MLOAD, FEXP, TPT, TPUMP) jobs.
• Involved heavily in writing complex SQL queries based on the given requirements.
• Heavily involved in System Performance activities such as: Workload management, TASM, Job Scheduling, Priority /Resource allocation, Query Performance Tuning and Optimization.
• Performed bulk data load from multiple data source (ORACLE, legacy systems) to TERADATA RDBMS using BTEQ, Fastload, Multiload, Tpump.
• UNIX scripting to support applications and database administration functions.
• Involved in administering and monitoring the TASM and Viewpoint - Setup, Configuration, setting changes.
• Defined Database Alerts using tools such as Viewpoint, UNIX scripting to - Define, setup, respond and take appropriate actions.
• Involved in System Maintenance /Database upgrade - Planning, Scheduling, Co-ordination, Communications, Implementation, and Testing.
• Data Mover jobs performance and Server maintenance.
• Involved in Backup / Restore - Performing backup, recovering and monitoring, Implemented Online Archive feature for certain databases which had ETL conflicts.
• Managing database space, allocating new space to database, moving space between databases as need basis.
• Addressing day to day user's issues such as resetting passwords, unlocking used id's, working on permission issues.
• Responsible for Performance Reports (PDCR) -Daily, Weekly, Monthly and Quarterly reports generation, review and presentation.
• Single point of contact for leading / coordinating with the offshore DBA team.
• Raising the Tickets at T@YS / Incidents Managements and coordinating with GSC to implement the fix/patch.

Environment: Teradata 14. Teradata Viewpoint, Teradata Administrator, TASM, TARA GUI, Netback up, TTU 14/15, Teradata Visual Explain, TSET, Teradata Index Wizard, Tableau, Datastage, Business Objects

Teradata Platform DBA

Responsibilities:

• Teradata platform monitoring support. The production platform alone handled 1 Petabyte data.
• Supporting and ensuring the Archival jobs completion and report to verify the database back-up status.
• Performed Query monitoring, Space monitoring and health checks of node using the View Point and experience using remote console utilities.
• Involved in monitoring of bad queries, looking for blocked sessions and working with support teams to resolve blocked sessions.
• Tuning bad queries by analyzing explain plans, visual explain to understand optimizer plans, created various NUSI index as needed bases.
• Created and automate the process of loading using Teradata load utilities.
• Involved in User Management tasks.
• Performed tuning and optimization of complex SQL queries using Teradata Explain.
• Handled security control tasks like logon and logoff rules for users.
• Involved in allocation of spaces like Permanent Space, Spool Space and Temporary Space.
• Used volatile table and derived queries for breaking up complex queries into simpler queries.
• Created unit test plans to unit test the code prior to the handover process to QA.
• Involved in troubleshooting the production issues and providing production support.
• Streamlined the Teradata scripts and suggested the standards for Teradata coding
• Collected statistics every week on the tables to improve performance.
• Developed unit test plans and involved in system testing.
• Created an archival frequency report to check the back-up status
• Recommending usage of query banding feature of Teradata to identify the problematic areas.
• Generate client requested reports like CPU Utilization, Database growth, Query history, Spool utilization etc.
• Proficient at MVC analysis/implementation, PI revision/implementation, PPI implementation and table rebuilds as year-end activities.
• Worked on ETL aspects primarily on TPT scripts writing. Worked on other Teradata Tools and Utilities including Fastload, Multiload and Fastexport.
• Actively involved in hardware expansion activities.

Environment: Teradata T12, T13.10, Windows XP, UNIX, Teradata Viewpoint, Teradata Administrator, TASM, Performance Monitor, Arcmain, Teradata Visual Explain, Data mover

Confidential, Chester-brook, PA

Teradata Applications DBA

Responsibilities:

• Assigned to remediate many weakly performing and CPU intensive SQL queries..
• Worked with multi statement, multi-table and multi-join queries.
• Wrote custom queries to identify duplicates, data skew in large tables having over 1 million rows.
• Used highly tuned queries that facilitate action-taking or decision making in a time-sensitive environment by using Tactical queries.
• Recommended join indices where required.
• Worked on loading of data from several flat files sources to Staging using Teradata TPUMP, MLOAD, FLOAD and BTEQ in various applications.
• Analyze reusage& trend reports using Teradata Manager for CPU, I/O, database & table growth, user count.
• Purging the system logs like resource usage logs, DBQL logs, dbcmngr logs, etc. (logonoff, reusage, acclogtbl, DBQL tables, event log, sw event log, logperm)
• Used Teradata Manager& Administrator to Monitor and Manage Teradata Databases.
• Generated a finalized physical data model which is used to create the physical data structures.
• Identified potential bottlenecks with user queries from the aspects of query writing, skewed redistributions, join order, optimizer statistics. Usage of Teradata Explain and Visual Explain to analyze and improve query performance.
• Space Management and Monitor the growth of the databases.
• Release Utility Locks of Multiload target table & dropping Multiload related tables for the aborted jobs.
• Abort Sessions for blocked, long & bad running queries.

Environment: Teradata 13, UNIX, Viewpoint, Teradata Administrator& Manager, PDCR DATA/INFO, DBQL, NET VAULT/ NETBACKUP (Arcmain Backup Restore, TaraGui, Datamover), (Teradata ETL Utilities - Multiload, FastLoad, PDCRDATA, SQLAssistant, PMON, TSET, TASM, Visual Explain, FastExport, BTEQ, Tpump), DBA Tools(SWS, TVI, BAR, SLES), ArcMain, TD SQL, Microsoft Products, Erwin.

Confidential, Charlotte, NC

Teradata Apps DBA

Responsibilities:

• Involved in Create / Modify / Drop Teradata objects like Tables, Views, Join Indexes, Triggers, Macros, Procedures, Databases, Users, Profiles and Roles.
• Involved in the complete re-design of the process flow, starting with design considerations, technical specification and source to target mapping.
• Actively involved in designing the primary indexes, secondary indexes with the application team for tables.
• Manage Teradata Database using Teradata Administrator, Teradata SQL Assistant and BTEQ.
• Performance Tuning, Query optimization (Explain plans, Collect statistics, Primary and Secondary indexes).
• Performed application level DBA activities creating tables, indexes, monitored and tuned Teradata BETQ scripts using Teradata Visual Explain utility
• Execute Diagnostic Help stats for session for queries to find missing stats on tables.
• Collect Statistics on UPIs, NUPIs, USIs, NUSIs, non-indexed join columns, small tables for better performance of the queries.
• Actively involved in analyzing & converting non compressed columns to Multi-Value compressed columns by creating a separate table with compressed columns & then moving the data to save database space.
• Execute change requests for DDL & DML statements from the users.
• Write, test and implement Teradata FastLoad, MultiLoad, FastExport and BTEQ scripts, DML and DDL.
• Perform data load to staging empty table using Teradata FastLoad from single input file or multiple input files, copy data from staging table to target table. Perform data load to existing tables using Teradata MultiLoad.
• Release Utility Locks of Multiload & dropping Multiload related tables for the aborted jobs.
• Monitor and Abort Sessions for blocked, high CPU consuming, highly skewed and long running queries.
• Monitor Teradata Database using Teradata Manager, Performance Monitor and Teradata Viewpoint.

Environment: Teradata V2R12, SQL, BTEQ/BTEQWin, TPT, FastLoad, Mload, FastExport, and Teradata SQL assistant 7.0/6.1, NET VAULT/NETBACKUP, Tera GUI, Informatica Power Center 8.5/7.1, Erwin4.0, Oracle 9i/10g, Windows XP/2000.

Confidential, Farmington Hills, MI

Teradata Application Developer / Apps DBA

Responsibilities:

• Managed database space, including allocating new space to databases and moving space between databases
• Created roles and profiles, including granting privileges to roles and adding users to roles based on requirements.
• Addressed day-to-day user issues such as resetting passwords, unlocking used IDs and working on permission issues.
• Analyzed and validated source data, designed source to target mapping and transformation logic, documented the approach, scripts and database layout.
• Monitored bad queries, including aborting bad queries using PMON, looking for blocked sessions and working with development teams to resolve blocked sessions.
• Tuned bad queries by analyzing explain plans to understand optimizer plans and used Statistics Wizard, QCD and Index Wizard for collecting stats and recommending indexes
• Worked extensively with DBQL data to identify high usage tables and columns.

Environment: Teradata V2R5, Teradata Manager, Multiload, FastLoad, PMON, TSO, ISPF, TD Data Mover, Tset, FastExport, MicroStrategy, ViewPoint, Tset, TASM, Sql, BTEQ, Tpump, DBA Tools.