We provide IT Staff Augmentation Services!

Sr. Oracle Dba Resume

Herndon, VA

PROFESSIONAL SUMMARY:

  • Over 8 years of professional experience as Oracle Database Administrator having good experience in Database administration, Database Installation in different platforms include Linux, Windows, Unix up - gradation, Migration, Installing patches, Performance Tuning, RAC Installation and Maintenance, setting up and configuring Dataguard, Performing all kinds of Backups and Recoveries, Cloning Databases, replications using Golden Gate and Auditing in Development and Production Environment.
  • Hands on experience on Oracle (9i/10g/11gR1/11gR2), installed and configured Oracle databases on different platforms like Windows, UNIX (RHEL 4/5, OEL 5/ 6, Solaris 10, HP-UX)
  • Worked on Different operating systems for OLTP & OLAP environment
  • Experience in configuring high availability systems like Real Application Cluster.
  • 24*7 on-call production database support and maintained remotely and Worked on databases.
  • Having good experience in 12c database administration and Installed 12c database on RHEL on Test Servers and configured 12C Grid Control on OEL 6.3.
  • Having experience in monitoring and managing of Oracle instances using Enterprise Manager Grid Control (OEM grid) 10g /11g.
  • Expertise in migrating production databases single instance to RAC environment.
  • Planned and Implemented Disaster Recovery (DR) and HA using RAC, Data Guard.
  • Experience in configuring, managing and monitoring both Physical standby and Logical standby database using Data Guard 10g/11g/12c and Have hands on experience on Active Data-guard.
  • Installed, Configured and replicated databases using Oracle Golden Gate.
  • Having good experience in migrating databases with zero downtime.
  • Generate and interpret Automatic Workload Repository (AWR), Active Session History (ASH), and Automatic Database Diagnostic Monitor (ADDM) reports
  • Configured Targets and used OEM to do the daily tasks regarding the performance, maintenance.
  • Experience in implementing and planning backup and recovery strategies using Recovery Manager (RMAN). Performed block recovery, data files and databases using RMAN.
  • Created clone databases for development and test environments using RMAN and User managed cloning and Implementation of Flashback Technology.
  • Installed patches using Opatch utility and upgraded databases from 9i/10g to 11gr2 and expertise in applying Oracle PSU and CPU patches.
  • Experience on Oracle monitoring tools including Oracle Application Server monitoring and Oracle Linux monitoring using NMON and TOP commands.
  • Implemented data transfer using Transportable Table Spaces (TTS), Data Pumps and Export/Import utilities.
  • Enforced Security administration, system monitoring by adding and removing users, configuring quotas, auditing, and analyzing security problems.
  • Experience in SQL tuning using Explain Plans and Hints, Performance Tuning for better performance and Monitoring and optimizing the performance of the database through database tuning - Tuning applications, Tuning Instance, and Tuning Disk Usage.
  • Performed various Transparent Data Encryption Operations and having good knowledge in Transparent Data Encryption Key Architecture.
  • Experience using Erwin as a Data Modeling tool & Designing the ETL processes.
  • Good knowledge on Oracle support process for technical requests using Metal link and other support features.
  • Good written and verbal communication skills, self-motivated team player and good analytical thinking.

TECHNICAL SKILLS:

Databases: Oracle 12C/11gR2/10g.

Operating Systems: Oracle Linux, Red Hat Enterprise Linux (RHEL) 4.x, 5.x, 6.x, AIX 6.1, Sun Solaris 5.8, 5.9, Windows 2003/2008

Languages: C, C++, PL/SQL, SQL, Unix shell scripting

Utilities & Tools: Oracle Enterprise Manager/Grid Control, SQL Developer, Putty, DBCA, Oracle DataGuard, Data Pump (expdp, impdp), Toad, RMAN, OEM

Oracle Products: Oracle 10g/11g/12c, Oracle RAC11g, GoldenGate, Dataguard, Import and Export, Data pump, Automatic Storage Management, Recovery Manager,, Grid Control, RMAN.

PROFESSIONAL EXPERIENCE:

Confidential, Herndon, VA

SR. Oracle DBA

