Om

Sr. Teradata DBA

acokc0@r.postjobfree.com

510-***-****

Job Related Summary:

1. 8 years of experience in IT Industry.

2. 7 years of experience in Teradata DBA.

3. 4 years of experience in Performance tuning, Capacity planning and security.

4. 5 years of experience in UNIX/LINUX/PERL Scripting.

5. 5years of Experience in providing ETL & BI integration solutions.

6. 5 years of Experience in Data Modelling.

7. 2 years of Experience in Teradata development

8. Experience on a large & complex DWH implementations.

9. Good communication and interpersonal skills.

Summary:

10. Have 8 years of IT experience with mastering on Software Development Life Cycle, Detailed

Documentation, Implementation, Production Rollout and Change Control Managemnet.

11. Have Managerial and Leadership experience, Team Building spirits, Interpersonal and Problem

solving skills; and possesses commendable oral and written communication skills.

12. Very strong knowledge on Teradata architecture, data models, worked on large MPP database of

capacity of 1+Petabytes running on Enterprise Servers & Appliances .

13. Worked with Data Modeling Tools like Erwin, ER-Studio, and VISIO, have Demonstrated

experience in Logical (LDM) and Physical Data Model (PDM) design process in Star, Snowflake

Schema and 3NF’s.

14. Worked on administrating DBObjects, maintaining databases, controlling standards for central and

local database.

15. 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.

16. Very strong knowledge on Viewpoint 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.

17. 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.

18. Expertise in using Visual Explain, Index wizard, Statistics wizard to tune the bad queries and

analyze the plans implement the recommendations to gain the performance.

19. 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.

20. Expertise in writing Scripts using Teradata parallel load/Unload Utilities like: BTEQ, Teradata

SQL Assistant, Tpump, FastLoad, MultiLoad, OLE Load, FastExport, TPT.

21. Experience in Database Programming, SQL Programming (Stored Procedures, Functions,

Macro and Triggers) for faster transformations and automation.

22. Experienced as on call DBA support (24X7) as part of a scheduled rotation with other team

members.

23. Automated and scheduled the jobs using UNIX shell scripting, AutoSys, and Control_M

24. Expertise with Cluster and All amp Backup and Restore operations of Teradata Databases.

25. Good Understanding of Teradata system tools such as Vprocmanager, Teradata Mulitool,

DBScontrol, locks, scandisk, checktable and packdisk.

26. Good understanding of Teradata internals such as cylinder index, master index, blocks and sectors.

27. Strong MVS knowledge, JCL skills and over all IBM mainframe expertise.

1

Technical Skills

Operating Systems: Sun Solaris, Red Hat Linux,MVS, Windows 2000 Server, Windows Server

and Windows OS, MAC OS.

Languages C, C++,SQL, T-SQL, PL/SQL, Teratata SQL

Databases: TD13.10/V12/V2R6/V2R5,Oracle 8i/9i, dBase, FoxPro,

Backup and Recovery: VERITAS NetBackup, Teradata Arcmain, Taragui.

System Monitoring: Teradata Viewpoint, PMON, Teradata Manager

Teradata Utilities: BTEQ, Fast Load, Multi Load, TPT, FEXP, TPUMP, OLE Load

ETL Tools: Informatica 8.6, Data Stage.

Reporting: Business Objects 3.1/3.0, Cognos 8, OBIEE

Education:

• Bachelor of Engineering in Computer Science, JNTU. India.

Certification:

• Teradata 12 Certified Professional

www.teradata.com/Certification

Verification # : ZXE15NBKKNVQ2XB4

Professional Experience

JPMORGAN CHASE

Wilmington, DE MAY 2013 -

CURRENT

Teradata System DBA

Technical Environment: Teradata database 13.10, Teradata TARA GUI, Net Backup, Teradata

appliance 2650, Teradata Administrator, Teradata View Point, PDCR,

Teradata Manager, PMON, Teradata SQL Assistant, Mload, Fload, Fexp,

Tpump, TPT, UNIX/LINUX and Data Mover

Responsibilities:

• Dedicated support engineer Teradata Database administration.

• 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 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.

• 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 modeling 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.

• 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

• Data Mover Job creation with DataMoverPortlet in Viewpoint.

2

Sutter Health, Sacremanto, CA October 2011 – March

2013

Teradata System DBA

Technical Environment: Teradata database 13.10, Teradata TARA GUI, ERwin 7.3, Net Back,

Teradata Administrator, Teradata View Point, PDCR, Teradata Manager,

PMON, Teradata SQL Assistant,Mload, Fload, Fexp, Tpump, TPT and

UNIX/LINUX

Responsibilities:

• Dedicatedsupport engineer Teradata Database administration.

• 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.

• 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.

• Strong expertise in Physical Modeling with knowledge to use Primary, Seconday, PPI( Partetion Primary

Indexes) and Join Index.

• Exposure to full project implementation lifecycle ( requirements, functional specifications, design,

development, test and training).

• 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.

• 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.

• Coordinating with Backup Administration Team for taking regular Cluster/Full backup based on the

requirement, using tools like Veritas NetBackup 5.1.

• Identifying the suitable objects for archiving consulting with business users and writing jobs for Archiving

to use the existing space efficiently; this includes the staging and archive data.

State Of Michigan-Lansing,MI January 2011- October 2011

Teradata System DBA

Technical Environment: Teradata database 13.10, Teradata Administrator, ERWin 7.3, Teradata View

Point, PDCR, Teradata Manager, PMON, Teradata SQL Assistant, Mload,

Fload, Fexp, Tpump, TPT, UNIX/LINUX and Windows NT

Responsibilities:

• 24X7 System Administration and Support.

3

• Coordinate and Deploy Products and Applications and Patch upgrades in Production, Client Test,

Development and QA systems.

• Execute Security Audits and Lockdowns to enforcePolicies and regulations.

• Participate in Cross Functional Teams, Change Control, Resource 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.

Intergraph, India June 2007 - December

2010

Teradata Application DBA

Technical Environment: Teradata database V2R5, Teradata Administrator, Teradata Manager,

PMON, Index Wizard, Static Wizard, Visual Explain Teradata SQL Assistant,

UNIX and Windows NT

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 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.

• Strong expertise in Physical Modeling with knowledge to use Primary, Seconday, PPI( Partetion Primary

Indexes) and Join Index

• Worked with 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.

4

Contact this candidate