Muhammad Ghazi Email & Phone Number

A self-starting and result-driven Oracle DBA with 5+ years of hands-on experience utilizing Oracle technologies from 11g to 12c/19c. Experienced in Oracle advanced features such as Oracle High Availability, Oracle RAC, Exadata/ODA, ZDLRA, Data Guard, VPD, RMAN, Grid Control, and data replication using Golden Gate, SQL Server/ AlwaysOn High Availability, MySQL, PostgreSQL. Proven record of delivering consistent results and being a reliable team player. • 5+ years of experience in Oracle Database Administration (12c,18c and 19c). • Experience in designing, building, and supporting large clusters Oracle RAC along with installation, configuration patching and upgrades.• Expertise in Installation, configuration, and maintenance of Oracle databases on UNIX andLinux systems.• Experienced in Patching Exadata components like compute nodes, storage nodes and InfiniBand/RoCE switches & virtual machines.• Analyze the database performance and performed database performance tuning, indexes, statistics, and setup baselines, SQL profiles, SQL patches, and analyze traces for performance investigation and parameter optimizations.• 12c/18c/19c Ongoing database maintenance, performance tuning, installation, and backup/recovery of Oracle databases running on Linux, Unix, IBM-Aix.• Experience in setting up the Active Data Guard, Standby data bases, RMAN with Veritas Netbackup, Configuration, monitoring, drilling, Switchover/failover• Experience in Database Refreshes with different tools like Datapump, AppSync and Delphix.• Golden Gate support like monitoring, table replication on various environments.• Hands on experience on Oracle RAC, Oracle standalone ASM and BD instance management • Thorough understanding of SDLC and migrations through test environments to production.• Documentation and improvement of backup and recovery procedures. • Experience in Capacity planning, resource management and process documentation• Experience in managing database security through grants, roles, privileges, and profiles.• Experience in Planning and implementation of Disaster Recovery high availability solutions.• Experienced with Oracle Cloud Control 13c/19c.• Oracle Infrastructure and Operation database administrator support and Responsible to provide 24x7 database administrative activities over different database servers.• Implemented Monitoring Templates and Incident Rule notifications using OEM cloud control 12C/13c for database alerting.• Experienced loading data from flat files to Oracle database using SQL* Loader.

• 

  Database Administrator

  Blue Cross Blue Shield Association

  Jan 2017 - Present - Chicago, Il, Us

  Projects:-Insurance domain.• Plan, test, and upgrade Oracle database from 11g to 12.2 and now to 19c. Created new Oracle 12c/19c databases.• Troubleshooting and patching of RAC and Standby system.• Oracle Infrastructure and Operation database administrator support and Responsible to provide 24x7 database administrative activities over different database servers.• Support TriZetto FACETS release upgrades (Facets Change Packs) Deployment • Work with change control management team to study and implement changes as per the requirement of the company.• Experience in Database Refreshes with different tools like Datapump, AppSync and Delphix.• Installed OEM 13C, registering databases, creating OEM users, deploying agents, monitoring databases, registered Databases in OEM Administering Oracle Database 11g and 12c/19c using Enterprise Manager• Projects Support, design modifications (Table modification, schema creation, privileges, and user profiles). Automation scripting for database code deployment. • Monitor the database during sessions that represent a typical load, gather statistics, and analyze statistics for peak loads and compare with historical data on regular bases. • Resolving network problems related to Oracle by configuring the Listener, tnsnames.ora and SQLnet.ora files.• 24/7 Support for Oracle Application server and other Databases.• Adept in creating database objects like Stored Procedures, Triggers and Packages.• Experienced loading data from flat files to Oracle database using SQL* Loader.• User, security and database resources management using user profiles.• Strong Troubleshooting, Problem solving, Analytical Skills.• Excellent organizational and interpersonal skills.

• 

  University Of North Texas

  Computer Science