Manager Oracle

Location:

Frederick, MD

Posted:

November 11, 2012

Contact this candidate

Resume:

Ravi BharadwajaOracle DBA

Phone: 240-***-****

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

Resumes ID: 49166

Location: Wilmington, Delaware

Posted: 05.02.2012

Resume Details:

Highly accomplished, deeply driven, database administrator with 8+ years of track record in oracledatabase administration. Proven ability to tackle and succeed in all endeavors of database.

Experience Summary

Databases

Oracle 7.x / 8.x/9i/10g/11g

Operating Systems

Red Hat Linux, Sun Solaris, AIX, HP-UX, Windows 98/2000/NT/XP

Tools

SQL*Loader, OEM, RMAN, SRVCTL, DBCA, BMC patrol, CSSCAN, Data Guard, GoldenGate, Instance Manager, Import manager, Export managers, Data Mover, Object Security, Performance Manager tools, TOAD, Spotlight,SCM and DBDiff.

Storage Tools

Tivoli Storage Manager, Veritas Net Backup

Hardware

P Series, NLSUN 829, SUN 6500, Alpha Server ES45, Compaq CL380T01

Languages

Shell Scripting, PERL, SQL and PL/SQL.

Job Scheduler

AUTOSYS

Excellent experience in oracle database administration on Oracle11g/10g/9i/8x/7x databases in different environments LINUX, AIX, HP-UNIX, SUN SOLARIS and WINDOWS.

Strongest skills on Sun Solaris and other Unix/Linux versions

Strong Experience in Installation, Configuration, Maintenance, PerformanceTuning (memory Tuning and SQL tuning), Backup& Recovery, Cloningin standalone and RAC environments.

Experience in using ORACLE SPATIAL TKPROF, EXPLAIN PLAN, SQL Trace, STATSPACK and Automatic Workload Repository (AWR).

Experience in Re-Organization of database using export/import and Data Pump.

Experience in implementing and using Oracle Streams AQ/DQ and Oracle GoldenGatefor Replication.

Hands on Experience with Oracle Internet Directory(OID) and Oracle Directory Server (ODS)

Experience with Disaster Recovery,Data Guard, RMAN, Real Application Cluster (RAC), OLTP and Data warehousing environments.

Enforcing Database security by creating and assigning Roles, Profiles and Privileges to various Users (Schemas) on different Objects.

Implemented Oracle Enterprise Manager (OEM), Automatic Storage Management (ASM) & Automatic Database Diagnostic Monitor (ADDM).

Proficient in using various database utilities like Export/Import, Expdp/Impdp (Data Pump), SQL * Loader and DBverify.

Extensive experience with RMAN backup, hot backup and cold backup. Performed full backups and incremental backups. Backup and Recovery strategy using hot backup, user managed and RMAN.

Experience in developing Shell Scripts to manage Oracle databases daily backups and monitoring jobs.

Migrating and Upgrading the databases to higher versions.

Excellent communication and interpersonal skills.

Proficient in Verbal and Written Communication skills which enhances my ability to communicate with everyone working around me and the ability to Prepare the Documentation with ease to understand.

A quick learner and an excellent problem solver who can work independently or as part of a team. Skilful in learning new technologies quickly and incorporating them in the existing infrastructure.

Worked as a team member to provide 24x7 on-call production support.

Employment History

T.RowePrice, MD Oct 2010 – Till date.

Senior Oracle DBA

Installation of 11.1.0.7 RAC software to support Real Application Cluster environments with 3 nodes.

Installation of 11.1.0.7 RDBMS software and created databases using DBCA.

Upgraded database from 11.1.0.6 to 11.1.0.7.

Solaris 8, 9, 10 Installation, Solaris Jumpstart Automated Installations

Application performance issues were supported using OEM GRID control and AWR reports.

Support more than 45 plus, 11g/ASM/10g/9i RAC database instances as primary DBA (PROD/DR/QA/SIT/DEV). Provide 24x7 supports for Production databases.

Manage both OLTP and data warehouse databases that have more than a thousand of concurrent user sessions and over terabytes of data.

Implemented DB control and Grid control in order to manage the databases using Oracle

Install and upgrade Oracle software using OFA structures. Applying patches and bug fixes. Appling company’s Security Baseline to the Oracle filesystems and oracle binaries post installations.

Create new Oracle databases using DBCA or database scripts.

Creating new ASM disk group or raw devices for RAC DBs. Configure RAC DB failover and load balancing.

Creation of different Application schemas and setup proper user profiles. Grant/revoke certain sys/object privileges to meet security requirement.

Build/Repair Standby databases/DataGuard using RMAN restore and duplicate command.

Perform Oracle performance tuning and monitoring using Oracle OEM/AWR.

Recover user errors using both Oracle Flashback based recovery and also time based incomplete recovery by applying archived redo logs from backups.

Configured VERITAS Netback up to store the backups on Tape devices.

Implement CA AUTOSYS and Oracle DBMS_SCHEDULER jobs to perform RMAN database disk and Netbackup tape backup with ZLIB compression to save space.

Implement systems with 24x7 high availability using different methods including Oracle RAC/Standby and SRDF.

Work with developer in designing database tables, partitioning/indexing, new 11g table compressions, developing PL/SQL codes, stored procedures, triggers and performing queries optimization.

Wrote PL/SQL codes for oracle spatial queries.

Troubleshoot DB issues and provide immediate response for critical Production databases. Reach out to Oracle technical support through Metalink and service request TARs.

Tune SQL slow statement by collecting/setting cost based optimizer statistics and also using hints to accommodate some particular queries.

Performed Schema as well as Table level Replication using Oracle Streams.

Configured and install Golden Gate for replication between RAC clustered Databases.

Refresh large databases using fine tuned Parallel Data Dump streams & imp/exp utilities, configurations of large undo/temp space, compressed dumpfiles, UNIX split command and named pipes.

Set up and maintain company standard db scripts and documentation for new Oracle databases build.

Environment: Oracle 11g/10g/9i, RAC, Oracle Fail Safe Manager, Erwin, OEM, Oracle Data guard, Oracle Universal Installer, Oracle Configuration Assistant, BMC patrol, Power Builder, PL/SQL, Unix Shell scripting, RMAN, Quest tools, Rapid SQL, Perl, HP-UX, Linux, Windows 2003, Windows 2008 server and AIX.

Celgene Corp, Summit, NJ Apr 2008 – Aug 2010

Senior Oracle DBA

Installation and configuration of Oracle 9i, 10g, 11g and Oracle RAC software.

Implemented DB control and Grid control in order to manage the databases using Oracle Enterprise Manager (OEM).

Creation of databases using Database configuration Assistant (DBCA) and custom scripts.

Migrated Oracle 9i to 10g.

Designed and developed scripts for Disk Backups & Net Backups.

Migrated Data from Production to UAT, QA, SIT and development databases.

Managing Users, Privileges and Roles.

Initiate and interpret user session trace using TKPROF.

Implemented Automatic segment space management (ASSM).

Implemented Automatic Storage Management (ASM).

Administered 2 node cluster databases (RAC).

Adding and deleting nodes in RAC using Oracle Universal Installer (OUI).

Implemented Data Guard for disaster recovery, high availability and performance configurations.

Implemented Oracle Streams with Advance Queuing (AQ)/ Dequeing (DQ) for Object level replication, schema level and tablespace level replication.

Performing Oracle 9i Database on HP-UX and Linux, PL/SQL, Relational Design, Backup, RAC, RMAN

Applying Database software patches.

Used SQL*Loader to populate the data from Flat files to Oracle Database Tables.

Experience with OLTP & DSS environments.

Configured the DATAGUARD for switchover and failover.

Schema and Table level Data migrations were implemented using EXPORT/ IMPORT and Data Pump.

Co-ordination with System Administrators and Network Administrators to achieve zero down time and better performance of the servers.

Extensively involved in maintaining & updating the database documentation.

Migrated over 40 10g database from Solaris 10 to IBM AIX systems.

Reorganized tablespace in order to avoid fragmentation and table reorganization in order to improve the Performance of the database.

Regular monitoring of database for inactive and hanged sessions which affect the performance of the database.

Implemented Autosys to schedule Monitoring, Administering and Application batch jobs on all the environments.

Optimized SQL, PL/SQL code and performance tuning using AWR, TKPROF, EXPLAIN PLAN & STATSPACK.

Provided on-call support for Production databases and also resolved the issues working with development team.

Galaxy Solutions, NJ June 2006 – Mar 2008

Oracle Database Administrator

Installation, configuration and upgrading of Oracle database for datawarehouse environments.

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

Clustering, Session configuration, Deployment Automation with shell scripts, Production Support.

Performance tuning of Oracle, which includes Memory & SQL tuning.

Implemented nightly cron jobs to maintain the backup and for other administrative works.

Archiving backups and maintaining backup’s library. Continuous monitoring for free space at backups archive destination.

Used SQL * Loader to load the bulk data into the database for converting legacy databases to oracle formats.

Upgrading BI Database from 9i to 10g.

Migrating schemas from development to test and test to production databases.

Refreshing data from production to test and development.

Managing tablespaces for different users & reorganizing the objects.

User creation and granting permissions to access the database.

Configured the DATAGUARD for Disaster Recovery, switchover and failover.

Experience in opening and resolving Tars.

Experience in working with Sybase database.

Monitoring server availability for 24x7 users.

Implemented Recovery Manager (RMAN). Created recovery catalog, performed complete and incomplete recovery using RMAN.

Experience working with Oracle Internet Directory (OID) and Oracle Directory Server (ODS).

Tuning Database for optimal performance.

Optimizing the SQL’s for maximum performance by using TKProf and EXPLAIN PLAN.

Performance tuning using SQL TRACE, SQL Trace for a particular session, DB Cache Advice, Statspack, appropriate index implementation, Database reorganization and OEM tools.

Performed database replication through GoldenGate.

Implemented the new features of Oracle 9i like Automatic Undo Management, Default Temporary Tablespace, Dynamic SGA management etc.

Troubleshooting day to day Oracle related problems in the production environment.

Implemented the Locally Managed Tablespaces thereby reducing the overhead of managing the extents by Oracle.

Performance Monitoring and tuning of the databases to improve server performance by reducing the disk I/O contention. Tuning the memory buffer cache, Library cache and data dictionary of shared pool.

Environment: Oracle 9i/10g, UNIX, LINUX, Windows 2003 server, Shell Scripting, PL/SQL, RAC, RMAN, OEM, QUEST tools, Erwin, SQL*Loader, Toad, SQL*Plus, Data Mover, Object Security, Import Manager, Oracle Configuration Assistant, Oracle Data guard, Oracle Universal Installer.

ACS HR Solutions, Kochi, INDIA. Feb 2004 – May 2006

Oracle Database Administrator

Installation and configuration of Oracle server software 9.2.0.1 on UNIX platforms.

Created Oracle 9i databases, allocated system storage and planned future storage requirements for the database.

Database Backups & Recovery using RMAN.

Responsible for designing the oracle Database & Schemas.

Responsible for Oracle database upgrades (all systems) from 8 to 8i and 9i.

Designed and Installed the Oracle 8i, 9i databases.

Responsible for pre-install analysis, activities, and installation of 8.1

Contact this candidate