Overview
Having 13+ years of hard-core IT experience (Oracle/ERP Apps DBA) including 8+ years with Telecom 24x7 IT Operations.
Was associated with Huawei Bahrain for 5 Years since Apr-2012. I was deputed in VIVA Bahrain Telecom as senior Oracle/ERP database administrator. I started this project since Due-Diligence, ITO Transition & IT Operations. I worked as Technical lead on multiple projects included (Huawei OSS project upgrade, Huawei BSS Project phase-I, BSS Application Transformation, Critical Billing databases upgrade –OBRM/CRM/AIA/OSM/ASAP/Payment/Notification from Oracle 11g to 12c, Database consolidation on 12c, Storage migration from VNX to VMAX, ERP Application upgrade from R12.1.1 to R12.2.5), VM dev/uat environments migrations, Capacity planning including software and hardware (lifecycle). (From Apr-2012 till Mar-2017)
Was associated with ITS - International Turnkey Systems (Bahrain) for 3.5 Years as Infrastructure Team Lead and deputed in Zain-Bahrain Telecom for billing system TABS administration /Oracle & ERP Database administration -DBA. I worked on multiple projects including TABS upgrade from 6.5 to 6.11 & ERP upgrade from R11 to R12.1.1. My main responsibilities included TABS billing application administration, deliveries deployment testing support with application team, rollout in production and Day-to-day DBA Operations support on 9i, 10g 11g. In addition, I worked on databases upgrade including Portal, BI and ERP R11 to ERP R12.2.1. I also worked as Infrastructure team lead (Database/Backup/System/Storage). (From Oct’2008 to Mar’2012)
Was associated with Dewan Mushtaq Group (DMG-Pakistan) for 5 Years as Manager Systems / Senior Database Administrator. DMG is one of the famous diversified industrial group which deals (Fiber, Textile, Sugar, Automotive & Cement) with 10+ physical locations in Pakistan.
I worked as senior Oracle/ERP Database Administrator (Lead).
Lead many projects included:
1- Oracle Database Administration (D2D) Operations
2- ERP DBA Operations Administration
Oracle Database Upgrades from 10g to 11g & 12c
2- ERP Upgrade R12.1.1 to R12.2.4 & R12.2.5
3- Database Consolidation on 12c
4- Purging huge Telecom mission critical databases
5- Support 24x7 Telecom Operations
6- Oracle & ERP Patching, Cloning
7- Day-2-Day Operations support
8- Worked with multiple vendors and different products
9- worked on Oracle RAC 10g, 11g, 12c
10- Active/Passive Enviroment
11- VM Enviroments
- Installations Oracle(8i, 9i,10 and 11g) Software in different UNIX/LINUX & Windows platforms.
- Installation of EBS-11i,12i and Application server 10g with BI Tools,
- Administration of Oracle BI and Discoverer.
- Implementation of Data Guard for UNIX and LINUX based environments.
- Manual Backup system Implementation.
- And automated the archive application on backup system of Oracle DB.
- Implementation of RMAN backup and disaster recovery plan.
- Implemented user managed backup & disaster recovery plan.
- Migration of UNIX Oracle9i databases to Linux Oracle 11g.
- Automated backup & restoration procedures using SHELL scripting.
- Automated backup & restoration procedures using BATCH scripting.
- Implemented Security procedures at OS & DB level.
- System administration of Globus (Temenos).
- Universe DB 9 administration.
- System/Application Administration of ERP 12i / 11i , Cloning, Upgrade and patches
- Operational support for Globus Central Core Banking System (EOD, SMS).
- Implementation of patches to test and production databases.
- Clone DB or Application and take backup on tap or hard drive
- Installation and troubleshooting of Database and Application Apply Patches to fix the bugs in application or update the recommended patches
- Implement and maintain database security (create and maintain users and roles, assign privileges)
- Perform database, application tuning and performance monitoring
- Taking backups using RMAN, incremental backups, full database backup, use scripts to take backup, enabling block change tracking, configuring the default devices, retention policy and carrying out recovery activity on the event of failure using RMAN.
- Recovery of control files, redo logs and data files.
- Planning and performing daily, weekly and monthly cold and hot backup.
- Moving data between database using utilities like export/import, sql* loader and transport table space.
- Oracle 10g new features (data pump, flashback table, transportable table space).
- Cleaning the backups, to release the space.
- Checking alerts logs for unknown errors and troubleshooting the same.
- Installing and configuring of oracle server software and related products.
- Managing physical structure of oracle database like data file, redo log file and control files.
- Creating database required for production, development and test usage.
- Monitoring alerts (session locks, space issues, CPU issues, Backup jobs, Archives etc.)
- Monitoring the Database hot points using ADDM & AWR.Oracle XML Publisher
- Creating & managing Users, Menues, Functions, and reponsibilities in Application system.
- Oracle BI Discoverer (Reporting tool)
- Using oracle discover develop Oracle Financial reports
(Account statements, Trial Balance, Employee Balances,
Project History, Facilities Report (LC, LG's, Loans) Supplier
Statements, FA detail, FA depreciation, Aging Receivable,
Aging Payable etc. )
As an Oracle DBA, I was managing 30 plus Production/Test/Development databases on Sun Sparc E250 and E450 with Sun Solaris 8.0 and on HP-Compaq Servers with Windows 2000 and 2003 servers Operating System.
My responsibilities was comprises on the following;
- Oracle 8i / 9i Databases installation, troubleshooting, managing and monitoring.
- Test, Development and Production Database creation, administration
- Made a comprehensive DRP (Disaster Recovery Plan) i.e. Replication and Data Guard
- Managing and troubleshooting the Advance Multi Mater Replication between different physical locations.
- Implemented patches to test and production databases ( 8i & 9i )
- Backup and Recovery, Database Tuning., Writing of stored functions, procedures and triggers.
- Test, Development and Quality Databases clone/refresh with production as and when requested.
- Installations, configuration and monitoring of Oracle 9i Application Server.
- Oracle Developer 6i/9i Forms & Reports installations installing patches , configuration and connectivity issues to the Database.
- Unix shell scripting
- Sun Solaris 8.0 Administration with respect to Oracle
- Cron jobs implementations
- Data loading with SQL Loader