SUMMARY:

• Over 12 years of IT industry experience and expertise working wif Data Warehousing Technologies.
• Proficient in using Teradata Administrator for managing Databases, Users, Tables, space management, statistics, managing permissions(Roles & Profiles).
• Hands on working wif Terdata Manager,Teradata Viewpoint to monitoring, aborting bad queries, looking for blocked sessions, etc.
• Good expertise in BAR activities and strategies, usage of Tivoli Storage Manger, NetBackup, NetVault,DSA in writing backups and restore scripts for Arcmain.
• Worked on Teradata system tools such as Vprocmanager, scandisk, checktable and packdisk.
• Good working experience in Teradata Upgrade from V12 to V1310, V14.10,V15.10
• Experienced working as on - call/production support DBA.

PROFESSIONAL EXPERIENCE

Confidential

Lead Teradata Database Administrator.

Responsible for:

• Work wif application sector to fix the day to day issues.
• Implement the DSA for Backup and Recovery procedures for Development, Testing and Production Servers
• Monitoring database space, Identifying tables wif high Skew, working wif data modeling team to change the Primary Index on tables wif High skew
• Cleaned up redundant roles and erroneous privileges in the roles, direct grant privileges as per Teradata Best Practices and implemented Strong Password rule set for all the Generic Profiles in all application sector
• Work wif Vormetric for Data Encryption and Decryption.
• Worked wif various user groups and developers to define TASM Workloads
• Interact wif GSC on Teradata software issues. Create/follow up on incidents wif T@YS.

Environment: TD 15.10 Viewpoint, Teradata Administrator, Tara GUI, DSA

Confidential

Lead Teradata Database Administrator.

Responsible for:

• Creating Users and granting access/privileges, Roles and Profile creation based on requirement wifout impacting the Security policies.
• Creating databases and setting up Environment for Development, Testing and UAT and moving the code and History data to production by following the implementation process.
• Developed Backup and Recovery procedures for Development, Testing and Production Servers using Tivoli and TARA GUI
• Configured view point to send alerts whenever reach threshold space utilization on databases, Session blocking, System health, adding the user in Viewpint.
• Worked on PDCR to generate performance related reports and system utilization report using PDCR tool kit.
• Worked on Teradata Work Load management concepts like TASM, Worked wif various user groups and developers to define TASM Workloads, developed TASM exceptions, implemented filters and throttles as need basis.
• Generated Audit weekly Reports to stop Direct Grant Users, unshielded Non Adhoc Profiles, Insecure Adhoc Users and other reports in Production for three LOBs
• Created Macros and Stored Procedures to Manage User Provision process, Role Management, Profile Management and Move the Space between databases
• Running Teradata system tools such as scandisk,checktable,clean up leftoverspool and packdisk on Monthly basics.
• Cleaned up redundant roles and erroneous privileges in the roles, direct grant privileges as per Teradata Best Practices and implemented Strong Password rule set for all the Generic Profiles in Three LOBs
• Involved in database upgrades, Migration and create, deploy the TTU package using BMC Blade Logic to install application Servers and User workstation.
• Moved the database objects from DEV to QA as per the Service Requests and QA to PROD as per the Change Management Request.
• Interact wif GSC on Teradata software issues. Create/follow up on incidents wif T@YS.
• Worked on Database Synch up across different Servers (Dev, Test, MO and Prod) using AtanaSuite SyncTool.

Environment: TD 12/13.10, 14.10 Teradata Manager,Viewpoint, Teradata Administrator, Tara GUI, Tivoli, BMC Blade Logic, Autosys, AtanaSuite.

Data Warehousing

Confidential

Responsible for:

• Responsible for day to day administration of Teratata database.
• Managing database space, allocating new space to database, moving space between databases as need basis
• Worked on loading of data from several flat files sources to Staging using Teradata MLOAD, FLOAD and BTEQ.
• Monthly Database Cleanup and Suggestions to the users on cleanup initiatives.
• created the procedure
• user creation Automation Script to create user in different Environments using Stored Procedure.
• Involved in Performance monitoring the different TD servers using tools like PMON, Dashboard, TD Alert and Reacting to alert system, if needed.
• Experienced in Teradata Manager which is used to create Alerts, Monitor system and clear the blocking .
• Perform Code review wif the Application Developers and discuss/review wif the DEV team from the initial stages of the design, data model and understanding the business needs in order to choose the Indexes and other Architectural designs that need to be taken care.
• Worked on PDCR to generate performance related reports(Daily/Weekly/Monthly) and fix the PDCR job failure issue.
• Backup, Archive and Recovery (BAR): Design, Implement, maintain and automated the appropriate jobs using Net Vault and manage the tape library.
• Schedule and monitor the ETL jobs using Wherescape scheduler.

Environment: Teradata V2R6, TD ADMIN, TD Manager, Visual Explain Index Wizard, Multiload, FastLoad, PMON, FastExport, BTEQ.

Frontier Communications

Confidential

Responsible for:

• Performed regular DBA activities like Create Database, Users, Tables, Views, macros, Procs, checking the tables skew, profiles, roles, grant/revoke permissions, space management (spool, temporary, permanent space), compression, troubleshooting the failure jobs.
• Expertise in using Teradata Manager in monitoring the system, setting the alerts and generating various performance reports.
• Monitoring database space, Identifying tables wif high Skew, working wif data modelling team to change the Primary Index on tables wif High skew
• Implemented various Teradata alerts using Alert facility in Teradata Manager. Involved in setting up alters to page DBA for events such as node down, AMP down, too many blocked sessions, high data skew etc.
• Monitoring number of Active, blocked, delayed Sessions time to time etc.,
• Extensive experience on performance tuning of SQL’s using various tuning methods like, analyzing the explain plan, analyzing skews, working wif Statistics collection and Compression
• Providing resolution for jobs blocking each other, jobs blocked by hut locks.
• Using Compression techniques to provide required compression values to gain space and for better retrieval performance

Oracle DBA

Confidential

Responsible for:

• Installed Oracle 10g R1 in Windows 2003 Server .
• Installed Oracle XE on their 46 Depots which runs on Windows 2003 Server
• Implemented standby database.
• Attended day-to-day database problems and trouble shoot them.
• Managing Cold and Hot Backups, database exports and imports
• Performed incomplete recovery due to corruption of Current log Group.
• Moved the database from one server to another server.
• Reorganized the tables and rebuild indexes to improve space utilization.
• Cloned the-production database for testing purpose.
• Recovered a large table wif live data when a programmer accidentally dropped.
• User Management like Adding / Removing / Modifying users, their roles, user profiles and privileges.
• Implement, Backup / Recovery like Logical and Physical backups
• Monitoring and re-organization of Configuring Listener process and assisting in establishing connectivity to Oracle Database from various front ends.
• Creation of databases, tables, indexes.