We provide IT Staff Augmentation Services!

Oracle Database Administrator Resume

Amelia, OH

PROFESSIONAL SUMMARY:

  • Over 5 years of experience as an Oracle Database Administrator with hands - on experience in database installation and configuration of oracle Golden Gate, RAC, DATA Guard, administration and production support, upgrades, patches, performance tuning, backup and recovery, space management, database security, cloning, migration, shell scripting and documentation.
  • Troubleshoot and resolve slowness or performance issues with extensive investigation and follow-up with respective application teams and proposed solutions.
  • Resolve lock/latch and resource contention issues during production hours
  • Configure Dataguard and Broker for administration of seamless switchovers.
  • Upgrade GI and DBs from 11g to 12c with physical standby DBs in place Installation and configuration of oracle Golden Gate.
  • Configured SCAN as a cluster alias for load balancing and as a client connection failover mechanism
  • Experience in using Golden Gate to support data replication in the Oracle database environment.
  • Experience in applying PSU patch on standalone as well as RAC databases.
  • Experience in Golden Gate upgrade from 10.4 to 11.2.
  • 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.
  • Migrate to Multitenant Architecture using CDB and PDB of applications that otherwise have their own instances and qualify to be PDBs.
  • Configured Manager, Replicate and Extract processes and implemented unidirectional, bidirectional replication using Oracle 11g Golden Gate on RHEL 5 platform.
  • Planned and implemented DR & high availability solutions using Oracle 11g Standby Database using Oracle Data Guard 10g RAC and 11g RAC.
  • Management of schemas, objects & Partitioning the tables & indexes, AWR, ADDM and 10g OEM Grid Monitoring,11g AND 12c OEM Grid Control.
  • Excellent knowledge in Hot/Cold Backup and Recovery and Cloning of databases using RMAN with VERITAS Net Backup & IBM TSM.
  • Experienced in using 10g, 11g and 12c features of Data pump, Flash-Back Recovery, AWR, ASM, ADDM, Grid Monitoring, and Recycle Bin.
  • Extensive performance tuning experience, specializing in Operating System Tuning, SQL Tuning, Database/Instance Tuning.
  • Delivering Oracle Database performance-tuning services for customers with EXPLAIN PLAN, TKPROF, STATSPACK, SQL TRACE, ORADEBUG, 10gOEM Grid Monitoring custom scripts troubleshooting oracle databases using sqltrace utilities.
  • Experienced in Oracle Support processes for technical requests through Metalink (MOS) and other Support Procedures.
  • Good experience in SQL, PL/SQL, Shell Scripting, Perl Scripting, Partitioning, Data modeling, OLAP, Logical and Physical Database Design, Backup and Recovery procedures.
  • Experience in basic and advanced replication using Oracle Goldengate Classic and integrated Capture (both 11g and 12c) and experience in using OEM, TOAD, Data Migrations using export/import, benchmarking using load testing tools.
  • Expertise in maintaining Database Security using security compliance auditing, expertise in loading data from flat files using external tables, SQL*LOADER.
  • Proficient in Database Administration activities such as Upgrades, Patches, Backup and Recovery, Performance Tuning, capacity planning, script development, and documentation.
  • Installed, configured and Monitored Oracle Enterprise Manager Grid Control 11g & Cloud Control 12c.
  • Expert in Database Health Maintenance using Stats pack, TKPROF, RACDIAG, RDA, AWR (statspack) ExplainPlan, SQL Tuning Advisor, Oracle Enterprise Manager(OEM), Self-developed Scripts & methodology, Procedures.
  • Experience in fulfilling DBA daily activities, including schema management, user management (creating users, synonyms, privileges, roles, quotas, tables, indexes, sequence), space management (tablespace, rollback segment), monitoring (alert log, memory, disk I/O, CPU, database connectivity), scheduling jobs, UNIX Shell Scripting.
  • Administration experience in Very Large Multi Terabyte Databases (VLDB) environments.
  • Strong experience in Backup and Recovery strategies using RMAN, creating RMAN scripts, Export/Import, Datapump, Hot and Cold backups.
  • Experience in understanding business requirements for analysis, detailed design, database design & development of applications.
  • Involved in doing Data Modeling, Data Mart, Data Warehousing, Data Transformation.
  • Experienced in Oracle Support processes for technical requests through Metalink (MOS) and other Support Procedures.
  • Excellent verbal and written communication skills. Willingness to learn new technologies, openness to new ideas and ability to learn very quickly.
  • Participated in on-call (off hours) schedule in providing technical support.
  • Good co-ordination and communication with system administrators, business data analysts and development teams.

