SUMMARY

• I have over 6 years of experience as an Oracle Database Administrator.
• I possess complete life cycle knowledge including Installation.
• Worked on Oracle 12c, 11g, 10g versions involving database administration, production support, installation, configuration, upgrades, patches, migration, backup and recovery, performance tuning, database refreshes and security management.
• Expert in setup, installation, configuration, maintenance and troubleshooting of several Oracle tools and utilities like Oracle Enterprise Manager (OEM), TOAD, Oracle SQL Developer in various versions.
• Have good experience in configuring OEM 12C cloud control and have hands on experience in monitoring databases using OEM 10g/11g and 12c.
• Implemented LINUX HUGE PAGES on OEL 5.5 and Redhat Linux 6.x for Clustered Environments.
• Performed installation, configuration and maintenance of oracle 11g/12c, 11g RAC databases.
• Experience in configuring oracle 10g, 11g Real application cluster (RAC) (2 and 3 nodes) using cluster ware and automatic storage management (ASM).
• Applying Patches, Critical Patch Update/Patch Set update and One - off Patches using OPatch.
• Scheduling repetitive activities like gathering schema statistics, exports, table space usage report using crontab.
• Experience in writing UNIX/SHELL scripts for providing the reports.
• Experience in patching RAC databases in rolling fashion to maintain high availability.
• Experience in partitioning such as Range partition, List partition and Hash partition.
• Applied PSU Patches (11.2.0.3, 11.2.0.4) as a part of maintenance activity.
• Installing Oracle patches, Migration of database across releases.
• Excellent experience in Installation, administration and troubleshooting of Oracle … for OLTP (multiple instances)/ OLAP environment on Very Large or Highly Transactional Databases.
• Implemented RMAN backup (Full, incremental and cumulative) and recovery, Incomplete recovery and disaster recovery using Data Guard.
• Solid experience in disaster recovery, database backup concepts and options such as user-managed backup, RMAN-managed backup with or without catalog, cold and hot backup, full back up, incremental, cumulative backup and implementing backup and recovery strategies
• System administration, Oracle Problem analysis and resolution and active cloning of databases from one server to another server.
• Utilized RMAN recover table functionality and created proof of concepts for our pre-prod environment.
• Installed and configured Oracle 11g database on a test server using Oracle standard procedures and OFA, for performance testing and future 10g production implementation.
• Testing and implementing different physical (hot/cold), logical backup and recovery methods including point in time, media recovery, full/partial, and data pump export/import.
• Data loading using SQL*LOADER, Logical backups using full export and DATAPUMP.
• Created database & database objects like table, index, table space, rollback/undo segments and views & analyzed relevant objects to collect statistics to tune the system performance.
• Performance tuning of the database - SQL Tuning, Used Tuning utilities like STATSPACK, TKPROF, EXPLAIN PLAN, AWR, ADDM and Tuning of SGA, Distribution of Disk I/O, Sizing of tables and indexes.
• Experience in tuning database and memory components for optimal performance using AWR, ADDM and ASH reports.
• Hands on experience in tuning mappings, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings, and sessions.
• Involved in tuning applications for optimal response time using SQL /Optimizer Trace at various levels and events, Explain Plan, TKprof, Oradebug and identifying the poor SQL's, histograms, row chaining & row migrations and tune accordingly.
• Implemented oracle 12c flexi ASM for pre-prod environment.
• Experience with large databases (1.5 Tb) for OLTP and OLAP applications.
• Expertise in setup/implementation/maintenance of Real-Application-Cluster (RAC) on 10g/11g.
• Performed migration of oracle 10g/11g non RAC single instance to RAC database instances.
• Experience with 11g cluster maintenance using CRSCTL command.
• Experience in using SRVCTL command for Oracle 11g RAC database.
• Implemented Disaster Recovery database 10g/11g Data Guard on physical standby database in maximum performance mode using LGWR ASYNC mode.
• Setup, Configured and Maintained Oracle Data Guard to control Primary and Standby Databases and to ensure disaster recovery using various data protection modes.
• Implemented oracle 12c active standby database for test database environment.
• Experience of Oracle Golden Gate installation, configuration and troubleshooting Golden Gate Extract and Replicate issues.
• Implemented OEM 12c Repository database, OEM 12c Agent and golden gate plugin Installations.
• Experience in Monitoring and Tuning system resources associated with the database performance, hit ratios, I/O, lock, and latch contention.
• Providing DBA support to multiple Cluster, Non-cluster and ASM Database in production, development and Testing Servers in Exadata, UNIX, Linux, Windows, and Solaris Environments.
• Providing database administrative support and 24x7 on call support for production, development oracle 12c/11g databases on Red Hat Linux 5.0 and oracle enterprise Linux 5.5.
• Have Hands on working in both Application and Production support environment.
• Extensive experience with Change Board Meetings and Change Control Management for all database changes.
• Excellent analytical, problem solving, communication and interpersonal skills.

