Muhammad Zeshan

ad185y@r.postjobfree.com

615-***-****)

SUMMARY

5+ years of Oracle DBA experience with Oracle Database Administration, Installation, Upgrade and Migration, Backup, Recovery, Performance Tuning, Database Security, Database Designing, Shell Scripting and providing 24/7 Production support in Oracle 11gR2/12c/19c on Linux/Unix/Solaris and windows environments.

Extensive experience in Oracle Database Administration including installation, migration, upgrade, RMAN backup/recovery, Database Tuning, Designing, production/dev/test support on EXADATA, OCI, AWS and no-EXADATA environment.

Upgrade RAC and non-RAC Prod and Non Production Databases from 12c to 19c

Experience with Oracle 12c/19c multi-tenant container and pluggable databases,

Refresh Pluggable Databases using Hot Clone PDB feature, RMAN Duplicate and DataPump.

Extensive Oracle Cloud experience to migrate and manage Oracle Databases on OCI environment.

Expert in using TDE Wallet, backups/upgrade/Patching on Oracle Cloud.

Expert in creating, configuring, and maintaining Dataguard physical Standby Databases on CDB and non-CDB environment using RMAN and Dataguard Broker.

Extensive use of Oracle Enterprise Manager (OEM) Grid control for Performance, Administration and Maintenance of Databases

Worked with Sunguard team to design, perform and document yearly Disaster recovery exercise.

Implemented Oracle Gateway to establish Database Link between Oracle and SQL Server

Expert in Performance Tuning by using SQL Profile/AWR/ASH/ADDM/Explain Plan/ SQL Tuning Advisor

Designed and implemented RMAN backups to Disk and Tape with recovery catalog and block change tracking for efficient backup and reliable recovery.

Perform Backup Based RMAN DUPLICATE Without Connecting To Target

Experience with building Active Dataguard for reporting and high Availability

Implemented Security policy enhancement through roles, profiles, privileges, and password policies as per business requirements.

Clone schemas, objects and databases on new server using Datapump for Solaris to Linux environments

Develop and implement preventative Database Maintenance plan for high transactional databases.

Participated in the 24/7 on-call DBA rotation schedule.

Manage Database Structure, Storage Allocation, Table partitioning, Table/Index segments, and Rollback segments, Constraints, Database Access, Roles and Privileges

Create and Manage Oracle ASM Diskgroups Add & Remove Disk for storage migration and to resize Diskgroups

Used range, hash and composite table partitioning which greatly decreased the DB_time and SQL execution time.

Performed Full & Incremental and cold backup and recovery using RMAN

Worked on application and database security (data access, passwords, network, etc.).

Applied Oracle's quarterly Critical Patch Update (CPU/ PSU application) using Opatch utility to install, test, and deploy patches to all database instances.

Education

Master’s in Computer Science, University of Missouri, Kansas- City, USA

4 years Bachelor degree in Computer Science, Institute of Southern Punjab, Pakistan

CERTIFICATIONS

OCA DBA 19c

Oracle Trainings:

Oracle Database 19c: New features for Administrator

Oracle Database 19c: Data Guard Administration Release 2

Oracle Database 19c: Performance Tuning DBA Release 2

Oracle Database 19c: Install and Upgrade Workshop

PROFESSIONAL EXPERIENCE

Company: Genesco Inc. www.genesco.com 05/2023 – TODATE

Position: Database Administrator

Location Nashville, TN

Serving as a Database Administrator to Support Oracle Production, non-Production and point of Sale systems.

Environment: 200+ Oracle Databases, 70+ Oracle Database servers, 2800 plus point-of-Sale systems,

Dataguard, GoldenGate, Oracle Cloud, AWS RDS, OEM 13c

Provided administrative support and maintenance on Oracle 19c, 12c installations, database creation, database security, database optimization and tuning.

Upgraded 60 plus non-production and Production Databases to 19c

Worked with Linux/Network/Storage Team to build Oracle Database Servers on Linux