Responsibilities:

  • Supporting Multi node 11g RAC / 12c RAC and Data Guard environment for HA.
  • Install setup and configured Oracle Enterprise Manager Cloud Control 12c as a tool of administration, performance tuning, monitoring, alerts and also OEM Grid Control 11g/12c. expdp/impdp errors in a RAC environment, configuring storage accordingly
  • Troubleshooting errors using Clusterware logs and patching 11g and 12c RAC environments
  • Involved in up gradation of databases from 11.2.0.4 to 12C in QA and DEV environments.
  • Implemented ASM on RAC and stand-alone databases. Managing disks and disk groups with ASM.
  • Knowledge in handling Distributed database and replication environment issues with Mviews, Streams, Golden Gate and Advanced Replication.
  • Installation and Configuration of GoldenGate 11.2 for Uni directional and Bi-directional replication of data and troubleshooting GoldenGate Extract and Replication files for Multiple Databases
  • Achieved High availability, Data protection and maximum performance by maintaining both physical and logical standby databases
  • Hands on experience working with Golden Gate Director and configured ODI to use Oracle GoldenGate for Change Data Capture.
  • Configured RAC 11gR2 DataGuard Standby Databases using Data Guard Broke r.
  • Worked on 11g new feature Active Dataguard and converted physical standby to snapshot standby
  • Experience in fulfilling DBA daily activities, including schema management, user management (creating users, privileges, roles, quotas, tables, indexes and sequences), monitoring, scheduling jobs, Unix shell scripting
  • Performing Backups (Full, Cumulative, Differential), Recoveries using RMAN-NetBackup and Experienced in creating duplicate databases using RMAN
  • Experience in Data Refresh from Production to Test & Development environments using RMAN Duplicate Database.
  • Implemented data transfer using Data Pumps and Export/Import utilities
  • Responsible to monitor database performance u sing AWR, ASH and ADDM using Oracle Enterprise Manager Database and Grid Control 11g/12c , generated reports as needed.
  • Performance tuning via AWR and Statspack. Fine tune Transaction intensive servers i.e. OLTP situations (I/O bottlenecks, SGA, pinning objects, Sort space, Redo logs) using explain plan, tkprof and identifying the execution plan and tune queries, using Indexes, hints etc. Exporting dictionary statistics from production to stage for tuning .
  • Used Flashback Technologies-Flashback Table, Flashback Query & Flashback Database to recover from user errors and minimize the Full/Incomplete database recoveries.
  • Working with Development, QA and other teams to resolve the issues .
  • Implemented Oracle Partitioning , Advance Queuing and Index-Only Tables to enhance performance of large OLTP environments and enhance the online community experience .
  • Responsible to develop UNIX shell scripts to automate support tasks.
  • Responsible for network configuration and involved in a Client-Server environment using TNS, LISTNER, Net Configuration Assistant and other configuration files.
  • Created a disaster recovery ( DR ) document that recommended five different approaches to managing Disaster Recovery, implemented, tested and supporting resulting strategy
  • Executing DDL changes Capacity planning and forecasting Query tuning and optimization .
  • Creating and dropping of Users, granting and revoking permissions to users/roles when required.
  • Developed Scripts for transferring data from production server to testing/development servers.
  • Experience in using Oracle Tools and utilities such as TOAD, SQL*Plus, SQL Developer
  • Experience with BMC Remedy tool for all change management process

Environment: Oracle 11g/12c, RMAN, OEM, DataGuard, Oracle 11g RAC, ASM, GoldenGate, Data- Pump, Toad, UNIX.

Confidential, Piscataway, NJ

Sr. Oracle DBA

