Sample Banner

Oracle Database Administrator Sample Resume

John Michelle, Client Server/ Oracle Database Administrator

Summary

John Michellean excellent Oracle Database Administrator with 6+ yearsof experience with Oracle 11g/ 10g/ 9i/ 8i/ 8.0/ 7.3 Administration, Monitoring, Performance Tuning, Database Backup and Recoveryon Linux, Sun Solaris, HP-UXand Windows environments. He has got strong experience with OLTP(Online Transaction Processing)as well as DSS(Decision Support Systems) and Data Warehouse databases. He has got excellent experience in installing Oracle software, creating databases, developing backup and recovery strategies, loading external files to the Oracle database, Grid control, maintaining user accounts and privileges to maintain database security. He has got strong experience in migrating database across platforms using RMAN CONVERT. He has got excellent experience in developing UNIX/ Perl shell scripts for automation. He has got good experience in implementing the Oracle RAC(Real Application Cluster) with Multi node Cluster in ASM Environment, monitoring, tuning andload balancing RAC Environment. He has got excellent experience in configuring/ maintaining Standby database using Dataguard/Streams for Disaster Recovery.

John Michellecurrently working withCommonwealth of Massachusetts, Department of Public Health, MA as an Oracle Database Administrator fromApril 09 – Till Date.

Core Competency

  • Excellent DBAexperience in Oracle 11g/ 10g/ 9i/ 8i/ 8.0/ 7.3 Administration, Monitoring, Performance Tuning, Database Backup and Recoveryon Linux, Sun Solaris, HP-UXand Windows environments. Involved in different scenarios of OLTP(Online Transaction Processing) as well as DSS(Decision Support Systems) and Data Warehouse databases.
  • Excellent experience in configuring/ maintaining Standby database using Data guard/Streams for Disaster Recovery.
  • Strong experience in migrating database across platforms using RMAN CONVERT.
  • Experience in installing Oracle software, creating databases, developing backup and recovery strategies, loading external files to the Oracle database, Grid control. Maintenance of user accounts and privileges to maintain database security.
  • Experience with Oracle Parallel Queries and Materialized Views.
  • Experience in Performance/ Application Tuning, Performance Monitoring, Replicationusing Streams/ ShareplexandDatabaseCloningto setup test/ development database, Database Migration.
  • Experience with Streams Advanced Queuing (AQ) messagingsetup and support.
  • Experience in Export/ Importof database objects/ Schema/ database itself using Export/Import Utilities and DataPump
  • Experience with Import/ Export Utilities, Hot/ Cold Backup/ Recoveries using RMANfor 24/7 database availability and archival techniques such as transportable tablespaceusing RMAN.
  • Experience in Database Security Administration, Audit Trails, Oracle Alert and Patch Management. Experience in applying Patches on different versions of Oracle Software.
  • Experience in handling Space Managementfor Oracle DBs.
  • Experience in installing and configuring ASM (Automatic Storage Management)  .
  • Experience in implementing the Oracle RAC(Real Application Cluster) with Multi node Cluster in ASM Environment, monitoring, tuning and load balancing RAC Environment.
  • Experience in developing UNIX/ Perl shell scripts for automation, UNIX system administration.
  • Knowledge of network protocols, multi-tier architecture.
  • Extensively experience in end user group discussions to plan, design Database solutions.
  • Good experience in working as a Lead/ Senior DBA. Experience in interacting with senior managers, assigning work to team members, evaluating work, establishing priorities, monitoring progress and providing leadership on complex projects.
  • Experience in maintaining, supporting large Database environmentsand troubleshooting.

·Willingness to work in a highly dynamic environment and ready to take up challenges.

  • Excellent communication skills, self motivated, ability to handle multiple tasks, able and willing to learnquickly.

 

Technical Skills

 

 

Operating System

SUN Solaris(7/8/9/10, Red Hat Linux, AIX-5L, HP-UX10.2, Windows XP/2000/NT

Programming Languages

SQL, PL/SQL, T-SQL, UNIX Shell Scripting, PerlScripting, C, C++, Core Java/ JDBC, HTML, Visual Basic, DBMSPackages

Database

Oracle 11g/10g/9i/8i/7.x, ASM, RAC, SQL Server 2000/2005/2008

Tools

TOAD, SQL*Loader, Export/ Import, DataPumpExport/ Import, DBMSPackages, DBArtisan, OEM, STATSPACK, ASM, RMAN, OLTP/ OLAP, VLDB, OLS(Oracle Label Security)/ VPD(Virtual Private Database), Dataguard/ Streams, Oracle Application Express, Event Monitoring Service, CA-Erwin, ShareplexReplication, Oracle Developer2000, Clusterware, VERITASNetBackupand SQL Backtrack

Education and Training

  •  Bachelor’s Degree in Engineering