We provide IT Staff Augmentation Services!

Oracle Database Administrator Resume

Pittsburg, PA

OBJECTIVE:

Highly Creative, dynamic and detailed oriented Oracle database administrator professional with 6 years of experience in production and project support across full system development life cycle (SDLC). Duties include database installation, administration, configuration, production support, upgrades, patches, performance tuning, backup and recovery, space management, database security, Dataguard, Golden Gate, RAC, cloning, migration, shell scripting and documentation. Experienced in multitasking, enjoys working with people and communicate effectively both at the technical and managerial levels.

SUMMARY:

  • Experience On - Call 24x7 production support DBA.
  • Skilled in designing and implementing all the phases of Software Development Life Cycle (SDLC) as well as Software Implementation Life-Cycle (SILC).
  • Upgraded databases from 10g to 11g to 12c.
  • Performed/managed enterprise databases installation, RAC, Data Guard, ASM on Linux, Sun OS.
  • Experience in implementation of Real Application Cluster (RAC) environment with Auto Storage Management (ASM) on Oracle 12c, 11g and 10g.
  • Experience in Delivering Oracle Database performance-tuning services for customers with EXPLAIN PLAN, TKPROF, STATSPACK, SQL TRACE, ORADEBUG, AWR report, 10gOEM Grid Monitoring custom scripts troubleshooting oracle databases using SQL trace utilities.
  • Database Sizing, Tablespace Management and Advance Security Administration.
  • Planning, installation, configuration, management and troubleshooting of Oracle 10g, 11g and 12c databases on Linux and Windows OS.
  • Experience in Installation, Configuration, performance tuning of Oracle Real Application Clusters (RAC) on 2 nodes with Automatic Storage Management (ASM) on Oracle Enterprise Linux 5 and Redhat Enterprise Linux 5, Data Guard.
  • Good exposure of Oracle DBA tasks Installation, Patching, Cloning, and Upgrade of Oracle Databases.
  • Data transferring with export/import utilities and Data Pump and SQL* Loader.
  • Performing complete and incomplete recovery during disasters, failures and user errors.
  • Experience with very large-scale database environment and mission critical OLTP and OLAP systems.
  • Experience in applying several patches such as CPU/PSU patches, One-Off Patches, Interim patches, DST, Patch sets as per the oracle recommendations.
  • Experience in Backup & Recovery, Disaster Recovery options, Oracle Recovery Manager (RMAN)
  • Advanced Backup and recovery using Oracle's RMAN software, used offline/online for recovery in a production environment.
  • Database backup concepts and options such as user-managed backup, RMAN-managed backup with or without catalog, operating system backup, cold and hot backup, full backup, incremental and cumulative backup. Implementing backup and recovery strategies.
  • Expert in performing database refreshes (RMAN cloning) from Production to UAT, Test and DEV environments based on the requirements for testing and development.
  • Hand on experience in cloning the non-multitenant container database to pluggable database in 12c using the PDB Metadata clone, PDB Remote Clone and PDB Snapshot cloning feature.
  • Performed Strategic Planning, Logical and Physical Data Modeling.
  • Hands on Implementing High Availability solution like Dataguard, for disaster recovery (DR) plans using Physical standby database.
  • Installed, configured Oracle Golden Gate 11g/12c replication to remote sites (active/passive and active/active) for disaster recovery using zero Time migration, Integrated and Classic Capture/Extract.
  • Troubleshoot Golden Gate, monitor replicate lag, and check point.
  • Job scheduling using cron, at and batch utility at the OS level and Shell Scripting for automating DBA tasks.
  • In depth knowledge in implementing Database security using Oracle Security Features (roles, privileges), auditing & Network ACL Config, Transparent data encryption (TDE), DBMS CRYPTO, etc.
  • Hand on experience creating and managing users, profiles, roles, passwords expirations, auditing and authentication.
  • Resolved database network problems using Oracle Net Configuration Assistant (NETCA) and
  • Good Knowledge in setting PFile & SPFile parameters, maintaining Data Files, Control Files, and Redo LogFiles.

