We provide IT Staff Augmentation Services!

Oracle Dba Resume

5.00 Rating

Atlanta, GA

PROFILE:

  • Oracle Production/Application DBA with 5 - 7 years of extensive experience supporting next-generation oracle database solutions on a multi-platform, integrated IT environment
  • Rich hybrid of process improvement and service delivery optimization experience
  • Strong business acumen, communication skills and ability to effortlessly interface and build rapport with technical and non-technical users.
  • Multi-lingual: Fluent in English, French & Dutch

KEY COMPETENCIES:

SQL Optimization

Oracle RAC (HA solution)

Capacity Planning & Monitoring

Oracle Data Guard (DR Solution)

RMAN Backup & Recovery

OEM Grid Control

Partitioning

Advanced Compression

Business Communication

Agile (SCRUM) Methodology

EXPERT IT SKILLS:

Databases: Oracle 12c/11g/10g, SQL Server 2008, MS Access

Methodologies: Structured Analysis/Design

RDBMS Tools/Technologies: OEM, Toad, DBArtisan, SQL*Plus, RMAN, DGMGRL, EMCTL, SRVCTL, ASMCMD, Golden Gate, Oracle streams, TCP/IP Protocol

Office Applications: MS Office 2013 - Access, Excel, Word, Power Point, Project

Hardware: IBM AIX pSeries with the 47 GHz PowerPC POWER7, Sun Fire V880, EMC Data Storage devices

Data Models: ERD, Logical/Physical

Operating Systems: UNIX (AIX, Sun), Red Hat Linux, Windows

Languages: SQL, T-SQL, PL/SQL

PROFESSIONAL EXPERIENCE:

Oracle DBA

Confidential, Atlanta, GA

Responsibilities:

  • Provided database support for three (3) production Oracle 11.2.0.3/4 and 12.1.0.2 three-node RAC and single instance DG databases running on AIX and Red Hat Linux platforms; the databases ranged in size from 0.7 TB - 4.1 TB.
  • Supported Oracle multi-versions (10g,11g,12c) in Dev, Test, QA & Prod; performed database/grid infrastructure upgradation from 11.2.0.4 to 12.1.0.2.
  • In SDLC, supported Applications in Dev, Test, QA & Prod and performed application upgradation; Upgraded MAXIMO, an IBM-owned application from v7.5 to 7.6.1
  • Leveraged TOAD and OEM heavily for administrative, monitoring, scheduling, and query (SQL) optimization tasks
  • Traced user sessions and utilized AWR/ADDM/ASH reports for tuning
  • Trouble shooting skills include problem triage, analysis, recommendation and root cause
  • Wrote shell (korn and bash) scripts to automate routine work like backups and refreshes
  • Conducted security audit vulnerability assessments and remediate flagged flaws
  • Utilized a variety of tools - OEM, EMC TimeFinder, RMAN, Data Guard, Data Pump, UNIX shell scripts - to backup, refresh/clone databases
  • Leveraged AWR/ASH/ADDM/ reports and OEM (SQL Monitoring and Tuning Advisor) to monitor and optimize poor performing reports
  • Routinely applied scheduled PSU/CPU and one-off oracle patches to and upgrade databases using DBUA
  • Utilized SQL*Loader to load data in flat files from DB2 into Oracle
  • Participated in primary and back up 24X7 DBA on-call rotation schedule
  • Participated in the high-level design (HLD) and low-level design (LLD) of projects with database impacts
  • SME on partitioning and advanced compression techniques

Oracle DBA

Confidential

Responsibilities:

  • Installed, configured and administered Oracle 10g and 11g Development, Test, QA, and Pre-Prod single instance and RAC (two-node) databases on Red Hat Linux platform
  • Supported Change Management processes by migrating changes between environments
  • Wrote shell scripts, took backup and recoveries using RMAN and Data Pump utilities
  • Analyzed the execution plans generated by optimizer and replaced bad plans with historical execution and improved performance of sql running on databases
  • Worked with the Network team during OEM configuration to define ports in the firewall to enable traffic between the Oracle Management Server (OMS) and the Oracle Enterprise Manager (OEM) agent
  • Heavily utilized OEM/TOAD for monitoring, tuning, reporting & other admin tasks
  • Reviewed and optimized SQL and PL/SQL code for and from developers.
  • Tested, assessed and recommended alternative processes, procedures and tools to streamline operations and provide a more efficient database environment

Jr. Oracle Application DBA

Confidential

Responsibilities:

  • Installed, configured and supported the sandbox, development, test, and QA Oracle 10g and 11g R2 databases running on Sun Fire V880 servers for the Loan Solutions, group
  • Planned backup/restoration strategy; scheduled physical backups using RMAN and logical backups using Data Pump in OEM and cron
  • Up gradation of Grid Infrastructure and Oracle Databases from 11.2.0.1 to 11.2.0.3 on 3 node RAC environment.
  • Troubleshoot various Database instance tuning issues and maximized performance.
  • UNIX Shell Scripting for various backup / refresh of database from production to testing/development for cloning / renaming of database/applying PSU/CPU etc
  • Utilized OEM and DBArtisan for monitoring, administrative, reporting and tuning tasks
  • Migrated objects/schemas between environments and tuned bad queries

IT Support Specialist

Confidential

Responsibilities:

  • Managed user accounts, network access and file permissions using DOS & UNIX utilities
  • Created profiles, users, roles and assigned privileges as per the requirement.
  • Installed newly built and re-imaged desktops/laptops in offices
  • Built test cases and performed software testing prior to release.
  • Troubleshoot and resolved network related issues over the phone and remotely via WebEx/GoToMyPC

We'd love your feedback!