Oracle Database

Cellphone: 443-***-**** ********.*****@*****.***

Oracle Database Administrator!

Chris Olatunde

Database administrator (DBA) with extensive experience designing, coding, testing and supporting next-generation database solutions in Oracle enterprise for 8 years. I am able to manage, support and provide quality solutions for data management based on many years of progressive experience in database administration with extensive experience building and administering complex relational databases management system. I'm a self starter, also a strong team player with excellent troubleshooting, organizational, and good communication skills. Proficient in an assortment of technologies, including Oracle 10g, 11gR2, 12c database and Exadata on Oracle solaris, and oracle Linux respectively.

Ensure fast, reliable, secure and easy to manage performance. Optimized database workload, lower IT cost and delver a higher quality service by enabling smooth and rapid consolidation withn your datacenter.

Environment: Oracle 9i/10g 11gR2 12cR1, SQL Server, PL/SQL, SQL*Plus, SQL*Loader, TOAD 10, FTP, DTS package, MS- Office, UNIX (Putty), MS Office. Oracle 12c Goldengate

DBA skills include:

Oracle 10g and 11gR2 Database Administration

Performance Tuning & Capacity Monitoring

Data Security, Backup & Recovery, Sql*plus tools

Standby/Failover Administration

TOAD

OEM Cloud Control 12C

Red Hat Linux-Oracle Linux OS

Oracle Forms and Reports Development

Oracle database 12c Administrator

Exadata storage and adatabase performance.

Oracle RAC & ASM cluster file system

Oracle Linux and Solaris Cluster System

IBM ClearCase

SQL Tuning in an Oracle Environment

IBM ClearQuest

Objective Oriented Programming (VB)

Windows NT, 95, 98, 2000, XP, Vista, 7 and 8

Microsoft Word, Excel, PowerPoint

Oracle SQL, SQL*plus, MYSQL PLSQL

Oracle Failsafe, Enterprise edition 4.0, Oracle XE ffor migrating and business integration.

Daily Activities

Daily monitoring and analysis of systems to ensure 24x7 stable operations.

Troubleshoot day-to-day database issues to ensure system stability and throughput. Responsible for Oracle logical and physical databases maintenance on AIX 7.1 power8 server. Performs Oracle database performance analysis, capacity planning, system sizing and ongoing maintenance/tuning to ensure maximum performance. Performed database tuning using sql developer Toad, client tools, and Enterprise Manager. Monitoring the database activities using Alert log and trace files for errors to take appropriate actions. Monitoring space related issues of (data files, table spaces, Disk adding in ASM). Creating and managing database objects, users, roles, privileges, profiles. Creation and maintenance of database, space management and configuring database listeners. Implementing backup and recovery strategies using Hot/Cold backup.

Project Delivery

Achievements in the first one year

Carried out a comprehensive assessment of the environment and made recommendations.

Identified finacle queries for performance tuning.

Investigated performance and capacity issues in finacle databases and made recommendation.

Implemented recommendation that reorganized the physical structure of the database.

Resized the database memory components, this helped to stabilize the fnacle environment and improved the performance.

extensive experience in Java, J2EE and ADF based systems development, which includes System Analysis, System Designing, Programming, Debugging, Defect fixing, Testing, Application Performance Analysis and Deployment.

Extensive and proven experience 10g/11g, SQL, PL/SQL, SQL* Plus, SQL*Loader

Collaborated with application team to fine-tune some performance related queries.

Recommended Increase in the arhivelog filesystem and reduced the frequency of archivelog backups. This helps to reduce contention on controlfile and consequently improved performance

Designed and setup the test database servers for oracle 12c,d 11g deployments

Installed and deployed oracle 12c on finacle databse test server.

Installed and deployed 11g. Clients on finacle applcation server.

Installed 12c software on CSIS and WAS servers.

Installed, upgraded and patched Oracle software. Setup brand new machines including

Oracle software installation, Oracle side configuration, troubleshooting and backup testing on aix 7.1 power8 server. Developed some Unix Shell scripts to automate database operation and database monitoring. Successfully implemented Oracle 12C Cloud Control Successfully Implemented Oracle Data Guard.

Experience

Home Federal Bank. Knoxville, TN (Consulting via InfoSpan INC. Falls Church, VA) Duration: March 2013 till date

Job Role: Oracle DB (project Handling on Training and consultant)

Worked Oracle Database Administrator. Administers, architects and implements complex multiple Oracle 11g R2 database Exadata, Data Guard, Exadata Storage and Oracle ASM environments. Installs and maintains database products, including patch application and upgrade of Oracle 11gR2 RAC and Data Guard environments. Works closely with business, application development teams, data center teams, and external consultants in developing database solutions to solve business problems development, testing or demonstration of Oracle 11gR2 databases. Performs many related database functions across one or more engineering teams, including designing, installation, upgrade and maintaining new 11gR2 Oracle RAC and Exadata databases, backup/recovery design, replication and configuration management, with Exadata and UFS Storage administration.

