SUMMARY

• Over 8+ years of experience in requirement gathering, system analysis, application design, development, testing, configuration management, client/user support services.
• Proficient in Database Administration activities such as installation, database creation, sizing, backup and recovery, performance tuning and capacity planning.
• Hands on experience in BAR activities like Scheduling and monitoring of data backup. Proficient in archive and restore on both the environments NetBackup and NetVault.
• Setting up the policies/schedules using NetBackup console and TARA.
• Good knowledge about the Teradata Architecture and Concepts.
• Involved in Data Migration between Teradata, MS SQL server, DB2 and Oracle
• Well versed with Win XP/2000 Advanced Server /98/95/NT, UNIX, LINUX, Korn shell
• Has experience with installation and configuration along with Upgrades and Debugging.
• Proficiency with Database Query Log (DBQL) Query Performance Tuning, TSET, Teradata Active System Management (TASM), Protegrity Data Encryption Technologies.
• Hands on experience in using Teradata Data Mover to copy data and objects such as tables and statistics from one system to another.
• Good experience in Data warehousing applications, responsible for Extraction, cleansing, Transformation and Loading of data from various sources to the data warehouse.
• Experience in Business Analysis and Data Analysis, User Requirement Gathering, User Requirement Analysis, Data Cleansing, Data Transformations, Data Relationships, Source Systems Analysis and Reporting Analysis.
• Having solid experience with NPARC, which handles the data movement between two diff systems using a Named Pipe Archive.
• Configured Teradata TARA server for handling the Multistreams backup jobs.
• Good Knowledge on Stored Procedure, Triggers, Batch Referential Integrity, Indexes and other features of Teradata.
• Good experience on Atanasuite Tool (Like SyncTool, Compression Tool, DeltaTool) Expertise in using Visual Explain, Index wizard, ARCMain, Statistics wizard to tune the bad queries and analyze the plans implement the recommendations to gain the performance.
• Expertise in using Teradata SQL Assistant, Teradata Manager, Teradata Viewpoint Teradata Performance Monitor, Teradata ARC, Teradata Administrator and data load/export utilities like BTEQ, Fast Load, Multi Load, Fast Export and exposure to Tpump on UNIX/Mainframes environments.
• Provided applications support in Teradata, Sqlserver environment. Creating Tables, Stored Procedures, Views, Triggers, Rules, Defaults, macros and functions
• Very strong on Teradata SQL query optimization techniques like: EXPLAIN feature, COLLECT STATISTICS, Secondary Indexes (USI, NUSI), Partition Primary Index (PPI), Volatile and global temporary tables etc.
• Creating Join Indexes, SI and STATS collection, avoiding bad joins etc.
• Extensive knowledge on Dimensional Data modeling, Star Schema/snowflakes schema, Fact and Dimension tables
• Highly experienced in SQL performance tuning/SQL optimization and debugging of ETL process.
• Highly proficient in writing loader scripts like BTEQ, MLoad, FLoad and Fast Export
• Extensively utilized Business intelligence reporting Tools such as Business Objects 5.X/6.X.
• Acquaintance of different Schemas (Star and SnowFlake) to fit reporting, query and business analysis requirements.
• In - depth experience in scripting using Unix Shell.
• Exceptional in problem solving, logical and analytical abilities.
• Analytical and Systematic thinking ability with a goal and solution oriented approach.
• Worked on data analysis and data validations and preparing Unit Test Cases.
• Performed unit testing and integration testing for the developed data load process.
• Excellent interpersonal and communication skills, and is experienced in working with senior level managers, business people and developers across multiple disciplines.

PROFESSIONAL EXPERIENCE

Teradata DBA

Confidential, San Francisco, CA

Responsibilities:

