We provide IT Staff Augmentation Services!

Oracle Dba Resume

Columbus, OH

SUMMARY:

  • 6 plus years in Oracle Database Administration.
  • Best practices for Oracle Database Infrastructure, Standards and Implementation.
  • Build 4 - node RAC cluster on RHEL, OEL
  • Setup DR using Oracle Data Guard.
  • Extensive experience in Oracle Partitioning.
  • Extensive experience in Oracle ASM and ACFS
  • Worked on 12c Cloud Control
  • Worked on 11g Grid Control
  • Applied CPU, PSU and one off patches.
  • Analyze application activity, tuning the particular data caused for poor performance
  • Installation of Oracle Databases on Standalone and RAC cluster.
  • Data Guard setup with Primary and Standby Databases.
  • Strong Oracle RAC Installation, Configuration and Tuning Skills on RAC and Solaris
  • Clone databases using RMAN duplicate database
  • Extensive experience in RMAN restore and recoveries.
  • Good replicating experience using Materialize Views.
  • Worked on setting up Data replication using Oracle GoldenGate
  • Strong SQL skills to perform the data base operations
  • Very familiar with Oracle Dictionary Views.
  • Experience with configuring/administering Exadata environments.
  • Implementing, configuring, and hands-on support on Oracle Exadata
  • Worked on many export import and Data Pump tasks.
  • Used Shell scripts to automate jobs.
  • Scheduling backup Jobs using Cron (UNIX) and Schedule Task (Windows).
  • Experience with configuring/administering Exadata environments.
  • Implementing, configuring, and hands-on support on Oracle Exadata
  • Disk space monitoring and Database availability.
  • Physical database design, Logical database design, normalization, de-normalization
  • Set up Oracle GoldenGate unit-directional and Bi-directional setup.
  • Familiar with Database security and auditing.
  • Setup procedure for Database statistics gathering
  • Worked on Upgrade and Migration Project.
  • Monitored databases using cronjobs and OEM.
  • Written shell scripts to automate tasks.
  • Worked with offshore DBA
  • Provided on-call support on rotational basis.

TECHNICAL SKILLS:

Database Installation: User, Role, Profile managementSQL / SQL Developer / TOADSQL Loader

Linux Shell Scripting: Patching

Data Guard: Oracle Net, TCP/IP

Storage and Space management: 12c Cloud Control12c Cloud Control

Performance Tuning: ASH, AWR and ADDMStatspack, tkprof

RMAN: Linux, OEL, RHEL and Fedora

RAC Installation: Microsoft Windows 2012

Performance Tuning: AIX, HPUX, Solaris

PROFESSIONAL EXPERIENCE:

Confidential, Columbus, OH

Oracle DBA

Roles & Responsibilities:

  • Build 4-node RAC Cluster
  • Build and supported Disaster Recovery Site using Oracle Data Guard
  • Supported different clients with multi-terabyte databases.
  • Installed Standalone and RAC Database Servers
  • Migrated databases from non-ASM to ASM
  • Completely build RAC from scratch including OS and RAID configuration.
  • Scheduled meetings with application team for database migration review to gather legacy information such as type of application, database options, current oracle configuration, capacity and oracle outstanding tasks.
  • Worked and resolved Gaps in standby environment.
  • Setup and Oracle GoldenGate uni-directional and Bi-directional replication
  • Applied CPU/PSU patches.
  • Worked on Migration project where a data center is moved.
  • Developed, revised and implemented policies, standards, procedures and guidelines necessary to effectively administer the database environments.
  • Ensure databases adhere to corporate standards and policies.
  • Worked with application team, developers, change management team and DBA team to ensure smooth life cycle progress from development through testing and production implementation.
  • Monitoring and maintaining 2/3 node RAC database on Red Hat Linux. Providing support to the development team and handling release schedules.
  • Maintaining sound backup and recovery policies and procedures using RMAN. Monitoring the scheduled backup procedures for daily basis using crontab.
  • Database refreshes using export /import and datapump. Used RDA, ADDM and AWR reports to monitor the database performance.
Confidential, Chicago, IL

Oracle DBA

Role & Responsibilities:

  • Configured and Managed ASM disks and disk groups thru both Grid Control and ASMCMD utility.
  • Configure ASM for Oracle 10G R1 installation with RAW devices which include clustered file system for RAC.
  • Conducting Installations of Oracle9i and Oracle 10g, Oracle 11g, sizing/capacity planning efforts for the Oracle database applications on varied platforms like Solaris, Windows and Linux Servers
  • Migration of system from Oracle 9i to 10g, 10g to 11g using Database
  • Configuring and using the OEM in 11g for Performance and maintenance.
  • Create and maintain multiple databases.
  • Create multiple 11g databases on RHEL5 in development.
  • Schedule backup in 11g using db console.
  • Improving the performance of the database by tuning SQL and database instance parameters using Automatic Database Diagnostic Monitor and
  • Used SQL SQL Tuning Advisor and SQL Monitoring.
  • Constant monitoring of database space and space management
  • Setting up Oracle Standby Data Guard.
  • Setting up of Oracle and Application user accounts and passwords, monitoring application security
  • Responsible to improve the performance by Using the Hints, Indexes, Explain Plan
  • Automating the backup processes using shell scripts. Performing recovery in cases of system crashes.
  • Worked with RAC implementation team. Added nodes.
  • Tablespace management including, adding/resize data files, allocated quotas to user and managed disk space
  • Help developers writing database triggers, packages, procedures, functions, utilities for application development.
  • Export and Import of User, Tables and Database using exp/imp and Data Pump.
  • Build Grid control for Monitoring 400+ database.
  • Provided technical troubleshooting and give consultation to development teams.
  • Performed Database Refreshes and Database Copies using Data Pump.
  • Applied PSU patches.
  • Resolves cluster related issues.
  • Implemented basic replication through Materialized Views.

Hire Now