TECHNICAL SKILLS:

OPERATING SYSTEMS: LINUX, SOLARIS, Windows 2008, 2010.

RDBMS: Oracle 12c, 11g, 10g.

LANGUAGES: SQL, PL/SQL, Shell script.

TOOLS: / UTILITIES: DBCA, DBUA, Recovery Manager (RMAN), Oracle Enterprise Manager (OEM), OEM Grid Control, OEM Cloud Control, Oracle Data Guard, Oracle Management Service (OMS), Real Application Clusters (RAC), ASM, SQL Navigator, TOAD, Data Pump (expdp, impdp), SRVCTL, SQL*Plus.

TUNING TOOLS: SQL TRACE, TKPROF, EXPLAIN PLAN, STATSPACK, AWR, ASH, ADDM, DBMS.STATS, PA Performance TOOL

PROFESSIONAL EXPERIENCE:

Confidential, Amelia, OH

Oracle Database Administrator

Responsibilities:

  • Supported & maintained over Production/Test/Development databases on various servers.
  • Installed, configured, and maintained Oracle 10g and 11g R2 on Linux and also Upgraded from Oracle 10g to 11g.
  • Configured Oracle Data Guard to ensure disaster recovery, high availability and data protection.
  • Database monitoring and performance tuning using OEM GC, AWR and ADDM, ASH, SQLT, TRCA, SQL Access Advisor, SPM,
  • Performed Database refresh from Production RAC environment to TEST RAC environment.
  • Experience in monitoring and managing of Oracle instances using Enterprise Manager Grid Control (OEM grid) 10g /11g/12c.
  • Expertise in Performing Tuning Database - Tuning involved I/O, Memory, CPU utilization, SQL Tuning, SGA tuning, Shared Pool tuning, Buffers and Disk I/O tuning using Oracle's regular performance tuning tools like Explain Plan, STATSPACK (perfstat), SQL*Trace, TKPROF.
  • Proficient in Performance Tuning and Monitoring of Oracle Databases on Unix/Linux platform using database tuning, Tkprof, Explain plan, AWR and ADDM reports, Advisors as SQL Tuning, SQL Advice, Undo, Segment, MTTR, Memory.
  • Starting and stopping the agents to clear metric alerts and collecting ADDM reports in OEM.
  • Creating blackouts and templates in OEM and migrated databases from Non ASM TO ASM.
  • Involved in Tuning the RAC interconnect Finding RAC wait events. And Tuning the RAC using the Enterprise Manager Grid Control.
  • Performed various tasks on ASM, creating a disk group, adding a disk to disk group, making disk online and offline and troubleshooting issues in ASM environment.
  • Implemented physical standby database for maximum availability using Oracle Data Guard 11g with Oracle Enterprise Manager (OEM) 12C cloud Control.
  • Used import/export utilities for cloning/migration of small sized databases and Datapump import/export to move data between 9i and 10g/11g environments.
  • Applying upgrade patch, maintenance and interim (opatch) patches on all the databases.
  • Refreshing Dev and Test instances with data from Production on a regular basis.
  • Developed PL/SQL packages, DML, DDL, Oracle tables, Stored Procedures, functions, cursors, triggers and UNIX shell scripts.
  • Responsible for configuring datagaurd physical and standby database setup for high availability and handling synchronization issues between primary and standby.
  • Implemented ASM on RAC and stand-alone databases. Managing disks and disk groups with ASM.
  • Done migration of non ASM database to ASM database.
  • Scheduling and maintaining level 0 and level 1 RMAN (Recovery Manager) backups.
  • Working as a primary DBA on a critical application and managing 30TB of databases.
  • Managing two node Oracle 11g R2 RAC with grid infrastructure and set up Dataguard for them.
  • Managing stand alone database with ASM devices.
  • Set up failover for oracle clusterware with HACMP clusterware for 11g r2 database with ASM.
  • Configuring and maintaining Physical standby data guard for RAC and non RAC databases on 11g r2.
  • Monitoring, Troubleshooting RAC cluster using SRVCTL and TAF.
  • Performed multiple cross platform migration from regular file system to ASM for 15TB of databases.
  • Experience in Upgrading databases. (10gR2 to 11g, 11gR1 to 11gR2).
  • Performed SAN migration from one disk group to other disk group using asm copy command and used rename disk group. Also used RMAN copy. Worked on QC of the database before it go live.
  • Monitoring and maintaining 2/3 node RAC database on Red Hat Linux. Providing support to the development team and handling release schedules.
  • Maintaining sound backup and recovery policies and procedures using RMAN. Monitoring the scheduled backup procedures for daily basis using crontab.
  • Database refreshes using export /import and datapump. Used RDA, ADDM and AWR reports to monitor the database performance.
  • Developed and maintained PL/SQL Stored Procedures, Packages, Functions and Database Triggers.
  • Developed and maintained shell/Perl scripts for setting up batch jobs and managing release scripts.
  • Implemented SQL outline to get the better execution plan for the offending queries. Setting up analyzing scripts and coordinated with development team to gather table statistics.
  • Perform Database Tuning & Performance, Storage Management, Plan growth and changes (capacity planning), Database Monitoring, Security Management and Tuning SQL queries.
  • Diagnosed Oracle bugs and coordinating with Oracle support through metalink to resolve them in timely manner.
  • Performed various tasks like Administering RAC using SRVCTL, adding nodes and instances, Administering Storage Components, Parameter Management, and Configuring High Availability Features for RAC.
  • Have installed and setup Oracle 12c databases on test servers to test the multitenancy
  • Refreshed multiple databases for Development and Testing upon short request.
  • Performance Monitoring and Tuning of Oracle Application Servers using Statspack, TKPROF, and OEM for tuning on10g and on 11g using SQL access manager, SQL tuning manager.
  • Performed database cloning/exp/imp to setup identical databases in the production and development environments.
  • Perform Backup and Recovery thru RMAN.
  • Strong exposure in Installing / configuring / maintaining RAC, Dataguard, Physical / Logical Standby environments.

