Sr. Teradata Dba Resume
Riverwoods, IL
SUMMARY
- Over 8 years of total IT experience in the Analysis, Design, Development, Testing, Implementation, Administration and Support of Database Systems in UNIX and Windows environments.
- Over 5+ years of experience in Teradata 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.
- Experienced in UNIX Shell scripting as part of file manipulation and text processing.
- 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.
- Design and Development experience in data warehouse modeling using Erwin and experience in Teradata Database Design (Physical and Logical).
- Excellent Programming experience in Teradata SQL, Stored Procedures and Macros.
- Expertise in Application Development with knowledge of full software development life cycle.
- 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)).
- Capable of working as an individual and also as a part of team.
TECHNICAL SKILLS
Tools: &Utilities: Teradata V2R6/12/13, Teradata Manager, Teradata Administrator, Teradata SQL Assistant, BTEQ, MLOAD, TPT, PMON, ArchMAIN, TASM, Tpump, ERWIN
Databases: Teradata V12/V2R6/V2R5, Oracle 9i/10g, DB2, MS Access, MS SQL Server 2005/ 2000
Languages: C, C++, SQL, Java, PL/SQL, COBOL, VB, Perl Scripting and Korn Shell Scripting.
Technologies: Data Warehousing, Rational Unified Process, SDLC, QALC, Manual Testing
Web and Application servers: HTML, DHTML, XML, JSP, J2EE, JSP, EJB, Web Logic, Web Sphere, Tomcat, IIS
Operating Systems: Windows 95/98/2000/2003/ XP/Vista/7, Mac OS, Sun Solaris 5.6, Unix-AIX, HP-UX, Linux
PROFESSIONAL EXPERIENCE
Sr. Teradata DBA
Confidential, Riverwoods, IL
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 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 and fast load.
- 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, Suse Linux, Shell Scripting, Teradata Administrator, Teradata SQL Assistant, Bteq, MlOAD, TPT, PMON, ArchMAIN, TASM,Tpump,NetBackup6.5,BTEQ,ERWIN
Sr. Teradata DBA
Confidential, Los Angeles, CA
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, 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, ARCHMAIN, TASM, Net vault, UNIX, Shell scripts.
Teradata DBA
Confidential, MD
Responsibilities:
- Configured Load Utilities like FLOAD, MLOAD
- Granted & Revoked Object Rights, System Rights on Databases / Users / Roles.
- Dealt with Incremental data as well Migration data to load into the Teradata.
- Performed tuning and optimization of complex SQL queries using Teradata Explain.
- Constant Testing of Source and Target after loading to ensure Consistency in the Data
- Worked on call to ensure system availability
- Implementation of TASM and Analyst Packs to identify the system variations and SQL trends.
- Moved Teradata Databases from UNIX-MP RAS to Linux SUSE 64 bit to increase performance.
- Worked with Logical and physical data models with help of Erwin.
- Wrote scripts for BTEQ, and other tools.
- Used Teradata Tools and Utilities and configured them to understand the System.
- Developed MLOAD scripts to load data from Load Ready Files to Teradata Warehouse.
- Worked on Teradata Queryman to validate the data in warehouse for sanity check.
- Performance Tuning of sources, Targets, mappings and SQL queries in transformations.
- Upgraded older versions of Teradata through PUT utility.
- Analyzed performance after upgrade
- Worked on FSLDM to create physical data models.
- Performed Back up and Recovery activities as and when required.
- Monitored user sessions
- Implemented security as per the Norms of the Company.
- Automated recollection of stats by shell scripting as well as STATS Wizard.
- Selection of Indexes when creating a Table.
- Recommendation of SI and JI to influence the Optimizer.
Environment: Teradata V2R6, TASM, Teradata Administrator, Teradata SQL Assistant, Teradata Manager, BTEQ, PMON, MLOAD, ARCHMAIN, UNIX, LINUX SUSE, Shell scripts.
Teradata DBA
Confidential, IL
Responsibilities:
- Worked with Data feeds to ensure consistency of data after migration.
- Analyzed Performance issues
- User administration-set up roles and profiles for users
- Worked towards high availability of the system
- Worked on Database Backups
- Used ETL tools like FLOAD MLOAD, TPT to feed data into EDW
- Tracking Process behavior with DBQL
- On Call Support
- Development of scripts for loading the data into the base tables in EDW using FastLoad, MultiLoad and BTEQ utilities of Teradata.
- Performed Space Management for Perm & Spool Space.
- Reviewed the SQL for missing joins & join constraints, data format issues, mis-matched aliases, casting errors.
- Granted & Revoked Object Rights, System Rights on Databases / Users / Roles
- Assist the Data Architect in the dimensional modeling.
- Implement index strategy for all Dimension and FACT tables
- Manage the database growth through Capacity planning and Predictive Analysis
- Review and sign-off any new database change request
- Provide mentoring and knowledge transfer to junior DBA’s
- Creating error log tables for bulk loading
- Shell Scripts to automate various routine jobs like tablespace check, Materialized view refresh, run monthly user status reports in database etc
Environment: Teradata V2R5, TASM, TPT, Teradata Administrator, Teradata SQL Assistant, Teradata Manager, BTEQ, PMON, MLOAD, ARCHMAIN, Net vault, Erwin Designer, UNIX, Shell scripts
Teradata DBA
Confidential, Cincinnati, OH
Responsibilities:
- Created Teradata objects like Databases, Users, Profiles, Roles, Tables, Views and Macros.
- Modified Databases, Users, Roles & Profiles, Views & Macros.
- Involved in Requirement gathering, business Analysis, Design and Development, testing and implementation of business rules.
- Development of scripts for loading the data into the base tables in EDW using FastLoad, MultiLoad and BTEQ utilities of Teradata.
- Performed Space Management for Perm & Spool Space.
- Reviewed the SQL for missing joins & join constraints, data format issues, mis-matched aliases, casting errors.
- Granted & Revoked Object Rights, System Rights on Databases / Users / Roles.
- Dealt with Incremental data as well Migration data to load into the Teradata.
- Have experience in tuning some batch BTEQ queries.
- Enhanced some queries in the other application to run faster and more efficiently.
- Data was extracted from Teradata, Processed/Transformed using JCL programs and loaded into Data Mart.
- Used various Teradata Index techniques to improve the query performance
- Used BTEQ and SQL Assistant (Query man) front-end tools to issue SQL commands matching the business requirements to Teradata RDBMS.
- Created series of Macros for various applications in TERADATA SQL Assistant.
- Performed tuning and optimization of complex SQL queries using Teradata Explain.
- Created several custom tables, views and macros to support reporting and analytic requirements.
Environment: Oracle8i,MS-Access, TOAD, Teradata Administrator, Teradata V2R5, Teradata SQL Assistant, Teradata Manager, SQL, MVC, JCL, Autosys.