Installed Oracle Grid infrastructure 19c on RAC and standalone Databases.

Installed Oracle Database Software and created empty Container Databases on 19c

Ran Pre-Upgrade Utility on 12c Databases (CDB/PDB and non-CDB)

Unplug PDB from Lower version and plug into higher version in upgrade mode and complete upgrade including reviewing and fixing PDB Violations errors and warnings.

Worked with Application teams to resolve post upgrade and connectivity issues.

Upgraded Oracle RAC databases including Grid Infrastructure and Databases

Upgraded Physical Standby Databases along with Primary Databases without re-instate Standby,

Installed Oracle Clients on Application servers and configured tnsnames.ora

Built an automated Scripts to upgrade 200+ Point of Sale store registers during afterhours.

Installed and Configured GoldenGate Replication from MSSQL to Oracle and Oracle to Oracle

Created EXTRACT & REPLICAT for source and Targets databases.

Create CDC Jobs, Cleanup Job and add credentials to credential store for initial setup.

Reload Tables on Targets if mismatch data or change table structure.

Reconfigure the Replication after Refresh QA environment,

Applied Patch on GoldenGate to resolve slowness during initial load on XML columns.

Migrated Oracle Databases to EXADATA using Dataguard to maximize availability.

Configured Physical Standby Database to reduce downtime during cut-over time,

Converted Physical Standby Databases to Primary during Cut-over,

Created Physical Standby Databases on Disaster Recovery site for EXADATA environment,

Worked with Application team for connectivity, functional and performance Testing.

Build Disaster Recovery Environment for Company Critical Databases,

Created Physical Standby Databases with Dataguard Broker enabled for DR databases,

Configured Active Dataguard environment for reporting purpose,

Performed yearly DR exercise by converting Physical Standby to Snapshot Standby,

Converted Sanpshot Standby back to Physical Standby database after testing,

Prepared Step by Step document including RPO and RTO information.

Resolve performance issues using SQL Tuning Advisor, AWR, ADDM & ASH report.

Create SQL Profile to attach better plan with slow query for faster execution.

Defrag tables, Gather Stats, rebuild indexes on highly fragment tables to keep database healthy,

Applied Security patches quarterly on all production and non-production database.

Scheduled weekly Maintenance Job on highly DML operations tables.

Providing Production and non-production database support as a part of daily activity,

Helping developers to accomplish their goals as DBA Advisor and resolving issue,

Refresh non-production databases using rman duplicate from backup as well as from active.

Created and scheduled Backup script for RMAN backup to Commvault.

Used section size in rman backups for databases with Bigfile to split file into sections.

Participating in 24/7 on-call rotation for production support

Performed point in-time recovery of production database because of media failure,

Recovered datafiles to fix corruption in a datafile of a tablespace,

Create Container and Pluggable Databases on 12.1 and 12.2,

Configured Refreshable Pluggable le Databases and using Hot clone PDB.

Create and support Databases on EXADATA from 11.2.0.4 to 12.2.0.1 Databases

Create, Manage ASM diskgroups, add/remove disks to ASM diskgroup

Migrated all oracle backups from TSM to Commvault

Worked with off-shore team for L1/L2 Support,

Migrated ASM diskgroups to new SAN using add disk and remove disk without downtime,

Created Database links between Oracle databases

Configured Oracle Gateway for SQL Server to create Database links from Oracle to SQL Server

Supporting SQL Server Cluster 2012/2016/2019 environment,

Refresh non-production SQL Server Databases using backup/restore.

Create/manage users on SQL Server, and rebuild indexes/gather stats for performance issue,

Created Critical production XCENTER databases on AWS Cloud for point of sale,

Created 4 non-production XCENTER databases on AWS Cloud for DEV/QA environment.

Applying POS builds on AWS databases and taking snapshots before applying new build.

Performed DR exercise on AWS Cloud environment by restoring snapshots on Westcoast cloud.