• Involved in gathering business requirements, logical/physical modelling peer review discussions, data sourcing and data transformation, data loading, SQL and performance tuning
• Implement the physical data model received from Data Modelling team.
• Responsible for the generation of DDL scripts from Physical Data Model.
• Implementing compression across tables in the system and analyzing the impact.
• Responsible for producing Daily, Weekly and Monthly system health reports.
• Run different monitoring scripts to know the health of database and pin-point suspected issues and fix it before it happens to fail.
• Work towards database health reporting and capacity management.
• Automation of various processes though shell script to maintain the stability of the system.
• Used Teradata utilities fastload, multiload, tpump to load data.
• Wrote BTEQ scripts to transform data.
• Used Teradata utilities fastload, multiload, tpump to load data.
• Wrote BTEQ scripts to transform data. Wrote Teradata Macros and used various Teradata analytic functions.
• Performance tuned and optimized various complex SQL queries.
• Responsible for the Implementation of DDLs across the environments i.e. DEV, Test and PROD.
• Creating Databases, Users, Roles, Profiles and Account String for new batch and reporting IDs; also helping the business community to have the roles created by subject areas.
• Preparing the cross reference sheet and update the same as and when the new application gets deployed into the warehouse.
• Monitoring the Performance using Teradata Viewpoint. Notifying the batch and report users running the problem queries.
• Providing them with the consultation for changing the queries and possible improvement areas.
• Monitoring the system for stable system health across all the environments and take necessary action when required.
• Analysis of database loading and data access frequency and design process for collect stats.
• Developed the process for statistics collection which has removed the overhead after proper scheduling frequency.
• Responsible for Teradata code review i.e. ensuring the code going in LIVE is following the standards and not violating the data warehousing standards and provide feedback to DEV team.
• Preparing the best practices for usage of LOAD utilities such as FASTLOAD, MLOAD and FASTEXPORT.
• Understand the business processes, business rules and calculations involved.
• Identifying problems with the ETL processes and providing performance improvement suggestions to Ops team.
• Moving space across databases, taking backups, assigning account strings and determining spool allocation for new users.
• Analyzing the performance issues using the PDCR Reporting tool kit and looking at the performance impacted attributes for Production system.
• Also suggesting the changes in the business queries in order to avoid the unwanted resource utilization in terms of I/O and CPU.
• Workload management, TASM tuning, priority scheduling and capacity planning.
• Implementing compression across tables in the system and analyzing the impact.
• Periodically checking various inactive users on the DB and making sure they are handled.
• Analyze the queries with the help of PDCR Toolkit and fix the bad queries as and when required.
• Also define the additional stats, indexes or suggest the physical design change.
• Tuning the queries for better performance and also reduce skewness to improve overall system performance.
• Responsible to perform the additional performance improvements like creating the Join Indexes or NUSI, PPI etc.
• Building the most effective strategy for archiving the small subset of the data using the Partition Primary Index.
• Application Management for different projects.
• Identify poorly performing queries in production and consult with developers to resolve.
• Prefer someone with working knowledge of TASM and how it impacts the BI users/applications.
• Help create and maintain operational documentation to support the solution in a production environment.

Environment: Teradata 13.10/14.10 , Teradata SQL Assistant, Teradata Administrator, Teradata Utilities, Mload, Fastload, FastExport, BTEQ, Teradata Manager, Teradata Viewpoint, AtanaSuite Tool.

Teradata DBA

Confidential, Round Rock, TX

Responsibilities:

• Implemented system level and application level tuning and supported the application development teams for database needs and guidance using tools and utilities like explain, visual explain, PMON, ViewPoint, DBC views.
• Implemented new functionality/technology to business problems and managed development and production database environments with emphasis on security, availability and performance.
• Responsible for support production Teradata data warehouse. Validating that development teams and other users follow programming standards.
• Also provided database services in compliance with all audit and regulatory requirements.
• Administered Teradata Servers across the globe, monitor the performance of databases and make tuning changes, researched and evaluated alternative solutions related query performance and recommend the most cost effective design solutions.
• Responsible for Patch upgrades, performance monitoring, responding to Alerts, tuning, creating appropriate Indexes, and creating Incidents with Teradata and assistance/follow up with the CSR.
• Developed Shell Scripts, Stored Procedures and Macros in order to automate to run based on the frequency.
• Involved in production upgrade from TD 1 .10. Actively participated in various pre and post-upgrade activities.
• Performed query optimization and assisted ETL developers and users by analyzing DBQL data, explain plan and join strategy and Partitioning large tables to improve performance of sqls.
• Performing database health checks and system health checks on a regular time frame.
• User session's analysis, resource usage analysis and implementation of the required Workloads.
• Proficient with day to day DBA activities like creating Databases/Users/Tables/Views/Roles/Profiles etc., Viewpoint monitoring, Access grants, Load support/assistance such as resolving the deadlock issues, creating the Join Indexes and SI, STATS collection, avoiding bad joins etc.
• Reviewing the DDL/DML before it goes into TEST/PROD. Discuss/Review with the DEV team from the initial stages of the design, data model and understanding the business needs in order to choose the Indexes and other Architect things that need to be taken care.
• Responsible for the migration activities under the qualified environments.
• Set up and implement backup/recovery and security strategies, setting up the policies/schedules using NetBackup console and TARA.
• Analyzing sessions with for high spool usage, high CPU usage, high disk usage, and high skew etc. when alerts are received.

Environment: Teradata 13.10/14.10 , Teradata SQL Assistant, Teradata Administrator, Teradata Utilities, Mload, Fastload, FastExport, BTEQ, Teradata Viewpoint, BAR NetBackup

Teradata DBA/Developer

Confidential, Austin, TX

Responsibilities:

