Oracle Database

BAKAR KANU

US CITIZEN.

Dalecity, VA ***** Cell: 571-***-**** **********@*****.***

PROFESSIONAL SUMMARY:

Over 8 years IT experience with troubleshooting skills, administration, installing, upgrade, performance tuning, backup and recovery and patching Oracle software. SQL*Plus and Linux proficient, creating databases using DBCA or manually. Additional skills include Oracle Grid Control, ASM, RMAN, RAC, Data guard, Enterprise User Security, Partitioning, GoldenGate replication and Data PUMP. 6+ years of experience with VMware, Red Hat Linux/Unix and Solaris 11, I have extensive experience with database cloning, Bash Shell Scripting for task automation and data migration using Data pump (Impdp, Expdp) utility. 3+ experience of AWS (IAM, EC2, S3 buckets, cloudfront, Elasticache, RDS etc). Experience with Oracle 12c, 11g, 10g, PL/SQL, MySQL, SQL Developer, and Oracle super cluster. Knowledgeable with working in a production, testing, and application developing environment. Knowledgeable in Business Analyst (BA) with Excellent interpersonal and strong analytical skills, documentation & Problem-solving skills with customer service oriented attitude. Able to produce result in a team environment or independently, with strong oral and written communication skills, including presentation skills.

WORK HISTORY:

Oracle DBA Consultant 04/2016 – Present

STACK IT SOLUTIONS Bowie, MD

Key Achievements;

Currently administering a 400GB production environment with a two-node Real Application Cluster hosting Oracle 12c (12.1.0.2.0) on Red Hat Linux (RHEL 6) operating system with Tomcat/Weblogic servers as the application servers. Administering a 70GB development database environment on single instance servers hosting 11Gr2 (11.2.0.3) database on Red Hat Linux (RHEL 6) operating systems. Administering a 100GB QA environment with single instance Oracle database servers on 12c (12.1.0.2.0) on Red Hat Linux (RHEL 6) operating system.

Additional responsibilities;

Created, implemented and managed custom Oracle databases on Linux and windows platforms

Worked in a database environment hosting tomcat/weblogic application servers

Provided Oracle database administrative support to various user groups (application developers, data managers etc); created and maintained Oracle database objects (schemas, tables, indexes etc)

Analyzed and tuned voluminous SQL code

Installation and Administration of Centos/RHEL Linux/Ubuntu

Designed, developed and implemented technology-based systems for a wide range of applications for different user groups

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

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

Installed and configured Oracle 12C databases

Using RMAN to restore and recover control and data files respectively

Performed 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

Supported 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

Administering Oracle GoldenGate for windows and unix databases

Provisioned EC2 instances in the AWS cloud, Patching EC2 servers and databases in AWS cloud

Allocate S3 buckets and create databases on AWS cloud

Create roles, groups, multi user authentication with (IAM) AWS services

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

Strong knowledge in Database Monitoring and Performance Tuning by using AWR Statspack, ASH Report and Explain Plan.

Strong knowledge in Database Security and User Management through Authentication, Auditing, Encryption and Enterprise Security for availability, liability and integrity for the organization.

24hrs on call rotation

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

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

Created non-default listeners for databases.

Registering databases and listeners to OEM Cloud Control 12C.

Participated in scrum meetings sessions as BA

Have dealt with both Agile and Waterfall applications

Oracle DBA 04/2015- 04/2016

JELANI CONSULTING Inc. Greenbelt, MD

Key Achievements;

Provide support in the operations and management of the company’s databases

Install and maintain Oracle database 11g on Red Hat Linux and Window platform

Install and maintain Oracle database 12c on Red Hat Linux and Window platform

Performed database maintenance by applying required patches and software updates

Monitor and perform tuning database to ensure the system continue to perform of the desire level of performance using OEM, AWR, ASH and ADDM

Monitored the status of ASM instance and RAC database

Provide support in the operations and management of the company database

Assisted in Installation and configuration of data guard and RAC

Create database, tablespaces, tables, indexes and other database objects

Monitor database health to ensure high performance capacity, for availability and reliability using vmstat, Sar, iostat, Top and netstat

Performed migration by using Data Pump utilities (Expdp)/ (Impdp) and SQL*Loader to load data from one platform to another.

Performed backup and recovery by using RMAN for hot/cold backups, and weekly full backups.