Responsibilities:

  • Involved in designing of Disaster Recovery using Data Guard and High Availability using 11gRAC.Implemented Oracle Database 11gR2 2 node Real Application Cluster (RAC) using Oracle Cluster-ware on UNIX and Installed RAC on Linux.
  • Responsible for setup and implementation of 2 NODE RAC on 11Gr2.
  • Relocating services , using srvctl to stop start instance or database, create and drop services, node eviction issues.
  • Added a new node for 2 Node RAC for minimizing the downtime, maximizing availability and also achieved load balancing by minimizing the interconnect traffic.
  • Used CRSCTL and SRVCTL commands for the stop / start Cluster operations.
  • Performed converting single node instance to RAC and Adding instance to the existing 2 node RAC.
  • Implemented Disaster Recovery Plan for critical databases using DATAGUARD.
  • Worked on physical and snapshot standby databases in Data-guard environment.
  • Involved in construction of Disaster Recovery (DR) for all the production databases using DATAGUARD.
  • Configured pfile, Listener and Net service names manually for production and physical standby databases in Data-guard.
  • Worked on database Sizes 3TB and Responsible for capacity planning, database security, recovery planning and installing patches.
  • Installed standalone servers on ASM and migrated databases to ASM and Worked extensively on monitoring 11g grid control database, configuration of error notifications, installing listeners, and adding them to the grid control.
  • Collected ADDM recommendations using OEM 11g/12c to tune the TOP running SQL Query's.
  • Performed Database Refresh from production to testing and development environment and used EXPDP for schema level.
  • Worked closely with PL/SQL developers for fine performance tuning and Supported development teams by providing SQL statement tuning and removing load and query performance bottlenecks by using tools EXPLAIN PLAN, STATSPACK, and TKPROF.
  • Experienced in scheduling the database backup jobs using Crontab and Created a Clone database using RMAN on remote server & Worked with VERITAS net backup team.
  • Involved in database design and used Erwin as a Data Modeling tool & Designing the ETL processes.
  • Involvement in space management, rectification of lock problems, managed quotas.
  • Monitored Oracle Instances, Users, Tables, Table-spaces, Memory structures, and Rollback segments, Redo-logs, Archived Redo-logs and Alerts.
  • Worked extensively on performance tuning of queries by maintaining Aggregates, Compression, partition, indexing and use of statistics.
  • Provided instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical I/O and Memory Usage.
  • Created and monitored database objects like Tables, Indexes, Views, Users and DB links.
  • Conducted time to time analysis and monitoring of the software and hardware requirements and act accordingly.
  • Installed Golden gate on source and target side for Replication and implemented load balancing topology using GoldenGate .
  • Upgrading Databases from 11.2.0.2 to 11.2.0.3 and applying patches as per requirements
  • Experience in taking daily/weekly hot backups and cold backups using RMAN.
  • Configured Golden Gate Parameter files for Extract and Replica process for replication.
  • Performing day-to-day database administration tasks like Tablespace usage, checking alert log, trace files, monitoring disk usage, Table/index analyze jobs, database backup logs etc.
  • Oracle Database Performance tuning and SQL Tuning using SQL TRACE, AWR, ADDM, & EXPLAIN PLAN.
  • Refresh the test and development databases from the source production databases on a regular basis using export/import utility.
  • Performed applying latest Oracle patches and security patches for Oracle databases.
  • Experience in both Agile and scrum development environments which helps in Keeping the team together all the time to ensure successful outcome.
  • Configured ASM and suggested feasible workarounds for ASM Metadata corruption and Configured user log on load balancing and failover on RAC database.
  • Performed FLASHBACK features to handle efficient database recovery.
  • Created Shell scripts and scheduled for monitoring Oracle Databases.
  • Researching errors/issues/bugs which were impacting the performance of the database and recommended permanent solution without losing the performance.
  • Applied High priority, security patches downloaded from Metalink.
  • Implemented database auditing, data security and Remediate high-risk violation in production environment.
  • Applied patch set and interim patches whenever required to make the database software up to date.
  • Written SQL, PL/SQL functions, procedures, packages and triggers.
  • Developing Hot, cold and logical backup scripts to automate the backup procedures.
  • Performed various Transparent Data Encryption Operations and having good knowledge in Transparent Data Encryption Key Architecture

Environment: Oracle 11gR2, Oracle Enterprise Linux 5.2/6.4, RMAN, Oracle 11g RAC, GoldenGate ASM, OEM, Data pump, TDE, Exadata, OEM, SQL*Loader, Toad and SQL developer.

Confidential, Chicago, IL

Sr. Oracle DBA

Responsibilities:

  • Responsible for Installation, configuration and setup Oracle 11g databases.
  • Responsible to install, configure, and setup Oracle 11g DataGuard as High Availability. Implemented the Oracle 11g DataGuard between Primary database and standby database in production and test environments.
  • Performed the Upgrading of databases from 11.2.0.1 to 11.2.0.3.
  • Responsible to analyze and resolve, or recommend solutions to highly complex technical problems such as performance issue s, reliability issues, and data quality issues, and also tuning the Oracle RDBMS (database initialization parameters, redo log files, archiving et c.)
  • Responsible for developing and scheduling jobs and UNIX crontab and its scripting to automate and scheduling various routine maintenance tasks.
  • Efficiently used Oracle Tools like OEM, SQL* Plus, SQL* Loader, TKPROF, LOGMINER, AWR, ADDM, STATSPACK, Data Pump, FLASHBACK and RMAN.
  • Implemented ASM on RAC and stand-alone databases. Managing disks and disk groups with ASM.
  • U p-gradation / MIGRATION of dev/test/prod databases from 10g to 11g.
  • Involved in the implementation of High Availability solutions with Oracle 11g RAC .
  • Worked with other DBA’s for Capacity planning of new Databases. Data replication between different Oracle databases using DB Links. Setup test environment to simulate the migration process.
  • Worked with backup support team to implemented hot/cold backups using RMAN and recovery using RMAN, Export/Import and Data Pump utilities .
  • Implemented backup and recovery strategies using export/import, Datapump, RMAN Incremental backups, Traditional hot, cold backups.
  • Extensively worked, implemented Oracle Partition strategy on the tables and indexes.
  • Responsible to implement tablespace, table and indexes Oracle compression in dev/test and production.
  • Responsible for data modeling, metadata management, database design, database administration and support throughout the system lifecycle for project.
  • Responsible for build database(s), maintain database baselines, support application requirements, testing and implementations.
  • Responsible to monitored database performance using AWR, ASH and ADDM using Oracle Enterprise Manager Database and Grid Control, generated reports as needed.
  • Responsible to work with system admins to Server virtualization using VMware for Oracle database support.
  • Responsible to develop UNIX shell scripts to automate support tasks.
  • Extensively used Rational Clear case, clear quest, Toad, SQL developer, SharePoint tools to manage and maintain Oracle databases .

