We provide IT Staff Augmentation Services!

Senior Oracle Database Administrator Resume

SUMMARY

  • Oracle Database Administrator (DBA) with 10+ years of extensive knowledge and production support experience in Oracle databases from 9i up to 12c on numerous operating systems including Unix, Solaris, AIX, Exadata (x2, x4, and x6). Experienced in patch implementation (PSUs, CPUs, patchsets), database upgrades and development, migrations, and Oracle software installation.

TECHNICAL SKILLS

  • Oracle database management, upgrades, tuning, and patching 9i, 10g, 11g, 12c (PDB and non PDB), and Exadata (x2,x4,x6)
  • ASM RMAN restore, management, and backup Data Guard
  • Shell scripting Oracle Enterprise Manager Exadata Management
  • Oracle RAC Excel Toad

PROFESSIONAL EXPERIENCE

Confidential

Senior Oracle Database Administrator

Responsibilities:

  • Migration of 10g and 11g databases
  • Mass upgrades of oracle databases from 10g to 11g using Oracle Flashback Database for rollback
  • Creating Rman Catalog for use with Commvault
  • Script creation for mass user provisioning
  • Modernizing of Oracle Audit scripts

Confidential

Senior Oracle Database Administrator

Responsibilities:

  • Working in a two - person team focused on migrating existing solaris databases to X2 and X4 Exadata
  • Migrated four applications from start to finish while also managing day-to-day oracle administration duties
  • Re-IP'ed Exadata X2 for datacenter move from Portland to Salt Lake City
  • Assisted in setting up X6 to continue planned migration from 10c to 12c for all applications

Confidential

Database Administrator

Responsibilities:

  • Consulting position focused on improving ASM and CRS in preparation of 12c upgrade
  • Trained and provided guidance to junior members on ASM monitoring, maintenance, and the importance of compatibility between database and ASM
  • Assisted with one-on-one training with various tools and technologies such as toad, crontab, and use of symbolic links
  • Converted databases which were formerly owned by disparate application groups to allow the oracle team to take over the oracle database maintenance while application groups handled their application side
  • Reviewed and standardized databases to meet oracle group specifications

Confidential

Database Administrator

Responsibilities:

  • Completed upgrade and migration of multiple secure government RAC databases to 11g in a project requiring government clearance
  • Commended by client for outstanding multi-tasking, effective communication, and superior time management
  • Created hot standby databases with Oracle 10g. Upgraded 9i cascading standby located in UK to 11g
  • Conducted database health checks including reviews of initialization parameters
  • Developed and enhanced a cross client privilege format to provides user with greater flexibility while maintaining database security in compliance with PCI standards
  • Collaborated with teams in the UK in setting up ACLs between their clients and servers while also allowing access to our team
  • Created ssh keys that allowed secure, non-interactive logins between grid management server and target servers
  • Managed routine DBA responsibilities such as tablespace creation, user creation, setting up audit trail, and trail cleanup
  • Setup routine scripts for environment monitoring, audit trail maintenance, and cleanup of log files
  • Resolved problems in connectivity issues, SQL-Net interfaces, errors, and troubleshooting
  • Contributed to ongoing shell script based monitoring and improved functionality by creating and streamlining new script and code

Hire Now