Built Dataguard to high availability and disaster recovery and Active dataguard for Reporting

Implemented Security policy enhancement through roles, profiles, privileges, and password policies as per business requirements.

Clone schemas, objects and databases on new server using exports from Solaris 12c database and imported in 19c using data pump.

Performed backup and recovery procedures using RMAN and Data Pump utility for Oracle databases.

Applied PSU and bug fix patch on 19c and 12C databases.

Implemented, tuning and maintaining Oracle database using OEM.

Developed preventative maintenance documentation and weekly activity report.

Managed Database Structure, Storage Allocation, Table partitioning, Table/Index segments, and Rollback segments, Constraints, Database Access, Roles and Privileges

Extensive use of Oracle Enterprise Manager (OEM) Grid control for Performance, Administration and Maintenance of Databases

Day to day maintenance included patching, cloning, and administration of concurrent manage process, Users, Forms, Reports and performance issues.

Used range, hash and composite table partitioning which greatly decreased the DB_time and SQL execution time.

Performed RMAN incremental/Full and cold backup and recovery using RMAN

Worked on application and database security (data access, passwords, network, etc.).

Company: Anox Technologies https://www.anoxtechnologies.com.pk 02/2018 – 07/2022

Position: Database Administrator

Location Multan, PK

Worked as a Database Administrator to handle all kinds of production issues, critical migrations, upgrades, performance issue and Changes.

Environment: 100 Oracle Databases, 20 Oracle Database servers, 2 EXADATA,

Dataguard, GoldenGate Replication OEM

Providing Production Support to assist in administration task and to resolve incidents.

Built Oracle servers including RAC and non-RAC with Oracle version from 12.2 and 19c.

Configured and maintained Physical Standby databases with DG broker and manual.

Installed and supporting ASM base servers on RAC and non RAC.

Setup and support GoldenGate Replications from Oracle to Oracle and Oracle to MS SQL server.

Configure and set up Alerts on OEM 13c and install agent for monitoring.

Help Developers and Business Analysts to design and implement Database solutions.

Support all production environment for Code deployment, Performance issue and any kind of Administration related work,

Using AWR/ADDM and ASH reports to diagnose any kind of performance issue and used SQL Profile to keep Query consistent with good plan,

Resolved large number of performance issues, fixed stale stats, rebuilds indexes, re-org tables and implement SQL Profile.

Also providing support for Q/A, DEV and test environment including refresh from prod data, move selected objects using Data pump or rman if full refresh.

Closely working with SAs, Storage and Network Admin to design new system, diagnose existing system issues and any Infra changes and impacts,

Worked with Clients and Vendors to implement new products and deploy our solutions for clients,

Participating in 24/7 on-call support for North America and off-shore teams

Provide limited support for MS SQL Serve 2012 and 2016 and some 2019

Troubleshoot any kind of issue related to Oracle Databases,

Supporting MS SQL servers as a secondary DBA and on-call incidents,

Migrated 10+ Databases from Linux Servers to EXADATA and resolve post migration issues.

Migrated Databases using Physical Standby to reduce downtime.

Upgraded 10+ 12c Databases to 19c including RAC and non-RAC

Configured RMAN backups to on Commvault for new production environments and performed restore for corrupt datafiles and recovered using RMAN

Used RMAN Targetless Duplicate to refresh non-prod.

TECHNICAL SKILLS

Database Technologies: Oracle Database 19c, 12c, 11g, SQL Server, MySQL, Real Application Cluster, Data guard (Physical Standby), GoldenGate, RMAN Recovery catalog, Oracle Apex, LDAP

Programming Languages: SQL, PL/SQL, Shell Scripting, C, C++, Java

Tools: Oracle Enterprise Manager Grid Control, Recovery Manager (RMAN), TOAD, SQL Developer, SQL* Plus, SQL* Loader, Microsoft Enterprise Manager

OS/Servers: Oracle/RedHat LINUX, AIX, Solaris, Windows

Contact this candidate