PROFESSIONAL SUMMARY:

• Total 14 years of IT Experience, with 14 Years of experience Teradata Database Administration and leading the team with onshore and offsite model.
• Experienced on Global Data Ware Housing & Business Intelligence, worked with cross - functional team environment with people from multiple business units, vendors, countries and cultures.
• Very strong knowledge on Teradata architecture, data models currently working on TD 13.10 database of capacity of 200+ terabytes running enterprise 5555 servers.
• Experienced working on Teradata 2650 appliance.
• Extensively worked on Teradata view point, Teradata PDCR to monitor systems, setting the alerts and implementing TASM and also to generate various performance and system related reports
• Very strong knowledge on working with data integration solutions using Informatica 9x.
• Worked with Data Modeling Tools like Erwin, ER-Studio, and VISIO, has Demonstrated experience in Logical and Physical Data Model design process in Star, Snowflake Schema and 3NF’s.
• Worked on administrating DBObjects, maintaining databases, controlling standards for central and local database.
• Expertise using WinDDI/Teradata Administrator for managing Databases, Users, Tables, Indexes, statistics, managing permissions( Roles & Profiles), addressing the user issues such as resetting passwords, unlocking user ID’s etc.
• Expertise working with Teradata View Point to monitor the systems.
• Very strong knowledge on PMON 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.
• Extensive experience on Teradata Work Load management concepts like TASM, Worked with various user groups and developers to define TASM Workloads, developed TASM exceptions, implemented filters and throttles as need basis.
• Used PDCR tool kit to generate various system & performance reports.
• Worked on Teradata system tools such as Vprocmanager, scandisk, checktable and packdisk.
• Good understanding of Teradata internals such as cylinder index, master index, blocks and sectors
• Strong working knowledge on DBQL and Resusage tables and making use of the information stored in these tables to generate various performance and system related reports.
• Expertise in using Teradata Manager in monitoring the system, setting the alerts and generating various performance reports.
• Expertise in writing Scripts using Teradata parallel load/Unload Utilities like: BTEQ, Teradata SQL Assistant, Tpump, Fastload, Multiload, OLE Load, FastExport, TPT.
• Experience in Database Programming, SQL Programming (Stored Procedures, Functions, Macro and Triggers) for faster transformations and automation.
• Worked on Security Administration & Desktop Software Management for Teradata Tools and utilities (TTU).
• Worked on LDAP authenticated Teradata Environment.
• Experienced as on call DBA support (24X7) as part of a scheduled rotation with other team members.
• Developed UNIX shell scripts to develop drive programs and to run Data stage Jobs.
• Strong MVS knowledge, JCL skills and over all IBM mainframe expertise.
• Experienced with DB2 RDBMS systems.
• I possess the ability to think outside the box and come up with creative and unique ideas in order to maximize opportunities. I am an excellent problem solver and seek to build solid relationships with my peers, partners, and other colleagues.

TECHNICAL SKILLS:

Teradata Utilities: BTEQ, MultiLoad, FastLoad, FastExport, Tpump, Teradata SQL Assistant, Teradata Administrator, Teradata visual explain 3.1 & PMON

Query Languages: Teradata SQL, SQL

ETL Tools: Informatica, Ab-initio

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

Databases: Teradata 12,13, DB2, Sql Server 2005, Oracle 9i, 10gOperating Systems

Appreciations: Received client/Business appreciations.

Received for Teradata .: Received employee excellence .

WORK EXPERIENCE:

Sr. Teradata DBA/Lead DBA

Confidential, Danville-PA

Responsibilities:

• Creating different environments.
• Creating different databases for different purposes.
• Requirements granting, Privileges and access rights by delivering new and high quality solutions to clients
• Used Teradata administrator and viewpoint tools for monitoring and controlling the system.
• Performance tuning, Monitoring and reporting Review system utilization by user.
• As Teradata DBA, involved in end to end DBA activities life cycle of different applications.
• Refreshed the data by using fast export and fastload utilities.
• Very strong on Teradata SQL query optimization techniques like: EXPLAIN feature, COLLECTSTATISTICS option, Secondary Indexes (USI, NUSI), Partition Primary Index (PPI), Volatile and global temporary tables etc.
• Using a logical database model and application specifications to create/analyze an efficient physical database design.
• Participate in the evaluation and recommendation of DBA tools, and new DBMS technologies
• Configured LDAP authentication for all 13 Teradata systems to leverage authentication by firm wide directory and eliminate multiple passwords for same user id on multiple systems.
• Created a custom scripts to run backups in parallel, check for long running backups, avoid conflicts, progress updates in database, alerts via email and page.
• Document DBA Procedures, Guidelines, alerts actions.
• Work with data modelers to address design concerns.
• Reviewed Operations DBA activities and provided valuable input to improve efficiencies:
• Viewpoint alerts
• Backup and Recovery strategy
• External Alerts and monitoring
• Teradata host level utility usage

Environment: TD 13.10, Teradata Administrator, Teradata SQL Assistant, ViewpointTeradata Arc main, Erwin, Oracle Data Integrator, UNIX.

Sr. Teradata DBA

Confidential, Irving- TX

Responsibilities:

• On-site dedicated sole support engineer Teradata Database administration.
• Migration of Data from DB2 to Teradata warehouse.
• Worked on COBOL,JCL,VSAM,DB2,TSO,FILEAID,XPEDITER,CA-INTERTEST,CHANGEMAN,QMF, SPUFI, ABENDAID.
• Develop customized programs and scripts using Perl, UNIX, SQL and scripting languages as needed.
• Customize Projects to the specific needs of the customer site and manage interacting with PMO.
• Troubleshoot end user technical and functional issues strictly following PMI model - Change Controls with approvals from appropriate stakeholders and upper management. Escalate complex issues to appropriate Project Leads and ensure timely resolution of the requests.
• Responsible for Customer Relations and End-user Support of the assigned site.
• Responsible for day to day administration of Teradata databases.
• In charge of quality control and auditing of databases to ensure accurate and appropriate data usage.
• Create users, establish roles, create database structures and understand how to get Teradata database to perform well.
• Work with developers to promote their code and solve day to day issues.
• Produced documentation and procedures for best practices in Teradata development and administration.
• Used Erwin data Modeler for Data Modeling and using Star Schema, Snowflake Schema, Fact and Dimension tables, Physical and Logical data modeling for Data Warehousing and Data Mart.
• Developed pro- active processes for monitoring capacity and performance.
• Worked with various user groups and developers to define TASM Workloads, developed TASM exceptions, implemented filters and throttles as needed basis.
• Monitoring database space, Identifying tables with high Skew, working with data modelling team to change the Primary Index on tables with High skew
• 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.
• Involved in database upgrades, TTU client software upgrade.
• 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, and Resusage.
• Writing UNIX shell scripts for automating common tasks
• Proven team player, effectively collaborate with cross functional teams, hard working and quickly adapt to demands of high pressure trading and brokering environment.

Environment: TD 13.10, Teradata Administrator, DB2, Teradata SQL Assistant, Teradata ManagerPMON, Teradata Arc main, Erwin, Oracle Data Integrator, UNIX.

Teradata DBA

Confidential, NE

Responsibilities:

• 24X7 System Administration and Support High Availability of Systems & Services with 99.99% uptime.
• Tuning for Database performance.
• Coordinate and Deploy Products and Applications and Patch upgrades in Production, Client Test, Development and QA systems.
• Execute Security Audits and Lockdowns to enforce Policies and SEC’s regulations.
• Configure and Monitor systems using Sun NetConnect, Disk and Storage Management using VERITAS Volume Manager.
• Participate in Cross Functional Teams, Change Control, Resource & ITO Alarms Review meetings.
• Analyzing data quality, data organization, metadata, and data profiling, and documenting quality of source data to be used within the warehouse.
• Create users, establish roles, create database structures and understand how to get Teradata database to perform well.
• Addressing day to day users issues such as resetting passwords, unlocking used id’s, working on permission issues.
• Monitoring bad queries, aborting bad queries using PMON, looking for blocked sessions and working with development teams to resolve blocked sessions.
• Tuning bad queries by analysing explain plans, visual explain to understand optimizer plans, created various NUSI index as needed bases, also used Statistics wizard, QCD, Index Wizard for collecting stats and recommending indexes.
• Work with developers to promote their code and solve day to day issues.
• Produced documentation and procedures for best practices in Teradata development and administration.
• Developed pro- active processes for monitoring capacity and performance.
• Worked with various user groups and developers to define TASM Workloads, developed TASM exceptions, implemented filters and throttles as needed basis.
• Monitoring database space, Identifying tables with high Skew, working with data modelling team to change the Primary Index on tables with High skew.

Environment: Teradata, TD Administrator, Teradata manager, PMON, DBScontrol, DBQL, ARC MainER-Studio.

Teradata DBA

Confidential, Tampa-FL

Responsibilities:

• Architect Database Design, Create, Maintain Data Warehouse, Database Maintenance, Reorganizations and Upgrades.
• Developed Disaster Recovery Plan, Implementation and Business Continuity plan.
• To monitor query run times using Teradata Performance Monitor.
• Worked with the DBA and Database developers to convert the functional specification to technical specification which is the DDL generation.
• Developed Shell Scripts for creating /dropping of table and indexes of performance for pre and post session management
• Worked with the DBA and developers to identify performance issues of the ODS population and work together to resolve the issues
• Done analysis which led to impact analysis and resolving them.
• Involved in deciding the Standards and Compliancy for the Database.
• Consolidation of the models to the repository, also consolidation to the main subject area model, identifying the impacts and correcting them.

Environment: Teradata SQL Assistant, Power designer, Microsoft Excel, Acquisition (internal process), MloadTpump, Fastload, UNIX & Windows NT.

Teradata Developer/Dba

Confidential

Responsibilities:

• Provide application support by investigating problems and attending to Client requests.
• Loading business data into Teradata data warehouse.
• Writing Reconciliation Queries as per Business Requirements.
• Involved in Performance Tuning of Queries.
• Created Reports based upon the user requirements like daily, weekly, Yearly, Quarterly and Monthly wise.
• Involved in the development scripts for data loading through Fast Export, Fast Load, Multi Load, BTEQ utilities.
• Created Procedures to load data from view into tables and executed it using BTEQ Session.
• Developed BTEQ scripts to add the logic to get the related data from the source database.
• Communication with Architect and principal programmers to get the clarifications on transformation rules.
• Worked closely with the Teradata DBA and the Source DB teams to get the clarifications in optimizing SQL scripts

Environment: Teradata SQL Assistant, Power designer, Microsoft Excel, Acquisition (internal process), Mload,