We provide IT Staff Augmentation Services!

Oracle Dba Resume

Wilmington, DE

SUMMARY

  • Result - driven IT Professional with referable & strong experience in Installing, configuring and administering Oracle 10g, 11g, 12c and Oracle RAC.
  • Highly skilled in performing Patch Installation, Migration, Upgrades, Backup and Recovery, Cloning, Replication, Database Security.
  • Good experience on managing databases on AIX, RedHat Enterprise Linux, UNIX and Windows environments.
  • Experience in configuring and managing Oracle RAC, Data Guard and Golden Gate for real time replication.
  • Highly experienced in Hot/Cold Backup and Recovery, VERITAS Net Backup and Cloning of databases using RMAN.
  • Experience on Data transferring with export/import utilities and Data pump.
  • Experience with active-active data replication using Golden Gate.
  • Good at implementing zero downtime migration and upgrade of 10g to 11g database using oracle Golden Gate.
  • Expert in planning & implementing high availability solutions such as RAC in Oracle 11g Grid and 10g on ASM and OCSF2 file systems.
  • Highly experienced in Oracle 11g, 10g ASM required to fulfill the storage needs.
  • Expertise in installing, configuring and maintaining Physical, Logical, Active standby databases supported by Data guard for disaster recovery.
  • Good experience on UNIX Shell Scripts for hot backups, SQL*Loader, export and import of database.
  • Hands on experience in implementation & administration.
  • Extensive experience with RMAN Backups, Hot Backups and Logical Backups.
  • Strong skills in applying patches CPU, PSU using Opatch utility.
  • Highly experienced in implementing Transportable Table space (TTS) feature.
  • Referable expertise in upgrading databases from 1og,11g to 12C using DBUA.
  • Experience with EXADATA, AWS, e-business, ETL and Informatica.
  • Versatile team player with excellent analytical, inter-personnel and presentation skill with ability to quickly adapt to new technologies & project environments.

TECHNICAL SKILLS

RDBMS: Oracle 10g, 11g and 12c

Languages: SQL, PSQL

Tools: TKPROF, EXPLAIN PLAN, STATSPACK, AWR, and ADDM. Toad, Putty, Win SCP

Database Utilities: SQL*Plus, Oracle Enterprise Manager, Real Application Cluster, ASM, Transportable Table spaces, SQL*Loader, RMAN, Data Pump, Export, Import

Operating Systems: HP-UX 10.x, 11.x. Sun Solaris 9, 10. AIX 5.3, 6.1 RHEL 4.x, 5.x, Linux Enterprise Server 9, 10, Windows 2010

PROFESSIONAL EXPERIENCE

Confidential - Wilmington, DE

Oracle DBA

Responsibilities:

  • Extensively worked on SQL Tuning Advisor, SQL Profiles, SQL Monitoring, SQL Access Advisor, SQL Baselines and utilities.
  • Tuning database and memory components for optimal performance using AWR, ADDM and ASH reports.
  • Supporting multiple databases for production, development, test and staging purposes on Sun Solaris and Windows environments.
  • Creating, granting and monitoring user access rights and privileges through roles and profiles.
  • Automated the Data Replication process using Materialized Views for reporting databases.
  • Applying upgrade patch, maintenance and interim (Opatch) patches on all the databases.
  • Refreshing Dev and Test instances with data from Production on a regular basis.
  • Developed PL/SQL packages and wrote UNIX/SHELL scripts.
  • Setting up infrastructure for databases in huge datacenters.
  • Implemented PTIR and Instance recovery done on 11g.
  • Scheduled Backups using CRONTAB.
  • Installation, setup and creation of 3 node RAC.
  • SQL statement tuning and optimizing performance removing load and query performance bottlenecks by using tools Explain Plan, SQL Trace, TKPROF, TOAD, ASH, AWR, EXPLAIN PLAN and OEM.
  • Installation/maintenance of Physical Standby database using Data Guard for Oracle 11.2.0.3 and Oracle 10.2.0.5 RAC databases.
  • Monitoring and optimizing the performance of the database/application using OEM.
  • Table partitioning to improve I/O access.
  • Refresh from Prod to Test and Dev using RMAN Duplicate or Datapump, conventional Export/Import of 11g, 10g.
  • Implementation of enterprise databases on enterprise Storage Solutions using Storage Area Networks (SAN) and Network Attached Storage (NAS)
  • Configuring PostgreSQL Streaming Replication and Pgpool for load balancing
  • Control Postgres cluster access using PostgreSQL.conf, pg hba.conf and pgpas
  • Upgraded PostgreSQL database servers from Version 10.x to 11.x and from 11.x to 12.x using pg dump, pg restore and pg upgrade.
  • Managing the monitoring tools for better performance like PgBadger, Kibana, Graphana, and Nagios
  • Used tools such as OEM, WinSCP, Putty, SQL developer, Toad to manage databases.
  • Installed, configured and managed PostgreSQL servers and worked recently with PostgreSQL Version 10.x, 11.x and 12.x Community and Enterprise editions.
  • Participated in a 3months Migration project from Oracle to PostgreSQL on premise and in AWS cloud using tools MTK, Ora2pg, AWS DMS & SCT to Migrate data/databases.
  • Setup HA solution Streaming Replication (including cascading replication) between Master and two slaves on a PostgreSQL Server for disaster recovery, high availability and load balancing.
  • Used Postgres native tools like pgBadger, pgpool/pgbouncer, PEM and PgDash.
  • Backup PostgreSQL databases using tools like pg basebackup for physical backups and pgBackRest & BART for incremental and differential backups as well as pg dump and pg dumpall for logical backups and refreshes.

