We provide IT Staff Augmentation Services!

Oracle Dba Resume

Columbus, OH

SUMMARY:

  • Installation and configuration of Oracle Databases.
  • Managed oracle 10g, 11g and 12c databases.
  • Installation, configuration and maintenance of RAC and ASM.
  • Database upgrade from 10g to 11g to 12c
  • Patching of Oracle grid and oracle database homes
  • Database cross platform migration using transportable database and transportable tablespaces methods.
  • Build RAC from scratch
  • Installed and managed ASM diskgroups.
  • Configuration of Data Guard with physical standby for DR.
  • Account Management, Responsibility assignment and monitoring/adding users.
  • Written Health checks shell scripts.
  • Monitor and regular checks for I/O, CPU and memory utilization
  • Checking Alert log, Backup - Log and other files.
  • Tablespace growth and management
  • Implement recommended configuration for high availability.
  • Backup management, Hot and Cold backups.
  • Recovering database based on scenarios.
  • Plan for backup and recovery of the database, along with the backup/recovery team.
  • Performing/participating in DR testing
  • Participate in business continuity testing.
  • Cloning tables from production to Test and Development environment
  • Tuning database in prospect of IO balance, adjusting memory parameter based on the server load.
  • Worked on oraInventory corruption issue.
  • Worked on the issues related to backup.
  • Worked on the data guard implementation.
  • Involved in the migration projects
  • Knowledge on Oracle Support processes for technical requests with Metalink.
  • Excellent written and verbal communication skills.
  • Experienced in Disaster Recovery setup.
  • Rotate on 24/7 on-call support.
  • Applied CPU/PSU patches

TECHNICAL SKILLS:

Operating Systems: RHEL, CentOS, Windows.

RDBMS: Oracle 10g, 11g, 12c

Languages: SQL, PL/SQL, C, Bash shell.

Tools: RMAN, OEM, SQL*Loader, Data Pump, SQL Developer, TOAD, putty

Tuning Tools: ASH, TKPROF, EXPLAIN PLAN, STATSPACK, ADDM, AWR

PROFESSIONAL EXPERIENCE:

Confidential

Oracle DBA

Responsibilities:

  • Oracle DBA in the Database Management Services group which supports and maintains the database infrastructure for Transport Canada, USA and Mexico.
  • Build multiple 2-node RAC Clusters.
  • Managed 11g and 12c database environments
  • Work in conjunction with application DBAs to develop and maintain the application database.
  • Setup alerts from 12c cloud control.
  • Worked on data center migrations.
  • Worked on restores/recoveries using RMAN
  • Document procedures in SharePoint.
  • Performed root-cause analysis of performance related issues.
  • Use of AWR and Statspack tools to diagnose performance.
  • Provided Automated Storage Management (ASM) technical assessment document.
  • Provided architecture document for the ASM including for Oracle and HP-UX Unix physical and logical layout.
  • Implemented Flashback technology as part of oracle high availability.
  • Build physical standby data guard on standalone and RAC.
  • Worked on ASM configuration and rebalancing issue.
  • Upgrade database from Oracle 11g to 12c
  • Configuration of security settings for Oracle Financials involved reconfigurations of Oracle roles, users, creation of triggers, procedures, synonyms and table constraints.
  • Applied CPU / PSU patches.
  • Setup Oracle Data Guard
  • Automation of Oracle Restart Configuration for the instances under the ASM configuration, part of the Oracle High Availability Services configuration.
  • Installation and configuration of Oracle 11R2 client and database.
  • Configuration and troubleshooting of Oracle Agents connections to Oracles OEM cloud Control.
  • Poses strong document skills
  • Perform daily database administration as required.
  • Applied Quarterly and PSU Patches.
  • Worked with offshore team.
  • Troubleshoot RAC node hang issues.
  • Used RMAN Active Duplicate database to clone database from prod to non-production databases.
  • Resolved gaps in physical Standby data guard environment.

Confidential, Columbus, OH

Oracle DBA

Responsibilities:

  • Installed of 10g and 11g on UNIX and Windows platform.
  • Configuration of OS, Staging of Oracle 10g Software, Backup's
  • Daily Health Check Activities
  • Regular file systems growth
  • Resolving user and network related issues
  • Applied patches on TEST, DEV before its go to PROD
  • Implementation of Open Database Backups (Hot Backups / Online Backups)
  • Implementation of Logical Backups (Export / Import)
  • Performed user managed backups and RMAN backups.
  • Periodical checks of scheduled Backups
  • Implemented Hot Standby Database for fail over situations
  • Implemented multiple ARCHIVELOG destinations to archive redo logs to the development server to support immediate database recovery
  • Created and altered Oracle Users, Oracle Roles, Granting Privileges and Profiles
  • Managing Password Security and Resources
  • Conversion of Database in Archive Log / No Archive Log Modes
  • Documented on implementation project
  • Initiating Backup scripts through
  • RMAN, & Cold Backup scripts
  • Schedule cronjob
  • Support & Maintenance
  • Solving Issues (Archive errors, Temp tablespace errors, User password issues, etc)
  • Good Communication between "Integration Team", "Data Migration Team", "Development Team", "DBA Team", and end-users
  • Database administration, Managing tablespaces, Objects, disk space
  • Create and Alter user roles, Granting privileges and profiles
  • Managing password security and resources
  • Database backups Online backups, Offline backups, & Logical backups (Export / Import using Parameter file, schema level, Full Database)
  • Backup strategy maintained Recovery Manager Utility (RMAN) for easier and well-managed recovery procedures, Configured hot standby database for fail over situations.
  • Configured multiple ARCHIVELOG destinations to archive redo logs to the development server to support immediate database recovery
  • Changed parameter
  • Worked on dynamic and static parameter changes.
  • Recovered pfile/spfile.

Hire Now