SUMMARY

• Having 10+ years of total IT experience in Teradata and Performance Testing.
• 6+ years of experience in TERADATA database administration, administering TERADATA production, Development, Disaster recovery, Testing databases and as a Support Analyst.
• Good at Teradata database Object management, space management, user management, capacity planning, security administration, viewpoint administration, alert management, scripts release on production system and data move on different environments, profile management, roles management
• Security Administration - Maintain Teradata roles and profilesand performs SOX validation tasks
• Configuring and Monitoring of Viewpoint alerts, queries, locking logger, access locks and database performance
• Proficient in performing SQL Tuning based on the CPU and Performance reports extracted from DBQL and PDCR. Rewrite/provide tuning recommendation on bad performing queries
• Extensive knowledge in Teradata Tools: Arcmain, TARA, Netbackup, Viewpoint, Visual Explain, Teradata Manager, PDCR, Index Wizard, Statistics Wizard, System Emulation Tool (TSET), Teradata Administrator (Winddi), Query Scheduler.
• Extensive knowledge in Teradata Utilities: Cns tool, Ferret, Check Table, Table rebuild, Show Locks, Recovery manager, DBS Control Records.
• Carried responsible role in Teradata Node Integration/Version Up-gradation Activity.
• Good at Reviewing Teradata technical alerts and identifying impacts over applications/systems/data and making necessary recommendations or actions to mitigate impacts.
• Extensive knowledge in Teradata ETL tools: Multiload, Fastload, Fastexport, Tpump, BTEQ, TPT, Informatica Power centre
• Has extensive experience working on Teradata Backup/Recovery Strategies
• Worked on PDCR to generate performance related reports.
• Good understanding of Teradata internal architecture and query processing mechanisms.
• Experienced in overall activities of Performance testing assignments. experience in performance and load testing using LoadRunner and JMeter
• Have experience in all the phases of Performance testing Life Cycle.
• Have experience in designing, planning and executing performance tests.
• Good at Scripting as per the given inputs, Test Executions and Reporting.
• Have experience in Performance test scripts simulation scripts for stress testing applications.
• Good Experience in Result Analysis and identifying bottlenecks.
• Competent in customer focus, change & innovation, strategic thinking, effective communication, relationship building & influencing, results focus and inspirational leadership
• Good analytical, reasoning and problem solving skills.

TECHNICAL SKILLS

RDBMS: Teradata (Versions: V2R6 / TD-12 / TD-13/ TD-14/TD-15)

DBA Utilities: Cns tool, Ferret, Check Table, Vprocmanager, XCtl, XdbwTable rebuild, Recovery manager, DBS Control RecordsShow Locks, PMON, Viewpoint.

DBA Tools: Arcmain, TARA GUI, Netbackup, NetVault, Viewpoint, Teradata Manager, PDCR, Visual Explain, Index Wizard, Statistics Wizard, System Emulation Tool (TSET), Teradata Administrator (Winddi), Query Scheduler.

ETL Methods: Multiload, Fastload, Fastexport, Tpump, BTEQ, TPTInformatica Powercentre

Operating Systems: WIN 9X/XP/2000, UNIX( Solaris, MPRAS), SUSE Linux Enterprise server 10

Scheduling & Automation: Crontab programming, Control-M

PROFESSIONAL EXPERIENCE

Confidential - NY

Teradata DBA & BAR SPOC

Environment: Database: Teradata 15.00 Teradata SQL Assistant, Teradata Administrator, Viewpoint, BTEQ, TARA GUI, VERITAS NetBackup, Console Utilities, T-SET. SUSE Linux Enterprise server 10(Production & BAR Servers), Windows XP (Standalone)

Responsibilities:

• Teradata Production DBA support.
• Participating as a key player while Teradata version upgrades activities.
• Maintaining the EDW compliance standards as per client requirement.
• Working closely with TD-GSC BAR team during BAR hardware and software upgrades.
• Weekly maintenance activities like Check Table, Scandisk, Packdisk using Ferret Utilities
• Granting & Revoking Object Rights, System Rights on Databases/ Users/ Roles.
• Reviewing the projects in all the phases and Migrating the database objects
• Defined a backup strategy for handling all adhoc & scheduled backups
• Space management and Data roll-offs based on pre-defined retentions.
• Managing the memory resources such as Spool, Temp Space and Perm Space effectively.
• Setting-up and monitoring of viewpoint alerts.
• Monitoring the ETL process on daily basis and re-running the jobs after error resolution.
• Creating or modifying bteq scripts, windows batch files based on client requirement.
• Working on ITQ incidents that are assigned by client.
• Regular administration tasks on Teradata Database Servers - Production, Development & DR includes:
• Monitoring space of critical databases and moving space from Space Donor.
• Checking for blockages and abort the culprit sessions
• Analyzing performance of long running queries.
• Pumping up the priority of certain critical sessions when client requests, by modifying their workload.
• Checking Skewed tables and do PI revision.
• Creating objects in different environments
• Checking/Granting access rights and role rights
• Checking/cancelling rollbacks in recover manager
• Enable/Disable logons
• Responsible for smooth functionality of PDCR
• Applying compression on tables
• Backup and Recovery - Arcmain and NetBackup, which includes:
• Monitoring daily backups
• Manually running weekly backups
• Adhoc requests for backup and restore.
• All tape management activities which includes manual image expirations, retention extensions etc. Tape off-siting process is also in place.
• Scheduling the backups through crontab.
• Sending weekly reports to the client which includes:
• Space detailed and summary reports
• ETL Job failures and the resolutions.
• Added & Dropped Databases and users list compared to previous week
• Providing probable candidate tables for dropping.
• CPU, I/O utilization reports.
• Creating and managing user accounts with appropriate security.
• Setting up LDAP login mechanism
• Assisting developers/users to tune queries.
• Overseeing daily and weekly back-ups. Tools: Veritas NetBackup & Tara GUI.
• Yearly PPI extensions.

Confidential

Teradata DBA

Responsibilities:

• 24*7 DBA Production support.
• Monitoring the ETL process on daily basis and re-running the jobs after error resolution.
• Administration of Teradata Database Servers - Production, QA & Development which includes:
• Monitoring space of critical databases and moving space from Space Donor.
• Setting up new users, databases, roles
• Checking for blockages and abort the culprit sessions.
• Analyzing performance of long running queries.
• Weekly system backup activity using NetBackup & TARA GUI.
• Performing Archive/Restore activities on Adhoc basis.
• Coordinate hardware maintenance (replace failed disks and other online operations)
• Purging outdated data in the database.
• Tune Queries from business users to make their reports reach them sooner.
• Migrating scripts from one server to another servers and executing them
• Implement structural changes as per the process.
• Monitoring daily/weekly/monthly DBA reports.

Confidential

Teradata DBA

Responsibilities:

• 24*7 DBA Production support.
• Space Management.
• Access rights management.
• Creation of Users, Roles and Profiles.
• Monitoring jobs to fix loader failures
• Monitoring daily/weekly backups using Netvault.
• Perform the backup/restoration on adhoc basis.
• Coordinate hardware maintenance (replace failed disks and other online operations)
• Purging outdated data in the database.
• Tune Queries from business users to make their reports reach them sooner.
• Implement structural changes as per the process.
• Sending the DBA reports on weekly basis.

Confidential

Teradata DBA

Responsibilities:

• 24*7 DBA Production support.
• Space Management.
• Access rights management.
• Creation of Users, Roles and Profiles.
• Monitoring jobs to fix loader failures
• Monitoring weekly backups using TARA GUI.
• Perform the backup/restoration on adhoc basis.
• Purging outdated data in the database.
• Tune Queries from business users to make their reports reach them sooner.
• Implement structural changes as per the process.

Teradata DBA

Responsibilities:

• 24*7 DBA Production support
• Performance Monitoring
• Space Management
• User rights management
• Creation of Roles and Profiles
• Preparation of backup/restoration scripts and monitoring (Veritas Netbackup & TARAGUI)
• Archiving and Purging of Tables
• Multivalue compression on defined tables,
• Execution of Adhoc queries
• Tuning the queries having performance issues
• Advice structural changes and gives STATS collection recommendations wherever required
• Conduct SQL code reviews as per client’s standards and best practices recommended by Teradata Corporation
• Carried responsible role in Nodes expansion
• Held responsible role in TD up-gradation from V2R6 to TD12
• Setting the rules and throttles in the TDWM
• Sending the Daily DBA reports (Node Usage, user query count, Production space, Logon off, Memory Utilization, Average Free Cylinders on all Amps (FSP), Wait Time.).
• Involved in the node integration activity.

Confidential

Team Member

Responsibilities:

• Involved in business Requirements gathering.
• Involved in Test Plan Preparation
• Identification of Business Critical scenarios
• Script Development
• Test Data Development
• Preparing scenarios
• Executing scenarios
• Analyzing the results
• Identifying the bottlenecks
• Preparing the test Report.

Confidential

Team Member

Responsibilities:

• Involved in traversal document verification
• Identification of Business Critical scenarios
• Script Development
• Test Data Development
• Executing scenarios
• Analyzing the results
• Identifying the bottlenecks
• Preparing the test Report.