TECHNICAL SKILLS

Oerating Systems: HP-UX 10.x, 11.x. Sun Solaris 8, 9, 10. AIX 5.3, 6.1 RHEL 2.1, 3.x, 4.x, 5.x.Linux Enterprise Server 9, 10. Windows 95/98/NT/2000

RDBMS: Oracle 10g, 11g, 12c

Languages: SQL, PL/SQL

Tools: TKPROF, EXPLAIN PLAN, STATSPACK, AWR, and ADDM.Toad, Putty, NX client, Winscp, Remote Desktop Connection, VNC, Team Viewer, LogMeIn and Cisco VPN Client

Database Utilities: SQL*Plus, Oracle Enterprise Manager, Real Application Cluster, ASM, Transportable Tablespaces, SQL*Loader, RMAN, DataPump, Export, Import

PROFESSIONAL EXPERIENCE

Confidential - Atlanta, GA

Oracle DBA

Responsibilities:

• Automated hourly, daily, weekly system health reporting using Crontab, PL/SQL and shell scripts.
• Designed, developed and maintained UNIX shell scripts to collect and monitor database metrics and Statspack snapshots and reports.
• Developed custom scripts and implemented standard procedures to troubleshoot Live Production issues by leveraging ORACLE ASH and AWR and ADDM Data.
• Writing SHELL SCRIPTS for the system and database for effective functionality and report generation.
• Wrote scripts for Backup of databases, maintenance of archive logs for databases.
• Wrote shell scripts for purging trace files, alert log and network log files in Linux boxes which is used as standard script across all the databases.
• Expertise in PL/SQL, SQL and UNIX Shell Scripting (Implemented UNIX Scripts using CRONJOB for Day-to-Day activities and Windows Task Scheduler)
• Extensively worked on setting up auditing in many databases we supported.
• Installed the Oracle software using silent feature also created databases.
• Worked on designing, installing & maintaining OCR, 11gRAC and Dataguard components of Oracle.
• Involved in User Management and Database Security by granting appropriate Roles, Privileges, and Profiles.
• Monitoring the availability of system, listener, database, alter log file, trace file.
• Performed numerous ORACLE software upgrades from 10g to 11g by managing whole process.
• Performed Hot Backups, Cold Backups.
• Performed incremental backups using Recovery Manager (RMAN).
• Created recovery catalog, performed complete and incomplete recovery using RMAN.
• Used Data Pump for export and import.
• Performed Schema level and Table level data refreshes from Production to Development environments using Datapump EXPDP/IMPDP.
• Streamlined backup procedures and implemented RMAN for backup and disaster recovery.
• Database Refreshing/Replication from production to testing using Exp/Imp.
• Monitored the various database activities such as Backup, Error Logs, Space, Object, Performance, User and Session monitoring to ensure proper Capacity and Availability.
• Performance tuning of the database - SQL Tuning, Used Tuning utilities like STATSPACK, TKPROF, EXPLAIN PLAN, AWR, ADDM and Tuning of SGA, distribution of disk I/O, Sizing of tables and indexes.
• Used Grid Control extensively and set up Rules for alert notification and schedule RMAN backups with Failure notification.
• SQL Query tuning on the OLTP Environments with the techniques like SPM (SQL plan management) fix by taking the advantage of cell offload efficiency.
• Maintaining ORACLE Software (RAC and standalone) by upgrades, Apply PSU patches on regular basis, test and Implement Applicable new feature during each upgrade.
• Maintain 24/7 Availability by implementing standard processes and troubleshooting live issues within defined tight SLA times.
• Manage High Availability Architecture (ORACLE RAC and ORACLE Data guard).
• Perform Database cutovers using ORACLE Data guard switchover
• Troubleshoot and maintain ORACLE Data guard environment where TBs of log shipping and apply happen every day.
• Troubleshoot Database Performance issues using OEM, AWR, ASH, TKPROF 10046 traces etc.
• Monitor Production Databases using various internal tools and custom scripts.
• Optimal Database parameter, Capacity Design for Heavy loaded High End OLTP systems.
• Database Capacity Management (Working with Storage teams for ASM Disks) using automated scripts/processes and Reports.
• Configured Golden Gate Downstream Mining and Integrated components for Active-Passive and Active-Active replication.
• Configured GoldenGate High Availability using Oracle DBFS and Active DataGuard.
• Experience on working with data guard physical/logical standby databases.
• Installed and configured GoldenGate Agent to work with OEM GoldenGate Plugin.
• Design and implement Application aware ORACLE RAC Active/Active Service based infrastructure
• Troubleshooting ORACLE RAC issues using ORACLE cluster ware and Database logs.
• Supported & maintained the Production/Development databases on various servers.
• Managing Database Structure, Storage Allocation, Table/Index segments, Rollback Segments, Undo Segments, and Constraints.
• Installed ASM environment and migrated databases from NON-ASM to ASM.
• Monitored different databases and application servers using Oracle Enterprise Manager (OEM) 12c Grid Control.

Environment: RHEL 5.X, 6.X; Windows NT 2000/2003; Oracle 10g, 11g

Confidential - Tulsa, OK

Oracle Production Support Database Administrator

Responsibilities:

• Performed policies on data confidentiality, integrity, availability, and auditability, based on Access controls for Access to Data at the database level.
• Used TOAD for database management.
• Implemented and configured 11g grid control on RHEL.
• Performed Logical backup of critical application databases using EXPDP/IMPDP with a scheduled jobs (Cron Job).
• Responsible for creating RMAN catalog Database and Registering the Databases in Catalog Database and Cloned production RAC instances to development and QA systems using RMAN duplication.
• Evaluated Oracle 11gR2 Golden Gate for future purposes that is for reducing the complexity involved inOracle Streams.
• Configured Oracle Streams on Oracle 11g, 10g databases for data replication and monitored them using Grid Control.
• Performance tuning of Queries by maintaining Aggregates, Compression, partition, Indexing.
• Performance tuning and diagnosing DBMS and individual Production databases, organized various migration review meetings with the application team to discuss the migration strategy based on their requirements.
• Performed SQL and PL/SQL tuning oracle contention and monitored production database using Automatic Workload Repository (AWR), Automatic Database Diagnostic Monitor (ADDM) and Automatic Session History (ASH).
• Experience in using 11g features such as Data Pump, Flash Back Recovery, ASM, AWR, and ADDM.
• Involved in Defragmenting data blocks of table spaces for optimized performance. Also partitioned large tables to increase performance.
• Implementing Datapump, conventional export/import utility of Oracle 11g, 10g for re-organizing Databases/Schemas/Tables to improve the performance.
• Used import/export utilities for cloning/migration of small sized databases and Datapump import/export to move data between 9i and 10g/11g environments.
• Efficiently performed installation, setup and creation of 4 nodes cluster RAC with Oracle 11.2.0.3 database using GRID infrastructure with ASM file systems on RHEL 5.5.
• Maintenance of Oracle 11gR2 Real Application Cluster (RAC) Database for High Availability, Scalability and Performance by determining the best Cluster architecture, choosing the best hardware configuration for Oracle RAC.
• Installation, configuration and maintenance of Oracle 10g/11g Real Application Clusters (RAC).
• Implement Grid based monitoring solution for large Databases and Installation of Cluster ware, configuring public, private and VIP.
• Successful in installation/maintenance of Physical Standby database using Oracle Data Guard for Oracle 11.2.0.3 and Oracle 10.2.0.5 RAC databases.
• Extensively worked in various areas of Data guard i.e. Installation, Recovery, RTA (Real Time Apply), Patching, Tuning, Switchover, Switchback and Failover.
• Implemented switchovers on primary and standby databases as a part of planned maintenance activities.
• Installed ASM environment and migrated databases from NON-ASM to ASM.
• Made optimal use of Oracle Support in resolving the SRs.
• 24 X 7 Production & Development database support and administration.

Environment: Oracle 11.1.0.7, 10.2.0.5, IBM AIX V6.1, RHEL 5.2, RAC, ASM, RMAN, AWR, ADDM, SQL* Plus, SQL*Loader, OEM, TOAD 10.0.