خلاصہ

·        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.
اکتوبر ۲۰۲۰ - موجودہ | 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
دسمبر ۲۰۲۲ - مارچ ۲۰۲۳ | Islamabad, Pakistan

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

کمپنی کا لوگو
Database Administrator
Askari Bank Limited
اپریل ۲۰۱۵ - ستمبر ۲۰۲۰ | 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
مارچ ۲۰۱۱ - دسمبر ۲۰۱۲ | 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.
ستمبر ۲۰۰۸ - فروری ۲۰۱۱ | 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
جون ۲۰۰۷ - مئی ۲۰۰۸ | 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)
مارچ ۲۰۰۴ - اپریل ۲۰۰٦ | 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.
اگست ۲۰۰۴ - مارچ ۲۰۰۵ | 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)