SUMMARY

• 9+ years of total IT experience in the Analysis, Design, Development, Testing, Implementation, Administration and Support of Database Systems in UNIX and Windows environments.
• 9+ years of experience in Database Administration, used all Teradata utilities (Multiload, FastLoad, FastExport, BTEQ, WINDDI, Queryman, TD Manager, PMON, TASM, SQL Assistant, DBQL, Visual explain, Index wizard, RESUSAGE, Macro’s, DBC. Tables, TPUMP) extensively.
• Certified as a Teradata Professional, Teradata Database Administrator.
• Experienced working as an Operations/Application DBA.
• Thorough knowledge on database space management.
• Efficient in creating various users, roles, profiles, views, macros based on requirement.
• Hands on with Teradata Viewpoint.
• Extensive knowledge on Data mover and Unity Director.
• Experienced on working with the backup and restore.
• Experienced in Disaster Recovery Management.
• Design and Development experience in data warehouse modeling using Erwin and experience in Teradata Database Design (Physical and Logical).
• 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)).
• Experienced in designing the semantic model thereby assisting the developers to carry out the semantic development.
• Good Experience on Teradata Parallel Transporter (TPT) to load multiple files with the sole aim of distributing the workload and eliminating the bottle necks in the data load process.
• Experienced in UNIX Shell scripting.
• Performing Cluster and All amp Backup and Restore operations of Teradata Databases.
• Good experience with Teradata query performance and tuning using Resusage data, DBQL, collect statistics and secondary indexes.
• Monitoring Teradata perm space for availability and monitor Teradata CPU/Load utilization.
• 5+ years of experience in UNIX/ LINUX flavors.
• 4+ years of hands-on experience Data Processing experience in designing and implementing Data mart applications using ETL tools.
• Excellent Programming experience in Teradata SQL, Stored Procedures and Macros.
• Expertise in Application Development with knowledge of full system development life cycle (SDLC).
• Capable of working as an individual and also as part of a team.

TECHNICAL SKILLS

Tools: &Utilities: Erwin Data Modeler, Teradata V2R6/12/13, Teradata Manager, Teradata Admin, Teradata SQL Assistant, BTEQ, MLOAD, TPT, PMON, ArcMAIN, TASM, TPUMP.

Databases: Teradata V12/V2R6/V2R5, Oracle 9i/10g, DB2, MS SQL Server 2005

Languages: C, C++, SQL, Java, PL/SQL, COBOL, VB, Perl and KSH Scripting.

Technologies: Data Warehousing, Rational Unified Process, SDLC, QALC

Web & App servers: HTML, DHTML, XML, JSP, J2EE, JSP, EJB, Web Sphere, Tomcat, IIS

Operating Systems: Windows 2000/2003/XP/7, Mac OS, Sun Solaris 5.6, AIX, HP-UX, Linux

PROFESSIONAL EXPERIENCE

Confidential, River woods, IL

Sr. Teradata DBA

Responsibilities:

• Creating various tables, views, macros, stored procedures, databases, roles, users and profiles as needed basis via EURC process.
• Implementing secondary indexes on columns that are frequently used to improve performance.
• Working with the development teams to create join indexes on frequently used join conditions.
• Working on explain plans to understand the optimizer plan and then change the code as part of performance tuning.
• Periodically checking the skewness of the tables that have a large volume of data.
• Working on TASM rule set to set various throttles and manage the workload.
• Preparing DBQL reports to check for the top CPU consuming queries.
• Preparing various PDCR reports to find the root cause of various incidents.
• Involved in various deployments and outages.
• Managing database space, allocating new space and moving space from database to another database based on requirement using EURC.
• Verifying the code that is getting deployed into the environment and making sure everything adheres to the Teradata best practices thereby eliminating the bad code.
• Implementing DDL changes in NON-PROD and PROD environments though ITSM.
• Continuously monitoring the Teradata Viewpoint to check the system performance and aborting the bad queries or sessions that are consuming a lot of CPU resources based on the priority assigned.
• Managing the Disaster Recovery system and making sure it is in sync with the source system.
• Worked on Data mover port let to move data from source environment to target environment.
• Worked on Unity Director to deploy objects into the source and the disaster recovery system on a parallel basis.
• Worked on automation deployments using UNIX shell scripting.
• Providing a 24/7 on call support and handling various incidents based on priority using HP Service Manager.
• Worked with Teradata Global Service Center (GSC) to resolve high priority incidents.
• Monitoring the backup jobs and restoring the data as needed using TARAGUI.

Environment: Teradata SQL Assistant 14.10, BTEQ, SuseLinux, Teradata Administrator, Teradata Viewpoint, AtanaSuite, Putty, TARAGUI, NetBackup.

Confidential, Cincinnati, OH

Sr. Teradata DBA

Responsibilities:

• Developed physical data model and implemented the data objects for the transportation BI team.
• Developed the physical model for finance dashboards for the Cost Optimized Supply Chain (COSC) project.
• Developed the physical model, created the objects and implemented the objects for LOS (level of service).
• Developed the physical model, created the objects and implemented the objects for Transportation Finance Dashboard.
• Developed the physical model, created the objects and implemented the objects for Collect Vendor Dashboard.
• Extracted data from Oracle using data stage to load into data warehouse repository.
• Created Entity relationships diagrams and multidimensional data models, reports and diagrams for transportation analysis.
• Used Model Mart of Erwin for the effective model management of sharing, dividing and reusing model information and design for productivity improvement.
• Created LOS (level of Service)model which analyze the impact of level of service for the vendor, facility and region types.
• Created a relationalmodel and dimensional model for online services such as on-time pick up and on-time delivery.
• Developed the physical data models using Erwin data modeler.
• Collaborate with data architects for data model management and version control.
• Collaborate with logical data modeler and data architects for physical data model design.
• Conduct data model reviews with project team members.
• Capture technical metadata through data modeling tools.
• Create data objects(DDL)
• Enforce standards and best practices around data modeling efforts.
• Ensure data warehouse and data mart designs efficiently support BI and end user.
• Developed new tables in Teradata EDW: landing, staging, foundation, semantic.
• Coordinated with ELT team for Extract data from data sources, transform, and load into EDW.
• Developed sematic view design.

Environment: Teradata 14/13.10, Viewpoint, Teradata Manager, Shell Scripting, Teradata Administrator, Teradata SQL Assistant, Bteq, MlOAD, TPT, PMON, TARA, TASM, PDCR, Tpump, NetBackup 6.5,BTEQ, ERWIN.

Confidential, Minneapolis, MN

Teradata DBA/Data Modeler

Responsibilities:

• Developed Logical and Physical model using Erwin Data Modeler.
• Designed the semantic model by capturing the business view of information to assist the developers carry out the semantic development.
• Helped the development teams to build the semantic views based on business requirement by helping them with the join conditions and suggesting them to create join indexes on as needed basis.
• Creating databases, users in dev, test and production environments.
• Designed, developed, optimized and maintained database objects like tables, views, indexes, soft RI, common procedure macro etc. Testing and implementation of systems.
• Worked on Teradata Parallel Transporter (TPT) to load multiple files using a single script in order to distribute the workload load on the load server thereby eliminating the bottlenecks.
• Creating roles and profiles as needed basis. Granting privileges to roles, adding users to roles based on requirements.
• Managing database space, allocating new space to database, moving space between databases as needed basis.
• Assist developers, architects in designing, architecture, development and tuning queries of the project. This included modification of queries, Index selection, and refresh statistic collection.
• Proactively monitoring bad queries, aborting bad queries using PMON, looking for blocked sessions and working with development teams to resolve blocked sessions.
• Proactively monitoring database space, Identifying tables with high skew, working with data modeling team to change the Primary Index on tables with High skew.
• Worked on moving tables from test to production using Fastexport and Fastload.
• Extensively worked with DBQL data to identify high usage tables and columns.
• Implemented secondary indexes on highly used columns to improve performance.
• Good experience with query performance and tuning. Extensively used explain plans, visual explain to understand optimizer plans, created various NUSI index as needed bases, also used Statistics wizard, Index Wizard for collecting stats and recommending indexes.
• Developed various DBQL reports such as top 10 queries with high CPU, Top 10 queries with high
• Implemented various Teradata alerts using Alert facility in Teradata Manager. Involved in setting up alters to page DBA for events such as node down, AMP down, too many blocked sessions, high data skew etc.
• Used Teradata Manager collecting facility to setup AMP usage collection, canary query response, spool usage response etc.
• Worked on capacity planning, reported disk and CPU usage growth reports using Teradata Manager, DBQL, Resusage
• Worked on exporting data to flat files using Teradata FEXPORT.
• Written several Teradata BTEQ scripts to implement the business logic.
• Populated data into Teradata tables by using Fast Load utility.
• Created Teradata complex macros and Views and stored procedures to be used in the reports.

