We provide IT Staff Augmentation Services!

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.

Hire Now