Experience

• 

  Ifast pvt. ltd

  Aug 2004 - Mar 2005

  Internee

  • Development of new forms and reports for Inventory Management System using Oracle 9i as a back-end and Oracle Developer 6i as a front-end.• Completed Oracle DBA Certification.• Same time served in Govt. Degree College Pabbi (Nowshera) as a Lecturer in Computer Science from Mar 2004-Apr 2006.

• 

  Millennium software pvt. ltd

  Jun 2007 - May 2008

  Software developer

  • Designing, development, implementation of new and existing applications using Oracle Developer 6i/10g.• Creating complex stored procedures, PL/SQL libraries and triggers on database level as well as on Oracle Forms and Reports 6i/10g. DBA Premier Software Pvt. Ltd.• Deputed in Trade Development Authority of Pakistan (TDAP) as a Database Administrator.• Responsible for Troubleshooting and overall Oracle DBA level activities like Oracle installation, database creation & configuration, application maintenance, user creation and rights, performance tuning, Backup & Recovery using RMAN, import/export.• Deputed in Mitsui & Co. Ltd. in Lahore and Islamabad as a Database Administrator.• Worked in Millennium Software Pvt. Ltd. as a Software Developer from Jun 2007- May 2008. Show less

• 

  Premier software (pvt) ltd. (marine group of companies)

  Sept 2008 - Feb 2011

  Application developer cum dba

  • Designing, development, implementation of new and existing applications using Oracle Developer 6i/10g.• Creating complex stored procedures, PL/SQL libraries and triggers on database level as well as on Oracle Forms and Reports 6i/10g.• Handling DBA level activities like User rights, import/export backup and performance tuning of Oracle Databases on client side.• Administration and maintenance of production databases in all Group Companies.• Upgrade/migration of all the databases at Marine Group of Companies from Oracle 8i/9i to Oracle 10g.DBA Premier Software Pvt. Ltd.• Deputed in Trade Development Authority of Pakistan (TDAP) as a Database Administrator.• Responsible for development, customization and overall Oracle Administration like Oracle installation, database creation & configuration, application maintenance, user creation and rights, performance tuning, RMAN backup & Recovery of Expo Management System.• Deputed in Mitsui & Co. Ltd. in Lahore and Islamabad as a Database Administrator.• Responsible for the overall development and database administration of Finance Management System, Inventory and HR/Payroll system.Software/Products: Inventory Management System Finance Management System Hospital Management System Shipping Management System Show less

• 

  National clearing company of pakistan limited

  Mar 2011 - Dec 2012

  Database administrator

  • Administration of Oracle 10g/11g databases on Linux, Solaris, IBM AIX platforms both OLAT and OLTP, Standby/Data Guard, Staging and development environments. • Implementation of Oracle Vault and Syslog auditing as per company Security compliance.• Monitoring of all Databases and also performed ongoing tuning of the Database instances and SQL Tuning.• Provide technical support to application development team, Deployment of application and new and updated objects in Databases.• Working with Oracle Technical Support to resolve any Oracle related problems and contact Oracle support MetaLink if required.• Migration from Oracle to Postgresql.• Postgresql Backup/Recovery, Performance Tuning and Streaming Replication configuration. Show less

• 

  Maple leaf cement factory limited

  Dec 2012 - Apr 2015

  Database administrator

  • Overall maintenance and administration of Oracle 10g/11g databases on Red Hat Enterprise Linux 4/5 platform for OLTP applications in production environment with Data Guard and Oracle ASM. • Implementation and administration of Oracle 11g Active Data Guard (primary in plant-standby in HO and vise versa).• Upgraded and migrated all Oracle 10g databases to 11g.• Designing and administering backup and recovery procedures using RMAN as well as Oracle Data pump.• Tuning of database and SQL code and assisting developers in writing and tuning SQL queries.• Installing, configuring, creating and managing Virtual machines using VMWare ESXi Server 4.• Managing and administering Oracle EBS R12 databases and Applications. Cloning and Backup/recovery of Oracle EBS R12 DB/Apps nodes from production to development/test servers.• Oracle Application DBA support, applying patches, multi-tier installations, automatic routines DBA task, oracle support dealing with functional , developers and end users.• Successfully upgraded Oracle e-Business suite Database/Application from release 10.2.0.2/12.0.6 to 11.2.0.3/12.1.3 with Oracons Consulting team on Linux RedHat 4.5.• Administration and monitoring of Oracle iAS 10g on RHL.• Overall maintenance and administration of Oracle 10g/11g databases in production environment with Data Guard. • Managing and administering Oracle EBS R12 databases and Applications. Cloning and Backup/recovery of Oracle EBS R12 DB/Apps nodes from production to development/test servers as well as applying patches.• Installation, configuration and monitoring of Oracle Cloud Control 12c/13c and monitoring of all databases and applications and management of monitoring Backup and DB monitoring using EM 13c.• Also served in Windstream USA as a Remote DBA. Show less

• 

  Askari bank

  Apr 2015 - Sept 2020

  Database administrator

  • Overall maintenance and administration of Clustered Oracle 11g/12c (RAC-Data Guard-ASM) Flexcube and its Reporting databases on Oracle Linux 6/7 platform for OLTP applications in production environment. As well as administration of important databases like Askari Credit card, IRIS, HOTSCAN and other dozens of other databases on EXADATA (X4 & X6). • Administration of Weblogic applications including Flexcube application.• Managing and administering Oracle EBS R12 databases and Applications. Cloning and Backup/recovery of Oracle EBS R12 DB/Apps nodes from production to development/test servers.• Monitoring and administration of SQL Server databases including Backup/Restoration and other daily tasks as well as administration of Log shipping, DB mirroring for High Availability and DR solutions.• Troubleshooting day-to-day problems encountered on production as well as development database environments. Show less

• 

  Maple leaf cement factory limited

  Oct 2020 - Sept 2022

  Database manager

  • Overall maintenance and administration of Oracle 10g/11g databases in production environment with Data Guard. • Managing and administering Oracle EBS R12 databases and Applications. Cloning and Backup/recovery of Oracle EBS R12 DB/Apps nodes from production to development/test servers as well as applying patches.• Installation, configuration and monitoring of Oracle Cloud Control 12c/13c and monitoring of all databases and applications and management of monitoring Backup and DB monitoring using EM 13c. Show less

• 

  Bankislami pakistan limited

  Nov 2022 - now

  Manager database administration

  • Administration of Oracle, SQL Server databases, ensuring data integrity, performance and availability.• Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security.• Provide 24x7 support for critical production systems.• Develops and implements policies and procedures related to data security and integrity.• Perform regular database maintenance tasks, including monitoring database performance, optimizing database configurations, and implementing backup and recovery procedures. Show less