Database Administrator Resume

PROFESSIONAL EXPERIENCE

Experience in designing, implementing, maintaining and monitoring DBMS in Oracle 7, 8i, 9i, 10g, 11g, 12c, Access, SQL/Server, Unisys 1100/2200, and A - series DMSII on Sun boxes, Solaris 10, HP boxes and Windows NT.
I also have technical expertise using PeopleSoft HRMS/Financial 7.5 thru 9.0 and CSS HRizon 7, 8 and 9 Enterprise application.
I gain my experience using various application tools such as RMAN, PeopleTools, DataMover, SQR, SQL, PL/SQL, SQL Loader, JCL, WFL and ECL scripts.
I also wrote computer applications in COBOL, Algol, and TIP programs.

TECHNICAL SKILLS

OEM
TOAD
UNIX
CANDE
WFL
ECL
JCL
Control/M
PeopleTools
SQR
COBOL
TIP
SQL
PL/SQL
Algol
Triggers
Oracle 7 8
8i
9i
10g
11g RAC and above
SQLServer
Microsoft Access
Oracle Designer
Oracle Developer
ERWIN
Weblogic 9.2
Toad
Tuxedo
Microfocus Cobol installation and compilation.

PROFESSIONAL EXPERIENCE

Confidential

Database Administrator

Responsibilities:

I was responsible with Database capacity planning (that included space capacity planning), Database creation, design, implementation, maintenance and the cloning of Databases for the Confidential Department of Education. I've upgraded and tested database software patches and new versions of Oracle 10g and above plus I have experience with Oracle 12c Cloud Control. I've performed SQL tuning using Explain plans and TOAD. I've provided advice to the System analysts with respect to how to better write their SQL. I'd used Disaster Recovery strategies such as Oracle DataGuard, RMAN, Expdp/Impdp and I've written scripts in both Windows/UNIX environments. I have the ability to install, configure and manage Oracle RAC, CRS, and ASM. I created the first cataloged RMAN Database system and written scripts the first scripts that managed whole and partial backups for over 10 Databases for the GDOE. Finally, I've written SQL scripts to manage the Audit table records in the System tablespace.

Confidential

Oracle Database PeopleSoft Administrator

Responsibilities:

I was the project team leader for the State Accounting office and DOAS e-Procurement systems this included the administration of the Production Training Databases Administration of the 10g/11g Production databases duties included tuning database SQL's, applying both the latest updated modules for PeopleSoft and Oracle software. Other duties included backup and recoveries using RMAN recovery manager. PeopleSoft duties included maintenance of the Application and the Web and Database servers which supported the PeopleSoft 9.0 application along with the PeopleTools versions 8.49.07 and 8.50.12. While working with a team of four DBA’s I would have to take turns as a weekly on-call DBA and I was responsible for the operation of the production batch jobs and the Databases that were accessed in the evening.

Confidential

Oracle Data Conversion DBA

Responsibilities:

Provided Data Conversion from various sources such as DB2, lower level of Oracle and over 300 excel spreadsheets. I also did Database tuning on initialization parameters and other Database objects such as

Tables, B-Tree and Bit Mapped indexes. I troubleshoot SQL problem using STATSPACK, and Explain Plans while using OEM and SQL analysis I was able to reduce runtime and fix storage, physical and memory I/O problems. I did Database Development work using PL/SQL functions that required comparative data manipulation which helped in maintaining up to date changes during large data conversion runs. I functioned as the owner of the SQL*Loader and was in charge all the jobs that were necessary to keep this project on track.

Confidential

Oracle DBA/PeopleSoft

Responsibilities:

I did routine DBA functions including providing UNIX cron and scripting jobs as well as troubleshoot SQL problems for a major PeopleSoft Application for a major Automotive Association. I also worked with Oracle Explain Plans, Stats pack and Hint rules for system efficiency.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship