Sr. Oracle Dba Resume
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