Monitored Oracle Data guard for Physical and Logical standby databases for disaster recovery.

Provide database security measures by creating and assigning appropriate roles and privileges to users.

Monitored Database growth trend and analyze trends and provide reports.

Managed schema and Create or modify databases and other database objects to improve performance processes.

Monitor network related to Database availability.

Participated on weekend call support and document all database support tasks.

Provide solution and maintain the database for troubleshooting by using trace files, alert log and oracle Meta links and document future solutions

Maintains data integrity by working to eliminate redundancy

Oracle DBA 01/2012 04/2015

Northern Virginia Training Center (State Facility). Fairfax, VA

Key Achievements;

Install and maintain Oracle database 11g on Red Hat Linux and Window platform

Upgrade Oracle 11g database from 11.2.0.1 to 11.2.0.3 using patch set

Performed database maintenance by applying required patches and software update

Create database, tablespaces, tables, indexes and other database objects

Maintain database security, create, modify and manage users accounts; grant privilege and restrict access to database objects

Monitoring the log files, backups, database space usage and the use of system resources

Monitor server and instance resources to ensure continuous database operations (i.e., datafiles, tablespaces etc.)

Utilize RMAN to backup and restore the database

Perform cold and hot backup and recovery using export/import

Confirm that backups have been made and saved successfully in the defined location.

Check Alert logs Files, Trace Files, and System Event Logs for unusual events.

Ensure daily RMAN backups were completed and valid for restore and recovery

Perform data migration using Data Pump export/import utilities

Participate in team meetings and building exercises

Create and maintain logical and physical data model to meet the of customer

Performed Installation and configuration of Oracle Enterprise Manager (OEM) and Grid Control for Oracle 10g and 11g.

Oracle DBA 10//2008 - 11/2011

The Home Depot. Alexandria, VA

Key Achievements;

Provided and maintained Oracle Applications Administration for 11g DBA skills for complex 24 7 environments for consistency and data availability.

Provide strategy for Upgrade Oracle database by using DBUA from Oracle 10g and 11g respectively.

Proactive manage the database to prevent it from poor performance

Performed backup and database recovery hot/cold backups.

Create database, tablespaces, tables, indexes and other database objects

Maintain database security, create, modify and manage users accounts; grant privilege and restrict access to database objects

Check Alert Logs Files, Trace Files, and System Event Logs for unusual events

Performed Oracle software installation and software updating to ensure proper data security

Monitored database for troubleshoots and problem solving to ensure that the system meets user needs and requirements, consistency and availability.

Perform database maintenance by applying required patches and software updates.

Provide strategy for Upgrade Oracle database by using DBUA from Oracle 10g and 11g respectively.

TECHNICAL SKILLS:

Database System: Oracle 10g/11g/12c

Oracle Utilities: ADDM, AWR, OEM, RMAN, DATA PUMP (Import/Export), RAC, Data guard & Grid control, Backup & Recovery Packages, Microsoft Project SQL, Repository Administration Utility SQL*Net Configuration, Netscape Navigator, Cute FTP TOAD, TCP/IP transport stack

Programming Languages: SQL, PL/SQL, VI editor, SQL Developer, Cross Platform Migration, J2EE, Data Guard, Golden Gate implementation. Oracle Critical Patch Update. PHP-Drupal, oracle cloud CX service and share point environment

Operating Systems: LINUX/UNIX (Red Hat), Windows / SQL Tuning Advisor, SQL Loader, PL/SQL, SQL Developer, UNIX System Sun Solaris Linux scripting skills to include Korn and Bash

Window server: 2006, 2008, XP/7/8

Virtualization: Oracle Virtual Box, VMware

Designing/ Analysis: Oracle Designer 2000, Oracle Developer 2000, Oracle Forms 4.5, Oracle Reports 3.0, ERWIN 4.14, Microsoft Office, Excel and Visio, Control Version and Toad.

EDUCATION:

Associates in IT, Northern Virginia Community College, Annandale, VA

Bachelor in Information Technology –George Mason University, Fairfax, VA

CERTIFICATION:

Oracle Administration Certified Associate (OCA): Oracle University

Oracle Database: SQL Fundamental I: Oracle University

Business Analysis (BA)

REFERENCES:

As requested;

Contact this candidate