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.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship