Sr. Oracle Database Admin

Amit Pawar

Email: *********.***@*****.***

Mobile: +91-845*******

http://amitpawardba.blogspot.in/

B. Tech / Oracle 10g/ 11g with 3.7 years of experience as Oracle DBA

OBJECTIVE:

Seeking a challenging and rewarding opportunity in the area of oracle DBA with an organization of repute which recognizes and utilizes my true potential while nurturing my analytical and technical skills

SUMMARY:

Involved in all the phases of software development cycle including Planning, Analysis, Design, Development, Testing and Implementation of application.

Excellent experience in Installation and configuration of different databases on Operating Systems LINUX and Windows platforms

Planning and scheduling the Physical (Cold/Hot) backups as well as Logical backups.

Maintaining Archive logs and their spaces for routine administration alert and trace monitor and purge however needed.

Good Exposure of Flashback in case of recovery of dropped table and in repairing of historical data

Having good knowledge of RMAN, Export & Import and Data pump.

Database Monitoring to ensure the smooth running of daily operations

Experience in schema's management, de-fragmentation and partitioning the tables & indexes to improve the performance

Taking RMAN hot & cold backup of database

Having knowledge about database design and implementation

Monitoring the performance of database using performance tools such as Stats pack, AWR, ADDM, SQL trace, Tkprof and Explain plan.

Installation, upgrading and migrating various versions of Database (10g/11g) on different platforms.

Installation and configuration of Oracle 10g/11g data guard, switchover and failover.

Having knowledge of Green Plum database

Provided 24x7 Remote/on-call production supports

TECHNICAL PROFICIENCY:

Languages

SQL/PLSQL, C++,

RDBMS

Oracle 9i/10g/11g, Green Plum

Operating System

Windows XP / 2000, UNIX, LINUX,

Packages

MS Office

Tools/Utilities

SQL*Loader, Data Pump (Export /Import), RMAN

Flashback

ADDM, AWR, Stats pack, TKPROF,

ACHIEVMENTS /AWARD/HONORS:

Acquired the Oracle Certified Associate DBA Core in 10g

Secured grade ‘B' in Elementary and Intermediate grade drawing examination held by government of Maharashtra

Secured 2nd prize in photography competition held inter college.

Completed Green Plum database training

EDUCATIONAL QUALIFICATION:

BACHELOR OF ENGINEERING, 2011, 64%BharatiVidyapeeth College of Engineering, Navi Mumbai

HIGHER SECONDARY COLLEGE, 2007, 71.33%BharatiVidyapeeth College, Belapur

PROFESSIONAL EXPERIENCE:

Role: Sr. Oracle DBA

Rediff.com

July 2015 –Present Mumbai

Currently working with Rediff.com

Rediff.com is an Indian news, information, entertainment and shopping web portal, founded in 1996 as "Rediff On The NeT". It is headquartered in Mumbai, with offices in Bangalore, New Delhi and New York City

Role: Oracle DBA

Institutional Shareholder Services Inc.

March 2015 –Present Mumbai

Previously Working for Institutional Shareholder Services Inc. (ISS) is the world’s leading provider of corporate governance solutions for asset owners, hedge funds, and asset service providers. ISS’ solutions include objective governance research and recommendations, end-to-end proxy voting and distribution solutions, turnkey securities class-action claims management, and reliable global governance data and modeling tools.

Roles & Responsibility:

Maintain highly critical databases in any operational mode on various servers.

Supports and Manages all the Production, Development and Staging databases.

Troubleshooting on Performance Issues by generating AWR,ASH Reports.

Use SQLT performance diagnosis utility to drill down performance issue.

Applying CPU patches (OPatch) for all databases.

Schedules the Cronjob Activities to automate the Daily Activities.

Configured Tablespace Reports for each database.

Automate the Archive zipping jobs with the help of shell scripting in Cronjob.

Writing SQL scripts for smooth operation in Monitoring Team.

Oracle Up-gradation and migration across various versions.

Creating users - assigning roles, privileges and profiles to users.

Configured ASM using ASMLIB & installed GRID home with Oracle 11gR2

Installation.

Database Creation Using DBCA.

Performed Export & Import of Schemas,Tablespace using Conventional export import & expdp & impdp utilities.

Performed Full, schema & object Level Exports/Imports.

Role: Oracle DBA

Reliance industries ltd

May 2012 – March 2015 (2.10 year) Navi Mumbai

Previously Working for Reliance industries ltd. From May 2012 to March 2015, RIL is one of the largest publicly traded companies in India by market capitalization and is the second largest company in India by revenue after Indian Oil Corporation. It is also India's largest private sector company by revenue and profit. The company is ranked 99th on Fortune Global 500 list of the world's biggest corporations for the year 2012.

Roles & Responsibility:

Responsible for providing 24 * 7 supports to production Database Team.

Expertise in Oracle Data Base Administration, Oracle 10g/11g. Conceptually strong with an innovative and analytical approach to the work with an eye for detail.

Installed and configured Oracle 9i/10g Database software on Linux / windows Operating system.

Installing and configure oracle data guard for disaster recovery.

Development and implementation of new applications and designing database.

Creating and managing table spaces and data files for data storage.

Conspicuously using database objects like Table, Indexes and Views etc. for customization/new application.

Granting and Revoking the system and object privilege to / from user.

Granting / Revoking the roles and privilege to and from the oracle db users.

