Oracle Dba Consultant Resume
Phoenix, AZ
TECHNICAL SKILLS:
COMPUTER SKILLS: Systems/Production Database Administration (UNIX, Linux & Oracle) Oracle 8/8i and 9i, 10g, 11g, 12 c Implementation & Configuration Discovery 9AIS, Materialized views Backup and Recovery planning using Veritas Netbackup Performance Tuning RAC (Real Application Cluster) 11g, Oracle Enterprise Manager, and Quest Software (Toad, I/watch Sherplex and Spotlight on Oracle) Report Server, SQL*PLUS, SQL*LOADER, SQL*NET, PL/SQL Database Link/Replication, Management and Optimization Enterprise Data Warehouses, my SQl, Sybase and SQL server HP - UX, Solaris & AIX People Soft Websphere MQ Solution software implementation and Configuration Business Intelligence reporting optimization. Dataguard implementation, Rman backup and disaster Recovery Migration from Unix to Linux Environment . OEM Grid control Implementation
PROFESSIONAL EXPERIENCE:
Confidential
Oracle DBA Consultant
Responsibilities:
- Performance tuning, Optimization and recommendations (Linux and Solaris Environment)
- Troubleshooting performance issues with database Migration.
- Backup and Recovery, 10 and 11G2 version, Rman database backup
- Implementing OEM Grid Control 12 C, Db Console and automated reports.
Confidential
Senior Oracle Database Administration
Responsibilities:
- Implemented and monitored over a hundred databases in a Unix and Linux environment
- DataGuard Implementation /Replication.
- Real RAC implementation and Golden Gate.
- Designed, configured and implemented the latest software. Oracle Diagnostics and Tuning Pack 11g to OLTP and large scale Data-warehouse databases for optimal performance, availability and reliability.
- Upgraded, installed and configured EM Grid control on 12C to administer and manage hundreds of databases on many different environments, including Unix and Linux.
- Applied patches to all OMS consoles to set the system and database environments.
- Automated QA/DEV core and DW Refresh and Sanitization using different DBMS packages and automated shell scripts.
- Set up Multi-master replication between real application cluster databases.
- Monitored the performance of production databases Made tuning recommendations and changes to ensure optimal performance.
- Upgraded Enterprise Grid Control from 11g to Enterprise cloud 12C. Applied all console patches to all OMS and set all system environments.
- Set up Oracle replication and advanced queries and partitioning.
- Participated in system capacity planning and forecasting as well as physical and logical modeling and security.
- Developed and implemented a strategy for validation of hot /cold backups.
- Implemented /automated Oracle Script to analyze and find Logical and Physical corruption.
- Implemented a strategy to detect and notify of any delays between primary and standby databases.
Confidential, Phoenix, AZ
Oracle Database Consultant
Responsibilities:
- Performance tuning, Optimization and recommendations (Linux and Solaris Environment).
- Monitoring Hundred of databases. AIX and Linux environment .
- Working with Remedy software, troubleshooting performance issues with database Migration.
- Backup and Recovery, 10 and 11G2 version, Rman database backup .
- HACMP, CVS and RAC Cluster failover troubleshooting.
Confidential, Los Angeles, CA
Oracle Database Administration Consultant
Responsibilities:
- Database Performance tuning, Optimization and recommendations (linux and Solaris Environment.)
- Implementing OEM Grid Control, Db Console and automated reports
- Backup and Recovery, 10 and 11G version, Rman migration Recovery .
- Implementing and configuring logical and Physical Dataguard .
Confidential, Los Angeles, CA
Senior Oracle Database Administration
Responsibilities:
- Installing, implementing and upgrading all Oracle database Servers to the latest Oracle Version 10G and 11G.
- Implementation of the OEM grid control, DB console and Automated reports
- Implementing Patches & other Oracle software’s related
- Implementing and configuring Physical and Logical Dataguard
- Testing implementing RAC in Solaris Environment
- Monitoring the Production database server's health and Performance tuning Optimization and recommendation
- Backing up and recovering data
- Performing data transfer more than 500 GIG database size, including migration data from and to different Platforms “from Solaris to Linux”
- Developed and implemented a strategy for hot & cold backups, using Rman/Shell scripting.
- Implemented and managed multiple instances
- Business Intelligence application implementation, administration and optimization .
Confidential, Kansas City, MO
Oracle Database Administration Consultant
Responsibilities:
- New implementation/Cloning Development database version 10g to Production in Linux environment
- Database Optimization/ Performance tuning and making Recommendations.
Confidential, San Jose, CA
Oracle Database Administration Consultant
Responsibilities:
- Performance Tuning of Oracle database 10g version, including SGA tuning and storage Tuning
- SQl tuning Using SQL Tuning Advisor, SQL Access Advisor, Analyzing AWR, ADDM Reports and recommending changes required improving performance using DBMS Packages Analysis and Materialized Views
Confidential, Los Angeles, CA
Oracle Database Administration
Responsibilities:
- Provided Oracle DBA support in a production databases, Sun Solaris and Windows NT/Windows 2000 Environment
- Oracle performance tuning, generating statspack and SQLnet tracing reports
- Upgraded Oracle database 8i release to Oracle 9i
- Oracle database implementation, Management, Migration and Configuration of Oracle 9i/RAC on Sun/Solaris
- Oracle Database/system Administrators and customers to resolve technical, and business process issues
- Data Modeling and design
- Developed and implemented a strategy for hot & cold backups, using Rman/Shell scripting, implemented disaster strategy recovery, and ensuring data integrity
- Implemented and managed multiple instances
- Performed capacity planning database and host data collection, trending, and extrapolation
Confidential, Los Angeles, CA
Oracle Database Administration
Responsibilities:
- Oracle Performance Tuning and troubleshooting.
- Oracle, Trend, and Trendweb installation on Solaris, IBM-AIX, HP-UX 11 on UNIX.
- Performed all database Administrator functions such as creating new schemas, tablespaces, rollback segments control files and redo logs.
- Tuned and verified queries using tools such as TOAD.
Confidential, Houston, TX
Oracle Database Administration
Responsibilities:
- Sun, Solaris workstation experience and UNIX system administration
- Imported map data from Oracle database into SeisWorks mapping files
- Exporting map data to Oracle database from OpenWorks and computing grids
- Trained Geosciences professionals in using different software packages
- OpenWorks data management
Confidential, Houston, TX
Software Consultant
Responsibilities:
- Seismic interpretation, reservoir characterization of deep water Gulf of Mexico using SUN-SOLARIS workstation
- Analyzed hydrocarbon reservoirs using geostatistical computer programs in UNIX environment
- Computer simulation and seismic modeling of dynamic hydrocarbon reservoir characteristics
- Backup and restore projects using tape devices in UNIX environment