Oracle Dba Resume
SUMMARY:
Total work experience of more than 12 years in the field of IT. Expertise in both Oracle as well as Teradata RDMS. Working in Teradata for 7 years as Global Delivery Consultant / Service Lead. Data migration expert and as DBA support to ensure 24*7 daily operations on many Managed Services accounts at Teradata. Managing data warehouse systems for over a decade helping customers get value of their data and reduce their stress of managing complex systems. Leading Managed Services teams on different critical accounts. Great tendency to work under pressure and problem - solving capability.
TECHNOLOGIES:
- Unix/windows/Linux
- Teradata Viewpoint
- Teradata Performance optimization
- Teradata utilities
- Teradata Aster
- Teradata ABU,Netvault,DSA
- Terdata querygrid
- Teradata datamover
- Teradata query director
- Teradata Unity
- Informatica
- Shell scripting
- Oracle
- TASM/TIWM
- Industries
- Telecom
- Retail
- Lottery
FUNCTIONAL EXPERTISE:
- TD performance DBA
- TD migration expert
- Professional Services Consultant
- Oracle DBA
PROFESSIONAL EXPERIENCE:
Confidential
Oracle DBAResponsibilities:
- Performed data migration activity to Intelliflex 2.0 from Enterprise Edition which includes statistics migration from older system to newer system as well as post migration activities such as assigning spool, perm space and migration of hash/join indexes to new system.
- This activity also involved view point configuration to new system and setting its portlets accordingly. The migration activity was well appraised by the client
Technologies: Deployed: Teradata 16.20,Teradata Viewpoint 16.10,Teradata PDCR.
Confidential
Lead Teradata Performance DBA
Responsibilities:
- I have also upgraded their systems to Teradata 16.20 version from 15.10 and resolve post upgrade performance issues.
- Further I have part of providng Daily DB operation tasks, Backup And Recovery operations, Implemented Automated stats feature, View point monitoring, CS coordination regarding incidents over TAYs, Monthly BAR & Service reports, Capacity planning.
- Have earned several appreciations from client on great performance
Technologies: Deployed: Teradata 15.xx,Teradata 16.xx,Teradata Viewpoint, TASM, PDCR, Teradata ABU,Informatica 10.2
Confidential
Responsibilities:
- Performed data migration activity for Confidential from TD version 15.10 to TD version 16.20 on Intelliflex 2.0.
- This also involved catering of performance issues after migration and involved activities involving stats collection, procedure rebuilding and suggesting best practices with regard to good performance .
Technologies: Deployed: Teradata 16.20,Teradata Viewpoint 16.10,ABU .
Confidential
Team Lead/Teradata Performance DBA
Responsibilities:
- Have done migration of Teradata nodes from TD 14.xx to Teradata 15.xx.Also provided DBA services as well as BAR services on Aster .
- Have been doing Unix users administration, Backup and Restore (BAR) environment administration, Cross system restores, Access Rights Management and daily day to day database adminsitrative tasks.
Technologies Deployed: Teradata 14.xx,15.xx,Teradata Unity,Teradata datamover, Teradata Query director,Teradata Query grid,Netvault, Aster .
Confidential
Teradata Performance DBA
Responsibilities:
- I have been providing Performance DBA services to this client along with unix administrative services.
- Have also been providing daily DB tasks as well as backup and recovery services to this client
Technologies Deployed: Teradata 14.xx,Teradata Viewpoint, Netvault .
Confidential
Team lead/Teradata Performance DBA
Responsibilities:
- I have been providing Terdata Performance DBA services along with ETL-level 1 services to this client.
- Have also performed floor sweep from Teradata 13.xx to TD 14.xx .
- The system was migrated from older system to new system with new number of amps.Also provided remedy to all the post upgrade/migration issues .
Technologies Deployed: Teradata 13.xx,14.xx,Teradata Viewpoint, Netvault .
Confidential
Teradata Performance DBA
Responsibilities:
- I have provided ETL-1 support to this client ensuring successful run of the daily batches along with teradata DBA services.
Technologies Deployed: Teradata 13.xx,Teradata Viewpoint, Netvault .
Confidential
Teradata Performance DBA
Responsibilities:
- I have provided ETL-1 support to this client ensuring successful run of the daily batches along with teradata DBA services.Have also worked on workflows executions and modifications in Informatica .
- Provided BAR sercices using Netvault to this client.
Technologies Deployed: Teradata 13.xx,Teradata Viewpoint, Netvault .Informatica 9.6