RESUME
8/5, Premsambandh, Ramnagar,
Bhandup (E),
Mumbai - 400042.
Mobile No: 9987935494
Sandip Damodar Ghanekar.
Career Objectives:
To maintain mission critical database in 24*7 operational mode on Unix/Linux and to share knowledge and experience to standardize the support environment.
Work Experience:
About 7+ years experience in full life cycle of database administration on Production/Development environments which includes Database creation, upgrades, maintenance in UNIX environments on Oracle.
Professional Qualification:
Oracle Certified Associate (OCA) in Oracle 9i.
Educational Qualification:
Bachelors in Mechanical Engineering from Mumbai University.
Strong knowledge of Oracle Architecture.
Installing & Managing Oracle on Unix/Linux
Creating & maintenance of Database.
Multiplexing & Creating Control files.
Maintaining & Monitoring Redo Log files.
Managing Tablespaces such as Creating, altering & dropping Tablespaces.
Creating disk groups, adding disk groups, dropping disk groups.
Managing Data files such as adding data files in RAC & Non-RAC databases, resizing, renaming & relocating Data files.
Creating Users & granting privileges.
Knowledge of Expdp & Impdp.
Done CPU and PSU patching on RAC database and Single instance Database.
Knowledge of Data Guard.
Upgrade Standalone & RAC database from 10g to 11g & from 11g to 12c
Knowledge of RAC & ASM
Knowledge of Data Guard (Configuration & Switchover)
Basic knowledge of Golden Gate
Skills:
|
RDBMS |
Oracle 9i/10g/11g |
|
Operating System |
Linux, HP-UX, AIX,Sun-Solaris |
|
Languages |
SQL |
|
Tools |
Toad, Remedy Tool, Expdp/Impdp |
Work Experience:
1 |
Tech Mahindra Pvt Ltd |
|
Role |
Oracle Database Administrator |
|
Clients |
State Bank of India |
|
Duration |
2 Yr & 4 Months(20 Mar 2017 to till Date) |
Responsibilities:
Installation and Configuration of Oracle Non- RAC Databases
Installed Two node RAC cluster for Pre-Prod environment and production database
Performed Patching on Both ORACLE_HOME and GRID_HOME on Oracle 11g RAC Databases
Maintenance of production database which includes tablespace management, user creation, privileges, roles etc.
Worked on database maintenance activity reorganize tables, index rebuild, stats gather
Perform logical backup (using Export/Import or expdp/impdp utilities).
Configuring & managing Physical Standby database
Performed DR-Drill Activity (Database Swicthover)
Performed Database Failover Activity
Database Up-gradation from 10g to 11g
Creating partition for existing tables in production
Killing user sessions as per user's appropriate request.
Creating and estimating the size of tablespaces like adding, resizing datafiles and monitoring free space.
Creating disk group, adding disks in disk groups in RAC databases.
Involved in Issue resolution, User communication and interactions and regular support activities
2 |
BCT Consulting Pvt. Ltd. |
|
Role |
Oracle Database Administrator |
|
Clients |
State Bank of India |
|
Duration |
11 Months(2nd May 2016 to 19 Mar 2017) |
Responsibilities:
RAC Installation on Solaris.
Perform DR drill activity.
Killing user sessions as per user's appropriate request.
Creating and estimating the size of tablespaces like adding, resizing datafiles and monitoring free space.
Taking export & Import
Patch Application to Installed Oracle Releases.
Creating disk group, adding disks in disk groups in RAC databases.
Involved in Issue resolution, User communication and interactions and regular support activities
3 |
Softenger (India) Pvt. Ltd., (Pune) |
|
Role |
Oracle Database Administrator |
|
Clients |
Vodafone Essar Ltd |
|
Duration |
2 years (27 Sep 2013 to 15th Mar 2016) |
Responsibilities:
Killing user sessions as per user's appropriate request.
Creating Tables & adding in replication on target Databases.
Involved in Issue resolution, User communication and interactions and regular support activities
Creating and estimating the size of tablespaces like adding, resizing datafiles and monitoring free space.
Taking export & Import
Patch Application to Installed Oracle Releases.
Creating disk group, adding disks in disk groups in RAC databases.
Resolving incidents, Severity tickets raised using REMEDY tool.
4 |
WDC Pvt. Ltd. |
|
Role |
Oracle DBA |
|
Clients |
Vodafone Essar Ltd |
|
Duration |
2 years (25 April 2011 to 26 Sep 2013) |
Responsibilities:
Installed and configured Oracle on UNIX platform.
Involved in the creation of client databases.
Day To day monitoring of alert logs.
Creating and estimating the size of tablespaces like adding, resizing datafiles and monitoring free space.
Patch Application to Installed Oracle Releases.
Creating disk group, adding disks in disk groups in RAC databases.
Managing database objects like tables, views, indexes, etc including creating, altering, deleting, analyzing & querying information.
Involved in Issue resolution, User communication and interactions and regular support activities.
User management including creating Users & granting privileges, assigning quotas on tablespaces, assigning default tablespace & temporary tablespace.
Managing user profiles, user accounts & password policies.
Coordinated with Unix Administrators for space management regarding mount points on various servers.
Resolving incidents, Severity tickets raised using REMEDY tool.
5 |
Softenger (India) Pvt. Ltd., (Pune) |
|
Role |
Associate consultant |
|
Clients |
Vodafone Essar Ltd |
|
Duration |
1 year (18 March 2010 to 25 April 2011) |
Responsibilities:
Monitoring more than 150 databases and Troubleshooting the tablespace space errors, archive log and space management for all the databases.
User management including creating Users & granting privileges, assigning quotas on tablespaces, assigning default tablespace & temporary tablespace.
Managing profiles, user accounts, password policies.
Disable, enable, lock & drop users as per requirement.
Production support for oracle database.
Generating monthly & quarterly user reports.
Involved in Issue resolution, User communication and interactions and regular support activities.
6 |
Q-Soft Systems & Soutions Pvt. Ltd., (Andheri) |
|
Role |
Consultant |
|
Clients |
Vodafone Essar Ltd |
|
Duration |
1 year & 4 months (1st Sep 2008 to 1st Feb 2010) |
Responsibilities:
User management including creating Users & granting privileges, assigning quotas on tablespaces, assigning default tablespace & temporary tablespace.
Managing profiles, user accounts, password policies.
Disable, enable, lock & drop users as per requirement.
Production support for oracle database.
Generating monthly & quarterly user reports.
Involved in Issue resolution, User communication and interactions and regular support activities.
Personal Details:
Birth Date : 20th Jan 1980.
Sex : Male
Marital Status : Married
Nationality : Indian
Passport No. : M3721943
PAN : ATGPG7581H
I hereby Declare that, the Information given above are true in the best of my Knowledge & Belief.
Place: Mumbai.
Date:
Yours Faithfully,
(Sandip Damodar Ghanekar.)