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 13.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 600 Terabytes of size.
• Good Knowledge & Understanding of the Bigdata concept & Hadoop Architecture.
• Worked on Hadoop, HDFS, Hive, Pig, Oozie, Sqoop, and Teradata.
• 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.
• 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 standrad DM template to sync the data in Prod & DR.
• 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.
• Expertise in Using the DBQL and Access Log to monitor the database log.
• Design and Develop Pig, Hive Sqoop jobs to perform the ETL and developed MapReduce programs with Java.
• 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 V12/13, Oracle 10g/9i/8iSQL Server 2005

Tools: Teradata Manager, Performance Monitor, 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

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 .
• Transfer and load datasets from different LOB’s.
• Build customer attributes using HIVE.
• Optimize HIVE queries.
• Prepare technical design documents, detailed design documents.
• Design and Develop Java Map Reduce applications for calculating/identifying outcomes, resources, track performance and compare.
• Have Monitored the Production Runs for the Processes and troubleshooted them incase of any issues.
• Used SQOOP to move data from DB2 and Teradata to Hadoop Cluster. Used Flume in Loading log data into HDFS.
• Performed Enterprise level Hadoop Upgrade on already existing Cluster, applied Patches and did version upgrade.
• 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, Union, NJ

Teradata Developer

Responsibilities:

• Worked with the Teradata Queryman 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.
• Worked with the MULTILOAD utility of Teradata database for better performance.
• Worked with Teradata BTEQ to run the scripts in batch mode
• Wrote Functions and Stored procedures in Teradata Database
• Created Teradata security 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.
• Written UNIX Scripts for event automation and input file validations.
• Did Unit Testing and made sure the code matches with the design.

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.

Confidential

Java\J2EE Developer

Responsibilities:

• Involved in development of processes for various workflows.
• Involved in the design and development of presentation and web layers based on MVC Architecture (Model-View- Controller).
• Developed the Java classes for the business rules and the test classes.
• Extensively Used RSA WebSphere for developing and testing the Security Infrastructure Service.
• Developed the classes for the business facts.
• Developed test cases and performed testing using JUNIT.
• Involved in implementation of Struts MVC framework and developed DAO classes. Configured the controllers and different Handler Mapping etc.
• Implemented the persistence layer using Hibernate and configured Hibernate to interact with the database.
• Involved in Developing the Web Interface using Servlets, JSP, HTML3.0 and CSS.
• Debugging the test cases to achieve the 100% code coverage.
• Involved in Design/Code Review with Team and task assignments.
• Responsible for design, development, application architecture, use cases, flowcharts, Application flow, prototypes, proof concept of sample codes.
• Responsible for writing detailed design specification document and implementing all business rules.