We provide IT Staff Augmentation Services!

Sr. Oracle Dba Resume

Jersey City, NJ

SUMMARY

  • Over seven (7) years of experience as Oracle Database Administrator including Oracle DatabaseInstallation, Configuration, Patch Installation, Performance Tuning, Migration, Upgrades, Patches, Backup and Recovery, Cloning, Replication, Space Management and Database Security with Oracle Software 11g/10g/9i Versions.
  • Installation and administration of Oracle 11g/10g/9i on OEL, Red Hat Linux (RHEL), Windows, UNIX and Sun Solaris in OLTP environment.
  • Installed and configured Oracle 11GR2 RAC along with Grid Infrastructure and ASM (Automatic Storage Management).
  • Migrations from RHEL to HP - UX using Datapump export/import and transportable tablespaces.
  • Performed upgrades of Oracle 11gr1, 10gr2, 10gr1 databases on production, test and development environment on Solaris 10, AIX and Linux boxes.
  • Experience in Configuration and Installation of 11g Enterprise Manager Grid Control (Oracle Management Services - OMS) along with installing grid agent on all database servers.
  • Configured Oracle Streams for bi-direction Replication using capture, propagation and applying processes.
  • Expertise in configuring Golden gate, Oracle Streams (Unidirectional Table Level) between homogenous databases.
  • Experience in Configuring Single Instance, Oracle Real Application Clusters (RAC) and Automatic Storage Management (ASM).
  • Good exposure of patching activities such as Patch Set Update (PSU), Critical Patch Update (CPU), One-off Patches (Interim Patch) using OPatch.
  • Performed Cloning of databases using RMAN Duplicate and DBCA.
  • Database backup concepts and options such as Physical backup, RMAN managed backup with or without catalog, Operating System (OS) backup, cold and hot backup, full backup, incremental and cumulative backup.
  • Experience in Logical Backups - full/partial, Conventional and Datapump Export/Import.
  • Expertise in Monitoring, Optimizing Oracle database for Performance Tuning and system/modules for Application Tuning using tools like AWR, ADDM, ASSM, STATSPACK, TKPROF, EXPLAIN PLAN, analyze TOAD, SQL*TRACE, UTL STAT and DBMS STAT.
  • Experience in Flashback technology with use of flashback table, flashback database for recovering tables and databases.
  • Configure & manage 11g physical standby database for disaster recovery & business continuity (Data Guard).
  • Monitoring and managing the space usage and local table partitioning.
  • Experience in data loading using SQL*Loader.
  • Writing backend procedures, functions, packages and triggers using PL/SQL.
  • Creating Users, Roles and Profiles, Privilege management with role-based security.
  • Experience in capacity planning, space management, Rollback segments and Undo segments.
  • Experience on handling databases sized 800GB to a max of 5TB.
  • Resolved database network problems using Oracle Net Configuration Assistant (NETCA).
  • Experience in shell scripting and scheduling jobs using cron utility.
  • Very good team player and self-starter with the ability to multitask.
  • Possess technical ability and self-initiative to learn and implement new concepts in short duration.
  • Excellent communication and interpersonal skills.

TECHNICAL SKILLS

Databases: Oracle 11g, 10g, 9i, SQL Server 2000, 2005

Tools: /Utilities: RMAN, Export/Import, Datapump, OEM, TOAD, AWR, SQL*Loader, STATSPACK, TKPROF

Languages: PL/SQL, SQL, Java, C

Web Tools: XML, HTML, TCP/IP

Operating System: Oracle Enterprise Linux (OEL), RHEL, Sun Solaris & Windows

PROFESSIONAL EXPERIENCE

Confidential, Jersey City, NJ

Sr. Oracle DBA

