Manager Data

Tej Teradata Architect/DBA *************@*****.***

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.

Database Design:

Worked with consultants on the Physical table design of all objects in the Enterprise Data

Warehouse as well as all production control DDL and DML operations. Analysis of the

business requirements and relational Logical Data Model analysis. Primary index

considerations for local AMP joins and redistribution issues.

Security Designed and maintained security level for users, roles, and profiles.

Tuning

Ensured all database objects are tuned for optimal performance using TD utilities such

as Priority Scheduler, TDQM, TD Manager features, and physical design techniques

(PPI, Join Indexes, Hash Indexes, Secondary Indexes, Triggers, Advanced Statistics,

etc Performed problem determination and resolution for database related problems

with analysis of QCD, Higa Macros, DBC Macros, and TD Manager features such as

Heartbeat queries and Trend analysis charts. Tuned Business Objects queries and

made recommendations to the Business Intelligence teams for Universe changes.

Created Stored Procedures and Macros for use with Reporting applications such as

Hyperion.

ETLDesign

Worked with ETL teams to develop ETL programs using ABInitio.

Modeling

Engaged in modeling and database design sessions for the logical implementation of

new entities for the Data Warehouse. Analyzed ERWIN models for efficient join and

usage patterns for proper physical database design with Primary and Secondary

Indexes.

Applications and Systems

Responsible for installing and maintaining the Teradata TTU software. Very Familiar

with the ‘Teradata at Your Service’ application to manage incidents, knowledge base,

and patch downloads. System integration and migration of PSF and TASM to ViewPoint.

Configuration and design of ViewPoint Workloads, filters, and throttles.

Technical Skills:

Tej Teradata Architect/DBA *************@*****.***

BTEQ, MultiLoad, FastLoad, FastExport, Tpump, Teradata

Teradata Utilities

SQL Assistant, Teradata Administrator, Teradata visual

explain 3.1 & PMON

Teradata SQL, SQL

Query Languages

ETL Tools Informatica, Ab initio

Erwin, Star Schema, Snowflakes Modeling

Data Modeling/Tools

Databases Teradata 12,13, DB2, Sql Server 2005, Oracle 9i, 10g,

UNIX, Windows XP/NT 4.0, Windows 2000 Server, Windows

Operating Systems

Vista, LINUX and Mainframe.

Data Warehousing Design, Data Modeling, Logical and

Methodologies

Physical Database Design

Professional Training/Certification

Appreciations:

1. Received client/Business appreciations.

2. Received certificate for Teradata Training.

3. Received employee excellence award.

Education:

• Bachelor of Science in Computer Science

Work Experience:

Sr. Teradata DBA/Lead DBA

June 2010 – Till date

Geisinger Health Plan,Danville PA

• 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

o

Backup and Recovery strategy

o

External Alerts and monitoring

o

Teradata host level utility usage

o

Environment: TD 13.10, Teradata Administrator, Teradata SQL Assistant, Viewpoint,

Teradata Arc main, Erwin, Oracle Data Integrator, UNIX.

Sr. Teradata DBA

June 2008 – June 2010

American Airlines, Irving TX

• 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 Manager,

Tej Teradata Architect/DBA *************@*****.***

PMON, Teradata Arc main, Erwin, Oracle Data Integrator, UNIX.

Teradata DBA

September 2004 – May 2008

Union Pacific Rail Road, NE

• 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 Main,

ER Studio.

Teradata DBA

December 2002 September 2004

Cognos, Tampa FL

• 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), Mload,

Tpump, Fastload, UNIX & Windows NT.

Teradata Developer/Dba

August 2001 – November 2002

Infosys, Chennai India

• 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

Contact this candidate