PROFESSIONAL SUMMARY:

• 7+ years of experience as Oracle DBA using 10g, 11gR2 and 12c databases with high availability.
• Experience in Goldengate, Data Guard and RAC combined with large databases in Oracle Database services.
• Worked on fresh Oracle 10g and 11g and 12c database server installs.
• Build Oracle 11g/12c Databases on Linux (Standalone, RAC, CDB’s and PDB’s)
• Install and configure active - active Goldengate 12c in RAC environment.
• Install Jagent to enable GG cloud control monitoring using 12c Cloud control.
• Configure CDR rules to manage conflicts.
• Analyze Goldengate load testing reports.
• Applied Goldengate patches.
• Configured Goldengate for Initial Load.
• Created Oracle Standby Data Guard databases for RDS Databases on Confidential Internal Cloud.
• Migrated High Volumes of Data from Legacy servers to RDS Cloud Databases.
• Worked on Oracle RAC to RDS standby build.
• Created more than 300 Oracle 11g/12c Databases on Linux mostly RAC in Confidential .
• Migrated Overall 100+ TB of Data in Confidential Data Center Migration.
• Performed Windows to Linux (cross-platform) migration for Confidential .
• Set up alert notification for space issues thru OEM Cloud Control 12c Administer, manage and configure various database versions such as 10g, and 11g via OEM Cloud Control 12c environment.
• Configure backup, monitoring and application jobs using shell scripts.
• Good understand in RMAN backup and restore. Performed cloning using duplicate database.
• Used Export Import / Data Pump, DBLinks for data movement.
• Created and managed role-based security to restrict or permit users according to their database usage.
• Good knowledge of Oracle RAC and Flashback technology in Oracle.
• Experience with Oracle Data Pump restoring and managing databases across multiple environments.
• Installation, upgrade, configuration, administration and maintenance of very large Oracle databases on most flavors of UNIX namely Sun Solaris, AIX, HP-UX, Linux and also on Windows 2003(NT 5.2)/2008(NT 6.0). Servers.
• Performed High level of Database Migrations with multiple techniques (Transportable Tablespaces, RMAN Cloning, Data Pump, ExpImp, and Goldengate Initial Load).
• Performed Database Upgrades 10g to 11g and 11g to 12c.
• Worked with Storage Admins for carving out partitions for data files systems.
• Worked with SAN, NAS for ASM disks.
• Experience in schema management, Tablespace, Data files and extent management, as well as user and privilege management.
• Involvement with physical and logical design of database.
• Experience monitoring Oracle RDBMS availability and operational support.
• Experienced in Database Security Administration using roles/grants.
• Created Data Guard for RAC and standalone databases.
• 24*7*365 DBA support for databases with a large amount of data.
• Planning, Testing, Performing and Monitoring Database Backup and Recovery, RMAN.
• Strong experience in OEM 12c Cloud Control and TOAD.
• Understanding of UNIX Shell scripting.
• Hardworking, result oriented, enthusiastic, good interpersonal and communication skills.
• Worked with Developers during Deployments.
• Worked on instance tuning as per the best practices.

TECHNICAL SKILLS:

Operating Systems: RHEL, HP-UX, AIX, Windows, Sun Solaris

RDBMS: Oracle 10g R2, 11g R1/R2, 12c

High Availability: RAC, DataGuard, Goldengate

Tools: RMAN, OEM, SQL*Loader, exp, imp, expdp, impdp, TOAD, etc.

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK, SQL Advisor, ADDM and AWR.

PROFESSIONAL EXPERIENCE:

Confidential, Bellevue, WA

Sr. Oracle DBA

Responsibilities:

