We provide IT Staff Augmentation Services!

Sr. Oracle Dba Resume

5.00/5 (Submit Your Rating)

Los Angeles, CaliforniA

SUMMARY:

  • Experienced Database Administrator with 10+ years of experience in a production/test/dev environment with a Onsite - Offshore delivery model. Experience includes install/upgrades, migrations, performance tuning, partitioning, monitoring, compression, backup, restoration, schema design, data modeling, automating DBA tasks and disaster recovery. Self-starter and commited to maintaining cutting edge technical skills and up-to-date industry knowledge.

TECHNICAL SKILLS:

Oracle: Oracle 9i/10g/11g/12c Administration, Hot/Cold/RMAN Backup and Recovery, ASM, Performance Tuning, Relational Design, Oracle Data Guard, Oracle Real Application Clusters (RAC), Partitioning, Oracle Data Pump

Case tools: ERWIN 4.0, Microsoft Visio

Software Languages: PL/SQL, Core/Applet JAVA, Shell scripting

Database: Oracle 9i/10g/11g/12c, MySQL, Netezza, MS SQL SERVER 2008/2012

Environment:: Windows 7/8/10, Unix (Solaris, Linux)

Other tools: NZ Admin, Aginity, Hummingbird, Toad 8.5, DB Artisan, Service Now, BMC Remedy, Autosys, OEM, New Relic, SolarWinds Orion, Kanban, Jira

PROFESSIONAL EXPERIENCE:

Sr. Oracle DBA

Confidential, Los Angeles, California

  • Migrated and upgraded 12.1 databases with oracle wallet (TDE) to 12.2 from Exadata X6 to Exadata X7 in a Oracle cloud environment.
  • Setup and monitored databases through OEM 13c.
  • Setup dataguard for 2-node RAC.
  • Upgraded clusterware from 12.1 to 12.2.
  • Supported weekly deployments as per business needs.
  • Supported oracle databases in a multi-tenant environment.
  • Migrated pluggable databases between Exadata clusters.
  • Performed full/schema refreshes for databases as per business needs.

Sr. Oracle DBA

Confidential, Rancho Cordova, California

  • Upgraded Oracle Enterprise Manager(OEM) from 12c to 13c(13.2).
  • Upgraded standalone database agents from 11g to 12.2 across the entire db space via OEM.
  • Db refreshes using volume copy or RMAN.
  • Database upgrades - 11g/12.1.0.2 to 12.2
  • Executed and provided ADDM, AWR and database health check reports to information owners and recommended solutions for improved performance.
  • Took ownership of complex database incidents and problems and provided resolutions in a speedy and timely manner.
  • Patched large number of db’s using Fleet Maintenance and patch plan method.
  • Supported major deployments for various projects.
  • Implementation of High Availability solutions with Oracle 11g/12c RAC, Physical and Logical Standby Databases (Data Guard).
  • Developing and maintaining jobs for monitoring and reporting various aspects of system performance, resource utilization, and application usage.
  • Recommend and implement new Oracle features or software enhancements.
  • Close liaison between SE, Storage, Network, Application teams to ensure database performance and availability.
  • Performed cross-platform migration for databases between Solaris and Linux.

Sr. Oracle DBA

Confidential, Glendale, California

  • Successfully migrated multi-terabyte databases related to Oracle Transportation Management across data centers.
  • Database/server monitoring through Solarwinds Orion, New Relic and OEM Grid 11g/12c.
  • Setup and configuration of 12C Cloud Control.
  • Oracle RAC implementations with RAC standby db’s.
  • Database refreshes (full/partial/schemas) between various environments.
  • Upgraded databases from 10g/11g to 12c.
  • Engineering, implemented, documented and support builds of new clusters to use Oracle 11g/12c RAC on Red Hat Linux. This included installing clusterware, ASM (and shared disks) and creating new databases.
  • Patched database servers based on BU downtime schedules.
  • Hands-on experience with AWS- Attended training and setup EC2 clusters and migrated databases to the cloud.
  • Familiarity with Exadata database appliance.
  • Experience with oracle database security products - Database Vault, Data Masking and Oracle Key Vault.
  • Good experience in Transportable Table spaces, SQL Tuning Advisor, Data Pump, Flashback Table, Table space Management and Materialized Views.
  • Worked on integrating SNAPI/Curl scripts with Service Now.
  • Evaluated server/instance architecture, hardware, system specifications, and capacity planning for new projects
  • Excellent interpersonal skills and analytical skills.
  • Provide support for Oracle Enterprise Manager Grid Control (11g/12c) and Agent issues.
  • Provide after-hours 24x7-database support for critical business applications.