TECHNICAL SKILLS:

Databases: Oracle 11G/10G/12c

Operating Systems: HP-UX, Sun Solaris, AIX, Linux and Windows

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

Languages: SQL, PL/SQL

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

PROFESSIONAL EXPERIENCE:

Confidential, PITTSBURG, PA

Oracle Database Administrator

Responsibilities:

  • Installation and configuration of 10g, 11g, 12c in UNIX/LINUX (RHEL) and Windows server 2008, 2012.
  • Installation and configuration of 12c Container Databases on standalone servers and cluster on windows and UNIX platforms.
  • Upgraded multiple Standalone and RAC databases and grid infrastructure from 11gR2 to 12cR1.
  • Worked with New Features on 12c databases such as recovering tables, masking the fields using advanced optimization parameters for good performance of 12c Databases.
  • Experience in troubleshooting RAC databases and engaging with application team for gaining performance enhancements for application in clustered environment.
  • Applied PSU on standalone TEST environment using OPatch and same PSU (Grid and RDBMS Patching) on production cluster using OPatch Auto.
  • Supported in Performing GoldenGate configuration, administration, installation, also configuring pumps and managing trail files by purging old extract files and log files.
  • Troubleshooting GoldenGate using GGSERR.LOG and logdump utility.
  • Responsible for Installation and upgrading of GoldenGate 11.2.1.0.1 to GoldenGate (v 12) 12.1.2.0.0.
  • Replication Using GoldenGate for multiple extracts and replication and mapping, Great understanding and usage of advanced parameters in Golden Gate.
  • Implemented Physical Standby Databases on 2-node 11gR2 Real Application Cluster and automated scripts to delete archive logs that already applied to standby.
  • Duplicating Tablespaces and Databases from Production server to Test server as per customer requirement.
  • Involved in datacenter migrating large size database in multiple platform.
  • Expertise in Active DataGuard, Snapshot using Dataguard Broker (DGMGRL) and RMAN.
  • Generated AWR (Statspack), ADDM, Explain Plan, TKPROF, SQLTRACE, ORADEBUG reports for Performance tuning and also used new tools of 12c for security purpose.
  • Hand on experience in cloning the non-multitenant container database to pluggable database in 12c using the PDB Metadata clone, PDB Remote Clone and PDB Snapshot cloning feature.
  • Have implemented two type of standby databases supported by Data Guard, logical standby and physical standby databases in 11gR2 on two node RAC
  • Having hands on experience in user-managed Hot/Cold Backup, Recovery and Cloning/duplicate of databases using RMAN with VERITAS Net Backup and Comm vault.
  • Implemented Active Data guard, creating both Logical and Physical Standby databases in 10g, 11g, and RAC & 12C environment for the Production databases.
  • Configured and managed Data Guard extensively for Production databases of sizes ranging from 70GB to 2TB.
  • Successfully upgraded the databases from 11g to non CDB 12c, migrated databases to 12C from Oracle 10g $ 11g.
  • Created Oracle Wallets and implemented Tablespace Encryption with Oracle TDE security.
  • Constantly monitor the performance (V$ dynamic performance views at peak load) of the Databases and viewing Alert log files & Trace files.
  • Experiencing in Installing OEM 12c Cloud Control and upgrading the 11g management agents to 12c agents.
  • Implemented and maintained Oracle 11g Data Guard/standby databases for fail-over purposes. Also worked on Network data encryption to improve the security and implemented SSL wallet to secure the connections.
  • Database Services creation for distributing the applications across multiple nodes, extensively used all command line utilities SRVCTL, CRSCTL, ADR, ASMCMD.
  • Scheduled RMAN backups, purge jobs, Maintenance Jobs using DBMS JOBS, DBMS SCHEDULER, Crontab and $UNIVERSE.
  • Designed and implemented different backup strategies like Cold, Hot, RMAN with Flash Recovery Area (FRA) and Logical Backups EXPDP/IMPDP.
  • Implement and enforce security for all of the Oracle Databases; the three basic security tasks are authentication (Setting up user accounts to control logins to the database), authorization (setting permissions on various parts of the database), and auditing (tracking who did what, with the database).
  • Experienced with ASM, adding, deleting disks to the disk group.
  • Supported development teams for all the database related issues and handled the critical issues like network failures and ASM DISK group errors and node failures in the RAC cluster.
  • Generated Statspack/AWR reports using OEM 12C from Oracle 11g database and analyzed the reports for Oracle wait events, time consuming SQL queries, tablespace growth, database growth.
  • Used Explain Plan, Oracle hints and creation of new indexes to improve the performance of SQL statements. Involved in SQL Query tuning and provided tuning recommendations to Application jobs, time/CPU consuming queries.

