We provide IT Staff Augmentation Services!

Oracle Dba Resume

3.00/5 (Submit Your Rating)

Dunwoody, GA

SUMMARY

  • Information Systems (IS) professional with ten (10) years of experience in the IT space and a solid track record of concurrently managing, with quantifiable results, multiple projects
  • Energetic, process and solutions - oriented and can effectively communicate complex technologies, optimize service delivery, cultivate relationships across all levels, and leverage communication skills to successfully bridge the gap between business and technology. Fluent French; conversational Spanish

TECHNICAL SKILLS

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

Languages: SQL, PL/SQL, T-SQL Shell Scripting (korn and bash shells)

Operating Systems Linux, UNIX(AIX):

RDBMS Tools: RMAN, srvctl/crsctl, SQL*Plus, SQL*Loader, Dataguard Broker (dgmgrl), expdp/impdp, GoldenGate, Erwin,TOAD

Data Models: ERD, Logical/Physical

Hardware: IBM AIX series, Sun Fire V880, EMC Data Storage Devices

Methodologies: Agile/Lean Six Sigma

PROFESSIONAL EXPERIENCE

Oracle DBA

Confidential, Dunwoody, GA

Responsibilities:

  • Supported twelve (12) 11.2.0.4 Dev/Test/QA single instance and three (3) production 12.1.0.2 two-node RAC databases running on Red Hat Linux platforms. The production databases ranged in size from 0.9 TB - 5.1 TB and were all part of a physical standby active (read only) datagurad configuration with asynchronous replication
  • Heavily utilized OEM for monitoring, job scheduling, performance tuning, and other routine DBA activities
  • Utilized Data Pump Export/Import extensively to migrate objects/schemas between environments
  • Utilized SQL*Loader to load data in flat files from DB2 into Oracle
  • Installed and configured GoldenGate replication for select tables in DB2 source to Oracle 12.1.0.2 target database
  • Monitored, traced, troubleshoot and resolved performance, capacity and backup issues using OEM and AWR/ADDM/ASH reports
  • Participated in on-call DBA rotation and built a solid track record for responding to and resolving issues in a timely & complete manner
  • Led the 12c POC effort and upgraded/migrated a host of Dev/Test/QA databases from 11.2.0.4 to 12.1.0.2
  • Heavily utilized FLASHBACK technology to flashback DEV, SIT and QA databases to existing restore points post Mock testings
  • SME on partitioning, Advanced Compression and SOX compliance

Oracle DBA

Confidential, Plano, TX

Responsibilities:

  • Created, configured and supported Oracle 11R1/R2g databases on Red Hat Linux and Windows platforms
  • Performed on-demand and scheduled logical backup (Data Pump Export/Import) in cron and OEM
  • Leveraged RMAN heavily for physical backups (incremental backup strategy) and cloning/refreshes using DPITR
  • Utilized BMC Remedy, our ticketing tool, daily when servicing database requests (WO, SR, INC, and CRQ)
  • Troubleshoot performance issues using tools like OEM & TOAD, AWR/ADDM/ASH/EXPLAIN PLAN reports

Jr. Application Oracle DBA

Confidential, Bentonville, AR

Responsibilities:

  • Worked closely with developers and Business Analysts during the SDLC process in managing Oracle 10gR1/R2 single instance Sandbox/Dev/Test/QA databases running on Sun Solaris platforms
  • Translated logical to physical models using Erwin and created the objects in the database
  • Completed ad hoc database requests and escalated complex issues

IT Specialist

Confidential, Plano, TX

Responsibilities:

  • Managed user accounts, network access and file permissions using DOS & UNIX utilities
  • Installed newly built and re-imaged desktops/laptops in offices
  • Troubleshoot and resolved network related issues over the phone and remotely via WebEx/GoToMyPC

We'd love your feedback!