We provide IT Staff Augmentation Services!

Oracle Database Administrator Resume

NY

SUMMARY:

  • Experienced Oracle DBA with 6.5 years of experience in Oracle Database Administration in large - scale production environments across multiple platforms.
  • Performance of day-to-day database administration tasks like checking all the alert logs, monitoring Tablespace usage, trace files, monitoring disk usage, Table/index analyse jobs, database backup logs etc.
  • Expertise in maintaining Database Security using auditing (Fine-grained auditing) that captures actual SQL statement issued rather than only the fact that the event occurred .
  • Database security using Oracle Security Features (roles, privileges), auditing & Network ACL Config, Transparent data encryption, DBMS CRYPTO, etc
  • Experienced in Performance Tuning using EXPLAIN PLAN, TKPROF, and STATSPACK.
  • High ability to analyse and understand the AWR reports and can fine tune the databases for maximum performance.
  • Experience in system Monitoring and Database Performance Tuning using Explain plan, SQL Trace, TKPROF, AWR and also Cluster Interconnect Tuning (RAC)
  • Provided valuable inputs for various performance tuning issues. Proficient in performance tuning using Explain Plan, STATSPACK, TKPROF, AWR, ADDM.
  • Performance Tuning of the database (Memory Tuning, I/O Tuning)
  • Performed RMAN backups (Full, Incremental and Cumulative) and recovery, Incomplete recovery and disaster recovery using Standby database or Data Guard.
  • Exporting and Importing of dumps using expdp and impdp.
  • Supported large-scale databases with size around 3TB in large system environments.
  • 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.
  • Expert in implementing High Availability solutions with Oracle 11g RAC, Oracle Data Guard and replication using Golden gate.
  • Have implemented two types of standby databases supported by Data Guard, logical standby and physical standby databases in 11gR2 on two node RAC
  • Created indexes to facilitate easy user interface implementation and tuning.
  • Worked on Set up, configuration and maintained Oracle Data Guard/Active Data Guard to control Primary and Secondary databases and also to ensure disaster recovery using various data protection modes.
  • Involved in construction of DR sites for all the Production and IST environments.
  • Upgrade/Migration of oracle databases from 10g to 11g and 10gRAC to 11gRAC.
  • Cloned Database from Production to Test and Development.
  • Experience in Delivering Oracle Database performance-tuning services for customers with EXPLAIN PLAN, TKPROF, STATSPACK, SQL TRACE, ORADEBUG, AWR report, 12c OEM Grid Monitoring custom scripts troubleshooting oracle databases using SQL trace utilities.
  • Expert in RMAN backups including full, incremental and cumulative.
  • Excellent knowledge in Flashback Recovery, Hot/Cold Backup and Cloning/Refresh of databases using RMAN.
  • Knowledge of Database Recovery Techniques and implementation of those recovery techniques to ensure business continuity.
  • Experience in applying patches/ patch sets to the databases.
  • Extensively worked on Import/Export and Data Pump Import/Export tools.
  • Knowledge in configuring ASM (Automatic Storage Management)
  • UNIX Systems Administration - Database and application integration efforts. Heavy UNIX shell scripting, CRON jobs.

TECHNICAL SKILLS:

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

Tools: and Utilites: RMAN, OEM, SQL*Loader, EXP, IMP, Data pump, TOADOracle SQL Developer

RDBMS: Oracle 10g, 11g and 12c

Operating Systems: HP-UX 10.x, 11.x, 12c, Sun RHEL 2.1, 3.x, 4.x, 5.x.Linux Enterprise

PROFESSIONAL EXPERIENCE:

Confidential, NY

Oracle Database Administrator

Responsibilities:

  • Upgraded the databases to version 12c from 11g and 10g
  • Installed, Setup, Configured Oracle version 12c Release2 64 Bit on Solaris 10 and RHEL 6
  • Up-gradation and Migration of Database from 10g to 11gand then to 12c and also applying patches whenever required.
  • Applying upgrade patches, maintenance and interim patches on all the databases.
  • Worked on Automatic storage management (ASM) with EMC storage for managing data in SAN.
  • Successfully implemented 10g RAC on nodes for high availability.
  • 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 9i and 10g/11g environments.
  • Involved in construction of DR sites for all the Production environments.
  • Installed 12c database
  • Worked on Multitenant databases.
  • Performed Database Refresh from Production to QA, UAT and Development databases.
  • Implemented and managed optimum physical database design (tablespaces, datafiles, extents, redo logs, archive logs) and assessed database capacity by monitoring online storage, growth and file system space.
  • Provided instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical IO and Memory Usage.
  • Extensive experience in RMAN recovery testing, RAC and stand alone database
  • Recovered huge Database (1 Terabyte) when UNDO table space got corrupted in Real Application Cluster (RAC)
  • Created a Clone Database using RMAN on remote Server and used SRVCTL commands for Real Application Cluster (RAC) Databases
  • Implemented Data Guard with high availability and performance configurations and participated in Data Guard Fail over tests.
  • Responsible for the smooth functioning of all ecommerce activities of the organization.
  • Monitored data transfer between the Database servers using Data Stage, Oracle Streams/CDC
  • Successfully implemented Backup & Recovery using RMAN which includes hot backups and Cold backups.
  • Worked extensively on Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Hints, Stored outlines, Statistics.
  • Installed and configured Oracle 12c database and cloud control 12c to monitor all databases.
  • Worked with T-SQL statements like DELETE and UPDATE statements and also like BULK insert of data into the datable.
  • Performing monthly and annual performance reports for trend analysis and capacity planning.
  • Assist in SQL tuning and providing consultation such as creating Materialized views, adding indices, dropping unnecessary indices, using hints wherever possible, amongst others.
  • Worked on both VMS and UNIX environments.
  • Troubleshooting of various database performances by proper diagnosis at all levels like SQL, PL/SQL, database design, database tables, indexes, Instance, memory, operating system and java calls.
  • Knowledge in Oracle Data warehouse DBA skills relating to administration and management of VLDB environments, Oracle OLTP.
  • Experience in writing UNIX/SHELL scripts for providing the reports.
  • Installed and configured Oracle 11g database on a test server using Oracle standard procedures and OFA, for performance testing and future 10g production implementation.

Environment: Oracle 11g/11g RAC/9i, VMS, Sun Solaris, Windows Server 2003, Red Hat Linux, TOAD, RMAN, SQL server, OEM.

Confidential, OK

Oracle Database Administrator

Responsibilities:

  • Extensively worked in various areas of Data guard i.e. Installation, Recovery, RTA (Real Time Apply), Patching, Tuning, Switchover, Switchback and Failover.
  • 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.
  • 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. Evaluated Oracle 11gR2 Golden Gate for future purposes that is for reducing the complexity involved in Oracle 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 policies on data confidentiality, integrity, availability, and auditability, based on Access controls for Access to Data at the database level.
  • 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).
  • 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.
  • 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.
  • 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.
  • 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.
  • Implemented switchovers on primary and standby databases as a part of planned maintenance activities.
  • 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.
  • Installed ASM environment and migrated databases from NON-ASM to ASM.
  • Used TOAD for database management.
  • 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