Responsibilities:

  • Installed, configured and supported Oracle 11gR2 RAC (Real Application Clusters) on a four node cluster with 11gR2 new feature (Grid Infrastructure) on Red Hat 5.0
  • Monitored all the 11g databases on Red Hat Linux environments by using OEM 11g and 12c.
  • Implemented Data Guard (Physical Standby database) on 11gR2 RAC environment for the Production databases as per the requirements and specifics tailored to the customer needs.
  • Migrated several RAC systems to ASM and handled the issues raised.
  • Building up Streams environment on databases. Both upstream and downstream setup on different database environments including QA and Production.
  • Implemented Table level and Schema level replication using Oracle Streams.
  • Monitoring Streams and working on the Apply Errors that could occur during the downstream Capture Process.
  • Performing Export operations at Database level as well as Schema level before configuring streams to maintain a backup copy of the environment.
  • Upgrading the environment with the recent releases as per the request (application upgrades)
  • Performed Upgrades of Oracle 11gr2 database on production, test and development environments on RHEL.
  • Monitored all the 11g databases on Linux environments and also monitored their performance by using OEM 11g and 12c versions.
  • Cloned schemas, objects and data on new server using Oracle Datapump export/import.
  • Responsible for the weekly Data Refresh from Production to Test, QA and other environments using datapump export/import utility.
  • Monitored alert log/system log.
  • Handled day-to-day activities in creation of databases depending on the specifications and also their maintenance.
  • Managed Database Locks and blocking sessions.
  • Implemented Flashback technology - Query, Table, drop and Database to undo specific transactions, recovered database objects and rewind entire database to a particular time.
  • Created Database links (DB links), Materialized Views for replication between two databases.
  • Planned Backup/Restoration Strategies like level 0 backup in the weekends, level 1 backups on the weekdays for medium sized databases. For small databases taking cold backups twice a week by shutting down the database.
  • Scheduled backups and recovery for Production and Test databases on an event of a system crash by using Recovery Manager (RMAN).
  • Used latest 11g Automatic Workload repository (AWR) and Automatic Database Diagnostic Monitoring (ADDM), ASH reports for health check of the databases and used the notification tool to send the alerts in OEM Grid Control.
  • Managed memory issues, space management issues and capacity Planning.
  • Applied patches for 11.2.0.1/11.2.0.3
  • Handled Oracle application system administration (managing concurrent process, creation of user, responsibility, registration of new application, monitoring user activity).
  • Automated the nightly RMAN backups for the Production and Test Databases using CRONTAB Utility.
  • Provided support and administration on as many as 12+ database environments on different servers with a maximum size of 5TB.
  • Have Production and other test environments DBA support experience in providing 24/7 support from 10 to 30+ Oracle Databases (on-call support rotation inside a 5 to 6 DBA team support)
  • Provided on call support for high and low severity tickets that were raised to handle different database issues and for performing daily database refreshes and upgrades depending upon requests from the application team.
  • Performed SQL tuning and Database performance tuning for daily loads and slow response issues based on reports generated by SQL Trace, TKPROF, STATSPACK, Explain Plan, AWR, ADDM and ASH for tuning and Analysis.
  • Performed General DBA tasks, such as assigning user privileges, monitor space usage; setup database performances alerts and troubleshoot database related issues.
  • Setup and maintained user accounts and Profiles.
  • Worked with Application developers on the application deployments.
  • Worked with IT Managers and Application developers to ensure the databases integrity, high availability and Security.

Environment: Oracle 11gR2, Streams Replication, RMAN, Data Pump, Shell Scripting, Red Hat Linux 5.5, Toad, Putty, Oracle Enterprise Manager, PL/SQL, Grid Control, SQL*Loader

Confidential, San Jose, CA

Sr. Oracle DBA

Responsibilities:

  • Installed, configured and supported Oracle 11gR2 RAC (Real Application Clusters) on a four node cluster with 11gR2 new feature (Grid Infrastructure) on Red Hat 5.0, IBM-AIX 6.1.
  • Monitored all the 11g databases on UNIX and Windows environments and their respective organic growth and the performance by using OEM 11g.
  • Implemented Data Guard (Physical Standby database) on 11gR2 RAC environment for the Production databases as per the requirements and specifics tailored to the customer needs.
  • Performance tuning i.e. Tuning RAC, tuning applications, shared pool, I/O distribution, rollback segments, buffer cache, redo mechanisms.
  • Migrated several RAC systems to ASM and handled the issues raised.
  • Weekly Data Refresh from Production to Test environments using datapump export/import utility.
  • Applied quarterly security patches (PSU/CPU), as well as interim patches for fixing bugs.
  • Monitoring alert log/system log.
  • Configured Oracle Enterprise Manager Grid Control for monitoring multiple database and notification of database alerts, and installed EM agents (Oracle 11.1.0.7 agents) on multiple database servers.
  • Performed replication using Golden gate, Oracle streams local capture between homogenous databases at Uni Directional table level and monitored Streams Issues using Grid Control.
  • Managing Database Locks and blocking sessions.
  • Implemented Flashback Technology-Query, Table, Drop and Database to undo specific transactions, recovered database objects and rewind entire database to a particular time.
  • Created Database Links (DB links), Materialized Views, for replication between two databases.
  • Planning Backup/Restoration Strategies like taking level 0 backup in the weekends, level 1 and level 2 backups on the weekday for medium sized databases. For Small databases, taking cold backup twice in a week by shutting down the database.
  • Successfully upgraded Oracle 10g (10.2.0.4) to Oracle 11g (11.1.0.7) on IBM-AIX nodes.
  • Scheduled backups and recover for Production and Test Databases on an event of a system crash by using Recovery Manager (RMAN).
  • Implemented Range Hash partitioning and Interval Partitioning for Data Warehouse environments.
  • Applied patches for 10.2.0.4/10.2.0.5 and 11.2.0.1/11.2.0.2
  • Applied security patches to all supported database systems and Performed testing.
  • Performed Database Cloning to setup Test and Development Databases using RMAN.
  • SQL tuning and Database performance tuning has been done based on reports generated by SQL Trace, TKPROF, STATSPACK, Explain Plan, AWR, ADDM, ASH, and monitored individual production databases performance on daily basis.
  • Oracle application system administration (Managing concurrent process, Creation of User, Responsibility, registration of new application, Monitoring user activity)
  • Managed Memory issues, Space management issues and Capacity Planning.
  • Automated the nightly RMAN backups for the Production and Test Databases using CRONTAB utility.
  • Loading data into database tables using SQL *Loader.

