We provide IT Staff Augmentation Services!

Oracle Database Administrator Resume

Ashburn, VA

SUMMARY:

  • 7.5+years of experience in the field of Database Technology with experience in designing, developing, implementing different Databases technologies.
  • Enabling Load Balancing in a Multi - Tier Architecture
  • Import/Export and Expdp/ Impdp utilities.
  • Monitor nightly Database backup Jobs and necessary actions for failed backup jobs including script corrections, disk space monitoring and Database availability.
  • Setup procedure for Database statistics gathering - Frequency, Best Time of the day to execute stats gathering jobs, correct level of gathering statistics.
  • In-depth understanding on oracle utilities SQL Trace, Explain Plan, TKPROF, Statspack, AWR, Analyzer and DBMS STATS in Performance Tuning.
  • Creating roles, profiles, privileges and assigning roles to users.
  • Extensively worked on monitoring and optimizing the database by performance tuning.
  • Hands on experience with various tools like SQL*Loader, TOAD, Oracle SQL Developer and Oracle Enterprise Manager (OEM).
  • Extensive experience in Installations, configuration, Cloning, Security, Patching, Upgrades.
  • Proactive Monitoring identifying areas that need to be improved performance in the application and database using 11g/10gOEM Grid Monitoring.
  • Performance tuning of the database (Memory Allocation Tuning, I/O Tuning, and Tuning Contentions) using TKPROF, EXPLAIN PLAN, STATSPACK, AWR, ADDM.
  • Creating extracts, data pumps and replicats on production servers, splitting replicats for efficient data transfer between servers, performance tuning using BATCHSQL, KEYCOLS, HANDLECOLLISIONS, CHECKPOINTSECS &troubleshooting extract/replicat ABEND issues.
  • Database Upgradation, Migrations using traditional way (DBUA, Manual and export/import) as well as non-traditional way (Transportable tablespaces).
  • Migrated databases from Non-ASM file system to ASM file system using RMAN.
  • Upgrading and Migration of Oracle database to higher version and other platforms using manual method and traditional Export/Import, datapump & Transportable Tablespace (TTS).
  • Experience in coding SQL, PL/SQL package, function, stored procedure, triggers, and materialized view for Oracle database.
  • Implementation of Enterprise wide Database Monitoring enabling Oracle 11g Enterprise Manager Grid Control. One stop solution for monitoring every single Oracle Database within the global enterprise.
  • Database Backup and Recovery using RMAN including duplicating/cloning Databases across with point-in-time recovery option.
  • Installed Oracle Golden Gate 11g, Implemented uni-directional and bi-directional replication.
  • Strong experience in RMAN, fail-over/fail-back/switch-over of stand by databases
  • Experienced in Installation and Configuration of Oracle Primary and Standby (Dataguard) Database and Switchover/Switchback of Database in 10GR2 /11GR2 RAC
  • Experience in multi-node and RAC environments including configuration of PCP.
  • Experience with various database Backup and Recovery methods like PITR, TSPITR, Export/Import and Flashback Technologies.
  • Troubleshooting the production databases (RAC, Non-RAC) within less time.
  • Highly Experience in Tuning database in RAC / Non-RAC environment for better Performance.
  • Hands on experience with logical backups, Hot/Cold backups, Recovery, and cloning of databases using (RMAN) Recovery Manager, SQL-Backtrack, VERITAS Net Backup.
  • Disk Space Management involving managing archives, space allocation to various tablespaces and also capacity planning for new applications.
  • Expertise in Configuring RMAN with Catalog /Nocatalog and worked on Point-In-Time Recovery and flashback.
  • Plugging the tablespace between different platforms using Cross platform transportable tablespace Utility.
  • Collecting performance statistics using Statspack/AWR (Automatic Workload Repository) and ADDM (Automatic Database Diagnostic Monitor).
  • Used TKPROF utility and Explain Plan for tuning SQL queries.
  • Experience in regular DBA activities such as Upgrades, Patches, TAR support, Cloning, Backups and Recovery Manager, Performance Tuning, Capacity Planning and documentation.