Maintaining Archive logs and their spaces for routine administration alert and trace monitor and purge archive logs however needed.

Tracing the User's by auditing the action of the user on specified object.

Having clear knowledge of the creation and maintaining database link, Multiplexing redo log& control files.

Proficient in using oracle tools like DBCA, SQL Loader and OEM etc.

Conceptual clear in Installation, Maintaining the Backup & Recovery using RMAN and logical through IMPORT / EXPORT utilities.

Enriched with the ability to learn new concepts & technology within a short span of time.

Coordinated with the front end design team and middleware design team to provide them with the necessary procedures and packages and the necessary insight into the data.

Created and modified several UNIX shell script according to the changing needs of the project and client requirements.

Created indexes and partition for faster retrieval of the data to enhance database performance.

Involved in data loading using PL/SQL and SQL*Loader calling UNIX scripts to download and manipulate file

Creation of database objects like tables, views, materialized views, procedures and packages, sequence using oracle tools like PL/SQL Developer

Fine-tuned procedures/SQL queries for maximum efficiency in various databases using Oracle Hints, for Rule based optimization.

Involved in full development cycle of Planning, Analysis, Design, Development, Testing and Implementation.

Environment: Oracle 11g, PL/SQL, SQL PLUS, sql developer and UNIX shell scripting.

Project Undertaken-1:

Project : Decision Support System (Reliance Retail)

Role : Junior Oracle DBA

Duration : May 2012 to till date

Team Size : 4

Roles & Responsibility:

Strong experience in installation and configuration of Oracle 10g/11g.

Maintaining Archive logs and their spaces for routine administration alert and trace monitor and purge archive logs however needed

Check whether all databases are up.

Monitor the alert log file and take actions if any errors found.

Performing DBA activities like Database creation, Table space Management, User Management, and Table/Index Management..

Re-organization of logical structures to remove fragmentation

Granting and Revoking the system and object privilege to / from user.

Managed Data files, Parameter files, Control files, Online Redo logs and Archive logs.

Managed table spaces, resizing and adding new, monitoring database growth

Planning for backup and recovery of database and maintaining Hot Backups and Cold Backups

Monitored and diagnosed database performance through monitoring of alert files, trace files

Performed Database Duplication using RMAN

Development and implementation of new applications and designing database.

Installation, upgrading and migrating various versions of Database (10g/11g) on different platform

Responsible for creating user logons and managing user accounts.

Monitor the instance and plan for future availability of storage on user's table spaces

Installation, upgrading and migrating various versions of Database (10g/11g) on different platforms.

Monitoring the performance of database using performance tools such as Stats pack, AWR, ADDM, SQL trace. Tkprof and Explain plan.

Installation and configuration of Oracle 10g/11g data guard, switchover and failover.

Production Support for rotational on call.

Environment: Oracle 11g, PL/SQL, SQL PLUS, sql developer and UNIX shell scripting.

Project Undertaken-2:

Project : Oracle Upgrade and migration project (DSS)

Role : Senior Oracle DBA

Duration : Dec 2013 to till date

Team Size : 3

Description:

Oracle Upgrade is retail level program which Upgrades all the oracle lower version of databases to Oracle 11g. We have upgraded nearly 20 databases as a part of this program.

Responsibilities:

Proposing planning and designing upgrade activity in details..

Identifying the unsupported and supported features in 11g database and proposed solutions.

Review of the upgraded code for unsupported features.

Identified prerequisite details for upgrade activity

Involved in production go live and post production.

Identified post requisite details after upgrade activity.

Validating the DB objects and optimizing the stored procedures, functions and packages

Performed post upgrade support like performance Tuning, maintenance and monitor

Environment: Oracle 11g, PL/SQL, SQL PLUS, sql developer and UNIX shell scripting.

Project Undertaken-3:

Project : Reliance 4G database environment setup

Role : Senior Oracle DBA

Duration : Feb2014 to till date

Team Size : 4

Description:

Reliance 4g is one of the biggest project of reliance,for which we have done almost more than 40 databases design and setup with production release.

Responsibilities:

Planning and designing implementation and setup activity.

Identifying user requirement.

Identified prerequisite details for implementation and configuration activity

Involved in production release and testing.

Identified post installation requisite details after installation activity.

Checking all the security aspects and user management, profile management.

Scheduling and designing plan as per performance point.

Planning and proposing backup strategy and maintenance activity.

Environment: Oracle 11g, PL/SQL, SQL PLUS, sql developer and UNIX shell scripting.

Project Undertaken-4:

Project : DATAGUARD POC for Reliance 4G

Role : Senior Oracle DBA

Duration : May 2014 to till date

Team Size : 4

Description:

Under this project we have done oracle dataguard poc for 4G project.

Responsibilities:

Setup and configure data guard(Disaster Recovery) enviornment

Testing all the features of data guard as per business point of view

Testing active and snapshot standby database features.

Testing failover and switch over.

Testing all the protection mode in data guard.

Testing performance and maintenance.

Testing and designing backup policy.

Environment: Oracle 11g, PL/SQL, SQL PLUS, sql developer and UNIX shell scripting.

PERSONAL DETAILS :

Nationality : Indian

Gender : Male

Date of Birth : October 03,1989

Permanent Address : B/10-23, 0:2 Sector-3 Navi Mumbai, Belapur,

PinCode - 400614

Languages Known : Marathi, English and Hindi

Hobbies : Music, sports, movies, surfing, traveling, chess,

painting

Contact this candidate