1. ہوم
  2. عوامی پروفائل

خلاصہ


  • Installation of oracle software and DB creation on Linux/windows.

  • Knowledge and basic experience on implementation and management of RAC.

  • Applying Patches in data guard (Physical Standby) environment.

  • Configuring and managing physical standby databases.

  • Switchover and Failover of Physical standby database.

  • Setup active data guard in oracle.

  • Roll Forward Physical Standby Database using RMAN incremental backup.

  • Convert a physical standby database to a snapshot standby database and vice versa.

  • Recovering a corrupted/lost data file in physical standby.

  • Resizing Redo Logs in a Data Guard Environment (Physical Standby in place).

  • Up gradation databases from version 12c to 19c

  • Applying the Patches on the oracle database.

  • Migrating the databases.

  • Recovering a Dropped Table, data files, control file using RMAN and Data Pump Options

  • Recovered corrupted blocks.

  • Enabling Flashback Database in Oracle

  • Refreshing databases for the testing/developing purpose (Database only).          

  • Preparing backup strategies. Perform logical and physical backups using export and RMAN backups, and failed backup troubleshooting.

  • Create users, profile and roles and grant appropriate privileges to users.

  • Administer space by creating table spaces, adding and resizing data files.

  • Develop shell scripts to automate database jobs and monitoring scripts.

  • Monitoring database performance using AWR, ADDM reports and SQL tuning Advisor

  • Identifying fragmented indexes and rebuilding indexes.

  • Provided 24x7 on-call technical supports.

  • Branch merging 

  • Applying daily deployments on CBS (core banking)

  • Stats gathering of stale tables of different schemas in a database

  • How to creates DB_LINKS and purpose of DB_LINKS

  • guaranteed restored point creation and its Purpose

  • How to attach an ORACLE_HOME to an existing inventory.

  • Creating database in silent mode using response File

  • Adding values automatically into database using cronjob

  • Partitions of tables & indexes

  • Copy missing archives from prod and applies into DR

  • Recover missing archives using Service Name

  • Installation of SQL Server 2019

  • Creation physical standby SQL Server

  • Backup and restoration process in SQL Server

  • Creation and implementation of transaction logs

  • Installation and management of WebLogic forms and reports 

تجربہ

کمپنی کا لوگو
Database Support Officer Primary & Standby Databases
MCB Bank Limited
اپریل ۲۰۲۲ - موجودہ | Lahore, Pakistan

کمپنی کا لوگو
Supervisor
Style Textile
ستمبر ۲۰۱۹ - مارچ ۲۰۲۲ | Lahore, Pakistan

تعلیم

The University of lahore
بیچلرز, بیچلرز ان سائنس, Bachelors in Science‎
Electric Power and Control System
CGPA 2.6/4
2019

پیشہ ورانہ مہارتیں

ماہر 24x7
ماہر CVs Screening
ماہر Data Pump
ماہر Database Admin
ماہر Database Management
ماہر DBCA
ماہر Microsoft SQL Server
متوسط MS SQL Server
متوسط Oracle Application Express
ماہر SQL Server Management Studio
متوسط Weblogic Administration

زبانیں

ماہر پنجابی
ماہر اردو
متوسط انگریزی

آپ کن کمپنیز کی پیروی کر رہے ہیں

مزید دیکھیے