Syed Hammad Shah

Advisory Software Engineer at Systems Limited

Pakistan

About

Oracle Certification OCA (Oracle 10G) OCP (Oracle 10G) Specialties: Oracle Database 9i / 10G / 11G Oracle Data Guard 10G Oracle 11G Grid Control RMAN Oracle Application 10 G Oracle Developer 6i / 10G MS OFFICE VISUAL BASIC Crystal Report TOAD PL/SQL Developer Oracle Database Enterprise Manager

Experience

  • Advisory Software Engineer at Systems Limited
    Mar 2020 - Present · 6 yrs 4 mos

  • Database Architect at Careem
    Nov 2018 - Sep 2019 · 11 mos

  • Sr. DBA at Innovative Channels Pvt Ltd
    Jul 2015 - Nov 2018 · 3 yrs 5 mos

  • Database Administrator at DataCheck (Pvt) Ltd.
    Dec 2013 - Jul 2015 · 1 yr 8 mos

    Implements and enforces security for all of the Oracle Databases. Performs ongoing tuning of the database instances. Administers all database objects, including tables, clusters, indexes, views, sequences, packages and procedures. Auditing Database Operations & object for better manageability. Implements, Maintain and Monitor two Oracle Data Guard on 11g database for the high availability of the live databases. Applying patch sets with Oracle data guard. Install , configure , Create and manage table partitioning and index partitioning, Oracle Transparent Encryption, Oracle Streams for both way data transfer, Oracle Database live like UAT as well as mask UAT for Training purpose, Oracle APEX, Oracle Data Vault for Oracle Security. Oracle Audit Vault for implantation security and Audit option in Databases, ORACLE GRID 11g, Oracle Enterprise Manager and SQL Server Databases, MYSQL Databases. Install new versions of the Oracle RDBMS and its tools and any other tools that access the Oracle database. Responsible for the implementation, planning, coordination, configuration, installation and ongoing management of all oracle databases Prepare a suitable Backup & recovery, performing Database Backups & Dealing all recovery issues Oracle Database, with and without Recovery Manager (RMAN). Assists with impact analysis of any changes made to the database objects. Troubleshoots with problems regarding the databases. Installing and Working on the Oracle Database 10g and 11g in Suse Linux, SQL Server and My SQL. Maintain and Monitor Flash back recovery area and also enable the archiving of database for the developers. Perform the Disaster Recovery (DR). Providing DBA services for Critical 24 x 7 environments. Working on shell scripting for the Schedule Back up and also writing bash files / VB scripting for updating and other work

  • System and Database Administrator at Al - Wanas Universal Enterprises (Posting at Ministry of Interior)
    Jun 2012 - Aug 2013 · 1 yr 3 mos

    Creates and maintains all databases required for development, testing and production usage. Performs ongoing tuning of the database instances and Oracle Grid 11g. Administers all database objects, including tables, clusters, indexes, views, sequences, packages and procedures and implements Oracle Database Security. Responsible for the implementation, planning, coordination, configuration, installation and ongoing management of all oracle databases Auditing Database Operations & object for better manageability. Prepare a suitable Backup & recovery, performing Database Backups & Dealing all recovery issues Oracle Database, with and without Recovery Manager (RMAN). Assists with impact analysis of any changes made to the database objects. Implementation, Maintain and Monitor of Oracle 11g Grid Control on suse 10 for administration of all oracle servers and also Oracle Data Guard on 10G for the high availability of the live databases Maintain and Monitor Oracle 10g Bi-Directional Streams for replicating the data in different locations (MOI and ROP) for (National Election of Oman). Create and manage table partitioning and index partitioning and working on 10g and 11g in Suse Linux and also Window 2003 server Maintaining HP-Protector tape library for HP-Blade server databases (4 databases) which has SAN and performing backup and recovery of oracle database and file system, daily, weekly and monthly. Maintain and Monitor Flash back recovery area and also enable the archiving of database for the developers. Manage Oman National level election voter attendance/card update data synchronization from mobile units/voting station systems with the Oracle database central server. Working on shell scripting and also writing bash files / VB scripting for updating and other work. Installation and Migrating of the database from Oracle old version to Oracle new version as per the requirement of the Ministry.