Design, install, and manage large scale, high-performance Linux systems (oracle Linux, Red Hat and CentOS) that support diverse online advertising platforms. Contributor to the automation, management, and optimization of our overall infrastructure. Develop scripts and procedures to automate routine processes. Work with Technology Operations in setting operations policy and procedure, such as related to patch management, monitoring, security, shared tools, shared infrastructure, etc. Research, design, develop and implement solutions for fault tolerance, performance, capacity, and configuration ‘management for applications. Identifies production stability concerns via break point and impact analysis. Designs, develops and implements remediation plans to address. Designs, develops, and implements documentation and/or tools to facilitate Technical Support team responsibilities and application maintenance. Provide Tier 2 support to issues escalated from Technical Support team. Interface with development teams, software vendors, or other Tier 2 teams to resolve issues. Investigates causes, test solutions, and puts solutions in place to reduce calls to help desk, as well as future handle times. Experience in developing commercial web applications, Multi-lingual web apps, enterprise applications and web services by using enterprise technologies, such as Java, J2EE, Spring, JSF, Oracle ADF

Experienced in Oracle cluster, both on oracle Linux and oracle Solaris Cluster Solaris OS Enterprise Edition, multiple clusters separated by long distances to protect applications using a redundant infrastructure, Using application or storage replication and automating failover. Disk mirroring and migration of Data across Disk.

Having 7 years of experience in the areas of Oracle and PL/SQL based applications using Oracle PL/SQL and SQL *plus Technologies under Windows WP/NT/2k, Linux Environments.

• Having database experience using Oracle 10g/9i/8i, SQL, PL/SQL, SQL*PLUS Stored Procedures, Functions, Exception Handling, Constraints, Triggers, Index, Views and Inline views.

• Involved in Development of the applications through Oracle using Pl/SQL created Tables, cursors and SQL Queries.

• Well acquainted with Oracle base technologies like SQL*plus, MYSQL, PL/SQL.

Oracle Database consultant and Training.

Using a Sql*plus and sql developer application in Working both on Linux and Solaris cluster system using ASM. (Automatic Storage Management)

Developing packages, procedures, functions, and triggers for the application.

● Using UNIX environment for performing the testing

● Performing the tests on the newly coded procedures and documenting the same.

● writing technical documents using the functional specifications.

● Writing PL/SQL code using the technical and functional specifications.

● Creating Oracle objects like tables, types, packages, procedures and functions.

● Automated sqlldr using shell scripting.

● Automated data fetch using UNIX shell script.

● optimized the queries to improve the performance of the application.

Environment: SQL * Plus TOAD, SQL*Loader, Forms 4.5 & Reports3.0 UNIX shell scripting

Installation of Application for driver tool for ASMlib, ASM support, ASM kernel for creating Disk and Managing ASM cluster system.

Assisting Teams of DBAs Implementation and support environment for oracle database cluster for grid infrastructure. Using SQL*Plus to provides access to the Oracle Database. It enables us to enter and execute SQL, PL/SQL, SQL*Plus.

Oracle 11g RAC, Oracle 10g RAC, 9i, HP-UX, Sun Solaris, RHEL, AIX, RMAN, ASM, SQL*Loader, DataPump, OEM (Grid Control), Golden Gate.

Using Sql*plus to Format, perform calculations on, store, and print from query results

Using Sql*plus to Examine table and object definitions

Using Sql*plus to Develop and run batch scripts

Using Sql*plus to Perform database administration

Serve as a technical assistance in oracle Real application Cluster troubleshooting, cluster failover and crash recovery System. In oracle RAC environment.

Oracle database 12cR1 multitenant database configuration and container database.

Automatic Diagnostics Repository (ADR) Enhancements in Oracle Database 12c (ADRCI)

Flashback Data Archive (FDA) Enhancements in Oracle Database 12c Release 1

Multitenant: Manage Tablespace in a Container Database (CDB) and Pluggable Database (PDB) in Oracle Database 12c Release 1.

Multitenant : Manage Users and Privileges For Container Databases (CDB) and Pluggable Databases (PDB) in Oracle Database 12c

manage users and privileges for container databases (CDB) and pluggable databases (PDB) in Oracle Database

Multitenant: Backup and Recovery of a Container Database (CDB) and a Pluggable Database (PDB) in Oracle Database 12c. Multitenant: Flashback of a Container Database (CDB) in Oracle Database 12c Release 1 (12.1) - Identify the restrictions when using flashback database against a container database (CDB) in Oracle 12c.