Confidential, Edison, NJ

Oracle Database Administrator

Responsibilities:

  • Successfully installed and configured Oracle 11.1.0.7, Oracle 10.2.0.5 databases on AIX platforms.
  • Supported & maintained Production/Test/Development databases on various servers using Oracle Enterprise Manager (OEM) 10g Grid Control.
  • Loading data from flat files to database using SQL*Loader, External Tables.
  • Automated the processes like moving files, managing alert log, efficient backup by developing UNIX scripts.
  • 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 9i 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).
  • Databases migrated to RAC for improved resiliency and performance.
  • Security User Management, Privileges, Role, Auditing, Profiling, Authentication. Creating Materialized views and Materialized View Logs for Increased Performance and Data Replication.
  • Knowledge in Golden Gate installation & Configuration setups in both windows/Linux environments.
  • Provided valuable inputs for various performance tuning issues.
  • Expertise in Performing Tuning Database - Tuning involved I/O, Memory, CPU utilization, SQL Tuning, SGA tuning, Shared Pool tuning, Buffers and Disk I/O tuning using Oracle's regular performance tuning tools like Explain Plan, STATSPACK (perfstat), SQL*Trace, TKPROF.
  • Expert in Performance Tuning and Monitoring of Oracle Databases on Unix/Linux platform using database tuning, Tkprof, Explain plan, AWR and ADDM reports, Advisors as SQL Tuning, SQL Advice, Undo, Segment, MTTR, Memory. Refreshed/cloned databases using RMAN utility.
  • Performed Database upgrade from Oracle 9i (9.2.0.7) 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.
  • 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 for database management.
  • Performed SQL and PL/SQL tuning, oracle contention and monitored production database using automatic workload repository (AWR), automatic database diagnostic monitor (ADDM) and Active Session History (ASH).
  • Worked closely with the Oracle developers for the better performance in Applications in writing the Packages, Triggers and Indexes on the tables.
  • Database refreshes using expdp, impdp, RMAN Duplicate and cloning.
  • Experienced in cloning the databases using HOT and COLD backups.
  • Used RMAN Duplicate and HOT/COLD backups to migrate the data from 11.1.0.7 to 11.2.0.3.
  • Made optimal use of Oracle Support in resolving the SRs.
  • 24 X 7 Production & Development database support and administration.
  • Achieved optimized performance for the databases by rebuilding indexes, on tables and indexes.

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

Hire Now