Environment: Oracle 11g/10g RAC, AIX, Red Hat Linux, Toad, Putty, Oracle Enterprise Manager, SQL * Loader, SQL Server, Oracle Application Server, PL/SQL

Confidential, Raleigh, NC

Oracle DBA

Responsibilities:

  • Configured, Implemented 10g/11g on standalone, RAC on RHEL, Solaris Servers.
  • Administering Real Application Cluster (RAC) database running on Cluster File System. Preparing cluster, configuring and Installation of Clusterware and Oracle RAC on Red Hat Linux. Startup and Shutdown of Individual instances on RAC database using Enterprise Manager.
  • Setup of Standby database for faster disaster recovery and Data guard setup for high availability.
  • Performing Capacity planning and evaluations with regular Maintenance cycles.
  • Utilized Oracle Streams to capture, propagate, and apply the transfer of data, transactions, and events within managed databases.
  • Utilized RMAN for backup and recovery strategy for different databases.
  • Implemented table level replication using Oracle Streams.
  • Installed and configured 10g Enterprise Manager and Grid Control.
  • Proactively monitoring and identifying areas that need to be improved in the application and database using Stats Pack, AWR, ADDM and 10g OEM Grid Monitoring.
  • Performed database upgrade from 9.2.0.6 to 9.2.0.8, 10.2.0.4 to 10.2.0.5
  • Implemented PSU/CPU Patches and ONE-OFF Patches wherever applied using OPatch utility, Run Installer and Scripts and applied Patches for 9.2.0.8/10.2.0.4 and 10.2.0.5/11.2.0.2 using Opatch.
  • Implemented new features of 10g like ASM, Flashback Recovery area, Flashback database etc.
  • Refreshing Development/Test/Production environments using Data Pump (expdp/impdp).
  • Worked on Transportable tablespaces and RMAN conversion using Cross Platform Migration.
  • Created and maintained different database entities included tablespaces, data files, redo log files, rollback segments and renaming/relocating of data files on servers.
  • Performed general DBA tasks, such as user privileges, monitor space usage, set up database performance alerts and trouble shoot database related issues.
  • Setting up and maintaining user accounts and profiles.
  • Worked with IT managers and application developers to ensure the database integrity, high availability and security.

Environment: Oracle 11g/10g, Solaris, Red Hat Linux, Toad, Putty, Oracle Enterprise Manager, Grid Control, PL/SQL

Confidential, Irving, TX

Oracle DBA

Responsibilities:

  • Installed Oracle 10g/9i standalone on RED HAT 4.
  • Configured database using latest features of Oracle 9i like Undo-Tablespace, Locally Managed Tablespace and Sorting Parameters.
  • Worked with users to determine system requirements.
  • Implemented Oracle Replication to enable database fail over in cases of system or database crash.
  • Cloned schemas, objects and data on new server using exports from 9i database and imported in 10g using Oracle data pump.
  • Monitoring of database objects like rollback segments, temp segments and tablespaces. Diagnose and troubleshoot Database problems and failures.
  • Intensively used latest 10g Automatic Workload Repository (AWR) & Automatic Database Diagnostic Monitoring (ADDM), ASH reports for the health check of the databases, and used the notification tool to send the alerts in OEM Grid Control.
  • Backup plan designing and implementation using cold/hot backups for database running on raw devices and Performed Monthly Cold Backup, Weekly Hot Backup and daily incremental backups using Data Pump, RMAN backup technology.
  • Experienced in using utilities like Export/Import and SQL Loader.
  • Monitor performance, Storage, backup logs, database logs, tables, extents, indexes, and all other back-end objects in production.
  • Capacity planning for table spaces, datafiles, tables, indexes according to DW requirements and size production instance.
  • Write scripts to automate the synchronization process between local and remote database.
  • Document all the back-end objects, logical and physical data model and database structures.

Environment: Oracle 10g, 9i, HP-UX 11.2, Linux Red Hat, Oracle Enterprise Manager, Grid Control, SQL *Loader, PL/SQL

Confidential

Junior DBA

Responsibilities:

  • Installed, Configured and Upgraded Oracle 9i on Linux.
  • 24*7 Production database Administration and Support.
  • Customized Data Guard as a tool for Disaster Planning and implementation.
  • Handling day-to day activities in Creation and maintenance of database.
  • Storage and Space management including table spaces and data files. Management of table space growth, monitoring data files additions and extent growth.
  • Monitoring of hot backups, exports on both UNIX and Windows
  • Maintained the RMAN repository and customized recovery catalog.
  • Performed database tuning for daily loads and slow response issues and also used STATSPACK, Explain plan for Tuning and analysis.
  • Created indexes, Triggers, Views and Partitions to reduce the time.
  • Creation and dropping of users, granting and revoking rights when required. Involved in Schema creation and management.

Environment: Oracle 9i Linux, UNIXs AIX 5.1, Windows, SQL, PL/SQL, Import/Export and SQL*Loader.

Hire Now