Oracle Manager

S hravan Kumar Jamalpur

Oracle Database Administrator

660-***-**** ) (mobile)

********.***@*****.***

SUMMARY OF EXPERIENCE:

8+ years of professional experience as Oracle Database Administrator having good experience in database

administration, database installation, up-gradation, migration, installing patches, performance tuning, RAC

installation and maintenance, setting up and configuring Data-guard, performing all kinds of backups and

recoveries, cloning databases, replications using golden gate, auditing and product support

• Hands on experience on Oracle (9i/10g/11gR1/11gR2/12C), installing and configuring, maintaining Oracle

databases on different operating systems like UNIX (RHEL 4/5, AIX 6.1, OEL 5/6, Solaris10, HP-UX 7) for OLTP

& OLAP environment.

• Having good experience in 10g/11g/12c database administration Real Application Cluster.

• Experience in configuring high availability systems like Real Application Cluster 10g/11g on RHEL 4 / 5.8, OEL

6.1.

• Experienced in managing RAC environment 11g/12C OEM Grid Control.

• Experienced in Installing, monitoring and managing of Oracle instances using Enterprise Manager Grid Control

10g/11g/12c.

• Configured Targets and used OEM to do the daily tasks regarding the performance, maintenance.

• Having good experience in working with World Fastest Machine Exadata (x2-8) Dataguard and Golden gate

• Planned and Implemented Disaster Recovery databases using Dataguard.

• Experienced in configuring, managing, trouble shooting and monitoring Physical standby using Data Guard

10g/11g/12c.

• Have hands experience in 11g new features Active Data-guard & snapshot standby.

• Installed, Configured and replicated databases using Oracle Golden Gate.

• Installed patches using Opatch utility and upgraded databases on 9i/10g/ 11gR2 and expertise in applying Oracle

PSU and CPU patches Up-gradation and migration.

• Upgraded databases from 10g to 11gR2 on Solaris and Linux platforms.

• Performed up-gradation of grid infrastructure from 11.2.0.2 to 11.2.0.3.

• Having good experience in migrating databases with zero downtime using golden gate & Dataguard.

• Performed cross platform migration of databases from IBM - AIX, Solaris, Hp-Unix to Linux 11g RMAN,

FLASHBACK and Data pump.

• Experience in implementing and planning backup and recovery strategies using Recovery Manager, created

clone databases for development and test environments using RMAN.

• Experience in taking Full and partial backups, Incremental and Cumulative backups using RMAN .

• Configured catalog database and registered databases in catalog using RMAN.

• Implemented data transfer using Transportable Table Spaces (TTS), Data Pumps and Export/Import utilities.

• Implemented User managed cloning and Flashback Technology Performance Tuning and Oracle Security.

• Experience in SQL tuning using Explain Plans and Hints, Performance Tuning for better performance and

Monitoring and optimizing.

• Performance Tuning of the database (I/O Tuning, Tuning Contentions) u sing oracle 11g tools like AWR,

ADDM, Advisories, TKPROF, EXPLAIN PLAN for the Better performance.

• Performed various Transparent Data Encryption Operations.

• Enforced Security administration, system monitoring by adding and removing users, configuring quotas,

auditing, and analyzing security problems.

• Experience using Erwin as a Data Modelling tool & Designing the ETL processes.

• Good knowledge on Oracle support process for technical requests using Metal link and other support

features.

• Good written and verbal communication skills, self-motivated team player and good analytical thinking.

• 24 X 7 Production database administration, support and monitoring to ensure Proactive problem recognition

and resolution of database issues.

TECHNICAL SKILLS:

Databases 11gR2, Oracle 11gR1, Oracle 10gR2, Oracle 9i.

Oracle Products Oracle Real Application Cluster 10g/11g, Golden Gate, Data guard, Import and

Export, Data pump, Oracle Wallet Management, Automatic Storage Management,

Recovery Manager, Oracle 10g/11g/12c (Grid Control), Oracle Exadata, RMAN,

Transparent Data Encryption.

Operating System Oracle Linux, HP UNIX 11i, Red Hat Enterprise Linux (RHEL) 4.x, 5.x, 6.x, AIX 6.1,

Sun Solaris 5.8, 5.9, 5.10, Windows XP/2003/2008

Languages SQL, PL/SQL, Unix shell scripting, Java

Tools & Utilities SQL Trace and SQL tuning Advisory, SQL* plus, ADDM, DBCA, Log Miner,

TKPROF, AWR, ASH, Toad, Oracle SQL Developer, DB Artisan Putty, ERWIN, ETL

PROFESSIONAL EXPERIENCE:

Johnson & Johnson Health Care Systems, Piscataway, NJ Aug 2013 – Aug 2014

Role: SR. Oracle DBA

Johnson & Johnson is an American multinational medical device, pharmaceutical and consumer packaged goods

manufacturer. It is an organized on the principles of decentralized management group responsible for strategic operations

and allocation of resources. Its operating companies are organized into three business segments: Consumer,

Pharmaceutical and Medical Devices and Diagnostics. It’s a manufacture and sale of broad range of products in the

health care field in many countries of the world.

Responsibilities:

• Installation, configuration, and maintenance of Oracle 10g, 11g on RHEL 4 and 11g on RHEL 5, HP-UX, AIX and

Windows 2003 Server and Upgradation from Oracle 10g to 11g.

• Upgraded databases from 11.2.0.4 to 12C in QA and Prod environments

• Responsible for setup and implementation of two node and three node RAC on Oracle 11g.

• Configured Oracle Dataguard for Oracle Disaster Recovery.

• Performed switchover/switchback from primary database to standby database for testing purpose for the

application teams when required.

• Worked on SQL SERVER 2005,2008.

• Performed day to day administrative tasks by analyzing the database like checking for failed processors, verifying

the query for particular issues and validating disk space.

• Migration of large number of databases from 10g to 11g.

• Implemented ASM on RAC and stand-alone databases.

• Migration of non ASM database to ASM database.

• Using list partitions for large tables and bitmap indexes for the OLAP databases.

• Cloned databases using RMAN Utility.

• Installation and configuration of Goldengate .

• Replication of data using Oracle Goldengate.

• Applied Interim patches & Critical patches in both 10g & 11g.

• Looking into day-to-day activities of Production database, Monitoring its growth and performance.

• Creation of users and granting them their roles and privileges.

• Configuration of Listener and TNS names using NETCA and NETMGR.

• Daily incremental backups and weekly cumulative backups using RMAN.

• Done exports and imports of tables, schemas and tablespaces with datapump.

• Archive weekly all production database exports to Tapes.

• Developed and enforced both database and OS-level security policies for data protection.

• Monitored all the databases in the areas of maintenance, tuning, performance, and troubleshooting.

• Installed and configured OEM 12c and monitored databases from OEM 10g/12c.

• Post installation process, kernel upgrade, applying support packs and add-ons.

• Worked extensively on Performance tuning of Queries by maintaining Aggregates, Compression, partition,

indexing and use of Hints, Stored outlines, Statistics.

• Worked extensively on monitoring grid control database, configuration of error notifications, installing listeners,

and adding them to the grid control.

• Efficiently used Oracle Tools like OEM, SQL* Plus, SQL* Loader, TKPROF, LOGMINER, AWR, ADDM,

STATSPACK, Data Pump, FLASHBACK and RMAN.

• SQL tuning and Database tuning has been done based on reports generated by Run time SQL execution plans,

AWR Reports, ASH reports, Explain Plans and monitor the database performance on daily basis.

• Developed Scripts for transferring data from production server to testing/development servers.

• Cloning of databases using RMAN and also user managed.

• Management of databases on multiple servers.

• Developed table structures, PL*SQL stored procedures and database triggers to implement business rules.

• Managing and providing 24X7 supports for various versions of databases.

• Performed on-call technical support to minimize the impact of system disruptions.

Environment: Oracle 10g,11g,Linux 6.3, Oracle Enterprise Manager, Grid Control, HP-UX, AIX, Windows 2003, OEM

Database control, PL/SQL, Oracle SQL Developer, Shell Scripting, TOAD, ASM, Golden Gate, Data Guard.

Valmont Industries, Omaha, Nebraska Oct 2012 – July 2013

Role: SR. Oracle DBA

Valmont is the global leader in designing and manufacturing poles, towers and structures for lighting and traffic wireless

communication and utility market. It also leads the world in mechanized irrigation equipment for agriculture, enhancing

food production while conserving and protecting water resources.

Responsibilities:

• Installed, configured and maintained databases on high availability systems like Data Guard and Real

Application Cluster environments

• performed fresh installation of 11.2.0.3 RAC on Automatic storage Management and created databases in RAC

environment

• Migration of SQL SERVER databases from 2005 to 2008.

• Installed OEM repository database, 12c agents on hosts and discovered targets and created new Groups,

Templates, Incident Rule sets in OEM 12c

• Configured Physical standby, Snapshot Standby and Active data-guard and performed Troubleshooting data

guard environment

• Up-gradation / MIGRATION of dev/test/prod databases from 10g to 11g