TECHNICAL SKILLS:

Databases: Oracle 10g, 11g, 12c

Database Tools: Oracle (Oracle Enterprise Manager, SQL*Plus, SQL Loader, DB Configuration Assistant) PeopleSoft, Toad, OEM Grid, RMAN, SQL*Loader, SQL DML scripts, Exp/Imp/Data Pump, Log miner, Statspack/AWR, Top, DBCA, DBUA, ADDM, Remedy, ETL

Operating Systems: UNIX (Solaris 8/9/10, AIX, HP-UX), LINUX, Windows

Hardware: Sun Fire 15K, Sun 6320 Storage, Sun Enterprise Servers 890/880/420/450 , Sun StorEdge 6320, Hitachi, EMC, Dell Servers, Compaq Servers 6000/3000/1600/800 , HP/UX-9000, Red Hat Linux 6.2

Middleware: BEA Weblogic 10.2.3, oracle service bus

Remote Tools: Cisco VPN, Checkpoint VPN, Remote Admin, VNC, Remote Desktop, VMware Virtualization

PROFESSIONAL EXPERIENCE:

Confidential, ASHBURN, VA

Oracle Database Administrator

Responsibilities:

  • Configuring and scheduling of Oracle database backup using RMAN.
  • Performed data loads from flat files into an Oracle database using SQL*Loader.
  • Partitioned tables Maintenance, adding new partitions, exchanging one-year-old partitions then archiving of the exchanged partitions, dropping or truncating of old portions.
  • Monitoring of tablespaces, memory structures, rollback segments, logs, and alerts.
  • Monitor and fully analyze performance issues in production Oracle databases by using OEM, ASH/AWR/ADDM, EXPLAINPLAN and TKPROF tools.
  • Partitioning Tables, Rebuilding of Indexes, Secure files, DBLINKS, Materialized Views, Store Procedures, Triggers and constraints.
  • Used SQL TRACE, TKPROF, EXPLAIN PLAN utilities for optimizing and tuning SQL queries.
  • Setting up of Oracle and Application user accounts and passwords, monitoring application security Setup, Configured Oracle Data Guard using physical standby database.
  • Implemented Data guard / Standby (with FAL), performed switchover/failover.
  • Patched Oracle databases using OPatch utility.
  • Responsible to improve the performance by Using the Hints, Indexes, Explain Plan,
  • Performance tuning of SQL statements using STATSPACK, TKPROF, Explain Plan and SQL Trace Setup and documented Golden Gate replication on 10g and 11g for support team.
  • Worked with RAC implementation team. Added nodes.
  • Tablespace management including, adding/resize data files, allocated quotas to user and managed disk space.
  • Creating user with assigning profile and privileges, revoking them as well as required.
  • Performing database migration from Sun Solaris to Linux, and from Linux to Oracle Cloud Infrastructure (OCI) using traditional data pump, Golden gate for zero downtime.
  • Help writing database triggers, packages, procedures, functions, utilities for application development.
  • Migration oracle database on-prem linux86 64 platform to Oracle Cloud Infrastructure (OCI).
  • Registering Database with OCI Tooling. Oracle Cloud Infrastructure with create a Database via their process using API calls with High level process.
  • Register your database with scripts on OCI server.
  • Create first your RAC database then Verify Wallet location and encryption over the wire with setting up in your Database's sqlnet.ora.
  • Setting up the TDE encryption wallet on the first node.
  • Modify your init.ora/spfile parameters:
  • Create your encrypted application tablespaces.
  • Create the rest of the supporting database objects.
  • Setup database administrative cron jobs.
  • Migrate data and database objects from on-prem to OCI Database using Export/Import.
  • Create your encrypted application tablespaces.

Confidential, Matawan, NJ

Database Administrator

