SUMMARY:

• A seasoned IT professional with over 16+ years of commendable success in Teradata Production DBA Support, Teradata Application DBA Support, Application Development and Implementation & Project Management.
• Well versed with Teradata Database Administration, Performance Tuning and Workload Management and various Teradata Load Utilities; Data warehousing concepts, Backup Tools such as NETVAULT, ARCMAIN and in programming using PB, C, C++, Dev. 2000 with Access, Oracle and Teradata.
• A keen strategist, planner and implementer with expertise in devising strategies aimed at enhancing overall organizational growth, sustained profitability of operations and improved business performance.
• Possess credibility & personal integrity that leaves lasting impression with corporate decision makers, motivates employees and generates loyalty.
• In - depth expertise in all aspects of the SDLC including requirement analysis, design, development, testing, troubleshooting and debugging.
• Strong collaboration, team building, interpersonal, communication skills with proficiency at grasping new technical concepts quickly & utilizing the same in a productive manner.

KEY RESULT AREAS

• Project Management * Database Administration *Application Programming Relationship Management * Maintenance * Team Management SDLC * Software Analysis * Client Relationship Management
• Interacting with customer & team for requirement gathering, risk assessment, finalization of technical specifications.
• Developing plans & schedules, resource allocations as per budgets, manpower deployment and team meetings for individual projects.
• Interacting with team members to ensure smooth progress of project work.
• Interfacing with clients for business gathering, conducting system analysis and finalizing technical / functional specifications and high level design documents for the project.
• Participating in design and coding of Software Applications; mapping requirements; participating in the finalization of product specifications and selection of appropriate techniques.
• Conducting system study and coordinating with team members for system design & integration, application maintenance, etc.; contributing to the design, development, testing, troubleshooting and debugging of the software.
• Create, maintain, and support Database architectural environment.
• Devise strategy for Backups, recovery & fine-tuning.
• Workload Management, Capacity Planning, user maintenance, database security imposition; performance analysis of application and database.
• Meet deadlines without compromising quality norms and adhering to SLA. Delivery Management & Post Implementation support.
• Understand & co-ordinate client’s needs / enhancements, customization, software-related issues, provide solutions in adherence to delivery schedules.
• Achieve customer satisfaction by ensuring service quality norms and building the brand image by exceeding the customer expectations.

TECHNICAL SKILLS:

Database: Teradata

Other Databases: Oracle

Tools: & Utilities Teradata Viewpoint, TASM, Teradata Administrator, SQL Assistant, Fast Load, Mload, PDCR, Arcmain, TSET, Visual Explain, Console, Ferret, LocksDisplay, DBS Control, BTEQ

Languages: SQL, PL/SQL

Backup Tools: Netvault, HP Openview, Legato

ETL Tool: Informatica

Operating System: UNIX (MP-RAS, Linux, Solaris, HP-UX), Windows

Hardware: Confidential WorldMark 5250/5350/5450/5400/5500/6700 Servers, Teradata Appliance

Front-End Tools: PB, Developer2000/6.

Data Modeling Tools: S-Designer, Erwin, Designer2000

Technology: Datawarehousing

Business: Telecom, Retail

Additional Trainings: Received Training in SQL-H of Big Data Hadoop and Aster.

PROFESSIONAL EXPERIENCE:

Confidential, Tampa, FL

Senior Database Administrator - Teradata DBA

Responsibilities:

• Migration of various application databases from Oracle to Teradata.
• Develop ETL (Extract, Transform, Load) processes and tools needed to migrate this data
• Creation of data extraction scripts for Oracle.
• Creation of Teradata Mload and FastLoad and Bteq scripts for Data Migration
• Creation of Informatica Interfaces and mapping for Data Transfers.
• Resolution of various data load errors.
• Recommendation of PI changes to reduce skewing factor of tables.
• Recommendation of additional Stats, Indexes for better query performance.
• Implementation Profiles.
• Disk space saving by implementation of MVC and Block Compression restores.
• Creation of Backup and Restore/Copy Strategies.
• Creation of new Functional ID’s for Application/Batch after reviewing/optimizing Sql’s.
• Creation/Granting/Revoking of Roles, Privileges to Normal and Secured Databases.
• Be the main contact for issue resolutions and be an efficient Teradata DBA.
• Create, maintain, and support Teradata architectural environment.
• Setting up of alerts, canary queries, etc.
• Creation of Macros; Space Management; Database Up-gradation and Migration Activities.
• Upgradation and usage of PDCR.
• Resolve any Teradata related issues raised by business users and application teams.
• Support the application development teams for database needs and guidance
• Support of production processes through tickets
• Sending of Confidential info to Teradata Confidential support via incidents for their in-house problem re-creation.
• Respond to change requests to create, change, or delete database objects (tables, views, indexes, DDL, DML, etc.) per client specifications.
• Received Training in SQL-H of Big Data Hadoop and Aster.

Confidential, Bentonville, Arkansas

Senior Manager - Teradata DBA

Responsibilities:

• Be the main contact for issue resolutions and be an efficient Lead DBA.
• Create, maintain, and support Teradata architectural environment.
• Migration of various application databases across servers for load balancing.
• Query Tuning which resulted in significant CPU savings which goes as quarterly reports to upper management equated as Dollar Savings.
• Creation of new DBC ID’s for Application/Batch after reviewing/optimizing Sql’s
• Grant/Revoke of Additional Roles, Privileges to Normal and Secured Databases.
• Monitoring and maintenance through Teradata Viewpoint.
• Using Teradata Manager to set alerts, canary queries, etc.
• Creation of Macros; Space Management; Database Up-gradation and Migration Activities.
• Resolve any Teradata related issues raised by business users and application teams.
• Support the application development teams for database needs and guidance
• Support of production processes through Remedy tickets
• Respond to change requests to create, change, or delete database objects (tables, views, indexes, DDL, DML, etc.) per client specifications.
• On-call support
• Provide Level 2 & 3 support

Confidential

Project Manager - Teradata Lead DBA

Responsibilities:

• Key Stakeholder Management
• Provide visibility to support managers and concerned stakeholders
• Suggest and Implement Service Improvement Plans from time to time
• Project review report from time to time
• Be main contact for issue resolutions and be an efficient Lead DBA
• Create, maintain, and support Teradata architectural environment
• Administration of production objects in change control environment
• Development of pro-active processes for monitoring capacity and performance
• Frequent MVC analysis for space saving.
• Using Teradata Manager to set alerts, canary queries, etc.
• Support of production processes such as P1,P2,P3 tickets
• Space administration. Ensuring that the disk space is effectively utilized.
• Database security administration.
• Database Backup, Archival & Restore using Netvault.
• Coordinating with Teradata Confidential for upgrades, patch installation, etc.
• Weekly meetings with the Client and the dedicated Confidential personnel.
• Running utilities like checktable, scandisk, etc
• On-call support
• Provide Level 2 & 3 support