Experience

Netsoftmate IT Solutions Pvt. Ltd.

• IT Manager, Database

  • juin 2016 - - aujourd’hui

  Oracle DBA.Oracle RAC.Performance Tuning.Data Guard.Exadata. GoldenGate. Oracle DBA.Oracle RAC.Performance Tuning.Data Guard.Exadata. GoldenGate.



Pythian

• Canada
• IT Services and IT Consulting
• 300 - 400 Employee

• Database Consultant

  • mars 2015 - juin 2016

  Oracle Database consultant. Oracle Database consultant.



Verizon Data Services India Pvt. Ltd

• Specialist-Database Administration

  • juin 2013 - mars 2015



Knot Solutions Pvt Ltd - CMMI DEV1.3 & SVC1.3 maturity level 3 appraised organization

• Consultant

  • janv. 2012 - juin 2013

  Oracle Database Administrator working with Knot Solution as a Consultant.Client: U Mobile , Malaysia Responsibilities as Database Administrator.• RMAN refresh from PROD to TEST.• Schema Management and Security.• Creating Monthly Partition and Backup of Partitions.• Data Purging and Archiving of Previous Partition months.• Manual Statistics collection of the Stale Objects.• Instance Changes as per request.• Creating and maintaining the users, secure application roles, privileges and profiles.• Performance Tuning ( Instance, Query)• Monitoring Database Health Check using Stats Pack/AWR.• Reporting and Analyzing Stats Pack/AWR.• Analyzing Trace File using Tkprof.• Analyzing Explain Plan.• Creating and managing Physical Standby databases.• Monitoring daily RMAN database backup.• Creating Database Objects like Table, Indexes, and Views and other DB objects for Application developers.



TCS

• Australia
• Accounting
• 1 - 100 Employee

• Oracle DBA

  • juil. 2010 - déc. 2011

  Worked as System Engineer with TATA Consultancy Services, Hyderabad. From July 2010 to till Dec 2011.Client: QUALCOMM , Hyderabad.Responsibilities as Database Administrator.• Created and Configured Oracle Database.• Creating and managing Initialization parameter file, Datafiles, tablespaces, Control files, and Redo log files.• Creating and managing tables with appropriate storage settings.• Security Administration by creating Users with appropriate Roles and Privileges, Creating and Grating profiles to users.• Transporting Data between Databases using Export/Import.• Performing schema refresh from production to development.• Taking backups using RMAN, incremental backups, full database backup.• Refreshing test/Development databases with Production database using RMAN.Client: CISCO, HYDERABAD Responsibilities as Database Administrator.• SQL Statement Tuning.• Monitoring Database Health Check using StatsPack/AWR.• Reporting and Analyzing StatsPack/AWR.• Analyzing Trace File using Tkprof.• Analyzing Explain Plan.• Collecting table and Indexes Statistics.• Creating and maintaining the users, secure application roles, privileges and profiles.• Creating and managing Physical Standby databases.• Monitoring daily RMAN database backup.• Database refreshes using RMAN.• Creating Database Objects like Table, Indexes, and Views and other DB objects for Application developers. • On-Call production DBA.