Environment: Oracle 11g(R2),12c, OEM 11g/12c, Red Hat Linux 6.8, Solarwinds Orion, New Relic, Service Now, CommVault, NetBackup

Sr. DBA (Oracle/Netezza/MySQL)

Confidential, Los Angeles, California

  • Successfully implemented cross-platform (Solaris to Linux) migration and upgradation (9i to 11g) of Peoplesoft Financial/Expenses/HCM/HRMS databases that use TDE(Transparent Data Encryption). Improved timing up to 40% for the database migration process.
  • Upgraded the Application Express (APEX) environment and databases (10g to 11g).
  • Performed various database upgrades from 9i/10g to 11g for Prod/non-prod databases.
  • Designed a proof of concept environment to facilitate functionality testing and features, built a pilot environment, which mirrored production to do in depth testing for all customers, and provided a detailed migration plan to migrate the current production cluster to the new environments.
  • Prepare the roadmap and implementation plan for the migration and upgrade of applications currently on Sun Solaris and Oracle 9i/10g to Oracle 11g on Linux platforms. Advice the best practices of data migration using enhanced techniques available like 10g Cross Platform Transportable Tablespaces and Data Pump.
  • Oracle RAC implementations (2-node) with standby databases.
  • Followed established procedures, escalations and troubleshooting methodologies leading to a high level of database availability and low outage durations.
  • Develop long-term strategy for historical data retention and archival plan for storage needs: defines data retention, backup, and recovery for all data.
  • Hands-on experience with configuring and managing Oracle Golden Gate.
  • Setup scripts for database backups/cloning/replication through Autosys - BCV, Snap/Clone, RMAN, SAN Copy, Recoverpoint.
  • Monitoring the operating system response in terms of CPU usage, disk space, and memory/swap space by using various UNIX utilities like TOP, VMSTAT, IOSTAT and TOP.
  • Performance tuning for optimized results using tools like EXPLAIN PLAN, SQL*Trace, TKPROF, STATSPACK, AWR and ADDM reports.
  • Hands-on experience with SQL Server 2012 - installation, configuration, backup and recovery, database refreshes and performance tuning.

Environment: Oracle 9i/10g(R1/R2),11g(R2),12c, Toad 12.6, Sun Solaris 5.9/5.10, Red Hat Linux 4.7, Aginity, NZ Admin

Oracle DBA

Confidential, Los Angeles, California

  • Installation and configuration of 11gR2 on various Dev/QA/Prod boxes.
  • Performed Upgradation of 10gR2 to 11gR2 on development and production boxes.
  • Setup/monitoring RMAN/HOT/COLD backups and scheduling backup jobs using Autosys and crontab.
  • Oracle RAC installation for 2-node setup.
  • Performed database refreshes from Production database to Dev/QA.
  • Efficient co-ordination with UNIX, Backup, Application teams to ensure smooth functioning of databases.
  • Cloning/Data migration of databases performed across data centers.
  • Performance tuning - resolving long running queries, SQL Tuning, memory issues, space monitoring.
  • Applying CPU and other patches using opatch utility.

Environment: Oracle 9i/10g (R1/R2), 11g (R2), Toad 9.6, Sun Solaris 5.9/5.10, Red Hat Linux 4.7

We'd love your feedback!