• Involved in gathering business requirements, logical modelling, physical database design, data sourcing and data transformation, data loading, SQL and performance tuning.
• Managing work flow priorities and maintaining high visibility with our clients and providing thought leadership externally and within the organization.
• Incorporated the new physical database structures into the existing database environments.
• Optimizing high volume tables (Including collection tables) in Teradata using various join index techniques, secondary indexes, join strategies and hash distribution methods.
• Automating Faster incoming file process to load into Teradata staging using BTEQ, Fast Load and then loaded into MLoad by concatenating files on the basis of table name
• Design, create and maintain Teradata Databases, Users and regular tuning of physical database objects (Tables, Views, Macros, Triggers and Stored Procedures) to support normalized and dimensional models.
• Developing Data Extraction, Transformation and Loading jobs from flat files, Oracle, SAP, and Teradata Sources into Teradata using BTEQ, FastLoad, MultiLoad and stored procedure.
• Design of process oriented UNIX script and ETL processes for loading data into data warehouse.
• Teradata performance tuning via Explain, PPI, AJI, Indices, collect statistics or rewriting of the code.
• Designing Archival Jobs, considering archival resources like the number of Media Servers, tapes, various limiting factors of Transmit/receive of data to the media.
• Educated the team on how to utilize the Teradata visual tools like Teradata Viewpoint, Database query language (DBQL), TDQM, Visual explain etc.,
• Being a Production DBA responsible for the smooth functioning of the system.
• The responsibilities included Job and Load monitoring (using PMON); also produce a RCA (root cause analysis) for failed jobs.
• Responsible for Performance Tuning of BTEQs and Teradata SQL statements. This includes reading the explain plan, analyze the data distribution among AMPs, index usage, secondary indexes, partition primary indexes, collect statistics, join strategies, unnecessary product joins, no confidence, join type, data format, type casting and aliases.
• Coding using Teradata Analytical functions, BTEQ SQL of TERADATA, write UNIX scripts to validate, format and execute the SQLs on UNIX environment
• Interact with business users and source system IT teams to define, agree and document incoming data mapping specifications.
• Working with ETL leads to formulate ETL approach and appropriately uses Teradata Tools and Utilities.
• Worked on complex queries to map the data as per the requirements.
• Populate or refresh Teradata tables using Fast load, Multi load & Fast export utilities for user acceptance testing and loading history data into Teradata.
• Identify poorly performing queries in production and consult with developers to resolve. Prefer someone with working knowledge of TASM and how it impacts the BI users/applications.
• Help create and maintain operational documentation to support the solution in a production environment.
• Helping development team for any Teradata related issue.
• On-Call Production support.
• Mentoring the Teradata team.
• Documenting and tracking the project related issues.

Environment: Teradata V2R13, Teradata SQL Assistant, Teradata Administrator, Teradata Utilities, Mload, Fastload, FastExport, BTEQ, Teradata Manager, PMON, Teradata Viewpoint.

Teradata DBA

Confidential, Cypress, CA

Responsibilities:

• Involved in DBA activities in the tests, such as creation of users, spool, temporary, permanent space.
• Checking the tables skewing, table compression, and Index recommendations.
• Used Teradata Manager& Administrator to Monitor and Manage Teradata Databases.
• Performed application level DBA activities creating tables, indexes, monitored and tuned Teradata BTEQ scripts using Teradata Visual Explain utility.
• Suggested some tuning of DBS control parms.
• Designing Archival Jobs, considering archival resources like the number of Media Servers, tapes, various limiting factors of Transmit/receive of data to the media in Netvault.
• Capacity planning and proactive monitoring to meet performance and growth requirements on PDCR Database.
• Monitoring Production system whenever in need and controlling Online and Batch jobs.
• Converted DB2 Logical data models into Teradata Logical and Physical database mode
• Interacted with Clients, Data Modeler and Data Analyst to develop the Logical& Physical Design for tables.
• Performed bulk data load from multiple data source SQL SERVER, LEGACY SYSTEM to TERADATA RDBMS using BTEQ, Fastload, Multiload, and TPump.
• Extensively used Teradata system Priority Schedule in controlling the load of the system.
• Worked on exporting data to flat files using Teradata FEXPORT.

Environment: Teradata V2R5.0, Informatica, Oracle 9i, Business Objects 6.x, XML, MS PowerPoint, TOAD, Unix, Win NT 4.0.

Teradata Developer

Confidential

Responsibilities:

• Experience using Teradata Manager to monitor and manage Teradata database.
• RDBMS resource utilization.
• Creating alert policies for monitoring database space, average disk usage etc.
• Monitor database and periodic performance tuning.
• Killing the long running queries and tuning the queries using explain plan and Visual explain.
• Tuning the queries using collect statistics and statistics wizard.
• Creating secondary indexes based on statistics collection using index wizard.
• Manage user access and implements/ensures security requirements are met.
• Design, creating and tuning physical database objects (tables, views, indexes) with Users developers' support.
• Monitoring Database / Table Space Usage
• Populate or refresh Teradata tables using Fast load, Multi load & Fast export utilities for user Acceptance testing and loading history data into Teradata.
• Exporting objects from one database to another database
• Did performance tuning, including collecting statistics, analyzing explains & determining which tables needed statistics & secondary indexes.
• Increased performance by 35-40% in some situations.
• Daily Space Management Report at the database level.
• Worked on Optimizing and Performance tuning on targets, sources, mappings, and sessions to increase the efficiency of session.
• Performed tuning of database and SQL queries.

Environment: Teradata V2R3.0, Oracle 9i, Informatica, UNIX.