概要

·        ORACLE 10g/11g/12c/19c certified Administrator having 13+ years of experience in Database design, administration, Production support, Installation, Configuration, Patches, Migration, Performance Tuning, Backup and Recovery, Cloning, Capacity Management, Database security and Monitoring, Database performance tuning and SQL Tuning.


·        Implemented High Availability solutions with Oracle Data Guard, Oracle Real Application Clusters (RAC) versions 10g/11g/12c/18c/19c as well as implementation of HA solutions for SQL Server, MySQL and PostgreSQL.


·        Maintains database performance by calculating optimum values for database parameters; implementing new releases; completing maintenance requirements. enforcing organization standards.


·        Maintains quality of service by establishing and enforcing organization standards.


·        Responsible to perform query optimization, database design optimization in addition to providing assistance/reviews/feedbacks to stakeholders in writing complex queries, stored procedures/functions, views, DDL/DML script.


·        Troubleshoot complex database issues in accurate and timely manner ensuring compliance to SLAs / OLAs. Ensuring Data Security & Encryption, controlling authorization/authentication, and adherence to the security compliance standards i.e. ISO, Data Protection Act, GDPR, Internal InfoSec etc.


·        Maintain database operational, disaster recovery, backup procedures/processes to ensure continuous availability and speedy recovery.


·        Responsible to maintain a good, healthy & friendly team environment.


·        Publish documents i.e. user manuals, maintenance procedures, RCAs and definition for data dictionary etc.


·        Having experience in managing AWS-RDS, Azure SQL databases.


·        Oracle Autonomous Database Administration and OCI experience


·        MongoDB Database Administration Replication, Sharding, Backup & Recovery etc.

项目

Configure Mobile App Approval for Oracle EBS 12.2.9
Upgrade Oracle EBS 12.1.3 to 12.2.9 and Database from 11g to 19c

工作经历

公司标识
Database Administrator
Maple Leaf Cement Factory Pvt. Ltd.
Oct 2020 - 代表 | Lahore, Pakistan

·        Overall maintenance and Administration of Oracle EBS 12.1.3 and 12.2.9.
·        Upgrade from Oracle EBS 12.1.3 to 12.2.9 with Oracle 19c database.
·        Managing different critical databases of Oracle 11g/12c/19c RAC, Active Data Guard.
·        Upgrade the databases from Oracle 11g to 12c/19c on Linux/AIX/Windows.
·        Responsibilities includes installation, administration, operations, support, and maintenance, monitoring & upgrading of database servers to ensure availability, security with optimal performance primarily.
·        Configured the OEM 13C Cloud/Grid Control for central monitoring of database servers.
·        Cross Platform Database migration from AIX to Linux, Windows to Linux/AIX.
·        Automatic Storage Management (ASM) configuration and management using 11gR2 Grid Infrastructure and so on.
·        Solid experience of Database and SQL Performance Tuning.
·        Responsible for capacity planning, recovery planning and patching.
·        Backup/Recovery of RMAN Backups, Logical (exp, expdp), incremental backup and Database Restoration.
·        Monitoring, Compression, Re-Organization of tables.
·        Managing MS SQL Server 2016.
·        Implemented Oracle E-Business Suite Mobile Apps on R12.2

公司标识
Database Administrator
BankIslami Pakistan Limited
Dec 2022 - Mar 2023 | Islamabad, Pakistan

Managing overall ORACLE and SQL Server databases and applications.
Performing RMAN backup/recovery and performance tuning.

公司标识
Database Administrator
Askari Bank Limited
Apr 2015 - Sep 2020 | Islamabad, Pakistan

·       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).
·       Designing and administering backup and recovery procedures using RMAN as well as Oracle Data pump.
·       Installation, configuration and monitoring of Oracle Grid Control 11g/Cloud Control 12c and monitoring of all databases and applications and management of monitoring Backup and DB monitoring using EM 13c.
·       Administration of all Weblogic application including Flexcube applications.
·       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.
·        Ability to troubleshoot day-to-day problems encountered on production as well as development database environments.
·        Experience in using Profiler and Windows Performance Monitor to resolve Dead Locks
and long running queries and slow running server.

公司标识
Database Administrator
National Clearing Company of Pakistan Limited
Mar 2011 - Dec 2012 | Karachi, Pakistan

• Administration of Oracle 10g databases on Linux, IBM AIX platforms for Data Warehousing, OLTP applications in production, Standby/Data Guard, Staging and development environments.
• Creating and administration of Oracle Data Guard.
• Implemented Oracle Vault and Syslog auditing as per company Security compliance.
• Monitoring all databases and also performs ongoing tuning of the database instances and SQL Tuning/ DB Tuning.
• Creating and Managing complex database objects like table and index partitioning and optimizing them for performance benefits and tuning SQL code/queries.
• Plan and implement backup and recovery procedures using RMAN.
• Implement and maintain database security (create and maintain users and roles, assign privileges) and also plan growth and changes (capacity planning).
• Provide technical support to application development team and creation and maintenance of database links across different databases.
• Synchronize the test/Dev databases periodically by cloning the data from the production databases using conventional methods as well as RMAN.
• Monitoring and Administration of Weblogic Server 7 and Oracle Weblogic 11g.
• Working with Oracle Technical Support to resolve any Oracle related problems and contact Oracle support MetaLink if required.

公司标识
Application Developer cum DBA
Premier Software (Pvt) Ltd.
Sep 2008 - Feb 2011 | Karachi, Pakistan

• 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.

公司标识
Oracle Developer
Millennium Software Pvt. Ltd
Jun 2007 - May 2008 | Karachi, Pakistan

• Development, customization, support and implementation of HRMS & Payroll Software.
• Developed a large number of reports using Oracle Reports 6i/10g.
• Involved in migration of HRMS and Payroll system from Oracle 8i/6i to Oracle 10g.
• Resolving client issues and user training and providing technical support.
• Maintenance and configuration of Oracle databases, User privileges, Import/Export and Data Loading on client side.

公司标识
Lecturer in Computer Science (Temporary)
Govt. Degree College Pabbi (Nowshera)
Mar 2004 - Apr 2006 | Nowshera, Pakistan

• Database Management Systems
• Troubleshooting and maintenance of LAN network in college.
• Object-Oriented Programming in C++, JAVA.

公司标识
Internee + Student (Part Time)
iFAST Pvt. Ltd.
Aug 2004 - Mar 2005 | Peshawar, Pakistan

• Developed new forms and reports for Inventory Management System using Oracle 9i as a back-end and Oracle Developer 6i as a front-end.
• Learned administering Oracle databases on Linux/Windows, Import/Export, backup/recovery and other development and administration tasks of Oracle database related.
• Learned Database administration skills.

学历

NWFP Agricultural University
硕士, 科学硕士学位, Masters in Computer Sciences‎
Database Programming and Administration
CGPA 3.0/4
2004
University of Peshawar
学士, 技术学士, B.Sc (Computer Science)‎
Computer Science
所占比重 64%
2001

技能

熟练 Oracle Developer 6i/10g/11g.
熟练 Oracle EBS R12 Applications | Weblogic
熟练 Red Hat Linux/Oracle Enterprise Linux,
熟练 RMAN, SQL*Loader, Oracle Data Pump.
中级 Symantec Backup Exec & Managing Backup
中级 VMWare ESXi 4 Administration
熟练 Database Clustering
熟练 Database Replication
熟练 PL and SQL

语言

熟练 英语
熟练 乌尔都语

My Video Introduction

Mansoor 联系人

Adnan Riaz
United Bank Limited (UBL)