Best Jesuorobo

**** ***** **** 202-***-****

Lanham, MD 20706 acthtx@r.postjobfree.com

Objective

To obtain an Oracle DBA position with an organization where I can utilize my skills to contribute to the company’s operations

Professional Summary

8 years’ overall IT experience and 7 years experience as Oracle DBA

self-motivated, responsible and reliable team player with strong technical skills

Experience in designing and implementing backup and recovery strategies

Experience with Oracle databases (9i,10g,11g,12c) as well as exposure to MySQL (5.5) and MS SQL Server 2008/20012

Experience with administering Oracle RAC

Experience with configuring and administering Automatic Storage Management (ASM) and GRID Control

Experience in performance tuning using EXPLAIN PLAN, AWR and ADDM

Lead several efforts in database migration, upgrade and patching

Experience as on-call 24x7 production DBA support, application/development DBA

Proficient in writing shell scripts

Designed and implemented various database security measures

Proficient in writing stored procedures and creating functions using PL/SQL

Experience with configuration and administration of WebLogic installations

Good understanding and knowledge of Data Guard and GoldenGate concepts

Knowledge of data modelling design and concept

Knowledge of Amazon Web Services (AWS)

Professional Certifications

OCA Oracle 11g Database Administrator Certified Associate

OCP Oracle 11g Database Administrator Certified Professional

OCE Oracle 11g Database Performance Turning Expert

OCE Oracle 11g Database Expert RAC Administrator

OCS Oracle 11g Database Security Certified Implementation Specialist

Professional Experience

Oracle/MySQL DBA Stinger Ghaffarian Technologies, NASA Langley Hampton, VA Jun 2015 – Present

Perform activities related to day-to-day administration and maintenance of the database systems

Used Secure SCP & FTP extensively for the files transfers from one server to the other

Install, configure and maintain MySQL environments and customize them as per application needs

Modifying the database structure, as necessary based on information provided by the application developers

Extensive database, schemas and table level refresh using Datapump (expdp/impdp) and MySQL dump

Knowledge of managing MySQL on Windows, Linux & UNIX

Upgraded various Oracle 11g databases from 11.2.0.3 to 11.2.0.4 using patch and DBUA

Monitor daily backups, export and cron jobs on various database platforms

Backup and recovery of MySQL as well as Oracle databases

Monitored MySQL Databases (5.6.16)

Design roles and groups using AWS identity and access management (IAM)

Use Amazon RD and Mysql to perform basic database administration.

Design EC2 instance architecture to meet high availability application architecture.

Experience with CloudTrail, CloudFront, and Glacier.

Install Amazon RDS with cross Multi-availability zone enabled to ensure high availability.

Configure, manage and utilize S3 bucket and Glacier for storage and backup on AWS

Oracle/MySQL DBA Oct 2013 – May 2015

NuCore Vision, Inc. Department of Labor, Washington, DC

Configure and administer Oracle WebLogic Application Server, administration not limited to managing the Admin server, creating managed server for application deployment via admin console and WLST tool

Implement and maintain database security

Develop/recommend, implement, maintain policies and procedures for ensuing the security and integrity of the company’s databases and system

Maintain regular communication with application developers to ensure technical and functional designs meet client and business requirement

Deploy EAR/WAR files using Enterprise Manager application control and maintain custom OCJ4 applications per developer requests

Responsible for planning, installation, configuration and administration of 15 (50G to 1TB) Oracle databases with sizes ranging from 50GB to 1TB

Develop and implement standards to ensure all application designs and codes are developed with proper integrity, security and performance. Frequently perform review on the design and code to ensure adherence to site standards

Providing support for database migration from development to production. Administered and completed data uploads utilizing export/import and Data Pump to perform refresh, migrate and clone schemas, tables and databases

Deploy Oracle Critical Patch update (CPU), one-off patches and bug fixes when applicable

Generated performance reports and daily health check of the database using utilities like AWR, and ADDM to gather performance statistics

Designed, implement and tested backup & recovery procedures using RMAN

Import data into databases using different tools e.g. SQL*Loader, Data Pump

Captured the database statistics and metrics for proactive database management

Set up Oracle Enterprise Manager (OEM) 10g & Grid Control (11g) for database monitoring/performance/diagnostics

Active member of the Production 24/7 on-call support team

Identifying and resolve row migration/chaining issues

Upgraded databases from 11g to 12c

Implemented table partitioning of large tables for better performance and manageability

Develop shell and SQL scripts to automate DBA tasks

Tune poorly performing queries that are using inefficient access paths

Create and manage materialized views

Oracle Database Administrator Aug 2008 – Sept 2013

Doctors Community Hospital, Lanham, MD

Provided 24/7 Production database administration support and monitoring to ensure a proactive problem recognition and resolution of database issues

Installed and configured Oracle RDBMS on UNIX and Windows environments

Responsible for creating, managing user accounts; granting and revoking required privileges

Wrote SQL code, DML and DDL scripts to implement specified requirements, new features, maintenance and bug-fixing

Installed, configured and managed 11gR2 (2 node RAC) on ASM storage

Managed RAC databases using CRSCTL, SRVCTL and grid control

Backup and recovery related issues (loss of OCR, Voting Disk and Oracle clusterware) & also issues with corruption of individual disk data blocks, loss of OS configuration files

Upgraded various Oracle 11g databases from 11.2.0.1 to 11.2.0.3 using patch set and DBUA

Created and rebuilt indexes as necessary to improve query performance

Developed and enforced database related policies, standards, naming conventions, SOP and best practices

Modified database structures as required by developers due to business or application requirements, clone development databases for testing and training

Performed backups, restores, cloning, or refreshing databases in all environments

Ensured availability of all databases in all environments (Test, Dev and Prod)

Tracked down poorly performing quires and tuned them

Reverse-engineered databases to generate logical/physical data models

Education

Computer Information Systems Associate, Prince George’s Community College

Technical Proficiencies

Operating Systems: Linux/Unix (Solaris, AIX, RHEL 6, HP-UX), Windows Server 2003/2008

Databases: Oracle (9i/10g/11g/12c), MySQL (5.5), MS SQL Server (2008/2012)

Programing Languages: Linux Shell scripting (BASH), SQL, PL/SQL

Other: SQL PLUS, Oracle Enterprise Manager Grid (OEM), SQL Developer, TOAD, Putty, SSH, MobaXterm, WinSCP, OracleVM Manager, Oracle WebLogic, MySQL Workbench, Erwin

References available upon request

Contact this candidate