Shafique Ahmad

Restored and backup of Oracle database for all Hands-on experience with disaster recovery techniques to recover mission critical data at Khafji Joint Operation (KJO)
Installed oracle 10g, Oracle 9x and oracle 8x in server and configuring the client machine Professionally trained in backup, restore procedures and techniques for Windows and UNIX based setups.
Managing 8 production Oracle databases
Logical to physical design of the database
Created UNIX shell script for Cold and Hot backups.
Creating, cloning, and migrating the database by cold and hot backup
Partitioning tables and indexes
Tuning the database for maximum performance
Exporting and Importing Data using EXP & IMP utilities.
Analyzing tables and rebuilding indexes
Storage Consideration in Tablespaces.
Created scripts using RMAN
Executed various scripts for determining the overall performance of the database including the OS.
Assisting and guiding the team members of software developers.

Designing, Development, and Implementation
Developed complete Hospital Information system like Patient Registration & Medical Records, Company Account system, Appointments System, Inpatient system, Laboratory & Blood Bank System and Radiology Management
Developed finance module, employee and payroll module purchase Requisition inventory module, Fixed Assets Modules
Well versed in Developer forms 6i and reports 6i
Experienced on writing long PL/SQL scripts, creating triggers, creating complicated SQL queries and making interface and reports.

Implementing the Well Integrity Management System during life cycle of wells.
Scrutinize and analyze the Offshore Oil and Gas Field data related to well integrity operations and report the progress as required to assist in formulating appropriate Offshore Field well integrity monitoring development plans.
Participate in the design, implementation, maintenance, and development of Data Management Systems in matters pertained well integrity, well log and well files.
Implemented the Commercial WIMS application successfully.
Direct implementation of approved systems/application and participate in provision of appropriate training for users.
Make in-depth use of the various database management tools used by the department and create fit to purpose intermediary data as when required to achieve business objectives.
Closely scrutinized the data of production tests, annuli pressure and well integrity surveys, present the analyzed and processed results to the requirements of the department.
Participate in technical meeting with relevant department in planning and executing required IT system, database requirements and review related plans.
To acquire various data from the sources such as existing databases (e.g. OGPS, EDM & LIMS), network drive, well files and hard copy documents for analyze, process and create archive them as suitable to each data sets to be used by data processing for the well integrity monitoring system.
Supports engineers and petro physicists in their use of databases and application software.
Responsible for organizing, analyzing and processing data in Oil & Gas Production System.
Participate at the required level in the ongoing training and development of Qatari DBA of Data Management (Oilfield related).
Migrated entire suite of information management applications and Geoframe 4.4 from Solaris 8 to Solaris 9 and Solaris 10.
Involve in the installation of openwork 5k.
Upgraded Finder 9.3 to Finder 9.4 and from Finder 9.4 to Finder 9.5
Upgraded eSearch 2.7 to till 3.1 service pack 3
Upgraded eSearch 3.1 to 3.2 (oracle 10.2.0.2)
Upgraded from Decision Point 5.2 to 2007.1
Upgraded Decision Point 7.1 to 2008.1(now on 10g)
Implemented Spread Sheet Loader (SSL) on Finder
Prepared the data control documents with data dictionary, data mapping and attribute standards.
Prepared the Data Loading templates, control files according to the loading strategy.
Helping loaders to load the data in proper way and correct procedures.
Created UNIX shell scripts and PL/SQL for data loading.
Implemented database backup and restore procedures and techniques for Windows and UNIX based setups through self-created auto-scripts on daily basis.
Restored and backup of Oracle database for all Hands-on experience with disaster recovery techniques to recover mission critical data at Khafji Joint Operation (KJO)

Installed oracle 10g, Oracle 9x and oracle 8x in server and configuring the client machine Professionally trained in backup, restore procedures and techniques for Windows and UNIX based setups.
Managing 8 production Oracle databases
Logical to physical design of the database
Created UNIX shell script for Cold and Hot backups.
Creating, cloning, and migrating the database by cold and hot backup
Partitioning tables and indexes
Tuning the database for maximum performance
Exporting and Importing Data using EXP & IMP utilities.
Analyzing tables and rebuilding indexes
Storage Consideration in Tablespaces.
Created scripts using RMAN
Executed various scripts for determining the overall performance of the database including the OS.
Assisting and guiding the team members of software developers.

Designing, Development, and Implementation
Developed complete Hospital Information system like Patient Registration & Medical Records, Company Account system, Appointments System, Inpatient system, Laboratory & Blood Bank System and Radiology Management
Developed finance module, employee and payroll module purchase Requisition inventory module, Fixed Assets Modules
Well versed in Developer forms 6i and reports 6i
Experienced on writing long PL/SQL scripts, creating triggers, creating complicated SQL queries and making interface and reports.