Experience in installing, configuring Oracle Fail safe.

Project: IT Modernization Special Permit Sub System (SPSS) – IT Modernization is Oracle ADF based enterprise web enabled J2EE application, which is developed based on agile development approach. The Special Permit Sub-system provides the functionality needed to support the PHMSA Office of Hazardous Material’s Special Permit Program. The Special Permit Sub-system uses a wizard to allow applicants to create requests for the DOT PHMSA Office to grant Special Permits. Technology we used for SPSS is Oracle ADF Faces, SOA, Web Service based web application on Oracle10g database.

New horizons System solution. Lagos, Nigeria May2012 – Jan 2013

Job Role Database Administrator

: Worked very closely with team to resolve user problems with applications and hardware. For more than 2500 user including graduate training. And ability to implement data guard training, Oracle e-business suite

Went out to users to either resolve issues that couldn’t be resolved by Level 1-2 and escalated if need be.

Participate in Oracle database configuration and installation, configuring oracle database grid control with oracle ASM disk for storage management. Using Linus Enterprise server 5.0. Oracle instance management, performing database backup and recovery using recovery catalog.

Also among few members of team to design and install oracle server for a client in south Africa configuration of ASM partitioning disk rebalance and migrating data across the disk.

Providing a solution during crash recovery. Instance accidental shutdown due disk failure and data recovery. Double check and mirroring the controlfile across a dick in a different location for safety to avoid database instance failure and providing support for front user application for easy login.

Responsible for standards and design of physical data storage, maintenance, access and security administration. Performs backup and recovery on Database Management Systems, configures database parameters, and prototype designs against logical data models, defines data repository requirements, data dictionaries and warehousing requirements. This position optimizes database access and allocates/re-allocates database resources for optimum configuration, database performance and cost. Performs work that is complex and varied in nature. Defines and discerns key aspects of a problem and develops an integrated solution within a broad technical and business context of significant impact. May provide guidance/training to more junior staff. .

Database and System Administrator

Maple group Lagos, Nigeria March 2011– January 2012

Job role

IT MANAGER => Supported Windows NT, Windows 95, MS Office, Outlook, Internet Explorer, Netscape and Bankcards. Also supported and installed hardware like printers, modems and network cards. Supporting a sister company Errandex server Installation, configuration (local and network), maintenance and troubleshooting of the database system Replication of databases across the network and local system Backup and recovery of database instances Monitor and optimize system performance using index tuning, disk optimization and storage access, system maintainance in each of the office units and web sevive and adminstarttive control.

Key responsibilities:

Environment: SQL; SQL*Plus MYSQL; Windows NT; TOAD

Perform database tuning with available Oracle tools, and extensive SQL skills

Monitor the space limit on the database with scheduler jobs

Work in a database environment hosting tomcat/weblogic application servers daily

Provide adequate support to developers and architects in the development life cycle of the software

Meet with team leads from various departments to ensure proper understanding and easy communication of the development strategy

Perform capacity planning in terms of memory and disk usage, establishing benchmarks for business and technical performance

Transform the backup and recovery tasks on Oracle database from using the USERMANAGE backup to using RMAN tool for fast, efficient and more accurate backup and recovery

Developed PL/SQL packages for electronic Document Exchange Manager

• Designed, created and maintained Web-enabled Oracle Forms & Reports for Networks Procurement.

• Generated SQL and PL/SQL scripts to install create and drop Trading Exchange Connection database objects including: tables, views, primary keys, indexes, constraints, packages, sequences, grants and synonyms.

Perform a flashback and point in time recovery when necessary

Part of the team that designs the continuity of operations (COOP) guideline incase of disaster or any type of failure

Creating a database recovery catalog and registering databases to the recovery catalog for efficient backup and recovery

Scheduling backups and daily monitor jobs using shell script with crontab utility

Support system administration groups with maintaining oracle database servers and in development, test, stage, and development environments

Part of the team migrating entire system to Unicode

24hr/week on call rotation and support on call rotation

Migrate data using the data pump export (expdp) and import (impdp)

Database Administrator

IDM/NIIT. Lagos, Nigeria

Duration: July 2008 – Dec 2010

Job Role: database Administrator

Worked in a group that provided configuration and Installations (UI), application development, integration and desktop support for over 400 user both the production and the customer service agent.

Part of the team for implementation and training to test and assess company’s alert and monitoring. Primary focus was Linus 3.0, 4.5 AS unbreakable & oracle Linus 5.0 enterprise server, l also supported a some of Office 2003 application to Outlook, and trained to laid down SLA’s, and support, (UBA bank) and supporting backend users with integrity.

Provided remote user setup and support including distribution of updates, using tools banking software like FINACLE, ORACLE GOLDEN GATE AND RPM.

