Teradata DBA
Resume:
Om
Sr. Teradata DBA
********.***********@*****.***
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