CV/Mission ORACLE FLASHBACK freelance

Aperçu des emplois de Khalid,
freelance ORACLE FLASHBACK résidant dans ?

• Assistant Vice President / Head of database infrastructure

  Abu Dhabi UAE
  Jan 2015 - aujourd'hui

  Responsible for managing the availability of the database environment for the Bank. Monitor and manage incidents using best practices to ensure timely and accurate support is delivered. Responsible for ensuring that the Bank’s security policies are adhered to and that the SLAs between the Bank and suppliers are met. Support on technology selection specifically for the database and associated solutions for enterprise level monitoring with Oracle Cloud Control and HP tools. Single point of contact for Oracle licenses and ACS.
  
  • Budget in excess of $14m including projects
  • Negotiated three years renewal Oracle license reducing it to $5 Million cutting $360K as part of phase one.
  • Architect and design consolidation platform for SQL reducing the license cost of 350 databases.
  • Implemented robust recovery systems and DR across databases to reduce RPO
  • Support the Implementation of big data in social media
  • Implementation of Oracle Flashback and IBM Tivoli Storage FlashCopy Manager to reduce RTP/RPO
  • Upgraded all Database to current and support release of 12c
  • Enabled Oracle Cloud Control for all Databases
  
  The current key projects
  • Implemented Oracle E-Business Suite (EBS)/ Siebel CRM solutions with a broader level of expertise by developing Architecture Solutions and IT strategies across a variety of platforms and systems.
  • Supported Murex on RAC database, redesigned on ASM storage and migrated to AIX platform.
  • Comparing the cost of ownership of the Oracle Exadata to a traditional build-your-own (BYO) solution, in this case an IBM Power 880 and Fujitsu SPARC M10. Review benchmark from three vendors and redesign capacity based TPS for 5 years.
  • Good knowledge in core banking T24 architecture design on XML database on 12c.
  • Performance and tuning of T24 by implementation of partition table and tuning XML Query based on Binary XML storage.
  • Implemented Oracle Enterprise Manager as Oracle’s on-premises management platform, providing a single pane of glass for managing all for Oracle all database of the bank with deep integration with Oracle’s product stack, with management and automation support.
  
  As Head of database services, I was responsible for support and release for all services provided to FGB and its subsidiaries for both local and international locations.
  
  • Managing a team of 20+ outsourced and direct staff comprising of DBA’s, PMOs, Application Operations, Networks, Transformation Program, Storage, Systems, Service Desk, and Change Management & IT Security.
  • Currently working on building Fabric Infrastructure through implementation of automation, virtualization, private cloud and converged infrastructure.
  • Architect and design consolidation platform for more than 350 SQL databases to Hyper-V and Oracle to reduce OPEX to $5 Million.
  • Implementation of high availability and robust recovery systems across databases to reduce RPO/RTO.
  • Redesign High availability for Trade System Murex, a bank-wide EBS/CRM/MDM/FACTA/FGBonline/Big Data implementation, Wealth Management, as well as a Digital risk and compliance on very fast moving milieu.
  • Single point of contract for Oracle controlling license cost.
   

• Senior Principal Software Manager Oracle Corp

  Jan 2000 - Jan 2015

  (15 years 6 months) location Washington DC - London - Amsterdam Area
  Over 15 years with Oracle since 2004 of professional experience in Software Systems Industry with special expertise7 on Replication of Databases and RAC/Dataguard/Golden gate/Streams/ Exadata as Database Administration and Data Architect.
  
  Teach, plan, design, develop high-quality and timely training materials. worked with "Oracle customer and consultant" to deliver training materials and write Oracle Support Notes. Troubleshoot and resolve highly complex techno-functional problems and resolving highly complex and mission-critical issues the average of 105 service requests per month and Handle large number of escalations for key customers Bank of America , BT, Yahoo, AT&T, Citigroup.
  
  Hold very rarely expertise with Zero Downtime Migration using Oracle GoldenGate or streams and worked extensively on Golden gate /streams/replication with over 60+ streams projects between USA, UK and The Netherlands. Design using Streams Bi-directional replication between Hub and spokes RAC databases.Provide advanced support with aggressive SLAs to top account customers.
  
  Leading architecture database administration teams. Highly skilled in implementing Business Continuity solutions, Define client business requirements to instrument system design, implemented Exadata v1 and v2 migration using streams-golden gate.
  
  Proficient in Oracle Database Architect’s activity includes Design of Hardware/Software, Installation and configuration of Oracle databases, Tuning, Logical/physical Standby (Data Guard), Streams (9i 10g,11g,12c), Backup/Recovery, Data warehouse, OBIEE, ETL, RAC 9i/10g, migration, Worked on numerous implementations Oracle Applications and Oracle E-business suite and has in-depth knowledge of the technical architecture and various modules.
  
  Update to date with new technology and involved in Beta 12c release

• Senior Database Administrator Revlon New York

  Jan 1998 - Jan 2000

  Worked with the team of 7 DBAs on 54 servers at a time; including 12 production servers range from 10 gigs to 700 gigs. 70% of the time spent working on production and support and 30% of the time focusing on schema, design and PL/SQL Development.
  
  Migrate, Redesign and implement production Sale and Marketing Datawharehouse database (500 GB and 250 GB with some tables size over 120 million rows) AIX environment from IBM rs6000 R30 to R80 with EMC Symmetrix storage.
  
  Also had Oracle DBA responsibility for a massively parallel Oracle/SAP database using Oracle Parallel Server. Supported Oracle developers, performed database tuning, created database reorganization procedures, database alert scripts, monitoring scripts and backup procedures. Also developed a method for configuring EMC disk arrays for data warehouses and created a system for detecting I/O bottlenecks
  
  Provided ORACLE database administration support, managing many different databases included SAP, Oracle financials/HR, manugistics, GEMMS, Viewstar,EDI. Major responsibilities other than user management, space management, and object management included maintaining performance, instituting measures to minimize down time, helping analysts with their logical to physical data modeling. Mentored junior staff to trouble-shoot SQL,PL/SQL and Database problems.

• Oracle Database Administrator Computer System Technologies

  Jan 1995 - Jan 1995

  Columbia, South Carolina United State of America
  Assisted in the design of project plans and implementation of all phases in a project life cycle. Interacted extensively with clients (Carolina Power & Light Company, PNM New Mexico, Bangor Hydro - Maine, Citizens' Electric Company, Con Edison New York, Green Mountain Power Corporation Vermont, SCANA Corporation -SCE&G, PS Jamaica) and authored technical specifications to modify the company's custom utility application
  24X7 administration of the production databases (oracle7, Oracle8i on various platform Sun Enterprise Servers, HP, AIX, VAX)
  Development of Database Security Schema providing for multi-role and multi-profile access control
  Expertise in Oracle Advance Queuing, SQL*Loader, writing triggers, procedures in PL/SQL , programming in Pro*C and UNIX Shell scripting to create batch jobs.
  Developing Data Models and Designing Databases using Oracle Designer/2000
  Backups database procedures with Oracle EBU/Shell script with (HP Omniback, Veritus Netbackup, Legato, ADSM).