Environment: Oracle 11g, Toad, RMAN, OEM, Oracle 11g RAC, ASM, PL/SQL, Korn shell, Toad, Win SCP.

Confidential

Database Administrator

Responsibilities:

  • Managing databases using Oracle 10g Grid Control.
  • Created and Managed Standby Database. Installed and configured DataGuard.
  • Used DataGuard broker to monitor DataGuard configurations on standby database.
  • Good working and implementation knowledge on DataGuard and Stand-by databases for fail-over and recovery.
  • Responsible for network configuration and involved in a Client-Server environment using TNS, LISTNER, Net Configuration Assistant and other configuration files.
  • Created and configured database manually using Oracle Database Configuration Assistant.
  • Implemented backup strategy using RMAN, Oracle Utilities (Export/Import) and OS methods.
  • Created and enhanced DB utilities needed for automation of system and unit tests and investigation of production issues, troubleshooting.
  • Responsible for installation and administration of Oracle 10g on Linux and Solaris platforms.
  • Also implemented logical, cold and hot backups.
  • Partitioning Tables by determining the suitable methodology to improve performance and manageability.
  • Applied patches whenever necessary by downloading them from Metalink.
  • Involved in doing block recovery and backup validations using RMAN.
  • Rebuilt indexes for better performance of Oracle database.
  • Worked extensively in Performance Tuning at various levels including instance tuning, Query tuning, Database performance tuning.
  • Performance tuning using tools like EXPLAIN PLAN, SQL*TRACE, TKPROF, STATSPACK for optimized results.
  • Performed database object sizing (performance tuning of database objects) and space allocation.

Environment: Oracle 10g, Windows 2007/XP, TOAD, OEM, EXPALIN PLAN, EXPORT/IMPORT, RMAN, NETCA

Confidential

Database Administrator

Responsibilities:

  • The work involves overall Maintenance of ORACLE Database, Performance Tuning, Backup, Recovery and other database related activities.
  • Worked extensively on developing various data base objects like Tables, Views, Materialized Views, Stored procedures, Triggers and Packages.
  • Hands on experience on Installing oracle server 11g, creating, Maintaining and upgrading for different environments.
  • SQL tuning and Database tuning has been done based on reports generated by Run time SQL execution plans, AWR Reports, ASH reports, Explain Plans and monitor the database performance on daily basis.
  • Generated PL/SQL blocks proficiently using dynamic cursors.
  • Skillfully used various built in packages like DBMS OUTPUT, DBMS SCHEDULER, DBMS ALERTS and others.
  • Worked with Development team to fulfill the requirements of applications with Database design.
  • Involved in applying latest patches on the oracle database and also upgrading the database.
  • Responsible for modifying the database structure as required based on information given by the developers.
  • Responsible for setting and managing user accounts, granting required privileges to users.
  • Performed code performance tuning (rule based and cost based) and optimization using Execute Plan, TK proof and Trace files generating indexes and providing hints.
  • Loaded data from flat file into the Oracle system developing SQL* LOADER scripts.
  • Configuring network components like TNSNAMES, Names Server etc. For easy and effective management of Oracle networking. Configured listener for external procedure calls.
  • Created and maintained Snapshot sites and Master site with Replication Groups.
  • Developed UNIX awk and sed scripts according to the user requirement.
  • Partitioning Tables by determining the suitable methodology to improve performance and manageability.
  • Involved in handling day to performance issues and keeping a track of alert logs etc for tracing any abnormal activity.
  • Maintained all documents of Oracle Database operations. Prepared documentation of database backup and recovery standards.

Environment: Oracle 10g, Windows 2007/XP, TOAD, OEM, EXPALIN PLAN, EXPORT/IMPORT, SQLLDR, RMAN, NETCA.

Hire Now