We provide IT Staff Augmentation Services!

Oracle Database Administrator Resume

Baltimore, MD

SUMMARY:

  • Experienced with all facets of Oracle DBA day - to-day activities like production support, database monitoring, Backup & Recovery using RMAN, Cloning, Troubleshooting production issues, and Physical Database Design.
  • Experience in working with the Tools like OEM, AWR, ASH, ADDM Expdp/Impdp, SQL Tuning Advisor, SQL Plan Baselines.
  • Expertise in all the phases of Software Development Life Cycle (SDLC).
  • Experienced in working with DBVERIFY utility and other method to find Data Corruption.
  • Experienced in resource management like data files with ASM (Automatic Storage Management) (Trouble shooting, Add, Remove Files etc.), online redo log files, control files.
  • Developed PL/SQL packages, DML, DDL, Oracle tables, Stores Procedures, functions, cursors, triggers and UNIX shell scripts.
  • Developed compliance reports and performed auditing at higher levels.
  • Thorough knowledge in setting up infrastructure for database in huge datacenters.
  • Experienced in writing and designing the SQL queries as well as have extensive knowledge of Relational Database Management Systems. (Normalization, De-normalization, Entity Relationship diagram, DFD etc).
  • Knowledge of Database Recovery Techniques and implementation of those recovery techniques to ensure business continuity.
  • RMAN point in time recovery and Instance recovery done on 10g.
  • Allocating logical storage structures like tablespace, schema and extents as well as configuring Oracle databases on Multi-Threaded Servers Implemented Hot/Cold physical backups (Incremental and full), cloning, duplicating of databases using RMAN with VERITAS Net Backup & IBM TSM.
  • Highly Experienced in Hot/Cold Backup and Recovery and Cloning of databases using RMAN.
  • Experienced in working with very large 24x7 Oracle RAC 10g & 11g databases on ASM of nearly 80GB to 22TB.
  • Knowledge in maintaining Oracle Cluster ware using Srvctl, Crsctl, has, ocrconfig, cluvfy, Private IP, public IP, SCAN IP and Virtual IPs along with NAS and SAN for ASM storage.
  • Installation, Administration of 11gR2 RAC on HP-UX. Configured ASM, and RAW devices for storage. Investigation of node eviction, CRS resources failure. Running Queries in parallel, setup inter instance parallelism, Load balancing. Resource utilization on each node. Fix corrupted OCR disk.
  • Tuning of RAC environment. Managing fail-over of instances. Configure table for parallel load.
  • Managed ASM storage. ASM cloning. Prepare/Add/remove ASM disks. Tuning of I/O on ASM based databases. Troubleshoot ASM crashes & memory problem.
  • Very comfortable in using ASM for creating disk groups, adding additional storage (DISKS) and troubleshooting ASM issues.
  • Successfully installed Oracle Real Application Cluster (RAC) including; Grid infrastructure (Clusterware and ASM) and Oracle rdbms software on a 2 nodes RAC architecture in development and UAT running oracle.
  • Setup the unidirectional replication on oracle 11g databases using Goldengate.
  • Monitoring and troubleshooting the gaps between source and target databases configured with goldengate.
  • Experience in designing and configuring high-availability systems using DataGuard with physical standby effectively configured and used DataGuard Broker utility.
  • Good Experience in applying patches like Critical Patch Updates (CPU), Patch Set Updates (PSU), and One-Off Patches, Interim patches, DST, Patch sets as per the Oracle recommendations.
  • Applying patches under UNIX platform.
  • Successfully Applying upgrade patch, maintenance and interim (opatch) patches on all the databases.
  • Upgraded the databases from 10g to 11g and from 11g to non CDB 12c.
  • Successfully migrated 12c Non CDB databases to pluggable 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”.
  • Installed Oracle 11g on Linux platform using ASM.
  • 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.
  • Worked on Data transferring with export/import utilities and Data pump.
  • Oracle Database performance-tuning services with EXPLAIN PLAN, TKPROF, STATSPACK, SQL TRACE. Applying patches under UNIX platform.
  • UNIX Systems Administration - Database and application integration efforts. Heavy UNIX shell scripting.
  • Worked extensively in Performance Tuning at various levels including instance tuning, Query tuning, Database performance tuning.
  • Experienced in performing Database related activities using GRID, Multitenant Architecture, OEM, Data Pump, SRVCTL, RMAN, SQL*Loader, datapump, Export, Import, PL/SQL, SQL*Plus, SVRMGR, Listener, AGENT Tuning using explain plan, SQL Trace, AWR, ADDM, SGA tuning, Statspack and tuning of initialization parameters.
  • Created Oracle Wallets and implemented Tablespace level TDE security.
  • Installed & configured Oracle Management Server (OMS) & Oracle Grid Control.
  • Experience as 24x7 productions DBA as well the application (development) database administrator.
  • Experienced in using 10g features like 10g RMAN, Data pump, and ASM.
  • Extensively implemented Datapump, conventional Export/Import (Oracle 11g, 10g) for migration and logical backup of database.
  • Experience in database patching, cloning, upgrade, migration & maintaining standby db server (DR).
  • Experience with database backup, recovery, and setting up disaster recovery Database servers.

TECHNICAL SKILLS:

Databases: Oracle 12c, Oracle 11g, Oracle 10g

Oracle Database tools: SQL*Loader, TKPROF, Toad, OEM, EXPLAIN PLAN, STATSPACK, AWR, ADDM, ASH, SQL Developer, SQL Tuning advisor, SQL Plan Baselines, Grid Control, Expdp/Impdp.

