Oracle Development
Resume:
TAIWO OGUNDIPE
abkm1z@r.postjobfree.com
US Citizen
Clearance - Public Trust
Oracle Database Administrator
Skills Summary
Software: Oracle RDBMS 6,7, 8 9i and 10g, Remedy, SQL*LOADER Unix 3.2,
VMS/Ultrix, TCP/IP, Decnet, windows 3.11, 95, XP Home Edition, Lotus Notes,
Excel, BMC Patrol, Microsoft Outlook, PeopleSoft, OEM, Sqlbacktrack and
Toad.
Server Platforms: HP, IBM AIX, DEC VAX, Sun Solaris
Experience Summary
Information Management Consultants (VA) July 2008 to date
Perform upgrade of 9i to 10g on a windows environment for Production,
Development and Test databases. Analyze guidelines and offer design
solutions to address the business needs for Substance Abuse and Mental
Health Services Administration applications Center for Mental Health
Services database application system. Provide logical and physical database
modeling. Create, size and maintain physical database objects. Develop
and maintain backup and recovery scripts. Develop and maintain SQL*Loader
data and scripts. Generate ad-hoc and routine reports utilizing Excel MS
Query and pivot tables. Modify PowerPoint training material and deliver
training for application users. Provide Helpdesk support and maintains user
ids and other user information.
SI International (VA) May 2007 to July 2008
Support Database Administrator in a development environment of System
Analysts, Developers and Testers for the State Department Consular Affairs
Information Systems - Immigrant Visa Information System (IVIS) and
Immigrant Visa Allocation System (IVAMS). The IVIS system assists Country
Posts in processing of immigration visas based on local necessities and
requirements established by the US State Department. The IVAMS system is an
Inventory System that deals with numbers of visas. This web-based
application authorizes users from the immigration services to submit visa
allocation requests via the Internet to the Visa office of the department
of State. Responsibilities include refreshing test and development
databases, creation of database objects for the development and test
environments, working with developers to tune SQL, utilization of Metalink
for research when troubleshooting issues. Upgraded an 8i Clear Case
Rational Requisite database to 9i on a Windows platform. Developed a
Standards of Procedure document for best practices.
TekSystems (DC) Oct 2006 - Jan 2007
Migrated 8i windows finance office acquisition management system database
to 10g and installed Grid in a test environment for testing and evaluation.
Kaiser Permanente (MD) Sep 2001- Oct 2006
Support of multiple Web Portal database Servers. The largest of which is
the KP Online a Comprehensive Health information system. This 450
concurrent transactional Member's website provides for employees, physician
and members to find reliable Kaiser Permanente approved health content as
well as services to help members and their families to stay healthy.
Supported a claims processing application that replicated data from the
primary online transaction database to the reporting database. Provided 24
by 7 support on a rotational basis with 5 team members for OLTP databases.
Maintained databases and trouble shot issues when they arose. Worked with
users to evaluate and determine requirements for systems. Installed setup
and configured Oracle software. Applied patches; provided technical
leadership for BMC Patrol roll out for monitoring via email and paging and
represented the Mid Atlantic information management group at biannual User
group meetings. I performed problem analysis through research via metalink
and OTN. Applied procedural and functional changes to supported databases
as part of the change management process. I oversaw ongoing system capacity
planning, forecasting and tuning. Provided support for standby database
used for reporting purposes. Modified Unix script files and maintained
PL/SQL procedures and functions.
Oracle Corporation - Bell South (GA) Feb 2001-Apr 2001
As part of a team of 12 members, provided 24 by 7 12-hour shift support for
the Bell South's Telephone exchange database system based in Atlanta
Georgia. Responsibilities and duties ranged from the setup and
configuration of Development, Test and Production databases. Created
tables, stored procedures, indexes and triggers. Performed Backup and
Recovery procedures.
Documented database operations for the adoption of administration best
practices for 'housekeeping' administration by the client site. For example
startup and shutdown scripts; backup and recovery operations; procedures
for the application of patches.
Oracle Corporation - NEXTEL (VA) Oct 2000 - Feb 2001
Performed SQL tuning for Nextel's application server database triggers. The
scope included analysis tuning, testing and recommendations to improve
performance on the multiple triggers.
Reviewed the current database triggers and made recommendations on the
tuning of SQL.
For example identified and removed unnecessary full table scans, indexes
not created on certain columns and driving tables that were causing
degradation in performance. Assisted in the regression testing of the
database triggers recommendations.
Maxim Group - Business Solutions (MD) Apr 2000 Sept 2000
Followed the full life cycle from Analysis to Implementation of a web
portal application for the Client. As custodian of the Erwin data modeling
software, I participated in the fact-finding sessions with the Business
Analysts and staff members of an organization that specializes in providing
Golf Packages inclusive of Travel arrangements, Car Rental and Hotel
Accommodation.
Installed Oracle 8I Enterprise Edition on NT and Sun Solaris within a
development environment for an E-Commerce package GoGolfTravel.com Oracle
interfaced with Jbuilder and Weblogic front ends.
Created Database objects produced through Erwin. Minimum database trigger
development.
Implemented Backup and Recovery routines on Unix and NT in house and PSINet
for production support.
Digital Consulting Services - Kaiser Permanente (MD) Sep 1999 - Mar 2000
Provided pre-production and post production consulting support to Kaiser
Permanente's Membership Claims Database application. Migrated Oracle7
instances to Oracle8 Enterprise Server on Unix Risc 600 servers. Performed
upgrades and applied installation patches. Refreshed development
environments and supported UAT users following completion of systems tests
by the development department.
Monitored and maintained nightly Backup and Recovery routines using crontab
and sqlbacktrack and evaluated a third party product, Shareplex as a
possible tool for replication of data.
New Boston Systems - Carey Limousines (DC) Jan 1999 - Aug 1999
Performed installations and configured Oracle Software for Peoplesoft front
ends
Migrated test, development and training databases from the Production
servers to the Development server on the NT production server.
Supported the Oracle 8 Production, Test and Development servers running
PeopleSoft Financial packages AR/AP and GL on NT. Trouble shot DBA and
PeopleSoft issues. In conjunction with the Senior PeopleSoft consultant.
Developed and installed the Backup Strategy for the database-using oracle's
OEM on the NT servers AT Scheduler and migrated the backup utility to
utilize RMAN and legato.
Comsys - AT&T (VA) Sep 1998- Dec1998
Developer/Production DBA for the switching Order System (SWORDS), a web
based application that kept track of commercial telephone numbers.
Installed, created and maintained the Development and Production instances.
Wrote SQL scripts and applied system changes to the Oracle 7 database
running Unix.
Comsys - MCI (VA) Jan 1998 - Sep 1999
Installed Oracle 7 and 8 servers for NT. Configured client workstations.
Created Oracle objects. Loaded data using SQL*Loader from DB2 tables in
ASCII files into the Oracle Data Warehouse database.
Installed and configured Oracle Express Server and Discover 3 for
evaluation as a front end application for the East Coast Billing Audit
Center for the purpose of utilizing on line analytical processing features
within the Oracle database.
Comsys - Mobil Oil (VA) Jun 1996 - Jan.1998
Administered multiple large production databases on remote platforms. This
included backup and recovery duties providing 24 by 7 support with 2
additional team members on databases running Oracle 6 and 7 on HP and VAX
running open VMS on a rotational on call basis.
Created and configured Oracle Instances and created and managed indexes.
Installed and upgraded Oracle products. Allocated and managed Physical
storage Structures. Migrated databases from VAX environments to Unix and
monitored instances in excess of several hundred concurrent users.
Configured SQL*NET V1/V2 connections. Performed database backup and
recovery. Monitored the database with the aid of BMC Patrol.
New Boston Systems - BDM Federal (VA) Oct 1995 - Jun 1996
Duties included supporting 12 databases and assisting developers in the
physical implementation of the American Red Cross' high availability
National Biomedical Computer System (NBC) using symmetric replication.
Migrated the database across nodes with extensive use of FTP. Performed
troubleshooting, backup and restoration of Oracle Databases. Configured
SQL*NET V1 and V2. Monitored the database for performance tuning purposes.
MAT Transport (UK) - Mar 94- Feb 95
I was responsible for the UK and Holland production and development
databases. Installed Oracle 7 server application tools. Migrated production
version 6 databases to Oracle 7.
Allocated system storage of Oracle data files and planned future storage
requirements for the database. Implemented change control procedures,
performed modifications, maintained system security and monitored
optimization and performance. Performed regular re-organizations of the
Oracle databases.
Education:
BS Information Systems Design - University of Kingston UK
Oracle 10g R2 New Features August, 2006
Learning Tree SQL Server 2000 Administration Hands on Sept, 2005
Learning Tree SQL Server 6.5 Administration Mar, 2001
PeopleSoft People Tools I Sept 2001
Oracle Corporation (UK) - Oracle RDBMS, Administer the Oracle Database II
and Oracle Tuning. Sept 1994
Contact this candidate