SUMMARY

• Over 8 years of progressive IT experience in implementation of Data Warehousing projects as a Teradata DBA and Development.
• Experience in setting up User & Security Administration, Data Administration
• Experienced in Backup and recovery (Bar systems), Query Performance Tuning, Arcmain scripts.
• Worked extensively on code deployments in various environments.
• Worked extensively on PMON and Teradata viewpoint tools for monitoring the sessions and workload management.
• Expert with Teradata and its utilities such as BTEQ, MLOAD, FASTLOAD, FASTEXPORT and TPUMP, Teradata Administrator, Viewpoint.
• Experience working with clients of all sizes in the insurance, financial, Retail, healthcare, manufacturing industries.
• Created and scheduled various Teradata recommended Performance, Capacity, trending and activity reports such as Space, Usage, Access, security reports.
• Set up the Teradata Workload Manager with the proper partitions and workloads based on Service Levels. Set up Teradata Query manager to automate many of the DBA tasks such as collection of statistics, monitoring spool space, candidate tables for purge, etc.
• Monitored the production and development systems on a daily basis to catch trouble queries, monitor access violations, and provide capacity planning.
• Expert in turning complex Teradata SQL Queries including Joins, Correlated sub queries and Scalar sub queries.
• Excellent knowledge in Teradata Tactical queries.
• Proficient in understanding Teradata EXPLAIN plans, Collect Stats option, Secondary Indexes (USI, NUSI), Partition Primary Index (PPI), Volatile, global temporary, derived tables etc.
• Experience with Design, Creation, maintenance, and support of database objects based on architectural guidelines and standards.
• Worked extensively on DBC tables along with Aggregates and building efficient views.
• Strong understanding of the Relational database concepts.
• Strong Technical Writing and user documentation Skills.
• Have good problem solving and troubleshooting skills.
• Good Analytical and Strong interpersonal and good communication skills.
• Quick learner and willing to adapt to new technologies.

TECHNICAL SKILLS

Teradata Utilities: BTEQ, MultiLoad, FastLoad, FastExport, Tpump, TPT,Teradata SQL Assistant, Teradata Visual Explain

DBA Tools: Teradata Administrator, PMON, Teradata Manager, View point, PDCR

ETL/Reporting Tools: Informatica, DataStage, Cognos. SSIS, SQL * Loader

Query Languages & Backup tools: Teradata SQL, VERITAS Net backup, TaraGUI, ARCmain

Data Modeling/Tools: Erwin, Star Schema, Snowflakes Modeling, Visio Enterprise.

Databases: Teradata V2R5/12/13, Oracle, Ms Studio.

Operating Systems: UNIX, Windows XP/NT 4.0, Windows 2000 Server, Windows XP, Windows Vista, LINUX and Mainframe.

Methodologies: Data Warehousing Design, Data Modeling, Logical and Physical Database Design.

Sub Version: SVN, TFS, CVS, ARCH.

PROFESSIONAL EXPERIENCE

Confidential, Durham, NC

Teradata DBA

Responsibilities:

• Support Test & Development environments for a large enterprise data warehouse project.
• Used highly tuned queriesthat facilitate action - taking or decision making in a time-sensitive environment by using Tactical queries.
• Worked on Code Deployments in various regions.
• Executing change requests for DDL & DML statements from the ETL and BI users
• Improving the table access by collecting statistics, compress multi values, define PPI as per the access patterns.
• Worked on performance tuning activities like creating Materialized views on the top of Custom views using stored procedures.
• Took advantage of techniques such as request (query plan) caching and session-pooling by using Tactical queries.
• Create / Modify / Drop Teradata objects like Tables, Views, Join Indexes, Triggers, Macros, and Databases.
• Handled USER management requests such as creating new Users& Profiles, and Roles.
• Granting & Revoking of Object Rights, System Rights on Databases / Users / Roles.
• Actively involved in designing the primary indexes, secondary indexes with the application team for tables.
• Developed stored procedure to collect statistics on Databases, Tables, Columns and Indexes by referencing from cross- reference table. The stored procedure also collects stats based on 10% change in database size.
• Manage Teradata Database using Teradata Administrator, Teradata SQL Assistant and BTEQ.
• Good Knowledge in MVCand BLC Compression technique
• Done different types of Backup jobs such as Daily/Weekly/Monthly and Full/Online backup and PPI &Triggered based backup jobs in Netvault/Netbackup GUI Tool.
• Having good experience with Backup and Recovery using Teradata ARCMAIN in Net Vault.
• Monitor Teradata Database using Teradata Viewpoint, Performance Monitor and Teradata Manager.
• Space management including PERM, TEMP and SPOOL space for the users and databases. Calculating the capacity and forecast the space proactively.
• Recommend users to improve the performance of the query by changing the Primary Index, use global temporary table, volatile table & derived table for intermediate results.
• Establish / recommend technical database administration standards, archiving strategy and security policies standards to ensure databases are compliant and optimized.
• Write, test and implement Teradata FastLoad, MultiLoad, FastExport and BTEQ scripts, DML and DDL.
• Monitor Database / Table Space Usage &Skewness at Database / Table / Vproc level
• Implement Partitioned Primary Indexes to improve performance of date range queries.
• Work & close HPSM tickets for database activities - create role, create database, create user, create profile, increase spool space to user, increase database perm space, drop user, remove user temporarily, reinstate user, assigning non-expiry profile to user, user password reset, release password lock on user, querying dbc.logonoff dictionary view (to get user information like reason for locking, when the user last logged on to the system, etc), querying dbc.qrylog dictionary view (to provide resource information regarding the query used by the user), remove direct access to the tables/databases, remove access from roles, grant access to roles, Generating reports using PDCR info for database space, tablesize, CPU utilization, user information, skewed queries, etc.
• Analyze DBQL entries to troubleshoot high consuming CPU and highly skewed queries.
• Monitor and Abort Sessions for blocked, high CPU consuming, highly skewed and long running queries.

