SUMMARY

• Around 8 years of experience in IT and Teradata administration, designing database solutions with Architecture.
• Extensive experience in Administration and maintenance of Dev, Stage, prod and standby databases for DSS and Data Warehousing environments.
• Hands on experience in Teradata RDBMS using FASTLOAD, MULTILOAD, TPUMP, FASTEXPORT, Teradata Parallel Transporter (TPT), Teradata SQL and BTEQ Teradata utilities.
• Excellent knowledge in moving database objects between Teradata systems and Teradata Database.
• Highly skilled in scheduling a cluster archive in parallel to improve archive and recovery performance.
• Excellent Programming experience in Teradata SQL, Stored Procedures and Macros.
• Experience in performance trending and analysis including recommending indexing strategies, partitioning, Join Indexes, compression opportunities and statistic collection planning.
• Expertise in Dynamic Workload and Resource Management using TDQM.
• Proficient in complex Data Warehousing concepts including in Data mart and Data Mining using Dimension Modeling (Star Schema, Snow - Flake schema Design and Normalized structures (3NF)).
• Expertise in Query Analyzing and Performance tuning.
• Proficient in performance analysis, monitoring and SQL query tuning usingEXPLAIN PLAN and Collect Statistics.
• Experienced with handling RESUsage and DBQL data.
• Expertise working with Teradata Viewpoint in monitoring Teradata system, looking for bad queries and long running queries, monitor the sessions to identify the blocked sessions and work with the development team to resolve session blockings, aborting the poor performing SQL’s and sessions requested by users.
• Worked on Building Teradata System from the Scratch, setting up Roles and Profiles, Priority Scheduler, TASM etc.
• Hands on experience in monitoring and managing varying mixed workload of an active data warehouse using various tools like Teradata Workload Analyzer, Teradata Dynamic Workload Manager and Teradata Manager (TASM).
• Experience in Designing and implementing disaster recovery plans.
• Experienced in archiving, restoring and recovering data on Teradata using ARC utility, Net Vault and TARA Net Backup.
• Excellent Experience withdifferent indexes (PI, SI, JI, AJIs, PPI)and Collect Statistics.
• Knowledge in UNIX Shell Scripting(SH (Bourne Shell) & KSH (Korn Shell)), Skills in backend testing using SQL Queries
• Confident to handle multiple modules at a time, setting priorities, plan/organize, mentor and carry out assigned tasks in an efficient manner and confident in serving the best results.
• High expertise in cross database coding/design skills( Oracle, Teradata and SQL Server)
• Expert knowledge in DBS control and settings.
• Excellent Coordination skills in working with cross functional team.
• Committed team player with ability to communicate at all levels and perform production support administration tasks including proactive monitoring, troubleshooting, tracing, backup, recovery and on-call support to ensure availability and performance requirements are met.

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

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

Data Modeling/Tools: Erwin, Star Schema, Snowflakes Modeling

Databases: Teradata V2R5/12/13, Oracle.

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

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

PROFESSIONAL EXPERIENCE

Confidential, Jackson, MS

Teradata Consultant

Responsibilities:

• Responsible and involved in Setting up the Teradata database, users, Roles and Profiles.
• Determining database perm, spool and temp space. Allocating and moving space between Teradata databases/users using Teradata Administrator.
• Monitoring bad queries, aborting bad queries using Viewpoint, looking for blocked sessions and working with development teams to resolve blocked sessions.
• Applied data protection including Transient Journal, Fallback and RAID.
• Resolved deadlocks and DBQL maintenance creating an archive DBQL SYSTEM MGMT database.
• Defined Permanent space limits both at the database and user level for different business scenarios.
• Performed online archives by selecting the Full Online, Full Multi-Stream On-Line backups using Net Backup.
• Worked with various user groups and developers to define TASM Workloads, developed TASM exceptions, implemented filters and throttles as needed basis.
• Assigning roles based on security layers in a controlled access environment.
• Implement database backup and recovery strategy based on data volatility and application availability requirements which will protect the business from unexpected hardware and software failures.
• Implementing the Alerting mechanism for the Production system using the Alerting service both to SNMP, and SMTP.
• Capacity planning including review and analysis of usage, capacity, and performance data.
• Took crash dumps and TSETs for the Teradata technology to analyze for certain crashes.
• Highly experienced in working with Teradata support team for Opening and tracking incidents for Teradata issues or any upgrades.
• Provided performance tuning and physical and logical database design support in projects for Teradata systems.
• Extensively Used TPT for load and update operation instead of fastload and multiload reducing the Script overhead.
• Improved Optimizer performance on database and applications using EXPLAIN, collect statistics, index selection, workload balancing, increase sessions, etc.
• Designed Security model based on the business model and enforced the security through roles.
• Worked with Teradata System Engineers and Support team to fix Node level issue.
• Installed patches to BAR server and Viewpoint.
• Used extensively Teradata Analyst Pack such asTeradata Visual Explain,Teradata Index WizardandTeradata Statistics Wizard.
• Achieved high performance using TPT for load/Unload operation.
• Addressing day to day users issues such as resetting passwords, unlocking UserIDs and working on permission issues.
• Designed DDLs and efficient PIs along with Identity Keys for efficient data distribution.
• Extensively used the new features of 14.xx versions like Row level security and enhanced Statistics, etc.
• Extensively used UNIX shell scripting for automating common tasks.
• Performance tuned and optimized various complex SQL queries.
• Highly successful in testing fail over nodes and vprocs migration.
• Experience in creating replication groups, adding extracts and sorts.
• Worked withExplainCommand and identified Join strategies, issuesand bottlenecks.
• Developed statistics macros and automated to run based on the frequency.
• Used Erwin for data profiling, data patterns and analyzing data for designing right Primary Index.