Responsibilities:

  • Worked in an environment comprising 200 databases with the largest databases each of size 5 TB.
  • Performed periodic refreshing/cloning of production databases to development & testing databases using RMAN Duplicate database.
  • Extensively worked on complete & incomplete recoveries of the databases including Point in time recovery (PITR) and Tablespace point in time recovery (TSPITR) using RMAN utility.
  • Involved in performing upgradation from Oracle 10g to Oracle 11.2.0.3 RAC database.
  • Applied PSU Patches (10.2.0.3, 10.2.0.4) as a part of maintenance activity.
  • Extensively used Data pump, conventional export/import utilities for loading data to & from databases, logical backups and migration of databases.
  • Fixed various database performance issues using Automated Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM) and Active Session History (ASH).

Confidential, Marlboro, MA

Oracle Database Administrator

Responsibilities:

  • Performed Installation and configuration of Oracle 10.2.0.1 database on HP-UX platform.
  • Worked with different middleware & IDM teams to resolve their issues from the database side.
  • Experience in Replication of Data bases using Oracle Streams and Logical Standby.
  • Worked with Data Architect on dimensional modeling to optimize the already existing data-warehouse database using STAR Schema, identifying Fact and Dimension Tables for providing a unified view to ensure consistent decision making.
  • 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, in adherence to the Optimal Flex Architecture.
  • Provided instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical IO and Memory Usage.
  • Monitoring Day-Day Backups, Log's and recovering them as per the requirement. Utilized LOG MINER Technology and applied Application Database Transactions on other Databases.
  • Developed Shell scripts, SQL & PL/SQL scripts for monitoring GoldenGate processes and their stats running on 60+ servers from one single database repository providing table level granularity with end-to-end replication map and thus maintain history of all GoldenGate processes for later analysis.
  • Performed Oracle Schema level and Table level data migrations using Datapump EXPDP/IMPDP.
  • Configuring and scheduling of Oracle database backup using RMAN.
  • Performed data loads from flat files into an Oracle database using SQL*Loader.
  • Partitioned tables Maintenance, adding new partitions, exchanging one-year-old partitions then archiving of the exchanged partitions, dropping or truncating of old portions.
  • Monitoring of tablespaces, memory structures, rollback segments, logs, and alerts.
  • Monitor and fully analyze performance issues in production Oracle databases by using OEM, ASH/AWR/ADDM, EXPLAINPLAN and TKPROF tools.
  • Partitioning Tables, Rebuilding of Indexes, Securefiles, DBLINKS, Materialized Views, Store Procedures, Triggers and constraints.
  • Used SQL TRACE, TKPROF, EXPLAIN PLAN utilities for optimizing and tuning SQL queries.
  • Setting up of Oracle and Application user accounts and passwords, monitoring application security Setup, Configured Oracle Data Guard using physical standby database.
  • Implemented Dataguard / Standby (with FAL), performed switchover/failover.
  • Worked with RAC implementation team. Added nodes.
  • Tablespace management including, adding/resize data files, allocated quotas to user and managed disk space.
  • Help writing database triggers, packages, procedures, functions, utilities for application development.
  • Implemented backup strategies using hot/cold, exp/imp used on the business req.
  • Cloning databases using scripts as well as RMAN and performed Tablespace point in time recovery (TSPITR) using RMAN.
  • Maintained the data integrity and security using integrity constraints and database triggers.
  • Provided 24X7 supports for all the production and development databases.
  • Successfully performed migrations from Oracle 10g/11g to 11gR2 RAC (Real Application) Database.
  • Designed and implemented different backup strategies like Cold, Hot, MAN with Flash Recovery Area and Logical Backups EXPDP/IMPDP.
  • Handled Chained Rows and Row migration, and solved the database performance issues.
  • 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
  • Implemented Logical and Physical Standby Databases for RAC cluster on Sun Solaris platform using Data Guard feature of Oracle 11g R2.
  • Successfully performed data replication using Materialized views and Oracle Streams in Oracle 11gR2.
  • Cloned/Migrated databases using RMAN and traditional Data Pump export/import utilities in Oracle 11gR2.
  • Implemented recovery strategies whenever required and successfully recovered databases in case database crash, media/disk failures by using RMAN.
  • Implemented disaster recovery system, using RMAN and custom written shell scripts. Create and maintain Oracle Data Guard configuration
  • Experienced working on non-prod databases which are resided on Virtual Machines and understanding the working process.

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

