Oracle Database Dba

Yazan Alishwait Oracle DBA

Email: *************@*****.***

Phone: 630-***-****

US Citizen

PROFESSIONAL SUMMARY

•Around 10 + years of experience as an IT profession along with extensive as on Oracle DBA in Production, Development and Test environments. Also, transforming business strategies of various organizations into efficient and integrated global business solutions.

•Worked on Oracle Materialize Views, Oracle Golden Gate, and Oracle Active Data Guard.

•Build 13c OEM Cloud Control and managed OMS and OMR.

•Configure 11g, 12c, 18c, and 19c Active Data Guard.

•Experience in installation, configuration and maintenance of Oracle 19c/12c/11g/10g RAC with ASM and single instance database.

•Supported database on Exadata X7.

•Installed, configured, and managed Red Hat Enterprise Linux (RHEL) environments

•Utilized Red Hat Satellite for system management, provisioning, and patching

•Implemented Red Hat OpenShift for container orchestration and deployment

•Build 2-node and 4-node RAC clusters from scratch.

•Build and migrated databases to AWS.

•Build new servers on Azure.

•Worked on project to migrate databases to AWS instance.

•Set up oracle instances on AWS cloud.

•Maintained databases and alerts from 13c cloud control (OEM).

•Migrated standalone databases to RAC on Exadata

•Setup unidirectional Golden Gate replication.

•Perform Oracle database administration in a variety of environments including Oracle Linux, HP-UX, IBM-AIX, Sun Solaris, and RHEL.

•Experience in system monitoring and database performance tuning using Explain Plan, SQL Trace, TKPROF, AWR and also Cluster Interconnect Tuning (RAC).

•Experience with Data Modeling

•Experience in RMAN procedure for backup and recovery and also cloned database using RMAN Duplicate.

•Experience in 12c Multitenant databases

•Experience in 12c container and pluggable databases

•Experience in Database Security including Oracle Vault, wallet and TDE.

•Managed Oracle server in high availability environments using failover, clustering, mirroring, Data Guard and cloning technologies.

•Build multimode RAC from scratch

•Migrated database from 10g to 11g by using scripts

•Experience in applied CPU and PSU patches

•Experience in database full backup (hot and cold), Incomplete Backup, Data Pump Export / Import, SQL backtrack and restore procedures.

•Experience in space management and capacity planning

•Experience in database creation with RMAN jobs and security implementations in Oracle.

•Ensure business continuity in the event of a disaster or disruption

•Minimize downtime and data loss

•Restore critical business functions and operations

•Ensure compliance with regulatory requirements

•Experienced in setting up service load balancing in RAC

•Installed 12c Grid agent on servers and configured 12c OEM Cloud Control.

•Perform data loading using SQL*Loader and DBVERIFY for corruption checking.

•Build ASM Disk Groups and migrated from non-ASM to ASM.

•Upgrade databases from 10g to 11gR2 to 12c to 18c and 19c

•Worked with networking team to get IPs and configure SCAN listener for RAC.

•Performed tasks to gather database statistics

•Worked as SQL Server Database Administrator.

•Experience with new features including Flash Recovery, ASSM, AMM, ASMM

•Good experience in database creation, partitions, set up parameters, tablespaces, indexes, user setup, roles, security, storage and hands on experience in network management.

•Experience of auditing, Oracle security, OEM, SQL Navigator and TOAD.

•Experience in Very Large Multi-Terabyte Database (VLDB)

•Worked with Performance Tuning tasks

•Worked on GoldenGate project.

•Experience in Building shell scripts to automate jobs.

•Worked with of offshore DBAs.

•Good experience in SQL, PL/SQL, stored procedures, and Shell Scripting.

•Experience in Data modelling using Data modelling tools such as Erwin and Toad.

•Prime responsibility includes first line support of PostgreSQL databases requests and tickets.

•Documentation all the technical documents related to PostgreSQL DBA activities

•Designed and implemented Azure Virtual Machines (VMs) for Windows and Linux workloads.

•Configured and managed Azure Virtual Networks (VNets), subnets, and network security groups.

•Utilized Azure Autoscale to dynamically scale VMs based on workload demand.

•Moving objects between tablespace in PostgreSQL

•Worked on SQL Server 2005 and SQL Server 2008.

•Experience with installing and maintaining Oracle Grid Control

•Documented all Oracle database installations and database operations.

•Perform 24x7 production database supports to ensure availability, efficiency & recoverability.

TECHNICAL KEYWORDS:

•RAC

•Performance Tuning

•ASH, AWR, ADDM

•Clusters

•DR Testing

•Shell scripting

•Azure

•Data Pump

•RMAN

•Database Cloning

•Refreshes

•Export-Import

•Data Guard

•ASM

•AWS Cloud

•Exadata

•Golden Gate

•Materialize Views

•SQL Server

•Table Partitioning

•Oracle 10g,11g,12c,18c,19c

•Sun Solaris

PROFESSIONAL EXPERIENCE:

Exelon, Chicago, IL

Oracle DBA

May 2019 to present

•Responsible for administration and supporting oracle 19c, 18c and 12c databases.

•Used various tools for Performance tuning.