Environment: Teradata 14.10, Teradata Administrator, Teradata SQL Assistant, Viewpoint, BTEQ, MLOAD, TPT, ARCMAIN, TASM, Net Backup, UNIX, Shell scripts.

Confidential, Richmond, VA

Teradata DBA

Responsibilities:

• Performance trending and analysis including recommending indexing strategies, partitioning, compression opportunities and statistic collection planning.
• Profile, Role management of database users.
• Physical implementation of LDM for the Warehouse, including selection and implementation of Indices, MPPIs, Semantic layer, and Performance AJI structures.
• Current Space usage analysis and recommendation regarding the utilization of space.
• Statistics Analysis and selection and implementation of the system wide object demographic Statistics.
• Compression analysis and implementation.
• User sessions analysis, resource usage analysis and implementation of the required Workloads.
• Weekly planning and implementation of Backup and Archiving Activities using Net Backup utility.
• Extensively used the Explain Plan and Collect Stats option in tuning the SQl query.
• Identified potential bottlenecks with user queries from the aspects of query writing, skewed redistributions, join order, optimizer statistics, and physical design considerations (PI/USI/NUSI/JI etc) etc.
• Usage of Teradata Explain and Visual Explain to analyze and improve query performance.
• Implementing the Teradata manager Services to enable the system wide resource collection, and reporting.
• Implementing the Alerting mechanism for the Production system using the Alerting service both to SNMP and SMTP.
• Upgrading the Teradata manager services to Viewpoint.
• Performing database health checks and system health checks on a regular time frame.
• Analyzed initial workload to understand the impact of various designs prior to having populated tables using TSET.
• Automated recollection of stats by shell scripting as well as STATS Wizard.
• Selection of Indexes when creating a Table and recommendation of SI and JI to influence the Optimizer.
• Writing UNIX shell scripts for automating common tasks
• Reduced storage space, improved I/O reads by using TD compression.
• Dealt with Incremental data as well Migration data to load into the Teradata.
• Enhanced some queries in the other application to run faster and more efficiently.
• Overall Operational Support for a 24/7.
• Used Change control procedures for logging, implementation, and closing for the releases.

Environment: Teradata 13.10, SQL, BTEQ, TPT, Fast Load, Mload, Fast Export, and Teradata SQLA, Viewpoint, TASM, Erwin4.0, Tivoli maestro, Oracle 9i/10g, Solaris 8, Windows XP/2000.

Confidential, Manhattan, NY

Teradata DBA

Responsibilities:

• Granted & Revoked Object Rights, System Rights on Databases / Users / Roles.
• Constant Testing of Source and Target after loading to ensure Consistency in the Data
• Worked on call to ensure system availability
• Implementation of TASM and Analyst Packs to identify the system variations and SQL trends.
• Moved Teradata Databases from UNIX-MP RAS to Linux SUSE 64 bit to increase performance.
• Worked with Logical and physical data models with help of Erwin.
• Use SQL to query the databases and do as much crunching as possible in Teradata, using very ComplicatedSQLQuery optimization(explains plans, collect statistics, data distribution across AMPS, primary and secondary indexes, locking, etc) to achieve better performance.
• Wrote scripts for BTEQ, and other tools.
• Presently implementing theTDQMto manage the resources efficiently and to give user better response times by eliminating bad queries entering the system and automatic demotion of certain workloads.
• DesignedDDLsand efficient PIs along with Identity Keys for efficient data distribution.
• Used Teradata Tools and Utilities and configured them to understand the System.
• Developed MLOAD scripts to load data from Load Ready Files to Teradata Warehouse.
• Worked on Teradata Queryman to validate the data in warehouse for sanity check.
• Performance Tuning of sources, Targets, mappings and SQL queries in transformations.
• Upgraded older versions of Teradata through PUT utility.
• Created several TD systemusage reportsfor monitoring and capacity planning and for the higher management.
• Analyzed performance after upgrade.
• Assisted Developers with coding and effective Join issues.
• Performed Backup and Recovery activities as and when required.
• Monitored user session.
• Automated recollection of stats by shell scripting as well as STATS Wizard.
• Selection of Indexes when creating a Table.
• Recommendation of SI and JI to influence the Optimizer.

