SUMMARY:

• Results - driven Oracle Certified Database Administrator with over 6 years of hands-on experience in teh daily administration of production Oracle 10g, 11g, 12c databases as well as installation and configuration of both standalone and
• Oracle Real Application Cluster (RAC) databases, backup and recovery using Oracle Recovery Manager (RMAN) and Recovery Catalog, database migration and refresh using Oracle Data Pump, Oracle database replication using
• Oracle Data Guard for Disaster recovery and GoldenGate for real time data replication and Oracle 12c Cloud Control configuration and monitor.
• Also, responsible for patching, upgrade, database troubleshooting and supporting development effort with regards to production deployment releases, database schema, role, user, and objects, database hardening and baseline per security policy to improve database security.
• Experience in creation of project presentations for progress meetings and other high-level discussions. Highly motivated, excellent team player, enthusiastic, strong initiative and quick learner of new technologies.

TECHNICAL SKILLS:

Databases: Oracle 12c/ 11G/10G

Operating Systems: Sun Solaris 2.5, 2.6, 8, 5.2, 5.3, 6.1, RHEL 2.1, 3.x, 4.x, 5.x., Linux Enterprise Server 9, 10. CentOS, Windows 2008, 2008 R2, 2012, 2012 R2, 2016

Tuning Tools: TKPROF, EXPLAIN PLAN, AWR, ASH and ADDM

Languages: SQL, PL/SQL, UNIX Shell Scripting, PERL

Utilities: RMAN, OEM, SQL*Loader, EXP, IMP, Data pump, TOAD, Oracle SQL Developer.

PROFESSIONAL EXPERIENCE:

Oracle Database Administrator

Confidential - Chicago, IL

Responsibilities:

• Installed and configured Oracle 10g, 11g and 12c on different OS platforms.
• Monitor and Administer databases using Oracle Enterprise Manager (OEM) cloud Control.
• Loading data from flat files to database using SQL*Loader. External Tables.
• Automated teh processes like moving files, managing alert log, efficient backup by developing UNIX scripts.
• Used Data Pump, conventional import/export utilities for Database cloning, refreshes and migrations to non RAC and RAC environment.
• Security User Management, Privileges, Role, Auditing, Profiling, Autantication.
• Creating Materialized views and Materialized View Logs for Increased Performance and Data Replication.
• Successful installation/maintenance of physical standby database using Oracle Data Guard for Oracle 11.2.0.3 and Oracle 10.2.0.5
• Golden Gate installation, Configuration and Management in both windows/Linux environments.
• Refreshed/cloned databases using RMAN utility.
• Performed Database upgrade from Oracle 9i to 10g to Oracle 11g and to 12c RAC database.
• Successful in applying RDBMS patches, security patches for improving teh security and functionality of teh databases.
• Installation, configuration and extended support to Oracle 11g, 10g two Node RAC (Real Application Cluster) with ASM file system.
• Created physical standby databases using RMAN with zero downtime, and performed failover and switchover using both Data Guard Broker and teh manual method.
• Converting a single instance database to Oracle RAC databases.
• Installed ASM environment and migrated databases from NON-ASM to ASM.
• Used TOAD and Sql Developer for database management.
• Performed SQL and PL/SQL tuning, oracle contention and monitored Worked closely with teh Oracle developers for teh better performance in Applications in writing teh Packages, Triggers and Indexes on teh tables.
• Database refreshes using expdp, impdp, RMAN Duplicate and cloning.
• Used RMAN Duplicate and HOT/COLD backups to migrate teh data from 11.1.0.7 to 11.2.0.3.
• Made optimal use of Oracle Support in resolving teh SRs.
• 24/7 Production & Development database support and administration.

Oracle Production Support Database Administrator

Confidential - St. Louis, MO

Responsibilities:

• 24/7 Production Database support of multi-terabyte Oracle 11g database.
• Installed and configured Oracle 10g, 11g and 12c on different OS platforms.
• Performed all aspects of database administration including Installation, Configuration, Patches, Monitoring, Import/Export, Cloning, etc.
• Upgrade/Migrated teh production and development databases from RAC /10g to RAC /11g.
• Installation, configuration and administration of Oracle Real Application Clusters (Oracle 11g RAC/Oracle 10g RAC) and Standby Databases for High Availability and Disaster Recovery purpose.
• Plan, implement, and troubleshooting Oracle RMAN backup, restore, and recovery.
• Provide performance tuning, problem diagnosis, data reorganization and database upgrade support.
• Monitor and tune Oracle database for optimum performance. Assist in capacity planning of Oracle database servers.
• Successful installation/maintenance of physical standby database using Oracle Data Guard for Oracle 11.2.0.3 and Oracle 10.2.0.5.
• Created physical standby databases using RMAN with zero downtime, and performed failover and switchover using both Data Guard Broker and teh manual method.
• Generated and analyzed STATSPACK, AWR, ADDM, Explain Plan reports, error checking and monitored statistics for performance tuning of teh database.
• Performed Data replication and Data transformation.
• Export and import of database objects using Data pump utilities EXPDP and IMPDP.
• Performed data loads using SQL*LOADER.
• Developed PL/SQL Packages, functions and triggers to implement various functionalities.
• Experience in Managing work repositories and creating reports.
• Installation and administration of GoldenGate.
• Wrote UNIX Shell Scripts for Backup and cloning.
• Tune SQL, PL/SQL statements found in teh reporting utilities and queries.
• Involved in teh maintenance and troubleshooting of RAC Databases.
• Monitored and managed teh space usage and table partitioning.
• Implemented and Configured Standby database (Data guard) for disaster Recovery

Junior Oracle Database Administrator

Confidential - Takoma Park, MD

Responsibilities:

• Involved in Real Application Cluster (RAC) administration including 10g Database cloning, tuning, patching and monitoring concurrent manager processing etc.
• Successful installation/maintenance of physical standby database using Oracle Data Guard for Oracle 11.2.0.3 and Oracle 10.2.0.5
• Wrote several shell scripts for checking oracle errors in alert file and database backup log files.
• Cloning of application from production environment to test environment and application of patches.
• Performing Backup/Recovery of all teh Oracle databases using Recovery Manager (RMAN), also setup Recovery Manager Catalog for teh same and hot and cold backups.
• Creating tablespaces, sizing teh system tablespace, allocating default table spaces for users.
• Creating users with restricted access, with default and temporary table spaces.
• Creating different kinds of partitions on tables and indexes.
• Creating roles and granting to users based on their group requirements.
• Creating profiles and attaching them with users, performing.
• Sizing teh SGA, sizing teh database buffers, shared SQL area, log buffer based on teh requirements.
• Oracle Export, Import, SQL*Loader and data pump utilities.
• Installing & configuring Oracle 10g, 10g RAC on Linux & RHEL.
• SQL issues and Tuning Considerations for Different Applications.
• Created physical standby databases using RMAN with zero downtime, and performed failover and switchover using both Data Guard Broker and teh manual method.
• Established and wrote teh Database Administrators Procedures document for teh IT department. This document outlines all standards for teh DBA Group including installing/upgrading Oracle, creating databases, DBA tools, administration and monitoring, naming standards.
• Estimate growth of database size by detail analysis of teh company's future policies and generating reports for teh management to act in advance.
• Clear documentation was prepared on all teh processes like program specification, bugs fixing logs & change requests for future .
• Expertise in PL/SQL, SQL and UNIX Scripting (Used to write UNIX Scripts & implemented by Using CRONJOB for Day - to - Day activities.)