Environment: Teradata V12/V13, Teradata Manager, SuseLinux, Shell Scripting, Teradata Administrator, Teradata SQL Assistant, Bteq, MLOAD, TPT, PMON, ArcMAIN, TASM, Tpump, NetBackup6.5, BTEQ, Erwin Data Modeler.

Confidential, MD

Sr. Teradata DBA

Responsibilities:

• Developed complete Normalized Data Warehouse with Tier - 4 Architecture.
• Developed Logical and Physical model using Erwin.
• Creating databases, users in dev, test and production environments.
• Designed, developed, optimized and maintained database objects like tables, views, indexes, soft RI, common procedure macro etc. Testing and implementation of systems.
• Creating roles and profiles as needed basis. Granting privileges to roles, adding users to roles based on requirements.
• Managing database space, allocating new space to database, moving space between databases as needed basis.
• Assist developers, DBAs in designing, architecture, development and tuning queries of the project. This included modification of queries, Index selection, and refresh statistic collection.
• Proactively monitoring bad queries, aborting bad queries using viewpoint and PMON, looking for blocked sessions and working with development teams to resolve blocked sessions.
• Proactively monitoring database space, Identifying tables with high skew, working with data modeling team to change the Primary Index on tables with High skew.
• Worked on moving tables from test to production using fast export, fast load and TPT.
• Extensively worked with DBQL data to identify high usage tables and columns.
• Implemented secondary indexes on highly used columns to improve performance
• Good experience with query performance and tuning. Extensively used explain plans, visual explain to understand optimizer plans, created various NUSI index as needed bases, also used Statistics wizard, Index Wizard for collecting stats and recommending indexes.
• Implemented Single Sign on and LDAP authentications as per the Norms of the Company
• Developed various DBQL reports such as top 10 queries with high CPU, Top 10 queries with high I/O using PDCR and SYS MGMT.
• Implemented various Teradata alerts using Alert facility in Teradata Manager and Viewpoint. Involved in setting up alters to SMS DBA for events such as node down, AMP down, too many blocked sessions, high data skew etc.
• Used Teradata Manager and Viewpoint collecting facility to setup AMP usage collection, canary query response, spool usage response etc.
• Worked on capacity planning, reported disk and CPU usage growth reports using DBQL, Resusage .
• Worked on exporting data to flat files using Teradata FASTEXPORT.
• Automated collection of Stats using Shell scripts.
• Written several Teradata BTEQ scripts to implement the business logic.
• Populated data into Teradata tables by using Fast Load utility.
• Created Teradata complex macros and Views and stored procedures to be used in the reports.

Environment: Teradata 14/13.10, Viewpoint, Teradata Manager, Shell Scripting, Teradata Administrator, Teradata SQL Assistant, Bteq, MlOAD, TPT, PMON, TARA, TASM, PDCR, Tpump, NetBackup 6.5,BTEQ,ERWIN.

