SUMMARY

• Oracle Database administrator with wide knowledge and proven experience of 8 years, Have been responsible for database administration, database installation, upgradation, migration, installing patches, performance tuning, RAC installation and maintenance, setting up and configuring DataGuard, performing all kinds of backups and recoveries, cloning databases, replications using Golden gate, auditing and product support.
• Senior Oracle Database administrator with experience in Oracle (9i/10g/11gR1 & R2), installed and configured on different platforms like Windows, UNIX (RHEL 4, RHEL 5, OEL 5, OEL 6, Solaris 10, HP - UX Itanium and IBM AIX).
• Experience in configuring high availability(HA) systems like Real Application Clusters(RAC) and Data Guard.
• Planned and Implemented Disaster Recovery(DR) and HA using RAC, Data Guard, Streams and made sure that the database is always available for the users even at critical times like failures and up-gradations.
• Configuration of Real Application Cluster with ASM and monitoring RAC instances with Crvctl and Srvctl.
• Experience in managing and monitoring ASM for standalone database and RAC database.
• Experience in configuring, managing and monitoring both Physical standby and Logical standby database using Data Guard.
• Configured and replicated databases using Oracle Golden Gate. Also set up Bi-directional (ACTIVE-PASSIVE)
• Successfully performed Oracle Golden Gate troubleshooting and performance tuning on Live databases.
• Experience in planning and managing multi-terabyte cross platform oracle database build and migration from Oracle 9i on Solaris server to Oracle 11g on RHEL 6.
• Experience in monitoring and managing of Oracle instances using Enterprise Manager Grid Control(OEM grid).
• Extensively used Oracle Enterprise manager for monitoring databases with strong ability at installing and configuring OEM database control, OEM grid control and Deploying Agents.
• Extensively created and maintained schema objects like tablespaces, tables, indexes, constraints, views, materialized views, synonyms, sequences and triggers.
• Monitoring and optimizing the performance of the database through database tuning - Tuning applications, Tuning Instance, and Tuning Disk Usage.
• Generated and interpreted Automatic Workload Repository (AWR), Active Session History (ASH), and Automatic Database Diagnostic Monitor (ADDM) reports.
• Developed and modified shell scripts with good amount of experience on PL/SQL coding, SQL tuning and PL/SQL debugging/tuning
• Expertise in Upgrading Oracle database and applying Oracle PSU and CPU patches.
• Experience in implementing and planning backup and recovery strategies using Recovery Manager(RMAN).
• Experience in planning and scheduling the Physical(Hot/Cold) backups and Logical backups.
• Used Oracle 10gR2 Flashback Query options such as Flashback database for recovering the whole database to a point in time, Flashback table for restoring the state of a table to a certain point in time and Flashback Drop
• Created clone databases for development and test environments using RMAN as well as User managed cloning.
• Implemented data transfer using Transportable Table Spaces(TTS), Data Pumps and Export/Import utilities.
• Enforced Security administration, system monitoring by adding and removing users, configuring quotas, auditing, and analyzing security problems.
• Good knowledge on Oracle support process for technical requests using Metalink and other support features.

TECHNICAL SKILLS

LANGUAGES: SQL, PL/SQL, JAVA, C, C++,Perl, KSH, SH,PHP, Python

HARDWARE: DELL XPS, IBM P5series, Sun Solaris: V890, V490, T5140

STORAGE: SAN Storage, EMC & Hitachi

DATABASE: MySQL, ORACLE 11g(11.1.0.7 & 11.2.0.1), 10g(10.2.0.x), 9i, 8i ORACLE RAC 11.1.0.7, 11.2.0.3, 11.2.0.4

OPERATING SYSTEMS: Windows XP, Vista & 7, Apple Macintosh, UNIX (Sun Solaris5.8 & 5.9)/ Red Hat Enterprise LINUX 5.x & 6.x / OEL 5 & 6 /

TOOLS: Oracle Enterprise Manager, Toad, Putty, VNC, PVCS, SHAREPLEX,VM,SQL*loader, TKPROF, GoldenGate V 10X/11.1/11.2, RMAN, Datapump, WinScp, ERWIN, Data Palette, Avamar

APPLICATIONS: Oracle financials(GL,AP, AR) 11.5.10.0, Oracle portal Application server 10.1.2.2.0, OBIEE 11.1.1.6.0, OBIEE 11.1.1.6.2 BP1, Siebel application

