We provide IT Staff Augmentation Services!

Oracle Dba Resume

Atlanta, GA

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.

Hire Now