Manager Oracle

SHEBAZ MALEK

Visa Status: Valid US B* / B* Visa till 2025

Nadiad, India

Mobile: +91-762*******, +91-799******* E-Mail: mailto:*************@*****.*** *************@*****.***

LinkedIn: https://www.linkedin.com/in/shebaz-malek/ Skype Id: ************@*****.***

SUMMARY

Competent professional with over five years of experience in planning, installation, backup and recovery, cloning, refreshing databases in 10g/11g/12c and 19c DBA

Hands-on experience in (Unix/Linux) in database upgrading, creating, standby and performance tuning as well as backup & recovery

Proven track record in automating Database and applications monitoring, cold and hot manual or RMAN backups using Shell Scripting designed to specific environment, cloning using shell scripts, working on databases and upgrading database

Skilled in developing, designing and maintaining highly available and scalable databases in Oracle

Expertise in administering the database security, creating users, granting roles, privileges to users, extending the database storage capacity and optimizing the performances

Experienced in troubleshooting, root cause analysis, resolving complex technical problems, utilizing advance tools and resolution procedures, Performance Tuning, Troubleshooting and generating reports

Proficiency in creating restore point and performing Flashback database as per testing environment also removing active logs from FRA for any warning alerts after taking FRA Backup

Extensive experience in supporting Unix team to start / stop clusters during OS level activity also performing start / stop activity on MongoDB, Couchbase, MySQL, and performing MySQL patching on yearly basis

Worked on designing backup strategies as incremental backup to enhance backup time and space utilization on disk and TAPE also restoring active data guard and resync them using incremental backup from PROD

Gained basic knowledge of oracle EBS and managing concurrent managers, AD utilities

SKILL SET

Database Administration

Recovery & Cloning of Databases

Client Support Management

Developing & Designing Database

Database Housekeeping

DBA Call Support

Oracle Database

Database Migration

Hot/Cold Backup

Database Maintenance

Resource Monitoring

AWR Report Generation

Data Designing

Database Installation

Troubleshooting

Team Management

Space Management

SQL Tracing

EDUCATION

Master of Science in Advance Engineering & Management from Leeds Beckett University, United Kingdom (June 2015)

EXPERIENCE

TSYS Card Tech Services India LLP (Global Payment) Jan 2020 – Present

Distributed Database Administrator

Engineering and administrating Oracle standalone and RAC clustered (11g, 12c,19c) database environments

Researching and analyzing emerging Oracle database technologies, techniques, and protocols and making recommendations accordingly

Supporting and documenting the implementation of approved changes to system configurations, software, and infrastructure within the approved testing schedule

Participating in technical meetings to evaluate hardware vendors, recommending for purchase hardware from database perspective, working with system administrator to setup file system layout for database

Providing Oracle DBA support for multiple large databases in production, development and test environments for various types of databases within RAC - OLTP and OLAP

Installing OEM agent and maintaining OEM database and application for proactive alert mechanism

Involved in installation of Oracle software, creation of database on UNIX and AIX boxes and applying quarterly patches to all instances to the latest patch level of all oracle i.e. 19c grid,11g,12c,19c RDBMS

Effectively maintaining dual oracle homes on each server to degrade downtime while patching activity, patching oracle database for bugs, applying patches and quarterly security patches.

Analyzing patches before applying to determine the impact of the patch to production also applying, testing and documenting DB Patches like Interim and Patches

Checking application/database on regular basis, setting up job to collect statistics and manually by using COE_SIEBEL_STATS given by Oracle, verifying all database tables and cleaning up logs, taking database snapshot for the purpose of DB performance analysis, writing script to check oracle errors on alert file and sent a message to DBA group when error occurred

Upgrading of database and grid from one release to next release using DBUA and manually i.e upgrading grid from 12.1 to 19c and troubleshooting to grid infrastructure issues with help of Oracle SR.

Infosys Limited May 2018 – Jan 2020

Technology Support Specialist

Worked closely with developers to extend support on all development activities and coordinated with onsite engineer, client/vendor for day-to-day activity to maintain system integrity

Monitored growth of the database and performed health check on daily basis for various production and non-production (DB) environments

Accountable for database backups, design, development, testing, and performance tuning also providing direction to team members supporting manager with resource management

Using Oracle tools Explain Plan, TKPROF, AWR, ASH report and some scripts identified, resolved, or provide recommendations to performance problems ranging from database performance to I/O hardware performance

Restored Oracle mission critical production database to current state without data lost, in case of data deleted by accident, resized / added data file to tablespace, table reorg and index rebuild

Maintained monthly, quarterly and daily partition of huge number of table (table size 3.6TB) as well as enable supplementary login for table and database level

Configured SBT_TAPE backup and archival policy, taking backup of OCR and Voting disk files also resolved any incidents related to backup

Configured CATALOGUE for faster recover and troubleshooting resync issue on standalone database and performed media recovery and block recovery

OM Consultance July 2015 – May 2018

Oracle Database Administrator

Monitored space usage & growth of data to ensure exact capacity planning required for maintaining database

Worked with the system DBAs to implement changes and performance improvements

Implemented Oracle database refresh/cloning with the hot backup, backup piece cloning using RMAN or full export, used Export/Import to do table level and full database defragmentation

Developed or modified some Oracle backup and recovery scripts by using Oracle RMAN Implement Oracle backup and disaster recovery

Set up and configured Oracle11g Data Guard for DR purpose with maximum availability

Performed regular DBA activities such as database installation and creation, users management, rollback segments and tablespaces management, security, backup and recovery

Worked on Real Application Cluster 11g and converted single instance to RAC on ASM Storage, also supported, monitored and troubleshoot RAC databases

Creating/ adding disk in ASM disk group as per business requirements

TRAINING & CERTIFICATES

Oracle Database 11g Administrator Certified Professional certification strongly desired

1z0-931: Oracle Autonomous Database Cloud Specialist 2019

1z0-997: Oracle Cloud Infrastructure Architect Professional 2019

1z0-1085-20: Oracle Cloud Infrastructure Foundation Associate 2020

Contact this candidate