PROFESSIONAL EXPERIENCE

Confidential, Highlands Ranch, Colorado

Senior Oracle DBE

Responsibilities:

• Installation, Configuration and maintenance of Oracle 11g/10g database software on RHEL and Oracle Enterprise Linux (OEL).
• Configured 3-node Real Application Cluster (RAC) and monitored RAC instances with Oracle Enterprise Manager Grid Control.
• Oracle Enterprise Manager Grid Control 11g/12c Software installation and Configuration.
• Upgradation of Oracle Grid infrastructure and Oracle Database software from 11.2.0.3 to 11.2.0.4 on 3-node RAC environment.
• Extensive experience in Installing, Upgrading, applying PSU's/CPU'S and Configuring Grid and RDBMS software in Silent mode
• Conveniently scheduled daily and critical jobs on Database servers using Cron and ESP(Event stream processing) tool
• Experience with Setting up and Configuring RMAN backups to tape storage via Avamar server and successfully restored databases on 100+ servers
• Configured and implemented Oracle 11g Active Data Guard for Database Disaster Recovery by using Data Guard broker (DGMDRL).
• Configuration of Oracle ASM on RHEL and HP-UX and managing disks and disk groups.
• Configuration and implementation of Golden Gate based replications through GGSCI.
• Experience with installing Oracle Golden Gate in Dev/QA and Production environment.(Configured and tested Replication using Golden Gate where Source and Target Database were both on LINUX Operating System and Database was in 11gr2) configure Oracle GoldenGate Monitor/Director and integration with Oracle Enterprise Manager Grid Control with Remedy using User Define Metrics.
• Worked on real time BI scenarios using Goldengate along with an ETL tool, also performed operational reporting and zero-downtime migrations.
• Worked on migrating the non ASM databases to ASM databases, and implemented ASM on RAC databases and standalone databases.
• Created database users on a regular basis and controlled and managed their roles and privileges.
• Involved in monitoring the database related activities using Oracle Enterpriser Manager 11g Grid Control and monitoring the backup jobs scheduled in Oracle Enterpriser Manager (OEM).
• Performed oracle database refreshes using expdp/impdp from production to test database.
• Done with performance tuning related jobs like general health checks and maintenance of databases using Automatic Workload Repository (AWR) and Automatic Database Diagnostic Monitor (ADDM) reports by finding wait events.
• Worked on Performance and Tuning databases using TKPROF, STATSPACK, SQL TRACE and EXPLAIN PLAN and collected performance statistics memory usage, data storage
• Periodically performed logical backups of database and schemas using DATAPUMP(expdp/impdp)
• Enforced Hot/Cold Backup, performed Recovery and Cloning of database using RMAN with Veritas Net Backup, IBM TSM & Legato Storage Manager
• Used ERWIN 8.0 to create and manage conceptual data modelling and database schemas.
• Performed rolling patch upgrades for RAC environment for bug fixing and also involved in applying PSU and CPU patches for Oracle Server.
• Daily incremental backup and weekly full backup of databases using RMAN.
• Participated in regular on-call support for production databases.

Environment: Oracle 11g(R1 & R2)/10g, Oracle Golden Gate 11gR2/10g,Oracle Enterprise Manager Grid Control, ASM, Real Application Cluster Loader, Oracle Enterprise Manager 12c (OEM), TOAD, Red Hat Enterprise Linux (RHEL) and Oracle Enterprise Linux (OEL).

Confidential, Kansas City, Missouri

Oracle Database Administrator

Responsibilities:

• Installed and configured Oracle 10g/11g database software and GRID, also managed oracle CRS
• Worked with OEM Oracle Enterprise Manager(11g/10g), Net Configuration Assistant.
• Setup maintenance of Data Guard for disaster Recovery and reporting purpose with various modes. Developing methodology to create logical/physical standby configuration with help of RMAN.
• Installation, Configuration and administration of Oracle Golden gate.
• Performed real time migration of production data using SHAREPLEX with zero impact on the database.
• Implemented Shareplex for real-time reporting, data warehousing and fast disaster recovery.
• Database creation using DBCA and silent install, Table space management, User/schema Management.
• Monthly, Weekly and daily call report generation using AWR/ASH and ADDM.
• Setup Oracle Golden gate on Oracle Clusterware with High Availability to ensure maximum database availability.
• Successfully detected and resolved data conflicts in Active-Active Golden gate implementations.
• Monitoring the system and performing the daily checks.
• Gathered Oracle Database statistics and maintained up-to date for the Optimizer
• Performed database upgrade and migration from Oracle 9i to Oracle 10g.
• Creation of Database Health Check reports (including database growth, cpu/memory utilization, Top sql etc).
• Communicate and coordinate with Oracle using TAR system for major database issues/ problems, apply the required patches, test (unit test/ system test) and roll out and implement the patches into production
• Performance Tuned and optimized SQL Query, SGA, and Disk I/O using Oracle Enterprise Manager and by monitoring the Statspack report generated from snapshots taken at the peak business hours.
• Created and managed users, roles and profiles, audited and monitored databases and user access.
• Used import/export utility and Data Pump utility for database migrations.
• Working knowledge of Datawarehousing tools like ETL (Extraction, Transformation and Loading)

Environment: Oracle 10g/11g,Oracle Golden gate 10.4, SQL*Loader, SHAREPLEX,Windows 2000/XP, Sun Solaris 5.6/10, Linux, Data Guard, SQL, Pl/SQL, OEM, RMAN, Exp/Imp, Putty, SQL Trace.

Confidential, Farmington Hills, Michigan

Oracle DBA

Responsibilities:

• Implemented Oracle Database 10g two node Real Application Cluster (RAC) using Oracle Clusterware and responsible for high availability and load balancing.
• Installed, configured Oracle 10g databases on Linux and also upgraded oracle databases from 9i to 10g version.
• Configured Oracle Dataguard for Disaster recovery.
• Achieved High availability, Data protection and maximum performance by maintaining both physical and logical standby databases.
• Created user accounts, roles and granting required access permissions and privileges to the database based on the application they are accessing.
• Extensive use of Oracle Data pump, Exports/Imports utility for moving data among the servers.
• Performed large batch jobs and tuning of SQL queries and database systems.
• Implemented Oracle database backup & recovery solutions using RMAN.
• Performed automated backups and scheduling using scripting.
• Written Stored Procedure and Triggers for database maintenance and management using PL/SQL, UNIX shell scripts for backups.
• Used oracle configuration assistants like Database Configuration Assistant(DBCA) for creating databases, Database Upgrade Assistant(DBUA) for upgrading databases and Network Configuration Assistant(NETCA) for creating a Listener, TNS names to establish a Client-Server environment.
• Configured and implemented Oracle streams(Advanced Replication) for high availability.
• Also migrated data from Oracle to SQL server for testing, reporting and analysis requirements.
• Generated Automatic Database Diagnostic Monitor(ADDM), Automatic Workload Repository(AWR) for monitoring database performance..

Environment: Oracle 11g/10g/9i, Red Hat Enterprise Linux 4.x,5.x, A.I.X 5.2, HP UX 11i, OEM, Oracle 10g RAC, TOAD, STATSPACK,EXPLAIN PLAN, SQL Server 2005.

Confidential 

Jr. Oracle DBA

Responsibilities:

• Installed and maintained Oracle 10g software on Linux systems.
• Migration of the database from sun Solaris to Linux.
• Monitoring of hot backups, exports on Linux and Windows.
• Performed Refresh of databases on Linux servers
• Create Schema (Tables, Indexes, views, sequences, synonyms, roles, and packages), grant roles to users.
• Monitor databases using OEM, re-organization of database tables and indexes.
• Tested and implemented different physical, logical Backups and Recovery methods like point in time recovery, Media recovery, full and partial recovery using export, import.
• Partitioned appropriate tables to optimize performance and simplified maintenance work.
• Write various SQL and PL/SQL scripts and procedures to support applications.
• Set up and administered tablespaces, data files, tables, indexes, views and sequences Configured and managed users, security and Redo logs.
• Performed database cloning to create Test and Development environments from Production.
• Implemented Physical Standby database using DataGuard in ORACLE9i/10g.
• Performance tuning for Oracle Day-to-day maintenance and management of the several different databases in development, test, regression and production environments; proactively monitoring production environment for any exceptions/ issues.
• Have written shell scripts for automation of various database-monitoring activities.

Environment: Oracle 10g, 9i, SQL, PL/SQL, Linux, Sun Solaris, TOAD