• Migrated applications from Unix to Linux using golden gate with minimum down time and resolved issues in

golden-gate

• Applied patch set and interim patches whenever required to make the database software up to date

• Involved in measuring smart scan, storage index and measuring offload statistics for individual SQL Cursors on

Exadata

• Focusing on Exadata administration

• used Flashback mechanism for logical corruption of databases

• Installed and Implemented Backup & Recovery procedures, Implement Hot, Cold and Logical backup plans

• Performed tasks like Database Sizing, Table space Management and Rollback Tablespace Management,

Transaction Management and Security Administration

• cloned databases for development and test environments using RMAN

• Taking periodic Backup of the Database and the software using RMAN and supporting VERITAS Net-backup

Team

• Creation of Users and granting them the required Roles and Privileges accordingly and Involvement in space

management, rectification of lock problems, managed quotas

• Managed Oracle space, performed Oracle table space management tasks, maintained tables, database objects

and Rebuilding indexes for better performance of Oracle database.

• Worked extensively in Performance Tuning at various levels including instance tuning, Query tuning, Database

performance tuning

• Used oracle tools like AWR, ADDM, Advisories, TKPROF, EXPLAIN PLAN for the Better database performance

• Extensive Performance Tuning, Memory (SGA) Tuning, RAID, RAW Devices

• Involved in Writing SQL scripts to monitor table space and extent growth

• Familiar with ORA-600 error & Involved with this ERROR

• Provided support to Application Database Administrators in designing the database

• Tested many scenarios in RAC, Dataguard and RMAN environment

• prepared documentation for maintenance, knowledge transfer and Mentoring level 2 DBA's

• 24 X 7 Production database administration, support and monitoring to ensure Proactive problem recognition and

resolution of database issues

Environment: Oracle 10g/11gR2, Sun Solaris 5.9, RHEL 5.x, OEL 6.3, OEM 11g/12C, EXADATA, RAC 10g/11g, ASM,

Data guard 10g/11g, Data pumps, RMAN, TDE, AWR, ADDM, ASH, TTS.

CenterPoint Energy, Houston, TX July 2010 - Sep 2012

Role: Oracle DBA

CenterPoint Energy operates in five primary businesses electric transmission and distribution, natural gas

distribution, interstate natural gas pipelines, field services, and competitive natural gas sales and services, where the CNP

web application consolidate the systemization of all the departments like Natural gas management, Electric accounts and

Power management

Responsibilities:

• Installation, configuration and maintenance of Oracle 11g databases

• Estimated growth of database size by detail analysis of the company's future policies and generating reports for

the management to act in advance.

• Performed up-gradation of grid infrastructure from 11.2.0.2 to 11.2.0.3

• Performed health checks of RAC instances using Crsctl and Srvctl utility

• Worked on X3-2 machine (half RAC)

• Worked on some stages in Exadata performing Smart scan, Storage Index, DBFS mount points and Flash cache

• Focusing on Exadata administration.

• Monitoring and managing of Oracle instances using Enterprise Manager Grid Control (OEM grid) 11g/12C

• Configured pfile, Listener and Net service names manually for production and physical standby databases in

Data-guard environment

• Migrated databases from File system to ASM & troubleshooting issues in ASM 11g

• Installed Golden Gate for replication between cross platforms

• Configured parameters files for extracts, replicat's

• Applied patches on standalone servers using Opatch utility

• Performed Migration of databases from 10g Unix to 11g on Linux

• Implemented data transfer using Data Pumps and Export/Import utilities

• Registered databases in catalog server and Performed Cloning of databases using RMAN from production to test

and dev environment

• Involved in scheduling incremental, cumulative and full backups and configured retention policy using RMAN

• Configured listener for external procedure calls, Worked closely with ETL applications team

• Performed daily maintenance tasks like space management, rectified locking problems, managed quotas

• configured network components like TNSNAMES, Names Server, Connection Manager, for easy and effective

management of Oracle networking

• Extensively used AWR, ADDM and EXPLAIN PLAN for Generating reports

• Develop and enforce both database and OS-level security policies for data protection.

• Involved in Setup the Oracle Wallet for Encryption Functions and Expertise in protecting the Oracle wallet with

ACFS access controls

• Created Tables That Contain Encrypted Columns and Oracle Wallet Management for Transparent Data Encryption

• Involved in administration of all databases in the areas of maintenance, tuning, performance, and troubleshooting

and debugging SQL/PL SQL involved in Application development

• Efficient in using the Oracle Tools like OEM, SQL* Plus, SQL* Loader, TKPROF, LOGMINER, STATSPACK,

SQL*Net, IMPORT/EXPORT, and RMAN

• Involved in writing for shell scripts for monitoring health checks and also for taking RMAN backups and Developed

Scripts for transferring data from production server to testing/development servers

Environment : Oracle 10g, 11gR1,11gR2 AIX 6.1, HP-Unix 7i, OEM, DBUA, RMAN, People-soft, Golden gate,

Grid, RAC, ASM, Data guard, SQL*LOADER, AWR, ADDM, ASH, TTS, Oracle Wallet, TDE, Data pumps

Epson America, Long Beach, CA Sept 2008 – July 2010

Role: Oracle DBA

Worked on “ERP” Application, where the Epson web application consolidate the systemization of all the departments like

service management, finance accounts and material management.

Responsibilities:

• Responsible for setup and implementation of 2 NODE RAC on 10g.

• Added a new node for 2 Node RAC for minimizing the downtime, maximizing availability and also achieved load

balancing by minimizing the interconnect traffic

• Used CRSCTL and SRVCTL commands for the stop / start Cluster operations.

• Worked on database Sizes >= 3TB

• Responsible for capacity planning, database security, recovery planning and installing patches

• Involved in UP-GRADATION of databases from 10.2.0.2 to 10.2.0.4 on Sun Solaris

• Installed 10.2.0.4 agent and involved in registering of databases in OEM

• Installed STANDALONE servers on ASM and migrated databases to ASM

• Worked extensively on monitoring 10g grid control database, configuration of error notifications, installing

listeners, and adding them to the grid control

• Collected ADDM recommendations using OEM 10g/11g to tune the TOP running SQL Query's

• Implemented Disaster Recovery Plan for critical databases using DATAGUARD

• Worked on physical and snapshot standby 11gR1 databases in Data-guard environment

• Involved in construction of Disaster Recovery (DR) for all the production databases using DATAGUARD

• Performed Database Refresh from production to testing and development environment and used EXPDP for

schema level

• Worked closely with PL/SQL developers for fine performance tuning

• Supported development teams by providing SQL statement tuning and removing load and query performance

bottlenecks by using tools EXPLAIN PLAN, STATSPACK, and TKPROF

• Experienced in scheduling the database backup jobs using Crontab

• Created a Clone database using RMAN on remote server

• Involved in database design and used Erwin as a Data Modeling tool & Designing the ETL processes

• Involvement in space management, rectification of lock problems, managed quotas

• Provided instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical I/O

and Memory Usage.

• Created and monitored database objects like Tables, Indexes, Views, Users and DB links

• Conducted time to time analysis and monitoring of the software and hardware requirements and act accordingly.

Environment: Oracle 11g/10g, Windows 2008, Sun Solaris 5.x, Oracle RAC, TOAD, VERITAS, OEM, LOGMINER,

Informatica, DB Links, SQL, PL/SQL, TKPROF, EXPLAIN PLAN.

CAPITAL IQ, Hyderabad, India July 2006 - August 2008

Role: Oracle Developer/DBA

Responsibilities:

• Involved in Up-gradation of databases from 9i to 10g

• Configured listener and TNS names manually

• Configured Oracle Data-guard for Oracle Disaster recovery on 10g Solaris.

• Achieved High availability, Data protection and maximum performance by maintaining physical standby databases

• Implemented Oracle database backup & recovery solutions using RMAN

• Configured and Tuned RMAN for better performance and backup strategies

• Involved in writing for shell scripts for taking RMAN backups

• Worked extensively on performance tuning of queries by maintaining Aggregates, Compression, partition,

indexing and use of statistics

• Restored and Recovered database at the times of occurrence of critical failures.

• Created user accounts, roles and granting required access permissions and privileges to the database based on

the application they are accessing

• Performed large batch jobs and tuning of SQL queries and database systems

• Monitored Oracle Instances, Users, Tables, Table-spaces, Memory structures, and Rollback segments, Redo-logs,

Archived Redo-logs and Alerts

• Performed automated backups and scheduling using scripting

• Written Stored Procedure and Triggers for database maintenance and management using PL/SQL and Involved in

gathering requirements from end users

• Estimate growth of database size by detail analysis of the company's future policies and generating reports for the

management to act in advance

• Clear documentation was prepared on all the processes like program specification, bugs fixing logs & change

requests for future reference

• Environment: Oracle /10g/9i, Sun Solaris 5.x, HP-UX 7.x, OEM 10g, Shell Scripting, TOAD, putty,

STATSPACK,EXPLAIN PLAN.

Education: Bachelor’s in Computer Science

Contact this candidate