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