概要


  • 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
Apr 2022 - 代表 | Lahore, Pakistan

公司标识
Supervisor
Style Textile
Sep 2019 - Mar 2022 | Lahore, Pakistan

学历

The University of lahore
学士, 理工学士, Bachelors in Science‎
Electric Power and Control System
CGPA 2.6/4
2019

技能

熟练 24x7
熟练 CV Screening Skills
熟练 Data Pump
熟练 Database Admin
熟练 Database Management
熟练 DBCA
熟练 Microsoft SQL Server
中级 MS SQL Server
中级 Oracle Application Express
熟练 SQL Server Management Studio
中级 Weblogic Administration

语言

熟练 旁遮普语
熟练 乌尔都语
中级 英语