Confidential - Thousand Oaks, CA

Oracle DBA

Responsibilities:

  • Install and managed Physical Standby database Data Guard for disaster recovery.
  • Worked on Backup and Recovery techniques using RMAN.
  • Integrated the Backup Status Reporting for all the databases in the enterprise to enable the web reporting using Oracle SQL, PLSQL
  • Used EXPORT/IMPORT utility of database to do table level and full database Defragmentation.
  • Worked on high transacted OLTP systems.
  • Created monthly IOT, creation and management of partitioned indexes and tables. Performance Monitoring and Tuning Databases and Application.
  • Partitioning for improving big tables to improve the Performance of the database.
  • Identifying bottleneck and rectifying it fine-tune store procedures to improve performance, database loads, performance improvements, proper setup of database files.
  • Performance tuning at database level for the parameters like SGA, PGA, PGA AGGREGATE TARGET.
  • Implemented and monitored all databases using OEM for maximum uptime and optimal performance.
  • Applying several patches such as CPU/PSU patches, One-Off Patches, Interim patches, DST, Patch sets as per the oracle recommendations.
  • Installation and configuration of RAC on different nodes with ASM.
  • Installation, upgrades and patches.
  • Database creation, performance tuning/reorganization, cloning, backup/recovery, user and security management, auditing, general troubleshooting, coding, and configuring servers.
  • Creation of table spaces, data files, roles, redo logs, rollback segments, stored procedures and Triggers.
  • Performance Tuning of database, instances, SGA, I/O, and rollback segment using different methods and detecting locks.
  • Wrote scripts to inform the DBA team on the status, performance and space management of the database.
  • Planning and implementation of off-site Disaster-Recovery planning and testing
  • Duties included database creation, backup/recovery using RMAN, tuning/reorganization, user and security management, auditing, cloning, general troubleshooting, and configuring servers.
  • Effectively involved in full life cycle of database administration in Oracle.
  • Worked as a Development Support DBA in Oracle.
  • Setup RMAN solutions for all Oracle Databases
  • Created RMAN repository, provided best practices, optimizations and data guard and cloning techniques -- restore and recovery.
  • Implemented and maintained Oracle 11g Data Guard/standby databases for switch-over and fail-over purposes.
  • Implementation of High Availability solutions with Oracle 10g &11g RAC, Physical Standby Databases.
  • Supporting the Production Database with complete lifecycle including Installations, Upgrade, Patching, Cloning, Backup/Recovery, High Availability including Oracle Real Application Cluster (RAC) and Data Guard.
  • Upgrading and configuring OEM Grid Control from 11g to 12c.
  • Utilizing 11g, 12c Oracle Enterprise Manager Grid control to manage users, privileges, profiles, and schemas.
  • Provided database related services to their development & QA environments.
  • Monitored and managed various database components (logical & physical) like table spaces, segments.
  • Installation/Configuring/Maintenance of Oracle Streams for replication, integration and transmission of data between different databases and applications.
  • Worked extensively on Shell scripting for backup, recovery and maintenance for databases
  • Experience in Implementing FLASHBACK technology and its various features in Oracle 10g/11g.
  • Configured physical and logical Standby Database (Data Guard) and tested for business continuity/Disaster recovery plan.
  • Extensively used Oracle Enterprise Manager for maintaining and monitoring database.
  • Worked on Logical backup using Data Pump.

Hire Now