Environment: Teradata 14.1, TPT, InformaticaPowerCenter 7.1.4, Oracle11g, PL/SQL, FastLoad, Mload, FastExport, Tpump, Teradata SQL assistant 7.0/6.1, Erwin 4.0

Confidential, Charlotte, NC

Teradata App DBA/ Production DBA

Responsibilities:

• Support Production, Test & Development environments for a large enterprise data warehouse project.
• Used highly tuned queriesthat facilitate action-taking or decision making in a time-sensitive environment by using Tactical queries.
• Took advantage of techniques such as request (query plan) caching and session-pooling by using Tactical queries.
• Create / Modify / Drop Teradata objects like Tables, Views, Join Indexes, Triggers, Macrosand Databases.
• Handled USER management requests such as creating new Users& Profiles, and Roles.
• Extensively used BTEQ scripts on UNIX to execute application specific scripts, transform data.
• Actively involved in designing the primary indexes, secondary indexes with the application team for tables.
• Done different types of Backup jobs such as Daily/Weekly/Monthly and Full/Online backup and PPI&Triggered based backup jobs in Netvault/Netbackup GUI Tool.
• Having good experience with Backup and Recovery using Teradata ARCMAIN in Net Vault.
• Granting & Revoking of Object Rights, System Rights on Databases / Users / Roles.
• Monitor Teradata Database using Teradata Viewpoint, Performance Monitor and Teradata Manager.
• Recommend users to improve the performance of the query by changing the Primary Index, use global temporary table, volatile table & derived table for intermediate results.
• Establish / recommend technical database administration standards, archiving strategy and security policies standards to ensure databases are compliant and optimized.
• Write, test and implement Teradata FastLoad, MultiLoad, FastExport and BTEQ scripts, DML and DDL.
• Does routine maintenance and supports the objects.
• Deformalized the logical data model (supplied by the data architect) for various reasons including performance, database constraints and storage needs.
• Monitor Database / Table Space Usage &Skewness at Database / Table / Vproc level
• Implement Partitioned Primary Indexes to improve performance of date range queries.
• Monitor and Abort Sessions for blocked, high CPU consuming, highly skewed and long running queries.

Environment: Teradata 13.1, TPT, InformaticaPowerCenter 7.1.4, Oracle11g, PL/SQL, FastLoad, Mload, FastExport, Tpump, Teradata SQL assistant 7.0/6.1,Erwin4.0,Teradata Administrator, PMON, NET VAULT/NETBACKUP, DBQL, ArcMain, ER-Studio, UNIX, BTEQ/BTEQWin.

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 queriesthat 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, resusage, 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, Michigan

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.

Confidential

Informatica Teradata DBA

Responsibilities:

• Created reports using SQL Server
• Provided high end design consultancy in all aspects of SQL Server 2000
• Checked the coding standards followed by peers of the team
• Prepared test reports and bug logs for the testing done
• Provide support to design/break fix issues in SQL Server 2000 and track to a closure
• Involved in data migration from Oracle to Teradata.
• Developed stored procedures, triggers and functions and added/changed tables for data extraction,transformation and loading.
• Tested and configured automated routine maintenance tasks like performance tuning, indexes and stores procedures, checked deadlocks and created scheduled jobs
• Used DTS to transfer files from Excel datasheets to SQL server database.
• Developed scorecards for the system using SQL Server reporting services
• Took part in data normalization process along with senior data base analyst
• Used SharePoint enterprise portal for hosting all the scorecards and reports
• Creation, manipulation and supporting the SQL Server Database
• Designed and optimized indexes, views, stored procedures and functions using T-SQL
• Writing database triggers, procedures, packages for applications
• Performed Database Normalization
• Handling database objects with Enterprise Manager and Query Analyzer.