SUMMARY:

• Teradata Lead DBA wif 16+ years of experience in IT Services industry and 12+ years of experience as Teradata DBA.
• Maintained database optimization while performing monthly maintenance activities wif the Coordination of Teradata GSC.
• Experienced in implementing DDL & DML scripts in the Production environment.
• Worked in - depth wif Teradata Administration tools like Viewpoint, TD Studio and Teradata Administrator.
• Proficient in working wif DBQL for analyzing resource usage, CPU usage and details of objects accessed.
• Knowledge in Implementing TASM (Teradata Active system Management) for workload management. knowledge of Virtualization technologies on Teradata along wif proficiency on Teradata utilities like BTEQ, Multiload, FASTLOAD, TPUMP, Fast export, PMON.
• Provide recommendations for tuning including statistics optimization, sampledStatistics, stats recollection, data distribution, indexes, PPI, join optimization.
• Solving the Incident tickets for the issues/concerns raised by Teradata database users as part of change management.
• Performing data copies of specific data between Prod/QA/DEV DB's as neededRefresh QA / DEV on periodic basis from Production.
• Involvement in Requirements Analysis, Design, Development and Maintenance of different applications.
• Worked on tuning the SQL queries in Teradata DB, by finding the hiccups efficiently and solving them timely.
• Worked on TD upgrades wif the vendors and participated in the disaster recovery exercises and worked on BAR activities.
• Able to perform security audits and develop framework, which includes designing and implementing roles, profiles and accounts.
• Knowledge and Hands on Experience in Data Migration from On-prem Teradata to Cloud (Azure Teradata).
• TEMPHas good command on Teradata Performance Tuning (SQL, PL/SQL and Explain Plan Analyzing and collecting the statistics and Indexes).
• Experience in taking backups (ADHOC, Weekly and Monthly) and recovery of data in Teradata.

TECHNICAL SKILLS

Databases: Teradata version 16 and 17, Oracle 10g/9i/8i

Hardware: Teradata Server NCR World Mark 6700,922 Amps, 142 PE s and 91 Node, 109 TB Space

Operating Systems: Windows 9X/NT, LINUX MP-RAS

GUI: Viewpoint 16, TARA GUI

Languages: SQL, PL/SQL, Batch Scripting

Case Tools: ARC, NETVAULT, Teradata Visual Explain, BTEQ, Teradata System Emulation Tool, Teradata SQL Assistant, Teradata Manager, PMON, Teradata Administrator, TASM, FASTLOAD, MULTILOAD, FAST EXPORT, TPUMP, Teradata Statistics Wizard and Priority Scheduler.

Tools: and Utilities Shell Script, Fast load, Multiload, Fast export, BTEG, VPROCMANAGER, XCTL, DBSCONTROL, CVSTOOL, TERADATA, MULTITOOL, CTL/XCTL, VPROCMANAGER, CHECKTABLE, SCANTABLE, RECONFIG, SHOWLOCK, QRYSESSN, RCVMANAGER, Teradata Dynamic Query Manager, QUERYMAN, TSET

Domain Knowledge: Pharmaceutical, Retail, Healthcare, Banking and Finance and ERP Implementation.

PROFESSIONAL EXPERIENCE

Confidential, Baton Rouge, LA

Sr. Teradata DBA

Responsibilities:

• Proactively and periodically check wif the Users for Issues and upcoming Tasks.
• Working as a Teradata Lead DBA, doing DBA activities that are Implementation of data and table-level security, setting up access rights and space rights for Teradata environment.
• Performance tuning, Monitoring and reporting Review system utilization by user.
• Acted as a liaison between the offshore and onsite teams.
• Provide 24x7 Production support as needed for production environments
• Perform general technical troubleshooting
• Own backup and restore operations.
• Performance tuning of high CPU consumption queries.
• Vendor coordination for database/environment patches/upgrades.
• General DBA activities (access/space/user management)
• Interface wif the vendor for technical support when required
• Interface wif other technologies required by database applications
• Implement proactive monitoring and alerting of critical events

Confidential

Sr. Teradata DBA

Responsibilities:

• Creating users, databases, database tables
• Profile, Role management of database users.
• Space usage analysis, and recommendation regarding the utilization of space.
• Index Analysis, Statistics Analysis and selection and implementation of the indexes and Statistics.
• Compression analysis and choosing the best candidates for compression.
• Monitoring the sessions and their resource usage.
• Weekly planning and implementation of Backup and Archiving Activities using Net Vault Backup utility.
• Creation of M-load Scripts and facilitating in automation of the process of creation of the M-loads.
• Wif the in-depth expertise in the Teradata cost-based query optimizer, identified potential bottlenecks wif queries from the aspects of query writing, skewed redistributions, join order, optimizer statistics, physical design considerations (PI/USI/NUSI/JI etc.) etc. In-depth knowledge of Teradata Explain and Visual Explain to analyze and improve query performance.
• Overall Production Support for Teradata system.
• Deliver new and complex high-quality solutions to clients in response to varying business requirements and creating and managing user accounts.
• Worked on creating and managing the partitions.
• Performed database health checks and tuned the databases using Teradata Manager.
• Did performance tuning, including collecting statistics, analyzing explains & determining which tables needed statistics & secondary indexes. Increased performance by 35-40% in some situations.

Confidential

Teradata Architect

Responsibilities:

• Based on the business requirement, preparing physical data model of project.
• Setup of development, SIT and Validation environments.
• Creation of Databases, Users, Roles, Profiles for 9 Regions in DEV, SIT and VAL environments.
• Created country specific databases and views for Qlickview reporting purpose.
• Proactively and periodically check wif the Users for Issues and upcoming Tasks.
• Perform support/applicationDBA activitieslike creating roles & profiles for users. Create, unlock user accounts manage database space.
• Actively involved in communication wif various vendors at courts to get daily, weekly incremental/full refresh files. Facilitate communication upward and across project teams
• Interact and work directly wif customer team members on projects and support issues.
• Follow change management and problem management processes.
• Documenting thestandards for securityareas such as best practice’s role creations for the end users

Confidential

Teradata database Administrator

Responsibilities:

• Reviews and Migrations of change request as well as projects.
• Fix the load failure issue on daily basis in Production and development.
• Monitoring database using Viewpoint and worked on Viewpoint Alerts.
• Taking Database backups using TARA GUI (Used Arcman tool earlier).
• Worked on Analysis of locks and indexing.
• Worked on virtualization of Teradata server using VMware.
• Involved in version upgrade of Viewpoint tool from 13 to 14 and Datamover from 13 to 14.
• Rotational On-call support.
• Responsible for end to end support (design phase to post implementation) for development projects.
• Maintain the standards based on System level Benchmark analysis.
• Database, User, Role and Profile creation.
• Involved in monthly Maintenance activities like scandisk and checktable
• Review and Migration of change request as well as projects.
• Fix the load failure issue as on daily basis load failure.
• Monitoring database using ViewPoint.
• Worked on Database Restores by Arcman.
• Worked on analysis of locks and indexing.
• Monitor system performance and workloads and develop capacity plans.
• Creating mapping between source and Teradata Target/Staging environments
• Loading data to target tables using Teradata utilities like FASTLOAD, MULTI LOAD, BTEQ, FAST EXPORT
• 24*7 DBA Production support
• Creation of user, database, roles, profiles, giving access rights.
• Refreshing data between different environments (Prod, DEV, VMware) Using ARCMAIN tool.
• Fixing any errors in Macros, Stored Procedures
• Checking and providing the spaces in the production databases.
• Checking the system through Viewpoint web portal.
• Reviewing the projects in all the phases and migrating the database objects.
• Stats collection, copying stats by TSET and providing logs to Teradata GSC.
• Backup of tables on database level.
• Granted & Revoked Object Rights, System Rights on Databases/ Users/ Roles.
• Migration of the sql, Bteq and objects from development area to production area.
• Raising and following up various incidents wif Teradata through TD@ys and provide the information.

Confidential

Teradata database Administrator

Responsibilities:

• Implementation of the New Database, including Creating users, Database Objects etc
• Profile, Role management of database users
• Physical implementation of cLDM for the Warehouse, including selection and implementation of Indices, MPPIs, Semantic layer, and Performance AJI structures.
• Current Space usage analysis, and recommendation regarding the utilization of space
• Statistics Analysis and selection and implementation of the system wide object demographic Statistics
• Compression analysis and implementation.
• User sessions analysis, resource usage analysis and implementation of the required Workloads.
• Weekly planning and implementation of Backup and Archiving Activities using Net Vault Backup utility
• Identified potential bottlenecks wif user queries from the aspects of query writing, skewed redistributions, join order, optimizer statistics, physical design considerations (PI/USI/NUSI/JI etc) etc. Usage of Teradata Explain and Visual Explain to analyze and improve query performance.
• Implementing the Teradata manager Services to enable the system wide resource collection, and reporting.
• Implementing the Alerting mechanism for the Production system using the Alerting service both to SNMP, and SMTP
• Upgrading the Teradata manager services to Viewpoint
• Performing database health checks and system health checks on a regular time frame.
• Mentoring the DBA Team for Operations
• Mentoring the User Base in the New Technology
• Overall Operational Support for a 24/7
• Using Change control procedures for logging, implementation, and closing for the releases
• Creation, implementation of the Development and test system.
• Implementing a ‘Swing’ system, migrating Production system to Swing system for the production system upgrade.

Confidential

Oracle Retail Techno-Functional Consultant

Responsibilities:

• Preparation of Technical specifications from the functional specifications received from the functional team
• Writing custom packages to develop conversion and interface programs.
• Developing conversion and interface programs.
• Outbound Interface is developed which data flows from REIM 12.0 to Oracle e-Business Suite (11.5.10) Application (GL and AP).
• Outbound Interface is developed which data flows from RMS 12.0 to Oracle e-Business Suite (11.5.10) Application (GL). Done all Functional SETUPS IN RMS Module.
• Inbound Interface is developed which data flow from Oracle e-Business Suite (11.5.10) Application (GL) to RMS 12.0.

Confidential

Technical Consultant

Responsibilities:

• Preparation of Technical specifications from the functional specifications received from the functional team like CV60, MD70 using AIM 3.0
• Writing custom packages and using API’s to develop conversion programs.
• Developing custom reports, conversion, outbound and interface programs that are registered as concurrent programs and which are run from SRS form.
• CONVERSION
• Defining Users.
• Defining Responsibilities and assigning in to users.
• Defining Request Group and assigning in to Responsibilities
• Defining Functions,Menus and assigning in to Responsibilities.
• Defining Executable Concurrent Program and assigning in to Request Group.
• Defining Value set.

Confidential

Technical Consultant

Responsibilities:

• Preparation of Technical specifications from the functional specifications received from the functional team like CV60, MD70 using AIM 3.0
• Writing custom packages to develop conversion and interface programs.
• Developing reports, conversion and interface programs that are registered as concurrent programs and which are run from SRS form.