Oracle Dba Resume
0/5 (Submit Your Rating)
Oklahoma City, OklahomA
SUMMARY
- Over 8 years of IT experience, 7 years of extensive experience as an Oracle DBA on10g, 11g and 12c.
- Worked onOracle 10g and 11gStandalone and Cluster Environment.
- Build RAC from scratch on Red Hat Enterprise Linux
- Experience in Data Center Migration.
- Experience in setting up Oracle Data Guard.
- Experience in setting upGrid Control and 12c Cloud Control.
- Experience in setting upASMdisk groups.
- Experience in setting upGoldenGate.
- Experience in Setting up Materialize View Server.
- Worked with the many new features of 11g
- Worked with Data Pump to clone tables, schemas and databases
- Worked on Tablespace/Extent/Segment Management
- Worked on Backup and recoveries using user managed and RMAN.
- Setup Oracle Enterprise Manager (OEM) and worked on 12c cloud control.
- Worked on Database monitoring / performance / diagnostics via dictionary views and cloud control.
- Planning and scheduling Backups, Database Recovery, taking Logical Backups (with Export/Import).
- Maintain Oracle fail over databases (Physical and Logical standby databases - Data Guard)
- Worked on Oracle Tuning Pack
- Worked on Oracle Flashback / Flash Recovery Area (FRA)
- Proficient in Oracle RDBMS - including SQL, PL/SQL and all areas of database Administration.
- Experience monitoring Oracle RDBMS availability, database exports, Data Pump, tablespace, and extents fragmentation.
- Worked on Automated Storage Management (ASM) for 10g/11g databases.
- Worked on much performance tuning including SQL tuning and instance tuning.
- Worked with Oracle on open issues.
- Provided On-call support on 24/7 basis.
- Have written shell scripts to automate database management tasks.
- Pose strong administrative skills in RHEL.
- Build RAC clusters from scratch.
- Worked on Migration project
- Worked on Upgrade project.
TECHNICAL SKILLS
- RAC
- Data Guard
- ASM
- GoldenGate
- ASH
- Exadata
- FRA
- Export Import
- Data Pump
- AWR
- Grid Control
- 12c Cloud Control
- Performance Tuning
- RMAN
- ADDM
- Database Cloning
- Duplicate Database
- Migration
- Upgrade
- SQL / PL SQL
- Tablespace Management
- User Management
- Index Management
- Shell Scripts
- Oracle Security
PROFESSIONAL EXPERIENCE
Confidential, Oklahoma City, Oklahoma
Oracle DBA
Responsibilities:
- Add new nodes to RAC 11g Cluster to distribute the load.
- Installed and implemented 10g RAC with 4 nodes with ASM.
- Upgraded Databases from 10g to 11g and applied patches as per requirement.
- Worked extensively on data center migrations on multiple database versions. i.e, 9i, 10g and 11g.
- Responsible for installing and configuring Golden Gate on Oracle Servers.
- Database migration from 9i to 10g to 11g.
- 24x7x365 administrative support staff.
- Configured Data Guard to provide high availability by implementing Physical stand by database.
- Used RMAN duplicate database feature to move/clone databases on Linux, AIX and Solaris.
- Cluster Installation and Configuration, Administering databases in RAC for high availability.
- Installation, Configure, setup of 11g RAC on Linux.
- Designed, configured and maintained backup and recovery policies including RMAN backups.
- SQL, PL/SQL Tuning and Monitoring.
- Compared and contrasted multiple snapshots using AWR.
- Experience in monitoring and tuning SQL Server and database performance using SQL Profiler, Index Tuning Wizard, and Windows Performance Monitor.
- Responsible for setting up Oracle Golden Gate to help in propagating information between databases.
- Recovered databases and clone applications Using RMAN.
- Proactive performance monitoring, and capacity planning for future database and server growth.
- Performed Range Partitioning as a cause to improve the performance of the database.
- Performed Cross platform migration using transportable tablespaces and RMAN.
- Performed Import and Export using Oracle Data pump utilities
- Administered and maintained database security policies and procedures. Experience with administration of high-performance and large-scale multi-terabytes databases.
- Handled all standard database administrative tasks, such as: proactive performance tuning and monitoring, trouble-shooting, back-up and recovery, installations and configurations on an as needed basis.
- Used external tables and SQL*Loader to import data from flat files.
- Monitored database space requirements and adjusted for future needs.
- Performed version upgrades and patch installs.
- Designed and implemented database backup/restore methodologies, responsible for Troubleshooting performance and networking issues. Basic OS system administration.
- Strict adherence to policies and procedures - specifically in regard to change management.
- Perform database administration tasks as part of a scheduled change management task.
- Solid discipline in providing end-users timely updates on their problems. Installing server software.
- Configured and managed agents to work efficiently with Grid Control.
Environment: Oracle 11g databases, Data Guard, 11g RAC, Data pump, Data Pump, 12c Cloud Control, Offshore Team, 24/7 on-call support.
Confidential, Chicago, IL
Oracle DBA
Responsibilities:
- Oracle DBA duties involving development and production support such as installations, configurations, backup/restore & recovery, database monitoring & operating system configurations, database performance tuning, assisting in the logical/physical database design, applications profiling, tuning queries and providing support to developers.
- Performing Hot/Cold backups of the database through RMAN or User Managed method.
- Generated and analyzed STATSPACK reports and monitored statistics for performance tuning of the database.
- Review alert logs and dump files to check for any problems related to the database.
- Perform database cloning/exp/imp to setupidentical databases in the production and development environments.
- Discoverer Administration including the design and administration of Business areas.
- Maintained Oracle Application Server 10g for use with Discoverer, Portal and J2EE deployments.
- Developed PL/SQL based program for loading Data Mart.
- Oracle Applications server including OID. Implementation of Oracle Applications Server for use with Portal, Custom Forms and Reports and Discoverer 6i.
- Create and maintain users, roles and privileges.
- Upgrade/Migrated the production and development databases from 9i to 10.2.0.1 to 10.2.0.2
- Involved in discussions with the management regarding the advantages/disadvantages and upgrade plans.
- Used Oracle 10g AWR & ADDM to monitor database activities and performance tuning.
- Involved in Database sizing, Capacity Planning.
- Perform Space Management & Troubleshooting the database issues.
- Upgrading OEMRepository and InstallingOEM 10Grid Control to monitor all the databases.
- Configured and managed agents to work efficiently with Grid Control.
- Lead coordinator between technical operations team (DBA) and applications users/information systems/processing specialists
- Generated ASH, AWR, ADDM reports from Grid Control and command line.
- Setting up privileges to create local and remote objects
- Create materialized views to refresh data at regular intervals.
- Using materialized view logs to reduce the replication time costs for fast refreshes.
- Upgrading/Migration from Oracle 8i databases to 9i and to 10g.
- Installing of quarterly security patches on all non-production and production servers.
- Cloning/replicating/refreshing production databases to test/ development environments using RMAN scripts.
Environment: UNIX, Oracle 10g/11g, Oracle, Sun Solaris, Veritas Net Backup