Description

Noman Ahmed. – Oracle Database Administrator

 

SUMMARY of Qualification

·         Processing excellent communication, presentation leadership, and analyst capabilities;

·         Having strong experience in Oracle database consolidation;

·         Processing in-depth knowledge of  Oracle Exadata engineered system, Oracle APPS DBA and Oracle DBA 12c

·         Working well independently as well as skilled in group work;

·         Providing high abilities in Oracle Database installation, configuration, maintenance, upgrade and support in 24×7 environment;

·         Experiencing in Oracle RAC (Real Application Clusters) , disaster recovery sites, implement Oracle Data guard servers, and load balance experience in Oracle Application Nodes EBS 12.x.x;

·         Advancing skills-in system analysis, implementation and resource management and utilizing domain knowledge;

·         Performing the capacity planning required to create and maintain databases

·         Developing, designing customize Enterprise solutions in Oracle Forms and Report.

 

TECHNICAL SKILLS

·         Oracle Database: Administration, Cloning, RDBMS patching, performance turning, database import & export, Database installation and Upgrade 11gR1 to R12c, RMAN backup and restore, Oracle standby server

·         Oracle EBS: Installation and upgrade from Oracle EBS 12.1.1 to 12.2.6, application patching, application cloning, high availability architecture, RAC, Applications release 11i and/or R12.1.1 and R12.2.x, Linux/Unix OS

·         Oracle Exadata Engineer System: Database Migration, Monitoring, Database installation, Database consolidation, Exadata patching, Oracle Enterprise Manage 12c for Oracle Exadata monitoring

·         Oracle Development: Oracle form and Oracle report, Toad

 

PROFESSIONAL EXPERIENCE

SAUDI BINLADIN GROUP                SAUDI ARABIA- JEDDAH                                            Feb, 2011 – Present
Database Section Head

·         Working with the project department and vendors to plan and execute projects, for understanding the technical requirement;

·         Providing a new project implementation plan, scheduling and execution that meets the future needs of company;

·         Monitoring Database Performance and Daily activates;

·         Cloning for Database and Application for apply function test  cases;

·         Helping Senior developer / developers resolve technical problems;

·         Good Working Knowledge in Oracle Linux, and Working on Database designing / Development.

Accomplishments

·         Oracle Exadata database migration & consolidation project of Oracle EBS R12.1.1 Database size 2 TB;

·         Backup and recovery by RMAN and Netbackup;

·         Maintain Disaster Recovery site and Oracle RAC (Real Application Clusters);

·         Oracle Application EBS Load Balance with OCFS2 Shared Top;

·         Two Nodes Oracle EBS Application Nodes implemented by hardware load balancer;

·         Oracle Concurrent Process configuration between the nodes for failover and failback cases;

·         Oracle Business Intelligence (Oracle BI Apps) Installation and Configuration with Oracle EBS;

·         Installation and Configuration Oracle Enterprise Manager Cloud 12c;

·         Oracle database upgrade from 11gR2 to 12c.

Tools: SQL/PLSQL, Toad

 

IBM – GBS                                     KARACHI, PAKISTAN                                                             Mar 2009 – Feb 2011
Oracle EBS Technical Consultant

·         Managing a team of personnel on three different projects;

·         Implementing Oracle high Availability Solutions by fallowing  the Oracle Best Practices- MAA;

·         Involving in DR Site planning and implementation for Civil Aviation Authority Pakistan;

·         Working on Oracle EBS Installation and configuration with Oracle RAC architecture;

·         Oracle database patching and Oracle EBS application patches, performance, turning, and cloning

Accomplishments

·         Implement two nodes Oracle EBS RAC  database 10g;

·         Two nodes Oracle Application load balancing architecture;

·         RMAN Backup & Recovery by HP Data-protector;

·         Securing Oracle application by implanting SSL certificate.

Tools: SQL, Toad, Oracle Forms10g & Report 10g

 

A. F. FERGUSON (MEMBER FIRM OF PricewaterhouseCoopers), KARACHI, Pakistan

Nov. 2006 – Mar. 2009
Oracle EBS Technical Consultant

·         Providing a software development plan that meets the future needs of our clients/ departments, and having Responsible Oracle EBS Database and Application Administration;

·         Helping Senior developer / developers resolve technical problems, and Working on Database designing / Development;

·         Working on Oracle ERP – Customization, Personalization, Complex Report Writing.

Accomplishments

·         Oracle Report writing for Oracle EBS R12.0.6 modules AP/AR/GL/PO/INV;

·         Application upgrade from 11.5.2.10 to 12.0.6, and Database upgrade (9i to10g);

·         Oracle EBS application installation and patching.

Tools: SQL, Oracle 11g, Toad, PL/SQL

 

DATACHECK PRIVATE LIMITED, KARACHI, PAKISTAN                                                      April 2004 – Oct.2006

Software Engineer

·         Writing systems to control the Defaulter for bank in terms of Credit Card, Personal Loans, Car/Home loans, and writing/testing code; then, refining and rewriting as necessary;

·         Testing & maintaining systems by monitoring and correcting software defects;

·         Consulting clients concerning the maintenance and performance of software systems and with a view to writing or modifying current operating systems.

Accomplishment

·         Developing, Designing and Implementing Credit scoring application, and Defaulter Enquiry

·         Bulk data uploading from Banks and financial institution

·         Defaulter deletion application after removal of bank.

Tools: SQL, PL/SQL, Oracle Forms 6i and Oracle Report 6i.HTML

 

KEYLINK INTERNATIONAL SOLUTION, JEDDAH, SAUDI ARABIA                                 Aug. 2002 – April 2004

System Analyst

·         Analyzing , Designing, Developing and Implementing Customize ERP

·         Writing and testing code and then refining and rewriting as necessary.

·         Working on Data Migration from Foxpro 2.5 to Oracle 8i, application Tuning and performance.

Accomplishment

·         Develop, Design, and implement Point of Sales system, Restaurant System, and data integration between Point of sales system and Customize ERP by using Oracle Database , forms and reports

Tools: SQL, PL/SQL, Oracle Forms 6i and Oracle Report 6i

 

OMAN MARKETING CENTER, MUSCAT, OMAN                                                             Sep. 2001 –Aug. 2002

Analyst Oracle Programmer

·         Analyzing , Designing, Developing and Implementing In-house ERP in Oracle database 7.3

·         Writing and testing code and then refining and rewriting as necessary.

Accomplishment

·         Develop, Design and Implement  Assets Management System

 

BRINK PAKISTAN (PVT) LTD , KARACHI, PAKISTAN

Oracle Programmer                                                                                                      July 1998 –Sep. 2001

·         Working on Analyses, design and develop the sales AP,AR,GL, Vehicle Management System in Oracle 7.3 under SCO Unix using forms 3 & Report writer 1.1

·         Working on Oracle Database Administration and SCO Unix Administration

 

EXPORT PROMOTION BUREAU, KARACHI, PAKISTAN                                            July 1995 –Nov. 1997

Oracle Programmer

·         Analyses, design and develop the Exhibition  Information System and Library Information System in Oracle 7.3 under SCO Unix using forms 3.0 & Report writer 1.1

 

EDUCATION

B.CS. (Computer Science – 1998), Shah Abdul Latif University, Khairpur, Pakistan

MBA. (MIS – 2007), Karachi, Pakistan

 

ORACLE UNIVERSITY TRANING

·         Passed ITIL V3 Foundation Certification Exam

·         Oracle Exadata Administration workshop

·         Oracle BIEE