SUMMARY

• DBA with Over 7 years of progressive IT experience in implementation of Data Warehousing projects as a Teradata DBA
• 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 Etnterprise.

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.
• Performed Materialization on Custom views.
• 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.
• 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.
• Expertise in performing 1 AMP or 2 AMP operations.
• Manage Teradata Database using Teradata Administrator, Teradata SQL Assistant and BTEQ.
• 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.
• 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 pdcrinfo for database space, tablesize, CPU utilization, user information, skewed queries, etc.
• Analyze DBQL entries to troubleshoot high consuming CPU and highly skewed queries.
• Used the GoldenGate TDM platform to implement several solutions that enable significant improvements to business intelligence and reporting.
• 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, Erwin 4.0, Teradata

Confidential, Phoenix, AZ

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, Macros, 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.
• Expertised in performing 1 AMP or 2 AMP operations.
• Used GoldenGate to actively load for real-time data feeds.
• Manage Teradata Database using Teradata Administrator, Teradata SQL Assistant and BTEQ.
• 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.
• Denormalized 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.
• 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 pdcrinfo for database space, tablesize, CPU utilization, user information, skewed queries, etc.
• Analyze DBQL entries to troubleshoot high consuming CPU and highly skewed queries.
• Used the GoldenGate TDM platform to implement several solutions that enable significant improvements to business intelligence and reporting.
• 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, Erwin 4.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, SQL Assistant, 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.
• Developed stored procedure to collect stats 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.
• 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.