Project Manager Oracle

An Oracle Database administrator with over * years’ experience on Oracle RDBMS.5 years of experience in Oracle Weblogic Servers installation, configuration, maintenance and troubleshooting,4 years experience in UNIX systems administration. I also have application analysis and business analysis experience ranging from Pubic Sector, Telecoms & Banks.Team player attitude with the ability to work independently. Possess very good analytical skills. Ability to effectively communicate with peers and management.

PERSONAL DETAILS

NAME Osagie Obasohan

Mobile Tel 0044-7591546183/00-417********

E-Mail acbqyl@r.postjobfree.com

TECHNICAL SKILLS

Databases/Fusion Middleware Oracle 8i, 9i, 9.2.0.4, 10g, 11g, Oracle AS 10g, DB2, SQL Server 2005, DB2, Web logic, J2EE, Service Oriented Archtecture(SOA), Oracle data integrator(ODI), Oracle Business Intelligence(OBIEE), OBIA.

High Availability Oracle RAC, Cluster Ware, Oracle Dataguard, Oracle Streams, Golden Gate, Grid Control, Recovery Manager (RMAN).

Management Support and Tuning tools SQL*Loader, SQL *Plus, PL/SQL, OEM/Grid Control, RMAN, ASM, DBCA, DBUA, Data Pump, Toad, Remedy, Export / Import, Spotlight, Oracle Golden Gate Director.

TOAD, SQL Developer, Oracle Restart, Oracle Weblogic Administration, Oracle Fusion Middleware suite.

Tuning Tools : TKPROF, EXPLAIN PLAN, STATSPACK, AWR/ADDM/ASH,TOAD, spotlight for Oracle RAC.

Reporting tools: Seagate Crystal Reports 8.5, Crystal Report XI, Oracle and SAP BI, Excel.

Operating system platforms and Solaris, AIX, Redhat Linux, citrix mainframe,

Windows Platform Server 2000, 20005

Present Employment

Employer Wipro/United Nations Organisation.(ILO)

Address Geneva, Switzerland

Job Title Senior Oracle DBA/Weblogic /Apps Administrator

Dates August 2013-Dec 2013

I Was responsible for the Installation and configuration of oracle software and database,Weblogic server and fusion middle ware suite (SOA, OID, OBIEE, Data integrator and webcenter) 11.1.1.7 installation setup and configuration including upgrading from Weblogic Server 10.3.0.5 to Weblogic Server 10.3.6

Provided functional and technical support for all levels of Oracle EBS users.

Responsible for recording/documenting information concerning failures & outages in Production and the measures taken to resolve them.

Configured Cluster Management, setting up Node Managers, Admin Servers.

Created and configured various database schemas and data sources for SOA Infrastructure, BAM, Repositories using Repository Creation Utility and SQL scripts on various environments.

Performance tuning and solving problems using thread dump and heap dump analysis.

Monitored Server log and Domain log, Application Deployment, and performance tuning of WebLogic.

Deploying applications to Staging and Production environments and troubleshooting issues in the process.

Raising logs with Oracle.

Worked on Web server and Weblogic consoles for non-critical fixes.

Trouble-shooting for different kinds of failures in Weblogic Servers, immediate fixture of the issue and performing root cause analysis on many of them.

Training and mentoring junior administrators on middleware technologies.

Worked extensively on deployment of new J2EE applications, creating clusters, managed servers, JMS queues, bridges & JDBC connections pools, managing JNDI,

managing security.

Previous Employment

Employer BG Asset Management Plc

Address Chicago, illinois

Job Title Senior Oracle DBA /Weblogic/Apps ( Remote support).

Dates Feb 2013-August 2013

Work with the System administrators, Testers and DBA's for pre-installation planning (hardware configuration, memory, disk space, kernel parameters, network connectivity etc.)

Installed and configured WebLogic in multiple environments.

I was responsible for administrating Oracle Application server instances, Oracle Weblogic servers.

Provided task level detail feedback to the Project Manager

Monitored Server log and Domain log, Application Deployment, and performance tuning of WebLogic. Setting the JVM parameters like maximum and minimum heap size in WebLogic startup scripts.

I carried out Performance tunning and configuration of Weblogic Server resources such as Connection Pool, JMS servers, and to Configure the Weblogic Server .Configuration Of LDAP Server on Weblogic Server to provide the Group and Roles Management outside Weblogic Server.

JNDI /JDBC / Data source configuration of Application Servers. Creation of Admin servers & Managed servers. Deployment of applications on Application Servers. Logical Machine creation for Application servers.

Administration of mission critical 24x7 databases on Oracle 10g Real Application Cluster.

