PROFESSIONAL SUMMARY:

• Over 8+ years of IT experience in Database Designing, Change/Release Management and Teradata Administration building all phases of Enterprise Data Warehouse.
• Experience as Teradata Administrator for managing regular DBA activities like Create Database, Users, Tables, Views, macros, Procedures, checking the tables skew, profiles, roles, grant/revoke permissions, space management (spool, temporary, permanent space), compression, troubleshooting the failure jobs.
• Proficient in Teradata Database Design (Physical and Logical), Application Support, Performance Tuning, Optimization, User & Security Administration, Data Administration and setting up the environments.
• Monitoring Teradata CPU/Load utilization, Space Management and System Health Trend periodically for the future enhancements and pipeline projects.
• Worked on Teradata View point, Teradata PDCR to monitor the systems and also to generate various performance and system related reports.
• Experience as On - Call DBA Support (24X7) as part of a scheduled rotation with team members.
• Involved in Data Migrations between Teradata, MS SQL Server, DB2 and Oracle.
• Programming experience in Teradata SQL, Stored Procedures, Macros and Triggers.
• Used most efficient way of data and DDL Backups and Environment refreshes.
• Responsible for the design and implementation of DW Dimensional Model Architecture using Join Indexes and Partitioned Primary Indexes to achieve and exceed the desired performance.
• Supported in the DR Releases to sync the objects between Prod and DR and generating a report.
• Used Data Mover in submitting the DM Jobs using the standard DM template to sync the data in Prod & DR.
• Used TARAGUI for the BAR operations of the Teradata Databases and also monitored the jobs.
• Enabled & Disabled TASM rule sets during outages/maintenance schedules. Also to define TASM Workloads, TASM exceptions, filters and throttles as needed basis.

TECHNICAL SKILLS:

Database: Teradata 15.10, Oracle 10g/9i/8i, Microsoft SQL Server

