SUMMARY

• Highly skilled professional with 8 years of experience in the Analysis, Design, Development, Testing and Major focus on Database Administration and support of Database Systems in Teradata.
• Currently working on TD 14.10, as a 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.
• Experience supporting very large production enterprise data warehouse system of more than 1.5 Petabytes of size.
• Experienced as On - Call DBA Support (24X7) as part of a scheduled rotation with team members.
• Monitoring Teradata perm space for availability and monitor Teradata CPU/Load utilization.
• Supported in Teradata Node Expansion release performing Validations, making necessary profile changes and resolving password issues.
• Supported in the COLO DR Releases to sync the objects between Prod and DR and generating a report.
• Expertise in handling production deployments also used Unity Director for deployments to sync the DDL’s in Prod & DR.
• Used Data Mover in submitting the DM Jobs using the standard DM template to sync the data in Prod & DR.
• Performed Performance tuning on queries with efficiency of PI/SI indexes, Join Index, PPI, Using Explain analyzing the data distribution among AMPs and index usage, collect statistics, definition of indexes, revision of correlated sub queries, usage of Hash functions, etc.
• Extensively worked on Teradata View point, Teradata PDCR to monitor the systems and also to generate various performance and system related reports.
• Expertise in Using the DBQL and Access Log to monitor the database log.
• As an ITSM - Change Approver Role, monitoring the ITSM Approver’s Queue regularly for the scheduled changes, assigning DBA’s & approving/rejecting the ITSM based on the review of the change following the standards of the ITSM process of Confidential .
• OnBoarded 30+ DBA’s, providing access to the system and the tools for the new hires, also training them the tools and giving them KT.
• Good Knowledge & Understanding of the Bigdata concept & Hadoop Architecture.
• Worked on Hadoop, HDFS, Hive, Pig, Oozie, Sqoop, and Teradata.
• Professional working experience with the design, development and implementation of Client/Server, three-tier architecture based applications using JAVA, JDBC, Servlets, EJBs, JNDI, JSPs& Unit Testing.
• Solid knowledge with Enterprise Architecture design and Implementation in J2EE architecture and design patterns.
• Proficient in Analyzing Business process requirements and translating them into technical requirements.

TECHNICAL SKILLS

Database: Teradata V14/13, OracleSQL Server

Tools: 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, FastExport, Informatica, Tpump, SQL*Plus, Peregrine ServiceCenter, EURC (End User Request Center, ITSM (Information Technology Service Management).

BigData: Hadoop, HDFS, Flume, Sqoop, Pig, Hive, MapReduce, Oozie.

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

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

Operating Tools: Microsoft Windows XP/NT/2000, UNIX, Linux

PROFESSIONAL EXPERIENCE

Confidential, Newark, Delaware

DBA

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.
• Use Teradata Explain to analyze and improve query performance.
• Granting & Revoking of Object Rights, System Rights on Databases / Users / Roles.
• Revoke the direct grants from external roles & assign the privileges to internal roles to external 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.
• Submit, Enable and start the DM Job.
• Monitor the logs of failed DM jobs & troubleshoot the DM jobs using DM repository framework.
• Generate the DM reports with sync issues between PROD & DR.

Confidential, NJ

DBA

Responsibilities:

• Monitoring the service now Queue and solving the requests before the SLA.
• Preparing the environment container scripts for the specific application projects & deploying them.
• Worked on the monthly, weekly CPU/Space Usage Growth Reports.
• As per the access layer architecture Granting and Revoking of object rights on databases/users/roles.
• Monitoring the system for the blocked sessions and high CPU consuming sessions/users & working with the developers to resolve them.
• Participated in the Data Migrations between Prod & DR systems.
• Participated in the On-call and weekend support responsibilities.
• Adding the DBA’s to the system alerts in VP, resolving the space issue alerts.
• Putting the maintenance jobs on hold when necessary and cleanup of the logs.

Confidential, Newark, Delaware

DBA

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.
• 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.
• Monitoring the ITSM Approver’s Queue regularly for the scheduled changes, approving/rejecting the ITSM based on the review of the change following the standards of the ITSM process of Confidential .
• Providing access to the system and the tools for the new hires, also training them the tools and giving them KT.

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 performancetuning in Teradata queries and utilities.
• Creating error log tables for bulk loading.
• Worked on capacity planning, reported disk and CPUusage 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)

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

Confidential, Warrensville, IL

Teradata DBA

Responsibilities:

• User administration-set up roles and profiles for users.
• Granted & Revoked Object Rights, System Rights on Databases / Users / Roles.
• Build tables, views, UPI, NUPI, USI and NUSI.
• Performed tuning and optimization of complex SQL queries using Teradata Explain.
• Worked on loading of data from several flat files sources to Staging using Teradata MLOAD, FLOAD.
• Upgraded older versions of Teradata through PUT utility.
• Analyzed performance after upgrade.
• Extensively used explain plans to get the statistical data forthe performance tuning of the Oracle Transact SQL queries and PL/SQL for stored procedures.
• Query optimization (explain plans, collect statistics, Primary and Secondary indexes).
• Creating error log tables for bulk loading.
• Tracking Process behavior with DBQL.
• Developed BTEQ scripts for Teradata.
• Worked with DBAs to tune the performance of the applications and Backups.
• Performed Back up and Recovery activities as and when required.
• Monitored user sessions.
• Involved in the logical and physicaldesign of the database and creation of the database objects.
• Ensured data integrity and referential constraints for accurate database operations.
• Coded stored procedures, functions, and ref cursors to store, retrieve and manipulate data from database.
• Involved in the performance tuning of the application through creation of necessary indexes.
• Responsible for the migration of data from Extract Tables to the flat files and relational table.
• Worked with UNIX Shell scripts.
• Performed Data analysis and Data validations.
• Coordinating tasks and issues with Project Manager and Client on daily basis.

Confidential

Teradata Developer

Responsibilities:

• Analyzed the existing Teradata applications for complexity and Enhancement.
• Participated in Joint Analysis Design with user community and Business users.
• Used BTEQ and SQL Assistant (Query man) front-end tools to issue SQL commands matching the business requirements to Teradata RDBMS.
• Modified BTEQ scripts to load data from Teradata Staging area to Teradata data mart Used FastLoad for loading into the empty tables.
• Used volatiletable and derived queries for breaking up complex queries into simpler queries.
• Updated numerous BTEQ/SQL scripts, making appropriate DDL changes and completed unit test.
• Created tables, access views and update views in the development database.
• 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.