Mansoor Ahmad

Mansoor ahmad

bookmark on deepenrich
location of Mansoor AhmadIslamabad, Islāmābād, Pakistan
Phone number of Mansoor Ahmad+91 xxxx xxxxx
Followers of Mansoor Ahmad1000 followers
  • Timeline

    Aug 2004 - Mar 2005

    Internee

    iFAST Pvt. Ltd
    Jun 2007 - May 2008

    Software Developer

    Millennium Software Pvt. Ltd
    Sept 2008 - Feb 2011

    Application Developer cum DBA

    Premier Software (Pvt) Ltd. (Marine Group of Companies)
    Mar 2011 - Dec 2012

    Database Administrator

    National Clearing Company of Pakistan Limited
    Dec 2012 - Apr 2015

    Database Administrator

    Maple Leaf Cement Factory Limited
    Apr 2015 - Sept 2020

    Database Administrator

    Askari Bank
    Oct 2020 - Sept 2022

    Database Manager

    Maple Leaf Cement Factory Limited
    Current Company
    Nov 2022 - now

    Manager Database Administration

    BankIslami Pakistan Limited
  • About me

    Senior Database Administrator | APPS DBA | OCI Architect | SQL Server DBA | MongoDB | PostgreSQL DBA | AWS | AZURE

  • Education

    • Institute of business management studies (ibms)

      2003 - 2005
      Mcs computer science

      MCS

    • Govt degree college pabbi

      2001 - 2003
      Bachelor of science - bs computer science
  • 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

  • Licenses & Certifications

    • Oracle certified professional - oracle 9i database administrator (ocp)

      Oracle
      Mar 2010