Senior Oracle Dba Resume
4.00/5 (Submit Your Rating)
San Jose, CaliforniA
SUMMARY
- Oracle DBA and developer since Oracle Version 7.3.
- Oracle RAC DBA since Oracle Version 10.2.
- Several years as SAN storage administrator of Confidential ’s SAN Volume Controller and DS8000.
- Have written several white papers detailing best practices for running Oracle on Confidential ’s SAN storage, including: designing storage layout for optimal
- Oracle performance and availability the usage of Confidential SAN block storage Snapshot technologies for backup/recovery and Disaster Recovery
- Oracle databases the effective usage of thin provisioning for Oracle databases the monitoring of all aspects of infrastructure performance
- Including at the database level, the server level and the storage level the effective usage of both storage - level and Oracle-level benchmarking tools
- Oracle performance tuning tools and methodologies - SQL execution plans, tracing, Automatic Workload Repository (AWR), Active Session History (ASH) and Wait events.
- Oracle backup and recovery and Disaster Recovery - RMAN, Data Guard, User-Managed Recovery.
- Confidential SAN block storage configuration.
- Confidential ’s storage monitoring product Tivoli Storage Productivity Center 5.2.7.
- Storage-level and Oracle-level benchmarking tools.
TECHNICAL SKILLS
DATABASE: Oracle RDBMS since Version 7.3
LANGUAGES: SQL, PL/SQL, Korn, C, and Bourne shells, Python, Perl, C, Java, Pro*C
OPERATING SYSTEMS: Many years as a System Administrator and end - user on Open Systems, including Linux, AIX, Solaris and HP-UX.
PROFESSIONAL EXPERIENCE
Confidential, San Jose, California
Senior Oracle DBA
Responsibilities:
- Worked extensively in determining best practices for running Oracle RAC, Versions 10.2 - 12c, on Confidential ’s SAN block storage, including the SAN Volume Controller and the DS8000.
- Used freely available storage-level and Oracle-level benchmarking tools for proof-of-concept configurations.
- The storage-level benchmarking tools included Vdbench, fio and Orion. The Oracle-level tools included Swingbench, Hammerdb and SLOB.
- Wrote white papers detailing the results of the proof-of-concept testing.
Confidential, San Jose, California
Senior Oracle DBA
Responsibilities:
- Working in support of a health services client of Confidential . Supported 24x7 web-based application which entailed performance monitoring, backup/recovery, and Disaster Recovery via Oracle 9i Data Guard. Responsible for upgrades from Oracle 9.2 to Oracle 10.2.
Confidential, Plano, Texas
Oracle DBA
Responsibilities:
- Responsible for deployment of Avantis Asset Manager on Oracle 9i and HP-UX 11i (capacity planning, security setup, development support).
- Maintained Oracle Financials 11.0.28 installation. Applied patches and supported the development team. Streamlined the production-to-test cloning procedure reducing time required by 50%.
- Supported Replication environment which was used for reporting on subset of Financials data.
Confidential, Dallas, Texas
Lead Oracle DBA
Responsibilities:
- Upgraded and consolidated backup and recovery architecture to address problems with data loss.
- New setup accommodated rapidly growing databases and allowed eventual nightly backup of several TB’s of data.
- Implemented first installation of Sun's High Availability Cluster architecture in a TI wafer fab.
- Trained developers in SQL performance tuning techniques.
- Mentored and trained other Oracle DBA's.
Confidential, Irving, Texas
Lead Oracle DBA
Responsibilities:
- Performed all AIX host operating system, database, and 3rd-party software installation and configuration.
- Set up backup and recovery architecture for all database and middle-tier hosts.
- Installed and administered Oracle Transparent Gateway for Confidential DRDA 4.0.1 to allow direct Oracle connection to a DB2 database running on MVS Confidential mainframe.
Confidential, Dallas, Texas
Primary Oracle DBA
Responsibilities:
- Deployed a new implementation of Oracle Financials Accounts Receivable which was being migrated from a mainframe application. Deployment was achieved on time and under budget.
- Revamped backup and recovery strategy for all databases, including changing from periodic offline backups to nightly online backups.
- Cross-trained Sybase and DB2 DBA's to be able to perform maintenance tasks on Oracle databases.
Confidential, Dallas, Texas
Oracle DBA
Responsibilities:
- Regularly addressed performance tuning issues for SQL and instance-level configuration.
- Performed periodic large-scale tablespace Confidential 's.
- Automated via shell script the production-to-development cloning process.
- Installed and maintained Oracle Financials 10.4.