• Development/Integration Manager - Settlement Accounting System Projects Energy Market UAE including Transco, different Power Plants etc• Responsibility to design, upgrade and implement ADWEA Central Settlement System under latest technologies e.g. Oracle11g, Pro*C/C++ 11g, VB .Net etc • Designing and implementation of Oracle11g Databases with Flash Back Technology • Oracle DB backup and restore procedures using RMAN.• Responsibility of ensuring that the delivered solution is… Show more • Development/Integration Manager - Settlement Accounting System Projects Energy Market UAE including Transco, different Power Plants etc• Responsibility to design, upgrade and implement ADWEA Central Settlement System under latest technologies e.g. Oracle11g, Pro*C/C++ 11g, VB .Net etc • Designing and implementation of Oracle11g Databases with Flash Back Technology • Oracle DB backup and restore procedures using RMAN.• Responsibility of ensuring that the delivered solution is as required by ADWEA, Government of Abu Dhabi. • Writing of Integration Plan, Acceptance Testing Plan, Training Plan, Installation Guides, User Manuals, Technical Infrastructure Plan and other project documents.• Designing and implementation of system models.• Responsibility for the creation, maintenance and sign off of all Project & Quality Plans, ITP, ITD, ITS, ATP, ATD & ATS, from a quality perspective and performing assurance reviews on projects to ensure compliance with project standards. Show less

• Designing, Deployment, Management and maintenance of 22 production and development Oracle9i and 10g databases installed on various high performance HP and Sun Servers.• Responsibility of ensuring that the delivered solution is as required by the Saudi Ministry of Interior as per Service Oriented Architecture (SOA).• Responsible for implementing a structured configuration management process under SOA.• Production of documents for Oracle Database Design, Daily DBA procedures… Show more • Designing, Deployment, Management and maintenance of 22 production and development Oracle9i and 10g databases installed on various high performance HP and Sun Servers.• Responsibility of ensuring that the delivered solution is as required by the Saudi Ministry of Interior as per Service Oriented Architecture (SOA).• Responsible for implementing a structured configuration management process under SOA.• Production of documents for Oracle Database Design, Daily DBA procedures, Database Backup and Recovery, Deployment and Configuration guides of 16 Windows based and 6 Sun Solaris based Oracle Databases• Writing PL/SQL procedures, SQL queries and Backup/Recovery scripts for projects development team.• Installed and maintaining VERITAS Cluster for Sun Solaris and Oracle9i for 6 databases of the PKI project. • Database backups/restore• Carry out performance checks for critical databases; document findings; monitor stats, events, waits, CPU, I/O, checkpoints; monitor at OS level; rebuild & relocate hot segments, fix chaining; pin packages, use of keep pool; generate top SQL reports; SQL tuning and indexing; use of bstat/estat, statspack, explain, tkpof, dynamic SQL, underscore parameters.• Modified PL/SQL procedures, packages, Pro*C code and Websphere MQ connectivity.• Control of Configuration Management processes, functions and assets register.• Development of Configuration Management standards, Configuration management plans and procedures.• Ensuring that changes to the Configuration Management methods and processes are properly approved and communicated to staff before being implemented. • Evaluating proprietary Configuration management tools and recommends those that best meet the project’s budget, resource, timescale and technical requirements. • Creation and management of the Configuration management plan.• Make availability of the CMDB to help identify other CIs affected by a fault that is affecting a CI. Show less