Badr L.

Oracle Database Administrator @Advantasure

Naperville, IL, US
MOBILE NUMBERS
+91 *********19

Signup · Get unlimited contacts

WORK HISTORY

Oct 2020 — Present

Oracle Database Administrator @Advantasure

View department →

Installation, Configuration and maintenance of Oracle 12c & 19c database on UNIX/LUNIX Extensively implemented, configured, and monitored Active – active and uni-directional OGG replication. Worked solo on 30 Exadata machines Worked on Exadata V1/V2/X2/X3/X4/X5/X6/X8 Implemented and Migrated Databases to Exadata V2/X2/X3/X4/X5/X6/X8 Machines Installed Exadata Storage Software 112/12.1/19.1 on X2/X4/X8full rack Upgrade from Exadata Quarter Rack to Exadata full rack Migrated several database from Non-Exadata to Exadata X8-2 Migrated database from Exadata V2 to Exadata X8 full rack Applied Exadata Storage patches since from V2 to X8 boxes Applied Exadata Bundle patches to Exadata machines Experience with Redis data structures such as strings, hashes, lists, sets, and sorted sets Implemented Flash cache compression to double the flash cache capacity on Exadata X6 and X8 Implemented master node replication between legacy and cloud regions Installed and configured Oracle GoldenGate one-way replication on Exadata Database machines. 24 X 7 Production database administration, support and monitoring to ensure Proactive problem recognition and resolution of database issues. Expertise in handling and Oracle Enterprise Manager on daily basis observing the performance of the production database using OEM. Configured and installed standalone DR servers on ASM (RAC One Node). Applied patches to Oracle Databases using Opatch utility and upgraded databases manually. Implemented Up-gradation of databases from 12.2.0.x to 19.0.0. Created databases in RAC environment using DBCA and involved in moving databases from NONASM to ASM environment. Installed Golden Gate for replication of database on 12cR2 RAC environments and 19C V Core environments Implemented Disaster Recovery (DR) and HA using RAC and Data Guard.

EDUCATION

2019 — 2021

College of DuPage

Associates in general education

2022 — 2025

DeVry University

Information technology, Data Modeling/Warehousing and Database Administration

ABOUT BADR L.

Over 15 years of experience as an Oracle Database Administrator having hands on experience in database administration and performed different tasks like installation, configuration, upgrades, patches, performance tuning, backup and recovery, production support, cloning, space management, database security. Experience in Installation, Configuration and Monitoring of Oracle Server on UNIX, Linux, AIX and Windows Environments. Experience in Installation of Oracle Real Application Cluster (RAC) with ASM and manage RAC instances using CRSCTL and SRVCTL Utility. Migrating databases to Oracle Exadata Database Machine for different clients Installing, configuring and maintaining Enterprise Manager Cloud Control to monitor and manage Exadata and regular databases. Configuring and implementing Oracle ASM on UNIX, Linux, and Windows platforms. Configure high availability systems like Data Guard and RAC environments. Installation, Configuration and Maintenance of Logical/Physical standby databases in Dataguard. Experience in Implementing BACKUP and RECOVERY strategies using RMAN. Installation and configuration of Recovery Catalog for multiple Databases. Experience in taking logical backup of the database using DATAPUMP (Expdp/Impdp). Experience in Oracle Patching for 11g, 12c and 19c. Experience migrating and upgrading systems from 12c to 19c both on legacy systems and AWS. Migrated 12c environment legacy systems to 19c conversions via RMAN. Experience in SQL tuning using Explain Plans, Hints and developing ad-hoc queries. Experience in Performance Tuning for better performance. Installation/Configuration Oracle GoldenGate for replications. Configured multiple database instances using a single ASM instance. Implemented RMAN backups. Having Experience in MS SQL Server database Administration. Generate and interpret Automatic Workload Repository (AWR), Active Session History (ASH) and Automatic Database Diagnostic Monitor (ADDM) reports. Experience in performing database related activities using Oracle Enterprise Manager Grid (OEM Grid). Technical Skills: Databases : Oracle 11g, 12cR1, 12cR2, 19c, SQL Server 2005 and 2008 Oracle Products : Oracle 12c (Grid Control), OEM (Oracle Enterprise Manager), RMAN,OEM 12C, SQL*Loader, Import and Export (EXPdp/IMPdp), ASM, TKPROF, SRVCTL, SQL* Loader And SQL * Net. Languages : SQL, PL/SQL, UNIX Shell Scripting.

This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.