•Build 2-node and 4-node RAC Cluster on Linux.

•Build Data Guard for RAC Cluster.

•Install the database on the AWS cloud.

•Migrated database to EC2 instances on AWS.

•Setup jobs on AWS.

•Setup monitoring on AWS.

•Setup Data Guard on AWS.

•Performed Silent installation on Exadata.

•Supported database up to Exadata X7.

•Worked with Oracle platinum services on patching Exadata.

•Proficient in using tools such as celcli and dcli in Exadata.

•Work on databases that were part of Oracle GoldenGate.

•Configure 19c Active Data Guard

•Installed, configured, and managed Red Hat Enterprise Linux (RHEL) environment

•Utilized Red Hat Satellite for system management, provisioning, and patchin

•Implemented Red Hat OpenShift for container orchestration and deployment

•Proactive database monitoring using OEM.

•Performing tuning of application with CBO, using Trace, tkprof, Explain plan, and stat Spack, AWR, ASH, and ADDM.

•Tuned low-running queries to optimize database performance.

•Database performance monitoring, Application performance monitoring, tuning database, and application with efficient database parameters.

•Worked on Performance Tuning tasks to reduce the query response time.

•Remove unnecessary histograms in highly volatile schemas.

•Familiar with Oracle GoldenGate concepts and advanced replication techniques.

•Worked in Tuning OS, Shared Pool, Buffer Cache, and Redo Log Buffer.

•Performed tasks on the setup of users’ accounts, passwords, roles, profiles, and quotas.

•Monitored data files, logical data storage, and data growth activities.

•Perform capacity planning required to create and maintain database environments.

•Designed and implemented Azure Virtual Machines (VMs) for Windows and Linux workloads.

•Configured and managed Azure Virtual Networks (VNets), subnets, and network security groups.

•Utilized Azure Autoscale to dynamically scale VMs based on workload demand.

•Database backup using RMAN for hot backup.

•Database Backup Database Restore and Database Recovery using various tools.

•Resolved gaps in Data Guard configuration.

•Replicate database using RMAN Duplicate on AWS.

•Used TDE to encrypt columns.

•Used Fine Grain Auditing to audit Uses and tables on Select and DML activities.

•Database Reorganizations for better space management.

•Written shell scripts (bash, korn) for backup and recovery

•Experience in creating development, test, stage, production, and RAC and standby databases for OLTP, DSS and Data Warehousing using customized shell scripts.

•Proficient in writing UNIX Shell scripts to automate business processes and daily backup.

•Experience in SQL, PL/SQL, Shell Scripting, Partitioning, Data modeling

•Monitored the various database activities by developing shell scripts and using various tools.

•Prime responsibility includes first line support of PostgreSQL databases requests and tickets.

•Documentation all the technical documents related to PostgreSQL DBA activities

•Moving objects between tablespace in PostgreSQL

• Ensure business continuity in the event of a disaster or disruption

•Minimize downtime and data loss

•Restore critical business functions and operations

•Ensure compliance with regulatory requirements

•export/import & OS scripts like shell & cron job schedule

•Performed database refreshes using Data Pump.

•Installed, migrated, and tested Oracle 11gdatabases in various environments.

•Worked on Active Data Guard and managed Standby with Data Broker.

•Written and modified scripts to automate cron jobs.

•Provided 24/7 on-call support.

•Used Data Pump to refresh databases.

•Used Export-Import to refresh schema objects.

• Build 4 node RAC.

•Setup Data Guard.

•Worked on Databases using ASM.

Sony, New York, NY

Sr. Oracle DBA

March 2015 –May 2019

Responsibilities:

•Build RAC Databases on Exadata

•Build Standby Databases using Oracle Data Guard.

•Installation of Oracle Database and Oracle products using silent install.

•Implementing Backup/Recovery Strategies on Exadata.

•Build 12c cloud control.

•Managed Databases on Exadata x3.

•Managed Materialized Views.

•Implementation of high availability of solutions with Oracle11g RAC and Data Guard.

•Setup unidirectional Oracle GoldenGate replication.

•Worked with Oracle on active issues using Oracle Support.

•Using Enterprise Backup utilities for backup.

•Written shell scripts (bash, korn) for backup and recovery.

•Database creation, Installation, patching and database upgrades.

•System tuning for better performance.

•Install SQL Server 2012

•Worked on SQL Server log shipping and backup/restore/recoveries.

•Applied CPU, PSU and one off patches using opatch.

•Used 12C OEM to run AWR reports, 12C MA agents registration

•Installed 12C MA Agents on Linux, AIX, and Solaris Platform.

•Creating packages and database triggers.

•Creating users and maintaining database security.

•Worked with application developers to debug PL/SQL procedures, tuning queries and

•Writing UNIX shell scripts for backup and recovery.

•Database/Schema Refresh as per client requirement.

•Managed databases on Linux and Windows

•Consolidate / migrated databases into one data center.

•Worked on Capacity planning.

•Provided 24/7 on-call support.

•Used TOAD and SQL Developer.

Environment: Windows 2012, Oracle 10g/11g/12c databases, 12c OEM, Shell Scripting.

Education: Bachelors in Computer Science Al Balqa University_ Al Huson

Contact this candidate