Confidential, Cincinnati, OH

Teradata DBA/Developer

Responsibilities:

• Supported active data warehouse Teradata environment.
• Worked with ERWIN tool for data modeling.
• Used Teradata Utilities to ensure High System performance as well as High availability.
• Worked with Data feeds to ensure consistency of data after migration.
• Implementation of TASM for performance Tuning and Workload Management.
• Usage of analyst tools like TSET, INDEX WIZARD, and STATS WIZARD to improve performance.
• Worked as a team with database administrators to determine indexes, statistics, and performed table partitioning the data warehouse, in order to improve performance for end-users.
• Used Explain facility to tune existing Teradata query processes to optimize for performance.
• Monitored user sessions.
• Developed scripts for BTEQ, FLOAD, MLOAD, FEXPORT and all other tools.
• Also responsible to develop ETL scripts for continuous streaming of data.
• Worked on and developed scripts for CronTAB to automate the monitoring tasks.
• Created Teradata objects like Databases, Users, Profiles, Roles, Tables, Views and Macros.
• Security administration including creating and maintaining user accounts, passwords, profiles, roles and access rights.
• Worked on Space considerations and managed Perm, Spool and Temp Spaces.
• Expertise in Query Analyzing, performance tuning and testing.
• Partitioning of primary indexes to increase performance.
• Designed data feeds to load Teradata tables from Oracle tables or from flat files, using Fastload, Multiload, and SQLPlus. Designed physical data mart schema optimized for Teradata.
• Tracking process behavior with DBQL.
• Involved in troubleshooting the production issues and providing production support.
• Using BTEQ for IMPORT/EXPORT.
• Optimal usage of Fastload to load empty tables.
• Using Multiload to insert, update, and delete records.
• Using Tpump for real time data loads.
• Worked with backup team in setting up Optimal Backup strategies .Worked as a single point of contact for all Backup issue and monitoring. Involved in scheduling Backups and archives and restoring data when required.

Environment: Teradata 12, Teradata Administrator, Teradata SQL Assistant, Teradata Manager, BTEQ, MLOAD, TPT, PMON, ArcMAIN, TASM, Net vault, UNIX, Shell scripts.

Confidential

Teradata DBA

Responsibilities:

• Created Teradata objects like Databases, Users, Profiles, Roles, Tables, Views and Macros.
• Physical and logical design of the dimensional model using ERWIN.
• Security administration including creating and maintaining user accounts, passwords, profiles, roles and access rights.
• Capacity planning including review and analysis of usage, capacity, and performance data.
• Performed Space Management for Perm & Spool Space.
• Performance trending and analysis including recommending indexing strategies, partitioning, compression opportunities and statistic collection planning.
• Reviewed the SQL for missing joins & join constraints, data format issues, mis-matched aliases, casting errors.
• Used various AMP based utilities like VPROC manager, Lockdisp, Showlock, Qrysessn.
• Creating roles and profiles as needed basis. Granting privileges to roles, adding users to roles based on requirements.
• Performed bulk data load from multiple data source (legacy systems) to TERADATA RDBMS using BTEQ, Fastload, Multiload and TPump
• Performed tuning and optimization of complex SQL queries using Teradata Explain.
• Used FastLoad for loading into the empty tables.
• Analyzed initial workload to understand the impact of various designs prior to having populated tables using TSET.
• Created a cleanup process for removing all the Intermediate temp files that were used prior to the loading process.
• Involved in troubleshooting the production issues and providing production support.
• Collected statistics every week on the tables to improve performance.

Environment: Teradata 13,Teradata Manager, Suse Linux, Shell Scripting, Teradata AdministratorTeradata SQL Assistant, Bteq, TPT, PMON, ArchMAIN, TASM, Tpump, Net Backup 6.5, BTEQ, ERWIN.