Operating Systems: Solaris 10/9/8, RHEL 5.X/4.X, HP UX 11i, Windows 2000/2003 server

PROFESSIONAL EXPERIENCE:

Confidential - Baltimore, MD

Oracle Database Administrator

Responsibilities:

  • Supporting multiple databases for production, development, test and staging purposes on Linux, Sun Solaris and Windows environments.
  • Refreshing Dev and Test instances with data from Production on a regular basis.
  • Scheduling repetitive activities like gathering schema statistics, exports, table space usage report using crontab.
  • Implemented Oracle ASM 12c software installation and configuration (Grid Infrastructure) and partitioning Disks in Linux.
  • Extensively worked on Oracle ASMLib Utility for managing ASM disk storage & Oracle 12c ASMCA.
  • Experience in setting up Oracle ASM storage for Oracle RAC databases.
  • Worked on ASM redundancy, Managing ASM disk failures & replace failed ASM disk with a new disk.
  • Implemented Oracle 12c Multi-tenant RAC database with 2 node cluster and instances using ASM storage.
  • Worked on to take backup and restore clusterware storage (Voting Disk, OCR Disk).
  • Worked to take backup on Oracle RAC database by using RMAN utility in a CDB (Multi-tenant) environment.
  • Worked on performing health checks in Oracle RAC & monitoring Oracle Instance.
  • Installed ASM environment and migrated database from NON-ASM to ASM.
  • 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.
  • Applied PSU Patches (11.2.0.3, 11.2.0.4) as a part of maintenance activity.
  • Implemented and managed optimum physical database design (tablespaces, data files, extents, redo logs, archive logs) and assessed database capacity by monitoring online storage, growth and file system space, in adherence to the Optimal Flexible Architecture
  • Provided instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical IO and Memory Usage.
  • Extensive experience in RMAN recovery testing on RAC and standalone database.
  • Recovered Database of 1 Terabyte when UNDO tablespace got corrupted in Real Application Cluster (RAC).
  • Performed database replication through Golden Gate.
  • 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 include hot backups.
  • Creation, Configuration and Setting up of RMAN Catalog databases and registering target Databases with the Catalog.
  • Setting up and managing Hot and Cold Backups, Exports, Imports.
  • Proficient in all DBA responsibilities such as user management (synonyms/privileges, roles, quotas, table partitioning, index, sequence), space management (Tablespaces, rollback segment), monitoring (alert log, memory, disk I/O, CPU, network activity).
  • Extensive knowledge of Oracle Architecture, SGA, PGA, Binary structure, Listener, TNSNames, SQLNet, V$ and DBA views.
  • Good knowledge in UNIX Korn Shell scripting and Perl scripting.
  • Performed Database Tuning - 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, SQL*Trace, TKPROF, Analyze, AWR and ADDM
  • Implemented ASM on RAC and stand-alone databases. Managing disks and disk groups with ASM
  • Implemented Goldengate unidirectional replication on RAC using ACFS file system.
  • Implemented 12c Grid control (Multi OMS architecture) on 11.2.0.3 database, Standby OMS architecture is under progress.
  • Monitored Goldengate using 12c Goldengate Plugin and also Goldengate Director and shell scripts for alerting GG process down alerts.
  • Installed Veridata to compare data between source and target and which are replicated using Goldengate.
  • Worked extensively on Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Hints, Stored outlines, Statistics.
  • Supported development teams by providing SQL statement tuning and optimizing ETL(Extract transform load) procedures and removing load and query performance bottlenecks by using tools EXPLAIN PLAN, STATSPACK, and TKPROF. 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 indexes, dropping unnecessary indexes, 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.

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

Confidential - Manhattan, NY

Oracle Database Administrator

Responsibilities:

  • Cloned/Migrated databases using RMAN and traditional Datapump export/ import utilities in Oracle 10gR2.
  • Performed disk and disk group management in ASM while installing 11gR2 RAC.
  • Monitoring Health checks of OCR, VOTING DISKS and troubleshooting issues in RAC environment (11GR2).
  • Ensured that oracle database systems operate securely and efficiently.
  • Managing databases from planning and testing stages through implementation and support.
  • Performed day to day activities like resolving Tickets for multiple environments. Provided Development Support in coordination with development for Application Tuning.
  • Worked extensively on monitoring grid control database, configuration of error notifications, installing listeners, and adding them to the grid control.
  • Performed conversion Non RAC single instance to Real Application Cluster (RAC) database instances.
  • Implemented recovery strategies whenever required and successfully recovered databases in case database crash, media/disk failures by using RMAN.
  • Scheduling the Physical backups (hot & cold) in CRON tab using RMAN utility and monitoring the scheduled jobs.
  • Responsible for Creating Users, Groups, Roles, Profiles and assigning the users to groups and grant necessary privileges to the relevant groups.
  • Used SQL TRACE, TKPROF, EXPLAIN PLAN utilities for optimizing and tuning SQL queries.
  • Maintained the data integrity and security using integrity constraints and database triggers.
  • Provided 24X7support for all the production and development 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”.
  • 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.
  • Performed Installation and configuration of Oracle 10.2.0.1 database on HP-UX platform.
  • Successfully performed migrations from Oracle 9i/10g to 10gR2 RAC (Real Application Cluster) Database.
  • Successfully upgraded the databases from 11g to non CDB 12c.
  • Successfully migrated 12c Non CDB databases to pluggable databases.
  • Created Oracle Wallets and implemented Tablespace level TDE security.
  • Constantly monitor the performance (V$ dynamic performance views at peak load) of the Databases and viewing Alert log files & Trace files.
  • 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.
  • 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

Hire Now