We provide IT Staff Augmentation Services!

Oracle Database Administrator Resume

Memphis, TN

SUMMARY:

  • I have 5+ years of extensive experience as an Oracle Database Administrator. I worked in complete system development life cycle environments. Good working knowledge on Oracle 12c, 11g and 10g versions.
  • DBA duties include production/project support, installation and configuration, upgrades and patches, database migration, backup and recovery, performance tuning and database security, Grid control, Dataguard, RAC, Goldengate.
  • Planned and implemented high availability solutions such as Real Application Cluster (RAC) in Oracle 11gR2 Grid and 10g on ASM and OCSF2 file systems, running on Linux operating systems. installation and configuration of Oracle cluster ware and Automatic Storage Management (ASM) in RAC environment.
  • Conversion of Single Node Instance to multinode RAC with ASM, and adding instance to existing RAC.
  • Experience in Real Application Clusters (RAC) setup with 4 nodes, configuration and cluster interconnection with Automatic Storage Management (ASM). Configured and maintained physical standby databases using Oracle Data Guard to perform quick disaster recovery.
  • Installation and configuration of oracle Golden Gate.
  • Experience in using Golden Gate to support data replication in the Oracle database environment.
  • Experience in Golden Gate upgrade from 10.4 to 11.2.
  • Configured Manager, Replicate and Extract processes and implemented unidirectional, bidirectional replication using Oracle 11g Golden Gate on RHEL 5 platform
  • Experience in Installed, configured and maintained Physical, Logical, Active standby databases supported by Data guard on Oracle 11g, 10g RAC servers for the purpose of disaster recovery procedures.
  • Highly experienced in performance monitoring/tuning/ troubleshooting.
  • Performance Tuning of the database (Memory Allocation Tuning, I/O Tuning, Tuning Contentions) using oracle 11g tools like AWR, ADDM, Advisories, TKPROF, STATSPACK, SQL TRACE, EXPLAIN PLAN for the better performance.
  • Performance Monitoring and Tuning of Database using Grid Control & Diagnostic pack (AWR, ASH ADDM)
  • Worked on Data transferring with export/import utilities and Data pump.
  • Extensively implemented Datapump, conventional Export/Import (Oracle 11g, 10g) for migration and logical backup of database.
  • Applying patches under UNIX platform.
  • Experience in taking Full and partial backups, Incremental and Cumulative backups using RMAN (Recovery Manager).
  • Extensive Experience with RMAN Backups, Hot Backups and Logical Backups.
  • Experience in user managed backup and recovery.
  • Highly Experienced in Hot/Cold Backup and Recovery and Cloning of databases using RMAN.
  • Implemented Hot/Cold physical backups (Incremental and full), cloning, duplicating of databases using RMAN with VERITAS Net Backup & IBM TSM.
  • Experience in Migration of Oracle Databases from non - RAC to RAC and non-ASM to ASM Instances.
  • Migration of databases across different platforms from Linux to Windows, and on the same platform (Linux to Linux).
  • Highly experienced in implementing Oracle's Transportable Tablespace (TTS) feature using Datapump Export/Import (Oracle 11g, 10g) allowing users to quickly move user Tablespace across Oracle databases.
  • Proficient with Database Cloning, Migration, and Patching of Oracle Databases.
  • Experience in applying PSU patch on standalone as well as RAC databases.
  • Strong skills in applying security patches (Patch set, Critical Patch Updates (CPU) / Patch Set Updates (PSU), One-off Patch) using “RunInstaller” and perl based utility “opatch”.
  • Expertise in implementing data refreshes (at database, schema & table level) using RMAN utility and Datapump, conventional Export/Import of Oracle 11g, 10g.
  • UNIX shell scripts for hot backups, SQL*Loader, export and import of database.

TECHNICAL SKILLS:

Operating Systems: Red Hat Enterprise Linux (RHEL), Solaris, AIX and Windows

RDBMS: Oracle 12c, 11g and 10g

Languages: SQL, PL/SQL, Shell Scripting

Tools: DBCA, DBUA, Recovery Manager (RMAN), Oracle Enterprise Manager (OEM), OEM Grid Control, Oracle Management Service (OMS), ASMCA, TOAD, Putty, WinSCP, SQL Developer, Data Pump (expdp, impdp), OPATCH utility, SRVCTL, SQL*Plus, SQL Server Management Studio (SSMS)

Tuning Tools: SQL TRACE, TKPROF, EXPLAIN PLAN, STATSPACK, AWR, ASH and ADDM

PROFESSIONAL EXPERIENCE:

Confidential - Memphis, TN

Oracle Database Administrator

Responsibilities:

  • Performing day-to-day database administration tasks like Table space usage, checking alert log, trace files, monitoring disk usage, Table/index analyze jobs, database backup logs etc.
  • Installation, configuration, Maintenance and Support of Oracle 11g and 12c (Multitenant and NON-CDB) Databases.
  • Upgraded both RAC and standalone databases from 10g (10.2.0.4 and 10.2.0.5) to 11g (11.2.0.2, 11.2.0.3 and 11.2.0.4) and 11g to 12c as part of performance improvement by utilizing the new features.
  • HP-UX Platform migration to Oracle Linux 6.3 Using RMAN Transportable table space
  • Configured Oracle Standby databases, both Active Dataguard for real-time replication and normal Dataguard for disaster recovery.
  • Worked on Disaster Recovery by converting physical standby databases to SNAPSHOT standby database and opened in the read/write mode for testing purposes without interrupting the primary production database.
  • Tested disaster recovery with database failover and switchover.
  • Successful installation/maintenance of Physical Standby database using Oracle Data Guard for Oracle 11.2.0.3 and Oracle 10.2.0.5 RAC databases.
  • Creation, Configuration and Setting up of RMAN Catalog databases and registering target Databases with the Catalog.
  • Responsible for Backup and recovery of the databases using RMAN Tool (Recovery Manager), and Database Flashback using GRP (Guaranteed Restore Point) and Export and Import (Datapump and traditional export) for restoring the specific objects at the database level.
  • Installed and Implemented Backup & Recovery procedures such as Hot, Cold, and Logical backup plans.
  • Setting up replication of databases using Oracle Golden Gate.
  • Recovering Golden Gate corruptions and managing host/cluster maintenance mode blackouts.
  • Implemented Initial Load, Batch/Online replication, Security in Golden Gate.
  • Apply PSU and CPU Patches.
  • Applied Database Patches that is PSU patches and one-off patches (for Bug resolution) using the OPATCH utility.
  • Efficiently performed installation, setup and creation of four node cluster RAC with Oracle 11.2.0.3 database using GRID infrastructure with ASM file systems on RHEL 5.5.
  • Used oracle wallet manager (OWN) to create database wallet used for storing the master key (used for TDE).
  • Implemented TDE (Transparent Data Encryption) for Encrypting the Sensitive data using column encryption and tablespace encryption. Also used TDE for Goldengate replication.
  • Created users, granted roles and privilege management. Maintained user accounts and privileges to maintain application security.
  • Installed and configured Oracle 11g database on a test server using Oracle standard procedures and OFA, for performance testing and future 10g production implementation
  • Monitoring of the databases using Oracle Enterprise Manager (12c).
  • Write and modify UNIX shell scripts to manage Oracle environment.
  • Experience in writing UNIX/SHELL scripts for providing the reports.
  • Knowledge in Oracle Data warehouse DBA skills relating to administration and management of VLDB environments, Oracle OLTP.

Environment: Oracle 11g/11g RAC/ 10g/ 12c VMS, Sun Solaris, Windows Server 2010, Red Hat Linux, TOAD, RMAN, SQL server, OEM.

Confidential - Nashville, TN

Oracle Database Administrator

Responsibilities:

  • Cloned/Migrated databases using RMAN and traditional Datapump export/import utilities in Oracle 10gR2.
  • Automated monitoring the databases, performance parameters, backup and recovery activities by running Cron jobs.
  • Customized various Unix Shell Scripts for sending Email for ORA- errors and reports for Quick Morning Check (QMC).
  • Automate routine DBA tasks of taking backups, exports, space usage monitoring, move Archive Logs to different mount points when Archive Destination is full and resync RMAN catalog.
  • Used to run scripts to check the status of databases such as growing table sizes, extent allocation, free space, used space, fragmentation, etc.
  • Performed space management, capacity planning, disaster recovery and overall maintenance of the databases.
  • Create and restore databases using Oracle Flashback Technology with Guaranteed restore point.
  • Worked on disaster recovery of dataguard physical standby Failover/switchover/loss of service /rebuild/corruption/loss of datafile testing.
  • Worked with a team for installation and maintenance of ORACLE 10g RAC, ASM database for high availability.
  • Monitored and tuned long running jobs by working closely with the application development team and analyzing objects, created or rebuilt indexes, query tuning using SQL TRACE, TKPROF, Explain Plan, TOAD.
  • Performed troubleshooting of database using AWR and ADDM reports.
  • Planned, tested and implemented backup strategy using RMAN, Oracle Utilities (Export/Import) EXPDP and OS methods.
  • Performed Database replication from production to test/development environment Using RMAN, Data pump utilities and manually
  • Responsible for network configuration and involved in a Client-Server environment using TNSNAMES, LISTENER, Net Configuration Assistant and other configuration files.
  • Strong skills in applying security patches (Patch set, Critical Patch Updates (CPU)/Patch Set Updates (PSU), One-off Patch) using “runInstaller” and perl based utility “opatch”.
  • Highly experienced in implementing Oracle's Transportable Tablespace (TTS) feature using Datapump Export/Import (Oracle 11g, 10g) allowing users to quickly move a user Tablespace Across Oracle Databases.
  • Expertise in implementing data refreshes (at database, schema & table level) using RMAN utility and Datapump, conventional Export/Import of Oracle 11g, 10g.
  • Installed Oracle and grid software on standalone servers on ASM and file system.
  • Performed activities on ASM, creating disk group with different Redundancy Levels/using Fail group, adding a disk to a disk group, making disks online/offline and mount/dismount disk groups as SYSASM
  • Constantly monitor the performance (V$ dynamic performance views at peak load) of the Databases and viewing Alert log files & Trace files.
  • Created Physical Standby databases using RMAN with zero downtime, performed Failover and Switchover using Data Guard Broker and manually as and when required.
  • Worked extensively with Physical Standby database, troubleshooting, switchover and switchback with Physical standby setup.
  • Successfully performed data replication using Materialized views and Oracle Streams in Oracle 10gR2.
  • Applied patches 10.2.0.2 and 10.2.0.3, 10.2.0.4.

Tools: Used: Oracle 10.2.0.1, HP-UX 11, Sun Solaris 10.0, Oracle Streams, RMAN, Datapump, SQL TRACE, TKPROF, EXPLAIN PLAN

Hire Now