Oracle Database administrator
Resume:
Badr Laasiri Infrastructure Engineer * (Oracle DBA)
adch21@r.postjobfree.com
Plainfield, IL
SUMMARY:
Oracle DBA with 5 years of experience in Application and Database Design, Development, Administration and Implementation on versions 18c/12c/11g/10g on different UNIX/Linux Platforms.
Extensively worked on Oracle DBA tasks involving design, development/production support, installations, configurations, backup/restore & recovery, database monitoring/performance tuning, assisting in logical/physical design, and providing support to developers.
Upgraded Oracle version 11.2.0.4 to 12.1.0.2 and 12.1.0.2 to 18.0
Experience in RAC and Adding instance to the existing multiple node cluster.
Experience in Database Administration activities such as Upgrades, Migration, Patches, Cloning, Backups and Recovery Manager (RMAN), and documentation
Experience in using 11g features Flash-Back Recovery, Data Pump, OEM
Worked as primary support for database related issues with clients.
Maintained RAC configuration, relocated services, and add/delete/modify configurations.
Experience in data transfer utilities like SQL *loader, Data pump, import/export.
Physical and logical data guard skills.
Installing oracle database and client software, creating, upgrading, patching databases in UNIX environments, maintaining standby databases and clone/refresh databases.
Experience with utilizing Oracle Enterprise Manager.
Experience in handling recovery issues using Oracle Flashback Technology.
Experienced using SRVCTL utility for managing multiple instances and nodes.
Good experience in SQL, Parallelism, Partitioning, OLAP, logical/physical backups.
Good experience with ASM environment such as Installation, taking backups, migration from NON-ASM to ASM environment.
Comfortable with both command-line (Silent installation) and GUI interface.
Support and administer critical production databases of various sizes from 100GB to 20TB.
Worked with many 11gR2/12c/18c new features including SCAN listener, Invisible indexes, and Active dataguard.
Excellent functional knowledge of oracle architecture
Dealing with database security and auditing.
Experience on Oracle Support processes; opening Service Requests
3 years of 24*7 production support during on call rotation.
Created and managed role-based security to restrict or permit users according to their database usage
Experience using of crontab to schedule jobs
TECHNICAL SKILLS:
RDBMS
Oracle 18c/12c/11g/10g
OS
OEL 5/OEL 6/RHEL5 and RHEL6, Windows 2003/XP/7/10 UNIX/Linux
Technologies
RAC, Data Guard, OEM, GoldenGate, ASM, RMAN, LDAP/OVD, Exadata X3/X4
Software/Tools
Sql*plus, DataPump, 12c OEM, srvctl/crsctl, TOAD, SQL Developer, SecureCRT/Putty, DBCA, RAC Clusterware,, shell scripting, OPatch utility, SQL Tuning Advisor
Professional Experience:
Lux Chateau – Lombard, IL
Infrastructure Engineer 1 ( Database Engineer)
Jan 2015 – Present
Responsibilities:
Daily support of Oracle 10g/11g/12c/18c RAC/ASM/Data Guard environment, Data Warehouse
Installed Oracle 11g/12c/18c Database instances onRAC Clusters and configuring DR for all instances in PROD/QA/DEV/ALTDEV/SBX
Upgraded Databases from 11G to 12C and 12c to 18c
Day to day monitoring experience of RDBMS and RAC
Migrating Databases using RMAN/DATAPUMP
Provide and implement performance and tuning recommendations of all components in the Database servers
Provide business as usual data structure manipulation (add, remove, modify storage) in the Database servers
Provide development and production support, including on call requirements.
Excellent communication skills and the ability to work independently or in a team environment.
Established certain daily task policies with Offshore Team members.
Diagnose and troubleshoot performance bottlenecks in Database environments using OEM.
Regular usage of AWR report as reference point for tuning measures.
Use TOP and other OS commands to trouble shoot performance related bottlenecks.
Configured Data Guard to provide high availability by implementing 11g/12c/18c physical Standby database.
Recover block corruptions using RMAN in RAC environments
Participate in code and design reviews to ensure quality to product standards.
Perform tablespace point in time recovery in production environment
Use Transportable Tablespace technology in multi TB environments.
24x7 Production support and monitoring to ensure a proactive problem recognition and resolution for multi- terabyte database issues.
Setup and implement multiple refreshes/clones from production/DR to support environments using automation script.
Regular usage of AWR report as reference point for tuning measures.
Work closely with security team to deliver the necessary database services to clients with proper roles and privileges.
Ability to work in a stressful environment while handling demanding internal and external clients.
Monitor RMAN backups and space growth in production environments.
Fulfill developers request to refresh schema’s/tables on regular basis using EXPDP/IMPDP.
Experience using NID utility to change DB name and/or DBID
Used SRVCTL/CRSCTL utility to manage multiple instances and nodes in RAC environment.
Configure database services to organize resource utilization.
Migration of data from different platforms using Data Pump or RMAN duplicate with minimal to no downtime.
Strong exposure in installing/configuring/maintaining RAC and Dataguard physical standby environments.
Perform monthly RMAN test restore/recovery scenarios.
Add/delete node in RAC environment, configuring RAC services
Restored & recovered production database via hot backup using RMAN.
Managed and troubleshoot when needed databases more than 20 TB in size.
Used TOAD for various database Administration tasks.
Reallocation of tablespaces to accommodate growth in data volume.
Troubleshoot Bad SQLs, tune SQL and indexes to enhance response time using SQL tuning advisor.
Implementation of standby database using Data Guard.
Set up multiple KT sessions with off-shore DBA for onboarding.
Amita Health Mercy Medical Center – Aurora, IL
Pharmacy Technician
Jan 2013 – Dec 2015
Maintained appropriate inventory levels of supply as well as performed monthly inspections.
Assisted on the improvement of existing procedures and in the training of pharmacy students in all aspects of the daily operation of the pharmacy.
Operated pharmacy equipment including compounding and Pyxis 2000.
Supported pharmacy daily operations by assisting in the preparation, distribution and the record keeping functions in the delivery of pharmaceutical supplies to patients.
Regularly inspected refrigerators in nursing units for recyclable IV's and medications, credited and documented expired IV's in the waste log.
Generated medication labels and necessary reports for refilling medication carts, restocking Pyxis MedStation units and other medications below par level.
Resolved medication discrepancies using proper documentation in a timely manner.
Prepared chemotherapeutic agents, compound nutritional solutions, TPN, and large volumes of various intravenous medications.
Maintained impatient medical profiles and assessed patient charts for preparing proper medication.
Communicated with various members of the healthcare team to ensure patient safety and confidentiality.
Assisted nurses with questions and medication issues.
Education:
Pursuing Bachelors in Computer Science
DeVry University
Professional Development:
Goldengate workshop
Exadata workshop
Skills
Pentalingual
(Moroccan Arabic, Regular Arabic, Spanish, French, English)
Easily adapting to rapid change (Fast learner)
Well organized along with interpersonal skills
Contact this candidate