Implementing the Well Integrity Management System during life cycle of wells.
Scrutinize and analyze the Offshore Oil and Gas Field data related to well integrity operations and report the progress as required to assist in formulating appropriate Offshore Field well integrity monitoring development plans.
Participate in the design, implementation, maintenance, and development of Data Management Systems in matters pertained well integrity, well log and well files.
To maintain data flows, database and participate in design implementation of optimized rules, procedures, and business process for well data including documentation, data flow analysis and reports.
Implemented the Commercial WIMS application successfully.
Direct implementation of approved systems/application and participate in provision of appropriate training for users.
Make in depth use of the various database management tools used by the department and create fit to purpose intermediary data as when required to achieve business objectives.
Closely scrutinized the data of production tests, annuli pressure and well integrity surveys, present the analyzed and processed results to the requirements of the department.
Participate in technical meeting with relevant department in planning and executing required IT system, database requirements and review related plans.
To acquire various data from the sources such as existing databases (e.g. OGPS,EDM & LIMS) ,network drive ,well files and hard copy documents for analyze, process and create archive them as suitable to each data sets to be used by data processing for the well integrity monitoring system.
Supports engineers and petro physicists in their use of databases and application software.
Responsible for organizing, analyzing and processing data in Oil & Gas Production System.
Participate at the required level in the ongoing training and development of Qatari DBA of Data Management (Oilfield related)
Migrated entire suite of information management applications and Geoframe 4.4 from Solaris 8 to Solaris 9 and Solaris 10.
Involve in the installation of openwork 5k.
Upgraded Finder 9.3 to Finder 9.4 and from Finder 9.4 to Finder 9.5
Upgraded eSearch 2.7 to till 3.1 service pack 3
Upgraded eSearch 3.1 to 3.2 (oracle 10.2.0.2)
Upgraded from Decision Point 5.2 to 2007.1
Upgraded Decision Point 7.1 to 2008.1(now on 10g)
Implemented Spread Sheet Loader (SSL) on Finder
Prepared the data control documents with data dictionary, data mapping and attribute standards.
Prepared the Data Loading templates, control files according to the loading strategy.
Helping loaders to load the data in proper way and correct procedures.
Created UNIX shell scripts and PL/SQL for data loading.
Implemented database backup and restore procedures and techniques for Windows and UNIX based setups through self-created auto-scripts on daily basis.

 More than 22 years of experience as an IT professional in database administration and various phases of Software Development including System Analysis and Design, Development, Testing, Implementation and Maintenance projects.
 12 years’ experience with different flavors of Oracle.
 More than 8 years’ experience in implementing and using the Well Integrity Management System (WIMS) during life cycle of wells.
 More than 5 years experience in oil and gas Industry as a DBA and E & P data Controller.
 Supervise the implementation and up-gradation SIS software like GeoFrame, Petrel, Eclipse, ProSource, Decision Point, eSearch with databases like Finder, LogDB, Merak Suites, Petrel Studio.
 Supervise the implementation and up-gradation of Halliburton applications alike OpenWork & EDM (OpenWells).
 Experience in supporting to users in data management and G & G Applications.
 Experience in Loading the E & P data like well general data, core, marker, deviation, well completion and production data and help other data loader to load with correct procedure in corporate database. And I used to QC the data through Inner logic and EDMS applications.
 Hands on experience on all aspect of Oracle Database administration in Windows and UNIX environment.
 Created customized many reports in DecisionPoint from FINDER (Corporate database of E & P) and other Databases.
 Experience in data loading and QC of oil and gas industry data.
 Well rated by present and past employers and clients and got appreciation.
 Keen problem-solver, good trouble-shooter especially in database, innovative and versatile, team-player, able to work without supervision, willing to acquire new skills and mentor others. I am also able to prioritize and supervise.
 Ability to complete the assignments within time budgets and calendar schedules while handling multiple tasks.
 Experience in conceptualizing and implementing software procedures.
 Reasonable & good analytical, communication and team management skills

 Installed oracle 10g, Oracle 9x and oracle 8x in server and configuring the client machine Professionally trained in backup, restore procedures and techniques for Windows and UNIX based setups. Managing 8 production Oracle databases
 Logical to physical design of the database
 Created UNIX shell script for Cold and Hot backups.
 Creating, cloning, and migrating the database by cold and hot backup
 Partitioning tables and indexes
 Tuning the database for maximum performance
 Exporting and Importing Data using EXP & IMP utilities.
 Analyzing tables and rebuilding indexes
 Storage Consideration in Tablespaces.
 Created scripts using RMAN
 Executed various scripts for determining the overall performance of the database including the OS.
 Assisting and guiding the team members of software developers.