Confidential, NEWYORK, NY

Oracle Production Support Database Administrator

Responsibilities:

  • Successfully installed and configured Oracle 11.1.0.7, Oracle 10.2.0.5 databases on AIX platforms.
  • Monitored different databases and application servers using Oracle Enterprise Manager (OEM) 10g Grid Control.
  • Loading data from flat files to database using SQL*Loader, External Tables.
  • Extensively used AWR, ADDM and explain plan for periodic performance tuning.
  • 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 10g and 10g/11g environments.
  • Implemented proactive monitoring using Tuning Pack, Diagnostics Pack, and STATSPACK, SQL Trace & TKPROF, EXPLAIN PLAN.
  • Database monitoring/maintenance, replication process and performance tuning are done using OEM (Oracle Enterprise Manager).
  • Troubleshooting and performance tuning golden gate replications, monitoring scripts for Golden gate in UNIX scripting.
  • Performed production database maintenance and modifications to ensure databases are operational, as well as diagnosed and corrected any database environment problems; monitored database usage, and reported on database performance and system availability.
  • Worked with developers to diagnose database related application problems, provided development support to maintain application schema and distribution of data.
  • Involved in capacity planning and resource planning.
  • Generated weekly performance reports to identify and solve the problems with performance.
  • Diagnosed Oracle bugs and coordinated with Oracle support through Metalink to resolve them in timely manner.
  • Applied patches and worked closely with Oracle to make Application environment up to date.
  • Responsible for data integrity, user security, daily monitoring for production and non-production systems. Used standard.
  • Install and configure Cloud Control 12c, deploy 12c agents, plug-in installations on the target servers and monitor databases.
  • Configure Oracle Advanced Security on 12c databases to implement Transparent Data Encryption at tablespace, table and column levels. Also configured Redaction using OEM's Policy expression builder.
  • Implemented Flashback technology of the Oracle 11g, 10g along with Recyclebin for a faster recovery of the databases and database objects.
  • Performed full & incremental backup (cumulative and differential) using RMAN and implemented recovery strategies.
  • Refreshed/cloned databases using RMAN utility.
  • Performed Database upgrade from Oracle 10g (10.2.0.2) to Oracle 10g (10.2.0.5) and to Oracle 11g (11.1.0.7) RAC database.
  • Successful in applying RDBMS patches, security patches for improving the security and functionality of the databases.
  • Achieved optimized performance for the databases by rebuilding indexes, on tables and indexes.
  • Automated the processes like moving files, managing alert log, efficient backup by developing UNIX scripts.
  • Involved in the installation, configuration and extended support to Oracle 11g, 10g two Node RAC (Real Application Cluster) with ASM file system on AIX platform.
  • Involved in converting a single instance database to Oracle 11g, 10g RAC databases.
  • Installed ASM environment and migrated databases from NON-ASM to ASM.
  • Used TOAD, SQL-Developer for database management.
  • Made optimal use of Oracle Support in resolving the SRs.
  • 24 X 7 Production & Development database support and administration.

Hire Now