SUMMARY

• 9 years of IT experience in software development, design and implementation with major focus on Database Administration in Teradata on providing Data Warehousing solutions and Business Intelligence solutions.
• Extensively worked on Teradata View point, Teradata PDCR to monitor the systems, setting the alerts and implemented TASM and also to generate various performance and system related reports.
• Performed regular DBA activities like Create Database, Users, Tables, Views, macros, Stored Procedures, checking the tables skew, profiles, roles, grant/revoke permissions, space management (spool, temporary, permanent space),compression, troubleshooting the failure jobs.
• Performance tuning on complex 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, usage of Hash functions, etc.
• Preparing Bi - weekly and Monthly Teradata database system reports to client
• Expertise in writing Scripts using Teradata parallel load/Unload Utilities like: BTEQ, Teradata SQL Assistant, Tpump, FastLoad, MultiLoad, FastExport.
• Experienced as on call DBA support (24X7) as part of a scheduled rotation with other team members.
• Possess leadership and managerial qualities with highly developed problem-solving skills with a documented can-do-attitude.
• Sound, resourceful business and technical decision-making capabilities, all contribute to high degree of success and customer satisfaction in all areas of endeavor.
• Involved in interacting with clients and understanding the business processes, requirement analysis, identifying potential usability issues, managing scope, implementing operating standards and maintaining technical documentations.
• Excellent communications and client relationship skills in delivering the projects on time to ensure customer satisfaction.
• Active holiday support during Thanksgiving and Black Friday period.

TECHNICAL SKILLS

Hardware /software: Teradata 12 and Teradata 13.10.04.01

Operating Systems: UNIX, Linux and Windows

Databases: TERADATA- 13.10.04.01 , Microsoft Parallel Data Warehousing (PDW),SQL SERVER2012,ORACLE 9I, 10G, NETEZZA

Tools: & Utilities: Teradata ViewPoint, Teradata Studio, BTEQ, Fastload, Multiload, Tpump, Query Man and other Teradata Client Utilities like, Administrator and administrative utilities etc. Familiar with general back-up and restore technology using ARCMAIN and Net vault, Net backup and Support activities for Teradata RDBMS.Netezza Aginity workbench,PDW SSDT,Informatica 7.1 and 7.5, ORACLE PL/SQL

PROFESSIONAL EXPERIENCE

Confidential, Richfield, MN

Teradata Production DBA

Responsibilities:

• Access management
• Working with Teradata tech support for issues and tickets.
• Worked on Backup/archive using TaraGUI, Netbackup.
• Code Migration, monitoring load jobs and scheduling them.
• Work load management by balancing workloads for optimal performance.
• Space management, capacity planning for feature trends based on existing trends.
• Scheduling Backups, Database Maintenance activities.
• View point monitoring, alerting Outages during patch-ups, upgrades
• Used Teradata Administrator and View point Tools for monitoring and control the system.
• DBA activities that are Implementation of database and table-level security, setting up access rights for Teradata environment.
• Performance tuning, Monitoring and reporting Review system utilization by user.
• As Teradata DBA, involved in end to end DBA activities Life Cycle of different applications.
• Database clean ups, Prod Implementations during project releases.
• Active holiday support during Thanksgiving and Black Friday period.

Confidential, Milwaukee, WI

Teradata Developer and ApplicationDBA Support

Responsibilities:

• Determine the optimal approach for obtaining data from diverse source system platforms and moving it to the BI environment. Work load management by balancing workloads for optimal performance.
• Working with Business people to analyze the requirements.
• Establish and enforce technical standards for deliverables of projects.
• System impact analysis with real data in sandbox environment
• Co-ordination preparation of Low Level Design (LLD)
• Co-ordination with offshore team for the deliverables
• Work with data designer and the ETL architect to determine space requirements.
• Coordinating with the support group for the deployment activities
• Performance tuning, Monitoring and reporting Review system utilization by user.
• As Teradata DBA, involved in end to end DBA activities Life Cycle of different applications.

Confidential, NYC, NY

Oracle 9I and Teradata Application DBA

Responsibilities:

• Creating different environments.
• Create different databases for different purposes.
• Creating and managing user profiles and accounts.
• Requirement Granting, privileges and access rights by delivering new and high quality solutions to clients.
• Used Teradata Administrator and View point Tools for monitoring and control the system.
• DBA activities that are Implementation of database and table-level security, setting up access rights for Teradata environment.
• Performance tuning, Monitoring and reporting Review system utilization by user.
• Involved in end to end DBA activities Life Cycle of different applications.

Environment: Teradata 12, Linux and Windows

Confidential

Oracle 9I PL/SQL

Responsibilities:

• Determine the optimal approach for obtaining data from diverse source system platforms and moving it to the BI environment.
• Working with Business people to analyze the requirements.
• Establish and enforce technical standards for deliverables of projects.
• System impact analysis with real data in sandbox environment
• Co-ordination preparation of Low Level Design (LLD)
• Co-ordination with offshore team for the deliverables
• Work with data designer and the ETL architect to determine space requirements.
• Co-coordinating with the support group for the deployment activities.
• Creating Mappings, sessions, workflows
• Developed the strategy for Migration of all the interfaces to Informatica 7.5
• Requirement analysis and clarification for the new interfaces and enhancements.
• Monitoring Workflows.
• Unit Testing.
• Modification and Revision of DLD for changed requirement