Teradata DBA Resume

SUMMARY

Completed 5.5 years of industry experience, mainly as Teradata Operation and Oracle DBA. Optimization/Physical Implementation specialist as well as Teradata DBA.
Worked on Data warehousing projects for Entertainment, Retailers & Consumer, Telecom, and Manufacturing Domains. Clients.
Extensively worked in Operation/DBA roles.
Experience on Teradata SQL Assistant, TASM, Teradata Administrator, Viewpoint and TARA Server for Backup and Recovery.

TECHNICAL SKILLS

Operating Systems: Windows, Unix

Databases: Teradata v12/v13.10,14.10,15.10 Oracle 11g

DBA Tools: SQL Assistant, TARA ServerNet backup, Teradata AdministratorViewpoint, Teradata Manager, DSA.

Data Modeling Tool: Sybase, Microsoft Excel

Reporting Tools: Teradata

PROFESSIONAL EXPERIENCE

Confidential

Teradata DBA

Responsibilities:

Deployment of Data from one environment to another.
Viewpoint Monitoring on regular basis.
Creating new users through the request.
Providing Access rights to the users.
Working on Ad - hoc requests on daily basis.
Tuned Long running queries, which were performing badly and hampering the performance of the system.
Took active part in Production Release for the deployment.
Resolved TPT issues while running loads.
DDL deployment on DEVQA & Prod database as per weekly activity
Worked on creating new users, reset passwords and providing roles to the Users.
Taking backup of Tables and Databases through Data Stream Architecture (DSA).

Confidential

Teradata DBA

Environment: Teradata v13.10, v14.10, SUSE Linux Role: Teradata DBA

Responsibilities:

Worked on Incidents and CO’s on various Issues.
Provided Space to the Database and User through
Teradata Administrator.
Creating Users and giving the Access Rights
Optimized Bad queries by collecting Multi and Single Columns Stats for the better Performance of the System.
Taken Manual Backups and monitoring them through TARA GUI.
Taking Backup of Table Manually through Incidents raised by users.
Worked on TASM related changes.
Approving Change Orders on regular basis.
Worked on Loading Utilities like Fast load and Multiload.
Worked on Shell Scripting through Bteq to implement Change Orders and Incident.
Used SQL Assistant extensively for pulling data from DBQL and for Performance Tuning as well.
Used Viewpoint in tracking Bad queries and removing Blockings in the System.
Hands on TASM for changing the Rulesets through Viewpoint for the better performance of the system.
Creating and Refreshing Views on client requests after new table creation.
Solved Ad-hoc requests from different users related to their job failures in MLoad.

Confidential

Teradata DBA

Environment: Teradata v13.10 Role: Teradata DBA

Responsibilities:

Worked on Incidents and CO’s on various Issues.
Provided Space to the Particular Database and User.
Creating Users and giving the Access Rights
Taken Manual Backups and monitoring them through TARA GUI.
Monitory Backup through TARA GUI and taking Backup of Table Manually through Incidents raised by users.
Worked on Shell Scripting through Putty for Change Orders.
Monitoring Viewpoint on Regular Basis.
Worked on TASM Changes Activity.
Worked on Access Rights Table to reduce size of the Table.
Creating and Refreshing Views.

Confidential

Oracle DBA

Responsibilities:

Involved in DBA activities, supporting Production & Datagaurd Environments
Supporting 100 production databases and 40 datagaurd databases
Creating new databases under various environments and maintaining different oracle homes in the same servers.
Installation, creation and support of Oracle 9i, 10g & 11g database in Production Environments.
Rebuilding the indexes and Gather statistics of tables to improve the performance.
RMAN restorations and recover ( block level recoveries, Data-file recovery)
Datagaurd activities.
DR drill and incremental Backup.
Resolve query tuning and database performance issues.
Patching activities on quarter basis.
Monitoring databases, which include basic health checks, growth of objects, performance of the database and giving recommendations how to resolve it.
Checking AWR, ADDM & ASH report through OEM.
Giving support to development team
Explain plan of queries.
Performing status checks by monitoring the Alert log, Trace files of the database.
Looking into action requests (tickets) and resolving issues, providing the root cause, providing the permanent fix.
Performing backups and restoration.
Support has Database administration on Development and Production databases.