Handling Oracle Database Administration activities like: Database Migrations, Database Upgrades, Database Re-Org,

Installations, Cloning, Patching, Code Movements, Performance Tuning, Database Backup/Recovery, and Proactive Health Check of databases. Also works on change requests related to Creating DBs, Schemas, Refreshing DBs,

Move DBs, Logical Backups.

Present Employment

Employer Cognizant-Orange Telecoms/T-Mobile.(Now Everything Everywhere).

Address Aztec West, Bristol. UK

Job Title Senior Oracle DBA

Dates June 2012 – Sept 2012

PROJECT : HIGH-LEVEL DESIGN FOR WESTMINISTER PROJECT,

Participated in the company’s business process planning and transformation to integrate enterprise-wide distributed applications and databases of Orange telecoms Current mode of operation-(CMO) with T-mobile’s future mode of operation (FMO).

• Supporting more than 50 instances.

• Install, configure, operation and maintenance Oracle 11gR2 for single instances, on RAC/ASM environment on Solaris SPARC and Linux Platforms.

• I successfully managed the complex installation of Oracle E-Business Suite, which incorporated Hyperion Essbase, and Oracle Business Intelligence Enterprise Edition.

• Performed Oracle Database Software installation, patch and upgrade to development, test and production servers.

• Performed cross platform database migration, Oracle Database upgrade using imp/exp and impdp/expdp.

• Refresh and clone databases as per user request.

• Support and monitoring of databases including primary and standby databases in dataguard environment.

• Perform Oracle OLTP database & data warehouse administration and development

• Debugging with procedures, Functions, Triggers, Packages and other PL/SQL objects.

• Create monthly databases reports for sales and infrastructure managers with recommendations and summary of tasks performed during the month.

• Performance Monitoring/Testing and capacity planning.

• Managed Partitioning of large tables for better performance and manageability.

• Take part in day to day operational activities: break-fix and requests Incident, request.

• Maintaining the production, staging and test environment – resolving problems indicated by daily checks, emails and generated tickets.

Backup/recovery procedures using Oracle Recovery Manager, Import/Export (and Datapump), SQL*Loader.

• Daily monitoring of Oracle and SQL servers for disk space, memory CPU usage.

• Participated in on-call rotation as required.

Previous Employment

Employer Trilogy Technologies. www.trilogytechnologies.ie

Address Aungier Street, Dublin 2, Ireland

Job Title Senior OracleDBA/Weblogic Administration

Dates June 2011 – May 2012

Worked as part of a team providing ICT solutions and managed service support to major Corporate Clients.

• Supporting More than 40 Database Instances.

• Provided Oracle and SQL server database administration and support to O2, Vodafone, Bord Gias, Largo foods and a host of corporate clients.

• Installation and configuration and monitoring of Web logic sever instances, domains, managed servers and clusters including Application deployment.

• Installed, configured and tuned various SOA Suite Domains and Clusters contains Admin Servers, SOA Servers, BAM Servers, Node Managers .

• Oracle 11G databases and schemas for various Fusion Middleware Components. Managed, Tested and Monitored Oracle fusion middleware 10g/11g Components using Enterprise Manager.

• Deploying applications to Staging and Production environments and troubleshooting issues in the process .

• Installed and tested new versions of Oracle Database, applications and patches.

• Performed database/infrastructure physical design, database upgrades & applied software patches to databases as per application/client requirements.

• Maintenance of applications on Oracle and SQL severs. Supporting multiple production,development and test databases of varied complexity RAC environments.

• Script performance tuning and code testing

• Daily monitoring of Oracle and SQL servers for disk space, memory CPU usage.

• Used Oracle backup utility (RMAN) and user-based backup to implement Oracle backup.

• Performed database cloning and refresh as per developers request.

• Releasing scripts to schemas as per developers request.

• Performance monitoring and tuning for optimized results using tools like EXPLAIN PLAN,SQL*Trace, TKPROF, STATSPACK, AWR, ASH, ADDM.

• Retrieve data from different types of sources such as flat files or relational schemas.

• Checking Alert Logs, Archive Logs, Trace files and to work proactively on alerts for the file system and cpu issues.

• Daily health checks and batch monitoring, reports on monthly PMs-performance Maintenance

• Responsible for troubleshooting and performing root cause analysis on all oracle related errors on applications and database servers, performing root cause analysis.

PREVIOUS EMPLOYMENT

Employer Dublin City University

Address Dublin, Ireland

Job Title Oracle Database Administrator.

Dates March 2008 – April 2011

• Managing and administration of 12 production and test databases, 9 development sites, this includes refreshing a whole or subset of data from production site.

• Managing user security through privileges and roles, managing user creation and administration Oracle, 8i, 9i and 10g databases running on Unix platform.

• Performed Backups, health checks, system monitoring and general house-keeping such as Regular checking of Alert log file.

• Install and maintain Oracle Databases and Applications in complex environments such as Single-node and multi-node (RAC) installations. This environment includes test, UAT, development and production.

• Regular update of schemas by releasing scripts as well as updates or Forms as per developers request.

• Configuration of SQL and Unix shell scripts-Writing scripts to create tables, indexes, views and aliases and synonyms to meet developers request.

• Implemented database refresh using full export. Used EXPORT/IMPORT to do table level and full database data modeling, installation, migration, procedures for backup/recovery, PL/SQL, tuning and support to developers.

• Patch analysis for database and applications patches including, family packs, and one-of patches.

• Performed cold, hot and RMAN backups and supplement it with daily export utility. Checking daily export dumps for Backup purpose.

Data upload using SQL* loader oracle utility, performance Tuning.

• Problem and management, escalation and incident reporting for the production environment

• Communicate with third party suppliers to get defects/issues resolved within suitable time-scales.

• Responsible for providing daily update reports to Project Manager.

Employer BARCLAYS WEALTH/Barclays Bank PLC.

Address London, UK

Job Title Oracle Database Administrator

Dates August – December 2007

• Provided Oracle DBA support for multiple large databases in production, development and test environments for various types of databases-OLTP and datawarehouse.

• Duies include system monitoring and troubleshooting (availability, capacity, performance etc). Daily health checks.

• Database Backup and Recovery, Back-up monitoring. On-call rota.

• Maintenance of Oracle software set (patches, upgrades, utilities).

• Conducted root cause and analysis for database incidents and problems.

• Participated in designing, testing and implementing an enterprise Disaster Recovery Plan.

• Monitored data activities (i.e. database status, logs, space utilization, extents, Checkpoints, locks and long transactions). .

• Adhered to Change Control Procedures.

• Developed & executed scripted changes requests in accordance with change control procedures.

• Designed, developed and executed Proof of Concept for Business Intelligence (BI) tools including Oracle Discoverer and Business Objects (BO).

• Provided & managed support to Environment of more than 50 Database Servers. Updated and wrote documentation and procedures.

• Handled Fine Tuning Operating System in-coordination with Server and Network Administrator to utilize the maximum resources for Database and Applications.

MAJOR PROJECTS-

Imaging & Workflow High Level Design.

The purpose of the project was to Re-platform the image and workflow applications with the aim of reducing the total cost of ownership and to improve service levels.

Migration of BT CSCS Terabyte databases with partitioning option. (Project involved migration of 3 production Terabyte databases and 3 development/test databases)

Designed and implemented backup strategy for development and production environment, I was also tasked with the documentation of backup and recovery strategy for the Go-Live and production environment.

Drafted the implementation of design of the dataguard environment for the Test and production database.

Employer Motorola corporation

Address Ireland

Job Title Oracle Database Administrator/SAP Basis Administrator

Dates MAY 2004-AUG2007

• Design, create and maintain oracle databases on Windows NT and Unix, open and closed database backups, 24x7 on call.

• Created and specified appropriate storage specifications for indexes, tables, table partitions, hash clusters, views, tablespaces and rollback segments using oracle database control.

• Performed SQL tuning using explain plan and TKprof.

• Provide remote technical support using SSH and Terminal services.

• User security and enrolments, assigning of roles and privileges.

• Performance Tuning at R/3 System level, Database level and OS-level.

• Client Administration - Client copy, client export, remote client copy, client deletion.

• Management of Transport Requests, Client Export/Import, Client Maintenance

Refresh development/test databases from production using Export/Import.

• Created and specified appropriate storage specifications for indexes, tables, table partitions, hash clusters, views, tablespaces and rollback segments using enterprise manager.

Employer Crystal Bank/Standard Trust

Address Lagos

Job Title Unix System Administrator.

Dates MAY 1999-2003

• Reviewed production systems and services.

• Managed queue management and Problem ticket creation.

• Provided technical feedback on process improvements.

• Carried out tasks to maintain service levels.

• Handled site issues to documented escalation matrix.

• Developed shell scripts and programming tools to automate administrative tasks such as backups

To College of Study Subject

1992-96 University of Lagos B.sc Business Information Systems

2003 Arup Nada Training Class OCA(Oracle Certified Associate)

2002-03. FAS Training Institute Linux System Administration, Microsoft Certified system administrator,

2004 Burleson Oracle and Trouble Shooting class OCP(Oracle Certified Professional)

2010 ORACLE Application Server 10g Administrator(OCA)

ITIL Information Technology Infrastructure Course.

Contact this candidate