SUMMARY

• 6 + years of hands - on experience as Teradata DBA with in-depth understanding of design, implementation, administration and managing, Teradata databases.
• Performed Migrations from Oracle to Teradata as well as 32 bit to 64 bit systems.
• Fully conversant with all aspects of systems analysis, design and SDLC
• Optimization of Queries in a Teradata database environment
• Performed DBA tasks on Teradata Data Warehouse using indexing, table partitioning, and Collect Statistics to enhance performance of Systems.
• Conversant with Teradata Utilities like BTEQ, FASTLOAD, MULTIOAD, FASTEXPORT, ORA2TD, OLEDB, and AAMT to Migrate Data from Oracle to Teradata.
• Responsible for quality control and auditing of databases to ensure accurate and appropriate use of data.
• Performed Capacity Planning with inputs from Application owners.
• Worked with Erwin tool for logical and physical data modeling.
• Worked with Data Modelers, ETL staff, BI developers, and Business System Analysts in Business/Functional requirements review and solution design.
• Worked with Data Modeling based on Health care LDM, FSLDM from NCR Teradata
• Process oriented, focused on standardization, streamlining, and implementation of best practices.
• Design, implementation and administration of a robust backup plan and recovery techniques.
• Implemented Dual Active systems for mission critical applications, and ensured availability of system for the same.
• Strong experience with performing installations, upgrades, patches, system trouble shooting and optimizations
• Good team player with excellent technical and interpersonal skills. Pro-active, self-motivated and able to work independently as well as in team.
• Excellent Documentation and Process Management skills with an ability to effectively understand the business requirements to develop a quality product.
• Skilled communicator. Thorough in explaining complex IT knowledge to the subordinates, management team and functional team.

PROFESSIONAL EXPERIENCE

Teradata DBA

Confidential, Lansing, MI

Responsibilities:

• Worked closely with Data architects to design the logical and physical model of the Database.
• Used Teradata Utilities to ensure High System performance as well as High Availability
• Implementation of TASM for performance Tuning and Workload Management
• Usage of analyst tools like TSET, INDEX WIZARD, STATS WIZARD to improve performance
• Supported active data warehouse Teradata environment
• Worked with ERWIN tool for data modeling.
• Was responsible for delivering logical and physical Data models.
• Developed scripts for BTEQ,OLEDB,FLOAD,MLOAD 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.
• Used informatica to configure Dual active systems
• Created Teradata objects like Databases, Users, Profiles, Roles, Tables, Views and Macros.
• Knowledge of UNIX MP RAS Administration
• 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
• 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.
• Expertise in Query Analyzing, performance tuning and testing
• Interpret Explain Plans and collect statistics to improve performance of long running queries
• 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.
• Worked with Business Objects developers to ensure that generated SQL was optimized for Teradata.
• User administration and security
• 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,CA

Responsibilities:

• 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.
• 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.
• Used informatica to load data into EDW.
• 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
• 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.
• Configuring AMP’s to accommodate new users within a Teradata Node
• Upgraded older versions of Teradata through PUT utility.
• Analyzed performance after upgrade
• Worked on FSLDM to create physical data models.
• Performed BAR activities as and when required.
• Monitored user sessions
• Implemented security as per the Norms of the Company.
• Compression of Tables to minimize the space usage.
• Collection of Statistics to ensure confident optimizer.
• 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, River woods, 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
• Knowlede of UNIX MP-RAS Administration
• Used ETL tools like informatica, 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, Radnor, PA

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 Ksh 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: Oracle 8i, MS-Access, TOAD, Teradata Administrator, Teradata V2R5, Teradata SQL Assistant, Teradata Manager, SQL, UNIX and Windows NT, Autosys.

Junior Administrator for Oracle/Teradata Warehouse

Confidential

Responsibilities:

• 24 X 7 Production Oracle database support and administration
• Implemented RMAN backups full and incremental backups
• Used various AMP based utilities like VPROC manager, Lockdisp, Showlock, Qrysessn.
• Involved in the analysis and implementation of their system.
• Granted & Revoked Object Rights, System Rights on Databases / Users / Roles.
• Performed bulk data load from multiple data source (ORACLE 8i, legacy systems) to TERADATA RDBMS using BTEQ, Fastload, Multiload and TPump
• Performed Space Management for Perm & Spool Space.
• Involved in analysis of end user requirements and business rules based on given documentation and working closely with tech leads and analysts in understanding the current system.
• Collected statistics every week on the tables to improve performance.
• Developed unit test plans and involved in system testing.
• Created and administered RMAN catalog databases.
• Involved in developing UNIX shell scripts to automate and schedule the database backup jobs.
• On call support
• Supported data transfer operations - import/export, SQL*Loader
• Configured OEM for the databases created and managed database space issues andsetup jobs to gather statistics using OEM.
• Managing Database security and creating and assigning appropriate roles and privileges to users depending on the user activity.
• Active participation in all team meetings and group meetings to meet the business requirements.
• Ensured consistent data feeds from Oracle to Teradata Data warehouse.

Environment:-UX Itanium 64, Oracle 9.2.0.8, OEM, Teradata Warehouse