We provide IT Staff Augmentation Services!

Oracle Database Administrator Resume

TECHNICAL SKILLS

Languages: SQL, UNIX

Systems: Oracle Database, Windows, AIX, SOLARIS, LINUX

Software: PL/SQL, Access, Excel, MS Word, Lotus Notes

PROFESSIONAL EXPERIENCE

Confidential

Oracle database administrator

Responsibilities:

  • Operating system environments: UNIX
  • Oracle versions 10 and 11
  • Upgrade Oracle binaries from version 10 to version 11
  • Upgrade database from version 10 to version 11
  • Applied latest Oracle security patches
  • Supported general maintenance and change requests (run scripts, check broken jobs status, schema exports, tablespace contention, short term user password requests)

Confidential, Ohio

Oracle database administrator

Responsibilities:

  • Operating system environments: SOLARIS and LINUX
  • Oracle versions 10 and 11
  • Refresh test databases
  • Worked with application installation teams to determine database requirements for new and upgraded applications.
  • Upgraded tables as requested by application teams
  • Create new databases through a GUI interface.
  • Performed schema exports/imports
  • Worked with large partitioned tables
  • Compress table partitions for archiving

Confidential

Oracle database administrator

Responsibilities:

  • Operating system environments: UNIX (AIX), LINUX, SOLARIS
  • Oracle versions 9, 10, and 11
  • Support production, staging, and development Oracle databases in a call - in/page-out service center environment.
  • Coordinate with multiple teams and account administrators to ensure the success of scheduled projects and system changes.
  • Troubleshoot all Oracle-related issues and determine root cause of issue when necessary.
  • Worked on call and responded to off-hours page-out issues.
  • Working with application teams to resolve issues and ensure an optimal Oracle environment for their requirements.
  • Worked with application installation teams to determine database requirements for new applications.
  • Create new databases both manually and through a GUI interface.
  • Upgrade databases both manually and through a GUI interface (version 10 to 11, 11.2.0.1 to 11.2.0.3).
  • Perform database refreshes using both export/import and RMAN procedures.
  • Perform database cloning.
  • Apply Oracle security patches
  • Resolved numerous logical Data Guard issues.
  • Worked with Oracle to modify logical Data Guard parameters to improve performance.
  • Ensure successful database and archive log backups using RMAN.
  • Performed database, table space, and data file recoveries.
  • Running datapump exports and imports (full database, schema, etc.)
  • Modify and/or create scripts as necessary.
  • Modify tables as requested by application users (add columns, add indexes, etc.)
  • Create database users and schemas.
  • Job scheduling through crontab.
  • Participate in disaster recovery exercises.
  • Identify and correct space contention issues on tablespaces and directories.
  • Trained coworkers on database procedures.
  • Collaboration between teams on a daily basis to resolve issues and coordinate projects.
  • Ticketing systems used: Manage Now, Impact, Remedy.

Hire Now