Tools: & Frameworks: Teradata SQL Assistant, BTEQ, Teradata Viewpoint, Teradata Administrator, Teradata Dynamic Workload Manager, Unity Director, Data Mover, TSET, Priority Scheduler, Teradata Index Wizard, Teradata Statistics Wizard, Teradata Visual Explain, MultiLoad, FastLoad, Fast Export, Tpump, SQL*Plus, Peregrine Service Center, EURC (End User Request Center, ITSM (Information Technology Service Management), Informatica Power Centre, Informatica Metadata Manager, Manta

Microsoft Management Studio: Active Batch, AutoSys, Control M

Languages: C, C++, Java, SQL, PL/SQL

Backup Server: TARAGUI Backup/Restore, Teradata ARC, Symantec NetBackup.

Operating Tools: Microsoft Windows, UNIX, Linux

PROFESSIONAL EXPERIENCE:

Confidential, Nashville, Tennessee

Teradata DBA

Responsibilities:

• Teradata Database Administration and resolving tickets/issues through committed SLA’s.
• Implemented Teradata Security on Database access, Control, Monitor and System-enforced security features based on user groups.
• Performance Tuning, SQL query optimization and code analysis.
• Prepared environment container scripts for specific application projects & deploying them.
• Managed database space, allocating new space to database, moving space between databases as needed.
• Built monthly, weekly CPU/Space Usage Growth Reports and provided recommendations.
• Granted and Revoked object rights on databases/users/roles per the access layer architecture.
• Live server monitoring and tract killer queries for blocked sessions and high CPU consuming sessions/users & worked with developers and end users to resolve them.
• Participated in Data Migrations between Production & DR systems.
• Participated in On-call and weekend support responsibilities.
• Worked with Informatica team and Business Objects team in testing their connection to Teradata.
• Created new ETL, Analyst, Reporting, DBA, Architect roles and profiles.
• Created access matrix for management purpose, to track rights for different profiles through different roles.
• Application databases created in Dev and assigned appropriate privileges on the objects to different roles.
• Enabled Access logging and DBQL logging in DEV, UAT following Teradata best practices.
• Monitored Database / Table Space Usage & Skewness at Database / Table / Vproc level.
• Assist developers to write DDL code following best practices.
• Review DDL code requests following some of the DDL standards and perform the deployments.
• Reviewed the SQL for missing joins & join constraints, Stats, miss-matched aliases, casting errors.
• Worked closely with end users to understand and resolve issues.

Environment: Teradata 15.10, Teradata Administrator, Teradata SQL Assistant, Viewpoint, TASM, TARAGUI, Symantec NetBackup, HPSM, Active Batch, SharePoint.

Confidential, Philadelphia, PA

Teradata Analyst

Responsibilities:

• Analysis of complex SQL scripting and lineage within Informatica Metadata Manager.
• Review BTEQ scripts being used to load data tables and confirm the lineage is matching how the BTEQ scripts are developed.
• Report discrepancies discovered through analysis and the suggested resolution.
• Documenting all the validated issues including missing lineages, bteq’s and clearly explaining to developers.
• Performing the validations in UAT, Prod & making sure both the systems are in sync.
• Confirm the objects are one-time load tables or Incremental tables based on the analysis for missing lineages.
• Installed all Teradata DEV, UAT and PROD Catalogs in Informatica Metadata Manager to perform data lineage analysis.
• Configure the properties and the necessary files into the Manta directories.
• Establish and maintain end-to-end data lineage accurately reflecting UAT, PRODUCTION processes and data flows in Manta.
• Drive data analysis meetings for data migration from external data sources, and documenting data conversion requirements.
• Retrieve all the involved BTEQ’s of a target lineage object for the migration purpose from DEV to UAT and UAT to PROD.
• Write SQL code on the audit columns to confirm if it’s an initial load or incremental load.
• Validating the no. of Bteq's under each database in IMM lineage between Dev, UAT and Prod.
• Work with Manta technical support team and raise tickets for any issues/blockers.
• Worked on the validation status documents & reporting to manager on regular basis.
• Followed the agile methodology & attending daily 15 mins scrum calls to synchronize activities and create a plan for the next 24 hrs.

Environment: Teradata 15.10, Teradata Administrator, Teradata SQL Assistant, Informatica Metadata Manager, Manta, Tableau, JIRA, SharePoint, BOX.

Confidential, Newark, Delaware

Teradata DBA Lead

Responsibilities:

• Monitoring the EURC (End User Request Center) Queue and solving the requests before the SLA.
• Participated in the Data Migration (DDL Reviews and Implementations) activities between Development and Production environments thorough standard ITSM Process.
• Support 24/7 On-Call/backup responsibilities as part of a scheduled rotation with other team members and solving p1/p2/p3/p4 tickets before they get breached.
• Monitor the Shared Mailbox regarding the end user questions/issues and working with them.
• Manage Teradata Database using Teradata Administrator, Teradata SQL Assistant and BTEQ.
• Create / Modify / Drop Teradata objects like Tables, Views, Join Indexes, Triggers, Macros, Procedures, Databases, Users, Profiles and Roles.
• Monitor Database / Table Space Usage & Skewness at Database / Table / Vproc level.
• Monitor and Abort Sessions for blocked, high CPU consuming, highly skewed and long running queries.
• Using the DBQL and Access Log to monitor the database log.
• Managing database space, allocating new space to database, moving space between databases as needed basis.
• Monitor backup results and resolve/troubleshoot failed database backups.
• Use Teradata Explain to analyze and improve query performance.
• Execute Diagnostic Help stats for session for queries to find missing stats on tables.
• Granting & Revoking of Object Rights, System Rights on Databases / Users / Roles.
• Performed the validations of the deployments.
• Collect Statistics on NUPIs/USIs/NUSIs/non-indexed join columns/small tables for better performance of queries.
• Supported in the DR releases to sync the objects between Prod and DR and generating a report.
• Supported in several Teradata Expansion releases performing Validations, making necessary profile changes and resolving password issues.
• Supported DR releases to sync objects between Prod and DR and generating a report.
• Submitted, Enabled and started DM Job.
• Monitored logs of failed DM jobs & troubleshoot DM jobs using DM repository framework.
• Generated DM reports with sync issues between PROD & DR.

Environment: Teradata 14.10, Teradata Administrator, Teradata SQL Assistant, Viewpoint, TASM, TARAGUI, Symantec Netback up, Subversion, Unity Director, Data Mover, Informatica, Tableau, ITSM, EURC, Peregrine Service Center, Password Vault, SharePoint.

Confidential, Bloomington, IL

Teradata DBA

Responsibilities:

• Understanding the specification and analyzed data according to client requirement.
• 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
• Worked on exporting data to flat files using Teradata FEXPORT.
• Worked exclusively with the Teradata SQL Assistant to interface with the Teradata.
• 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.
• Did error handling and performance tuning in Teradata queries and utilities.
• Creating error log tables for bulk loading.
• Actively involved in the TASM workload management setup across the organization. To define TASM Workloads, developed TASM exceptions, implemented filters and throttles as needed basis.
• Worked on capacity planning, reported disk and CPU Usage growth reports using Teradata Manager, DBQL, and Resusage.
• Used Teradata Manager collecting facility to setup AMP usage collection, canary query response, spool usage response etc.
• Developed complex mappings using multiple sources and targets in different databases, flat files.
• Developed Teradata BTEQ scripts. Automated Workflows and BTEQ scripts
• Worked on exporting data to flat files using Teradata FEXPORT.
• Query optimization (explain plans, collect statistics, Primary and Secondary indexes).

Environment: Teradata 12, Viewpoint, TASM, TARAGUI, Symantec Netback up, Teradata Administrator, Teradata SQL Assistant, BTEQ, subversion, Informatica.

Confidential, Oklahoma, OK

Teradata DBA

Responsibilities:

• Performed Data analysis and prepared the Physical database based on the requirements.
• 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, and Stats Wizard to improve performance.
• Responsible for populating warehouse-staging tables.
• Responsible for capacity planning and performance tuning.
• Prepared Performance Matrices.
• Worked on and developed scripts for CronTAB to automate the monitoring tasks.
• Created Teradata objects like Databases, Users, Profiles, Roles, Tables, Views and Macros.
• Developed complex mappings using multiple sources and targets in different databases, flat files.
• Worked on Space considerations and managed Perm, Spool and Temp Spaces.
• Developed BTEQ scripts for Teradata.
• Automated Workflows and BTEQ scripts
• Responsible for tuning the performances of Informatica mappings and Teradata BTEQ scripts.
• Worked with DBAs to tune the performance of the applications and Backups.
• Worked on exporting data to flat files using Teradata FEXPORT.
• Query optimization (explain plans, collect statistics, Primary and Secondary indexes).
• Build tables, views, UPI, NUPI, USI and NUSI.
• Written several Teradata BTEQ scripts to implement the business logic.
• Worked exclusively with the Teradata SQL Assistant to interface with the Teradata.
• Written various Macros and automated Batch Processes.
• Writing UNIX Shell Scripts for processing/cleansing incoming text files.
• Used CVS as a versioning tool.
• Coordinating tasks and issues with Project Manager and Client on daily basis.

Environment: Teradata 12, Teradata Manager, Workload Management, Symantec Netback up, Teradata Administrator, Teradata SQL Assistant, BTEQ, Subversion, FastLoad, MultiLoad, Informatica.

Confidential

Teradata Developer

Responsibilities:

• Worked with Bteq to interface with the Teradata.
• Involved in Full Life Cycle development for building a data warehouse.
• Involved in gathering of business scope and technical requirements and written technical specifications.
• Modified BTEQ scripts to load data from Teradata Staging area to Teradata data mart.
• Used FastLoad for loading into the empty tables.
• Worked with the MULTILOAD utility of Teradata database for better performance.
• Worked with Teradata BTEQ to run the scripts in batch mode.
• Updated numerous BTEQ/SQL scripts, making appropriate DDL changes and completed unit test.
• Wrote Functions and Stored procedures in Teradata Database.
• Created Teradata macros to create, modify and remove users and Grant/Revoke their access privileges.
• Gathered business requirements from users and groups to create Base views and secret (security Reference) views as per their roles.
• Extensively used BTEQ, Query Man and WinDDI for database creation, moving space between databases altering spool space and user creation and management in Teradata.
• Error handling and support of existing applications for failed reloads using Teradata MLOAD, BTEQ and Fast Load.
• Load balancing of ETL processes, database performance tuning and Capacity monitoring.
• Optimization and tuning of SQL’s for fixing Teradata Spool issues.
• Did Unit Testing and made sure the code matches with the design.

Environment: Teradata 12, Teradata SQL Assistant, BTEQ, Subversion, FastLoad, MultiLoad, Informatica.