Environment: Teradata V2R6, TTU 12, TASM, Teradata Administrator, Teradata SQLA, Teradata Manager, BTEQ, PMON, MLOAD, ARCHMAIN, UNIX, LINUX SUSE, Shell scripts.

Confidential, Somerset, NJ

Teradata DBA

Responsibilities:

• Maintenance ofAccess RightsandRole Rights,Priority Scheduling,Dynamic Workload Manager,Database Query Log,Database Administrator,Partitioned Primary Index (PPI), Multi-Value Compression Analysis,Usage Collectionsand Reporting ofResUsage, AmpUsage, Security Administration Setup etc. and leading a team of developers for workaround with different users for different, complicated and technical issues.
• Modification of views on Databases,Performance Tuningand Workload Management.
• Performed application level DBA activitiescreating tables, indexes, monitored and tuned TeradataBETQscripts using Teradata Visual Explain utility.
• PerformedSpace ManagementforPerm & Spool Space.
• Analyzing data and implementing themulti-value compressionfor optimal usage of space.
• Query Analysisusing Explain for unnecessaryproduct joins,confidence factor, join type, order in which the tables are joined.
• CollectedMulti-Column Statisticson all thenon-indexed columnsused during the join operations & all columns used in the residual conditions.
• Granted & RevokedObject privileges to the DatabasesUsers / Roles.
• Very good understanding ofDatabase Skew, PPI,Join Methods and Join Strategies, Join Indexes including sparse, aggregate and hash.
• Used extensivelyDerived Tables, Volatile TableandGTTtables in many of the ETL scripts.
• Tuning of Teradata SQL statements using Explain analyzing the data distribution amongAMPsandindexusage, collect statistics, definition ofindexes, revision of correlated sub queries, usage ofHash functions, etc…
• Flat files are loaded into databases usingFastLoadand then used in the queries to do join.
• Developed new reports for the end-users and maintained current ones. All the DSS and the Legacy systems are stored in Teradata Tables
• Use SQL to query the databases and do as much crunching as possible in Teradata, usingvery complicatedSQL Query optimization(explains plans, collect statistics, data distribution acrossAMPS, primary and secondary indexes, locking, etc) to achieve better performance
• Use PMON, Teradata manager to monitor the production system during online day.
• Excellent experience inperformance tuningand query optimization of the Teradata SQLs.
• UsedUNIXshell scripts for automating tasks forBTEQand other utilities.
• Performance tuning, monitoring and index selection while usingPMON, TeradataDashboard,Statistics wizardandIndex wizardand Teradata Visual Explainto see the flow of SQL queries in the form of Icons to make the join plans more effective and fast.
• Analyze root causes for failedbatch jobs.
• Documentation of scripts, specifications and other processes

Environment: Teradata V2R5/R6, TASM, Teradata Administrator, Teradata SQL Assistant, Teradata Manager, BTEQ, PMON, MLOAD, ARCHMAIN, UNIX, LINUX SUSE, Shell scripts.

Confidential

Teradata Application DBA, Developer

Responsibilities:

• Involved in Create / Modify / Drop Teradata objects like Tables, Views, Join Indexes, Triggers, Macros, Procedures, and Databases.
• Managed user level access rights through the roles.
• Built the Profiles to manage the spool space and User logging through ASE.
• Creating MLOAD and FLOAD scripts.
• Extensively worked in data Extraction, Transformation and Loading from source to target system using BTEQ, FastLoad and MultiLoad.
• Involved in writing scripts for loading data to target data warehouse for BTEQ, FastLoad and MultiLoad.
• Creating Data Stage jobs.
• Capacity Management and Space forecasting.
• Enforcing the System Security policies and setting the standards.
• Written different scripts for monitoring, reporting and alerting purpose.
• Build/Documenting the Standards and best practices for ETL/DBA practice.
• Did the set up of development database environment for new development for ready to use.
• Released Utility Locks of Multiload& dropping Multiload related tables for the aborted jobs.
• Worked closely Teradata RLDM (Retail Logical Data Model) for EDW implementation and built the flexible semantic layer applications on RLDM design.
• Involved writing the scripts using Teradata SQL as per requirements
• Involved in Unit Testing and Preparing test cases.
• Optimized performance on database and applications using EXPLAIN, collect statistics, index selection, workload balancing, increase sessions, etc.
• Involved in Peer Reviews.
• Developing BTEQ Scripts to find the delta data (changed data) in the staging phase.
• Worked on performance tuning as and when required on the project.
• Worked extensively on joins, sub queries and set operations.
• Loading of SCD type 2, aggregated tables.

Environment: Teradata V2R5/R6, TASM, Teradata Administrator, Teradata SQL Assistant, Teradata Manager, BTEQ, PMON, MLOAD, ARCHMAIN, UNIX, LINUX SUSE, Shell scripts.