Sql Server Oracle

OLADIMEJI A. OLAYIWOLA

Email: ****.******@*****.*** Cellphone: 240-***-****

SUMMARY:

Database and Linux Administrator experience on Microsoft SQL Server, Oracle Software and Linux Red Hat on Development, Pre-prod, Production environment. Seeking a challenging position, in a heterogeneous environment supporting multiple RDBMS databases on Linux and Window platforms. An accomplished, result-focused IT professional with government contract experience such as VA,SSA, works well with team as well as independently, assumes increasing levels of responsibility and interfaces with all levels of technology and able to work well under pressure and meet timeline and open to learn and developed new skills on any other databases tools and new technology.

Skills:

Experience with Government contract such as SSA, and VA IAM contract. Focusing on the database tasks by documenting SOP, explaining database issues to the client and how to improve it.

Extensive knowledge of 10g,11g,12c relational database logical/physical architecture of single instance, Real Cluster Application (RAC) and Standby Database (Data Guard) on Linux OS. Provide 24x7 on-call support, Identify the issues and solve emergency database issues.

Support and maintenance of MSSQL, Responsible for SQL Server database designed, installation and setup in standalone, clustered, in physical server and VMware technologies environment, data access permissions and privileges, maintenance setup, storage allocations, Mirroring, performance tuning, Tables, Triggers, Stored Procedures, backup and recovery setup in standalone and clustered environment.

Provided support for implementation, troubleshooting and maintenance of IT systems in virtualized environments, including large commercial Infrastructure-as-a-Service (IaaS).

Administered and worked on 10g, 11g and 12c and Grid Control and posses some networking experience on LAN and WLAN and DHCP server.

Experience in using various SQL Server Tools like Enterprise Manager, Management Studio, Query Analyzer, Profiler, SQL Server Agent, DTS, SSRS, SSAS and SSIS.

Experience in systems patching Linux OS, kernel tuning and resource management for Oracle databases alongside DBA's in team.

I am self starter, self motivated, quick learner, excellent interpersonal communication skills, strong problem solving skills and ability to work in a team or independently

A self-motivated, team player, database professional with proven experience in the SQL Server environments.

Design and Implement High Availability(HA) Disaster Recovery (DR) strategies, using SQL Replication, Log Shipping, and Database Mirroring

Experience with Oracle Golden gate and trouble shoot any issue that may arise

Experience in Hadoop Cluster system

Installation of Apache Hadoop cluster system and troubleshooting any issue that may arise

Experience in Microsoft Azure Cloud especially on SQL Server and Oracle database.

Certifications:

SQL Expert Fundamental Oracle database

Oracle Database Administrator Certified Associate (OCA)

Oracle Database Administrator Certified Professional (OCP)

Oracle RAC Grid Infrastructure Administration (OCE)

Oracle Certified Expert (OCE) Performance Tuning

WORK HISTORY

Oracle & SQL Server Database Administrator

Technatomy Corporation

Database Administrator

Fairfax, VA

January 2013-Present

Primary Responsibilities Includes:

Implement the Installation of 10g,11g,12c Oracle database, upgrade, migration, Storage Allocation, Backup & Recovery, Replication, Performance Tuning, Configuration/Installation of Oracle databases using oracle technologies such as Data Guard, RAC, ASM, and Advanced Security on the database.

Experience in implementation and configuration of Oracle, 10g, 11g and 11gR2 and 12c Standby Databases.

Implement the installation of the Oracle Data guard database and administer it on 10g,11g, 12c both on RAC, single instance and standalone.

Managing Database Structures, Storage Allocation, Table/Index segments, Rollback segments, constraints, Database Access, Roles and Privileges and Database Auditing on all 10g,11g, and 12c .

Experience in using various SQL Server Tools like Enterprise Manager, Management Studio, Query Analyzer, Profiler, SQL Server Agent, DTS, SSRS, SSAS and SSIS.

Experience in SQL Server 2005, 2008,2012,2016 Installation, Configuration of Stand-alone with multiple instance in Clustered and Non-Clustered environment.

Experience in high availability SQL Server Solutions that includes Mirroring and Clustering

Experience in creating Log Shipping and Replication (snapshot, transactional (P2P) and merge) for various customers.

Administration of ASM DISK management (creating disk group, adding/removing disks to disk-groups) on 10g,11g, and 12c

Experience to work on OS level clustering mechanism for Oracle database with ASM on 10g,11,and 12c

Design Database Mirroring, Replication, Publisher and Distributor

Creating and dropping of users, granting and revoking permissions to users/roles as and when required on oracle 10g,11g,12c .

Responsible for applying Oracle RDBMS patches using OPATCH and maintaining Oracle Inventory both on single and Real Cluster Application( RAC) on 11g and 12c

Administer Oracle standby database on single instance, RAC, and standalone on 11g and 12c

Implantation of AZURE SQL Server Database Migration 2012 to 2016

Experience with Golden gate and trouble shoot any issue that arise during the replication of data on 11g

Responsible for applying current patches on the SQL Servers

Experience in Oracle Enterprise Manager (OEM), Grid and Hands on Experience using Oracle utilities Data pump, SQL Loader, RMAN, Original export/import

Install and Administering Oracle ASM, RAC & GRID INFRASTRUCTURE 10g,11g,and 12c

Managed database maintenance (backup/restore), plan data growth and purge process

Daily database administration tasks including backup and restore with RMAN, import/export

Experience in applying critical patches (CPU/PSU, Security Patches) quarterly on the databases .

Generated AWR/ADDM/ASH reports, Statspack, SQL Tuning Advisors, SQL Plan Management, Database Replay, SQL Tuning sets etc., as part of performance tuning and critical issue analysis

Install and configure SQL 2014 and 2016 Always On

Configure SQL Mail for alerts and job failures on SQL server 2012,2014,2016

Design and Implement high availability OLTP strategies, under RAID-10 for better performances

Design SQL Log Shipping, Mirroring, clustering and Replication

Regularly Monitoring Alert log Files and trace files on Day to Day Basis and trouble shoot any issues that may arise on Oracle 10,11g, and 12c

Experience in scripting for automating maintenance tasks and to ease administration on 11g and 12c

Creating and dropping of users, granting and revoking permissions to users/roles as and when required on oracle 10g,11g, and 12c

Experience in Backup, Recovery and Restore of databases using RMAN and Exp/Imp utilities on oracle 11g and 12c

User administration, file System management, device management, volume management, spool administration. Backup the Databases using RMAN

Creating the required table spaces, users, and roles for the application on oracle 11g and 12c

Design and Implement High Availability(HA) Disaster Recovery (DR) strategies, using SQL Replication, Log Shipping, and Database Mirroring on SQL server 2012,2016

Oracle Database & SQL Server/ Linux Administrator

Soft Tech Corporation

Virginia VA

January 2011 – December 2012

(Contract Position)

Primary Responsibilities Includes:

Handled operational responsibilities like database refreshes, backup and recovery, security, documenting standards and procedures, data migration, data clean-up, data archiving on oracle 10g,11g and 12c etc

Responsible for Replication and Mirroring related issues on SQL server 2012,2014 and 2016

Export and Import of Database using pump utility on oracle 11g and 12c

Install and configuring MSSQL 2005,2012.2016 Server Clustering for Active and Passive

Install and configuring MSSQL 2008 Server stand alone

Experience with Virtualization technologies such as installing, configuring, and administering VMware ESX/ESX 6 5.5, Red Hat environment

Experienced with Linux family (Red Hat Enterprise Server, Cent OS).

Creating templates for Linux VM's used for deploying for the environments.

Performed regular installation of patches using YUM, and RPM utilities and remotely copying files using vsftpd, scp,and winscp

Hands-on experience in diagnosing, troubleshooting various networking, hardware & Linux/ UNIX server issues, performing preventive maintenance

Set up and administer user and groups accounts with restricted permissions

Installed and configured Logical Volume Manager - LVM

Experience in systems patching Linux OS, kernel tuning and resource management for Oracle databases alongside DBA's in team

Experienced with TCP/IP networking tool using them in network configuration, maintenance and troubleshooting

Experience installing and configuring UNIX server on the Solaris and centos platforms and introducing the server to the network

Analyzed and created new configuration for packaged software to meet system requirements.

Expertise in Installation, Configuration, Trouble-Shooting and Maintenance of Red Hat Enterprise Linux, CentOS in physical and virtual Linux servers

User administration, file System management, device management, volume management, spool administration. Backup the Databases using RMAN on oracle 11g and 12c

Experience in creating Log Shipping and Replication (snapshot, transactional (P2P) and merge) for various customers

Experience in applying critical patches (CPU/PSU, Security Patches) on oracle 11g and 12c

Experience in Backup, Recovery and Restore of databases using RMAN and Exp/Imp utilities on oracle 10g,11g and 12c

Responsible for Replication related issues, Data integrity checks, SQL Profilers etc

Review alert logs and dump files to check for any problems related to the database on oracle 11g and 12c

Oracle & SQL Server Database Administrator

Chimes Corporation Inc.

Database Administrator

Baltimore MD

April 2008–December 2010

Primary Responsibilities Includes:

Hands on experience in configuration, administration, maintenance & recovery of single-instance & Real Application Clusters (RAC) Databases

Performed regular system backups and recovery procedures, closely following SOPs to ensure system security.

Expertise in ASM administration and the creation of databases, table spaces, tables, indexes and other database objects

Hands on experience in configuration, administration, maintenance & recovery of single-instance & Real Application Clusters (RAC) Databases

Configure the SQL Transactional and Snapshot Replication.

Install and configuring MSSQL 2005 Server stand alone in Physical Server and VMWARE environment

Install and configuring MSSQL 2008 and 2008 R2 Server stand alone in Physical Server and VMWARE environment

Install and configuring MSSQL 2012 Server Clustering in Physical Server and VMWARE environment

Implement database mirroring in SQL 2005 and 2008

Work closely with the developers, programmers, business analyst to provide database standards and Deploys numerous of SSIS packages in Integration Services and scheduled the jobs.

Install and building Virtual Machines

Database architecture, high availability and disaster recovery.

Install and Administer Oracle Data Guard on oracle 11g and 12c

Grant Roles, files and user privileges on the database to the end users both on 11g and 12c

Design and Implement High Availability(HA) Disaster Recovery (DR) strategies, using SQL Replication, Log Shipping, and Database Mirroring

Expertise in ASM administration and the creation of databases, table spaces, tables, indexes and other database objects on oracle 11g and 12c

Experience in Disaster recovery strategies and setup. MSSQL setup in SAN Infrastructure

Skills Summary:

Databases: Microsoft SQL Server 2000,2005,2012,2016, 2017,Oracle 12cR2, Oracle 11gR2, 11gR2 RAC, Oracle10g,

DBA Tools: TOAD, OEM, Grid Control, SQL*Loader, RMAN, Shell Script, AWR, ASH, Toad, Shareplex and Cron jobs

RDBMS Tech: Oracle 10g, 11g,12c Standby Database.

Tools and Utilities: Export/Import, RMAN, Data Pump, WinScp, ASM, PUTTY,VNC

Operating Systems: UNIX, LINUX, SOLARIS, Windows Server

Networking :

Wireless/Virtual Local Area Network (WLAN, VLAN, LAN), Wide Area Network (WAN) TCP/IP, Virtual Private Network (VPN), Storage Area Network (SAN), Network Attached Storage (NAS)

EDUCATION:

Bachelor of Science in Criminal Justice

Coppin State University

Baltimore Maryland. May 2009

Masters of Science in Health System Management

University Of Baltimore

Baltimore Maryland. May 2012

Boltos Solutions Institute- Affordable Oracle Hands-On Training

Linux Academy Training

TrinityTech Consulting Institution

Kitsonlinetrainings

References:

Available on Request

Contact this candidate