Confidential, Ann Arbor, MI

Oracle Database Administrator

Responsibilities:

  • DBA supporting three major projects from Development to Production via Tech-Test environments, involving daily configuration, administration all running on IBM AIX 5.2 & 5.3. Database sizes range from 4GB to 2TB (in ODS & EDW environments).
  • Proven experience in troubleshooting issues related to Oracle RAC (Node Evictions, Node Reboots).
  • Experienced with all facets of Oracle DBA day-to-day activities like production, database monitoring, Backup & Recovery using RMAN, Cloning, Troubleshooting production issues, and Physical Database Design.
  • Extensive Experience in working with the Tools like OEM, AWR, ASH, ADDM Expdp/Impdp, SQL Tuning Advisor, SQL Plan Baselines.
  • 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.
  • Installed & configured Oracle Management Server (OMS) & Oracle Grid Control.
  • Designing (Physical & Logical) and Implementation, database user creation and database access both at role & table levels, as well as final Project Performance Assessment/Evaluation.
  • Create database Objects, Tablespaces, Schemas as needed.
  • Schema migrations from Development to Production via Tech Test environments.
  • Database refresh from Production to Tech Test as needed.
  • Backup Oracle DBA for two major projects involving periodic administration, troubleshooting & tuning of 10g Oracle databases (10g & 11g single instances running on both IBM AIX 5.3, SunOS 5.8 & HP-UX B.11.11.
  • Create oracle databases on configured servers using both the DBCA & Database creation scripts.
  • Planned and implemented high availability solutions such as Real Application Cluster (RAC) in Oracle 11gR2 Grid and 10g on ASM and OCSF2 file systems.
  • Highly experienced in Oracle 11g, 10gAutomatic Storage Management (ASM) required to fulfil the storage needs.
  • Installed, configured and maintained Physical, Logical, Active standby databases supported by Data guard on Oracle 11g, 10gRAC servers for the purpose of disaster recovery procedures.
  • Designed daily, weekly Backup and Recovery procedures for production, non- production databases using RMAN backups taking periodic Complete, cumulative and differential Incremental Backups.
  • Data Refresh/Cloning from Production environment to setup QA/ DEV using RMAN Duplicate.
  • Extensively worked on complete & incomplete recoveries of the databases including EXADATA managing complete security and control over the system. Prepackaged, optimized database to support fast transmission of data through fat pipes.
  • Intensively used latest 10g/11g Automatic Workload Repository (AWR) & Automatic Database Diagnostic Monitoring (ADDM) reports for the health check of the databases, and used the notification tool to send the alerts in OEM Grid Control.
  • Scheduled UNIX scripts in crontab jobs to automate daily tasks like backups, monitoring the alert logs, and backup logs to send notification emails.
  • Migrated data to a new ASM Diskgroup to improve the IO performance of the database.
  • Export/Import, Datapump, Transportable tablespaces to migrate databases from one database to another.
  • Oracle Database monitoring, troubleshoot, resolve the issues, monitoring alert log, trace files.
  • Recovery of Database (Recovering from Media Failure, Recovering the tables dropped accidentally, Recovering data files, recovering from Block Corruption) from previous RMAN backups.
  • Performed capacity planning, space monitoring like tablespace growth, ASM disk space.
  • Resolve critical issues by raising SR with Oracle Support and Root Cause Analysis (RCA).
  • Application of Oracle software patches when/where necessary.

Tools: Used: Oracle RMAN, Oracle 10g (9.2.0.8), DBMS STATS, Data pump, SQL TRACE, TKPROF, EXPLAIN PLAN.

Hire Now