Participate in setting up and installing Unix/Linux server in a multi-domain environment including basic commands and shell scripting.

Oracle Recovery Manager, Import/Export (and Data pump),SQL*Loader.

Reviews database design and integration of systems, provides backup recovery and makes recommendations regarding enhancements for improvements. Maintains security and integrity controls. Formulates policies, procedures, and standards relating to database management, and monitors transaction activity and utilization. May develop stored procedures and/or triggers.

Supports a full SDLC that consist of Development, Test, Stage, UAT and Production environments. I manage Oracle 11g R2 on both Windows and Linux environment on a VCS cluster that automates database and application failover within a multiple remote data center. We use Tomcat/Weblogic servers as a major part of the application servers, and on daily bases, I use Oracle tools such as the OEM, AWR, ADDM to closely monitor and enhance the performance of the database for end users. Data security and data encryption is also an essential part of my daily responsibilities. Oracle database administration assignments. Administering large databases in production environment with a two-node Real Application Cluster (RAC). Administering a single instance, development database environment, and a QA environment with single instance Oracle database servers. All on Red Hat Linux (HREL 5) operating system with Tomcat/Weblogic servers as the application servers. Enhance database performance, perform restores, implement recovery procedures, handle performance tuning and conduct regular system backups. Ensure technical and functional designs meet business requirements.

Key responsibilities:

Create, implement and manage custom Oracle databases on Linux and windows platforms

Work in a database environment hosting tomcat/weblogic application servers

Provide Oracle database administrative support to various user groups (application developers, data managers etc.); create and maintain Oracle database objects (schemas, tables, indexes etc.)

Analyze and tune voluminous SQL code

Design, develop and implement technology-based systems for a wide range of applications for different user groups

Perform capacity planning in terms of memory and disk usage, establishing benchmarks for business and technical performance

Perform backup and recovery tasks on Oracle database using RMAN and cold back -ups using shell scripts

Using RMAN to restore and recover control and data files respectively

Perform a flashback and point in time recovery

Creating a database recovery catalog and registering databases to the recovery catalog database

Scheduling backups using the crontab utility

Support system administration groups with maintaining oracle database servers and in pre-production, test, training, and development environments

Tuned database objects to run smoothly by analyzing query paths (creating explain path tables) and using efficient indexing

Control and monitor user access to the database using roles, and profiles

24hr on call rotation

Perform data migration from a database in one server to a database housed on another server using database link

Migrate data using the data pump export (expdp) and import (impdp)

Create non-default listeners for databases.

Registering databases and listeners to OEM Cloud Control 12C.

Environment: Oracle 9i/10g, 11g SQL Server, PL/SQL, SQL*Plus, SQL*Loader, TOAD 10, FTP, DTS package, MS- Office, UNIX (Putty), Perl Scripts, MS Office.

Brain System INC. March2007-May 2008

Graduate Traineed and internship on System Administrator and desktop operator, Determines sequence of operations by studying production schedule.

Prepares equipment for operations by accessing software in computer; loading paper into printers and plotters; preparing for output.

Starts operations by entering commands.

Maintains operations by monitoring error and stoppage messages; observing peripheral equipment; entering commands to correct errors and stoppages; reloading paper; making adjustments in process; notifying supervisor for additional resources.

Documents problems and actions by completing production logs.

Resolves user problems by answering questions and requests.

Ensures operation of equipment by completing preventive maintenance requirements and tests; following manufacturer's instructions; troubleshooting malfunctions; calling for repairs; maintaining equipment inventories; evaluating new equipment and techniques.

Maintains supplies inventory by checking stock to determine inventory level; anticipating needed supplies; placing and expediting orders for supplies; verifying receipt of supplies.

Maintains client confidence and protects operations by keeping information confidential.

Contributes to team effort by accomplishing related results as needed.

Computer Operator Skills and Qualifications:

Data Processing, Data Center Experience, Informing Others, Reporting Skills, Supply Management, Independence, Productivity, Confidentiality, Documentation Skills, Equipment Maintenance, Problem Solving

Education & Training

Obafemi Awolowo University ILE-IFE NIG

Bachelor of Science, computer Science And Mathematics

Univerity Of Maryland USA

Master In information system (in view)

DBA Workshops and hands-on: Oracle Database 11g Administration (2008), Advanced Oracle DBA (2009), Intro to Oracle (2007)

CERTIFICATIONS

NIIT Database Administrator and professional (2007)

Oracle Certified associate {OCA} 10g

Oracle Certified Professional {OCP} 10g

Oracle certified Professional {OCP} 11g

Oracle Enterprise Linux Administrator certified Associate

Oracle Enterprise Linux certified implementation Specialist

Oracle 10g DBA/ Web Developer 2007

Reference…

Contact this candidate