• Responsible for new Installations of Oracle RAC, ASM, OEM using 11gR2 and 12c under RH Linux 6.5 to 6.7 and AIX.
• Install and configure active-active goldengate 12c in RAC environment.
• Install Jagent to enable GG cloud control monitoring using 12c Cloud control.
• Configure CDR rules to manage conflicts.
• Analyze goldengate load testing reports.
• Applied Goldengate patches.
• Configured Goldengate for Initial Load.
• Responsible for creating and managing Data guard instances, and involved in database installation, maintenance and administration for disaster recovery.
• Created Oracle Standby Data Guard databases for RDS Databases on Confidential Internal Cloud.
• Migrated High Volumes of Data from Legacy servers to RDS Cloud Databases.
• Working on Oracle RAC to RDS standby build documentation.
• Created more than 300 Oracle 11g/12c Databases on Linux including RAC and CDB and PDB.
• Migrated Overall 100+ TB of Data in Confidential Data Center Migration.
• Fixed 100+ broken 11g Oracle Data guard Databases.
• Created 70+ Oracle Data guard Physical Standby databases.
• Performed Windows to Linux (cross-platform) migration for Confidential .
• Upgraded and patched existing Oracle homes.
• Performed GI Patching twice annually.
• Worked with customer for different RAC related issue such as node eviction, cluster issues, ASM issue and etc.
• Created document for adding more than one physical standby RAC databases for existing data guard configuration, Successfully Tested and implemented on databases.
• Involved as team member in planning phase of new Servers/RAC Databases to host databases that are as big as 3 Terabytes in size.
• Created Documentation on Transportable Tablespaces for Confidential for High Level Data Center Migrations.
• Install & configure Oracle Clusterware & RDBMS Software (Troubleshooting using cluvfy & handling common issues that arise during integration of the whole - bugs, network issues, configuration files issues, OCR issue, deinstallation & cleanup of clusterware) performance tuning, and Applied patches to 3 node RAC with ASM and Grid Control environment.
• Created Users/Roles, granted/revoked Permissions/Roles, defined quota on Tablespaces for users, and effective management of Locally Managed Tablespaces, Dictionary-Managed Tablespaces, and Temporary Tablespaces.
• Used exp/imp, data pump and dblinks to move the data.
• Having hands on experience in Hot/Cold Backup, Recovery and Cloning of databases using RMAN.
• Worked on schema Reorganizations for better space management
• Performed Database Refreshes and Database Copies for Development, Test and Production databases
• Configured and Managed ASM devices and disk groups through both ASMCA and ASMCMD utility.
• Patched Database using OEM 12c.
• Migration of system and applications from Oracle 11g to 12c.
• Configuring and using the Oracle Enterprise Manager in 12c for Performance, Maintenance and Administration tasks.
• Scheduled Backups in 12c cloud control.
• Monitoring of free space in tablespaces, Archive log destination, and monitor issues Database/Listener availability, Blocking Locks, etc.
• Configured RAC database with 4 nodes. Implemented Data Guard, Physical and logical Stand by databases to ensure high availability, data protection and disaster recovery.
• Improved the performance of the database by tuning SQL and database instance parameters using AWR, ASH, ADDM and SQL Tuning Advisor in Oracle 11g
• Using TCP/IP Protocol Configured SQL*Net files on server / client machines, and resolved client connectivity issues.
• Improved the performance by Using the Hints, Indexes, Explain Plan.

Environment: SQL, SQL*Plus, Oracle 11g. 12c, Linux, HP-UX, Windows.

Confidential, Detroit, MI

Sr. Oracle DBA

Responsibilities:

• Provided 24x7 on-call support to the Production database.
• Database tuning methodologies and monitoring techniques.
• Implemented backup, recovery scripts for Oracle Database using RMAN.
• Implemented incremental RMAN backup scripts (Level0, Level1, Archive log) created Cumulative backup and optimally scheduled RMAN backups.
• Hands-on experience in administering database including job scheduling (DBMS JOB), backup/restore (RMAN), data import/export (IMP/EXP), Data pump etc.
• Involved in Managing of table spaces such as dropping, creation and updating of storage parameters.
• Setting up physical standby database / data guard for operational recovery.
• Administer and create all the object of database including tables, table spaces, setting privileges, indexes, user logins, and passwords (security).
• Experience in upgrading oracle database from 10g to 11g
• Experience in applying the quarterly Oracle DB PSU's.
• Experience in building a new 3-node RAC and migrating the existing database on to the newly built servers including ASM storage migration.
• Involved in building a physical Standby for the Production RAC servers with Data guard.
• Experience in troubleshooting DR issues, applying logs manually, monitoring DR and its replication.
• Experience in adding an additional node to a stand-alone database and get the cluster services available for that.
• Experience in migrating database on cross platform i.e. from Oracle to SQL and SQL to Oracle.
• Provided assistance in getting the tickets resolved.
• Cleaning the ORACLE HOME file system by cleaning the log files, alert log file and listener.log files.
• Performing Backup/Recovery of all the Oracle databases using RMAN, also setup RMAN catalog for the same.
• Involved in using Oracle database features like Undo Tablespaces, External Tables, Locally Managed Tablespaces, and Transportable Tablespaces.
• Added Luns to ASM diskgroup from CANDIDATE DISKS
• Did server space management including SAN request and NEW disk initiation.

Confidential, El Segundo, CA

Oracle DBA

Responsibilities:

• Interfaced with client on daily basis.
• Implemented procedures and practices regarding database design, development, monitoring, access, and High Availability.
• Installed and configured database management system software.
• Developed and implemented backup and recovery strategies.
• Implemented capacity planning for databases.
• Implemented company wide database privileges, security, and migration.
• Developed policies and procedures for system operations to better serve clients.
• Presented database management solutions to internal clients
• Used Oracle 10g AWR & ASH to monitor database activities and performance tuning.
• Responsible for quarterly patching and bug fixes.
• Installing, Monitoring, Upgrading Oracle 10g/11g.
• Created Physical standby Data Guard.
• Configured Data Broker Configuration for Data Guard database.
• Practiced switched over and failover for Disaster Recovery.
• Database Backup, Database Restore and Database Recovery using various tools.
• Database Reorganizations for better space management.
• Performed Database Refreshes and Database Copies for Development, Test and Production
• Installation of Oracle 11g, 10g in RH Linux, Sun Solaris.
• Upgrading to new versions and applying patches as required.
• Install, tune and configure complex clustered database environments.
• Creating Database, Tablespaces, Rollback Segments etc.
• Create and maintain users, roles and privileges.
• Performed Online/Offline database backups.
• Built and configured RMAN Recovery Catalog for Backup and Recovery strategy.
• Involved in DB Security, Audit and Risk Management of DB systems.
• Implemented backup strategies, which involved taking an incremental backup and enabled the block change-tracking feature.
• Involved in monitoring the lock and latches processes, releasing locks in case of resource blockage and gathering statistics.

Environment: SQL, SQL*Plus, Oracle 10g, 11g, RHEL, AIX, Windows NT/2000, HP UX, TOAD, Grid Control, OEM.

Confidential, Schaumburg, IL

Oracle DBA

Responsibilities:

• Supported and maintained Oracle 10g databases.
• Experience monitoring Oracle RDBMS availability and operational support.
• Created databases for Production, Pre-Prod and Dev environments.
• Installed OEM agents on several databases
• Configured databases and monitored of all the databases using Oracle Enterprise Manager (OEM) 10g grid control.
• Worked on daily regular monitoring of the databases
• Understanding of shell scripts to automate database jobs.
• Upgrading and patching the 10g databases.
• Performed logical backup using export/import and data pump utilities
• Configured the RMAN backup
• Carried out hot backup, cold backup and RMAN backup
• Creation and configuration of Standby Database (Data Guard)
• Loaded the different formats of data into Oracle using SQL Loader.
• Supported data cleansing project.
• Troubleshoot listener.ora, tnsnames.ora and SQL*net issues between corporate & show site databases.
• Supported development teams on design and implement different database objects
• Provided full technical support to various application teams before the databases go to production.
• Restored & recovered some of the show site databases when they got corrupted.
• Perform Backups and Recovery, maintain 24 hours uptime for the database

Environment: OEM Grid Control, RMAN, Sql*Loader, Import & Export, Data pump, Data guard, RMAN, AWR, ADDM, Stats pack, ASM, TOAD, Shell scripting, AIX etc.