A highly energetic and hands-on Project Leading Oracle DBA with considerable experience and expertise in database design, implementation, migration, administration, maintenance, upgrading and recovery. First-class designer and able to devise highly ingenious solutions that solve complex business and technical issues. Proven team and project leadership skills, including managing, training and motivating others to achieve project deadlines and budgets. A top Oracle Expert who can quickly solve complex bugs and major performance issues. Designed and programmed 20 web-sites in ASP. Consulted on oracle replication and data-warehouse systems performance.
¨ Dramatically improved the performance of neopets.com’s web site by leading the conversion of their large database from MYSQL to Oracle. Fine-tuned and optimised the new Oracle system, enabling them to boost throughput considerably from 60 to 180 Mbits/second, taking their web site from 11th to 6th world-wide.
¨ Analysed and redesigned Multimap.com’s Oracle system to fine-tune and optimise performance and remove bottlenecks, which significantly boosted performance by 50%. Investigated and resolved a major core dump that occurred every 4 hours.
¨ Designed and implemented a new Oracle database for Multimap.com to migrate the entire USA street map data from flat files to Oracle and devised a highly innovate SQL Loader technique that significantly reduced the time it took to import the updated data each month from 48 hours down to 6 hours.
¨ Built 36 Oracle servers for 21 clients of Hitachi Adaptive Information Systems, including analysing clients’ requirements, designing / redesigning and implementing systems, performing installations, systems administration, fine tuning, maintenance and upgrades, defining backup / recovery procedures and training staff.
¨ Built and migrated 4 Oracle 8i to Oracle 9i systems.
¨ Created Oracle 9i new features course
¨ Built and maintained large emailing system for large London based marketing company.
¨ Migrated Barclays Capital Japan from a 7.3 system to a 8.i system using Unicode-8 for European to Japanese conversion.
¨ Consulted on the conversion to Unicode-8 for “Ciebiron” (a B.A.T. and Cap-Gemini company) for a CRM and Oracle “Datawarehouse/Data-Mart” system
¨ Founded Astro-Cybernetics as a trading vehicle to operate as an Oracle Consultant.
Mosaic London, Uk, 2002 June-Sept. 30
Designed and built a oracle system for emailing customers. Sent out 1 million emails per day. Made new in-stream triggers for sqlloader and other systems. Befored DBA tasks and maintained system.
Created and coded system to convert European to Unicode-8 sets for the trading system for Barclays Japan
¨ Re-configured the Oracle database for the largest map web site in the UK, redesigning the system to optimise system performance.
¨ Designed and developed a new database that enabled Multimap.com to migrate the entire USA street map data from flat files to Oracle.
¨ Investigated and analysed a major core dump that would occur regularly every 4 hours, identifying the problem and devising a solution that fixed it.
¨ Designed, developed and delivered web courses / course materials (HTML, JavaScript, JSP, Java, XML and ASP), training the trainers within the Training Department to deliver courses to staff within H.M. Customs and Excise.
¨ Set up SQL server systems and devised course materials for DBA roles.
¨ Led the project that converted Neopets large user database from MYSQL to Oracle 8.1.5 database on a Solaris 450 system – www.neopets.com offers computerised pets and is the 11th most popular site in the world receiving 36 million hits per day.
¨ Devised and developed SQL Loader scripts and Visual Basic programs to manipulate the data and designed the Oracle database, which had 280 tables.
¨ Fine-tuned and optimised the Oracle database to perform in one of the most intense environments in the world.
¨ Trained the company’s staff to maintain the Oracle / Sun Solaris system.
¨ Successfully recovered the data from Noble Star’s Oracle database for their gambling web site following a major database crash.
¨ Reconfigured the Oracle database correctly and allocated the required number of rollback segments.
¨ Converted the company’s Access Database to SQL Server and then to Oracle, delivering data to both the company’s web site and to mobile phones.
¨ Designed and built a complete Internet Service Provider system using NT and Linux with an Oracle back-end database and secured major Internet based clients.
¨ Devised a successful astrological e-commerce web site www.astrocye.com using Oracle, SQL*NET, Oracle Stored Procedures, ODBC, ASP and HTML.
¨ Designed and built an Oracle database to handle record royalties for Warner Brothers on a Sun/Solaris UNIX system.
¨ Developed a series of PL/SQL scripts for this International pharmaceutical company’s B2B E-commerce site, converting their entire product line from a text database to an Oracle database.
¨ Set up a customer web interface using Oracle's Web Server.
¨ Customised, upgraded and maintained installations of Hitachi’s document scanning system, which included an Oracle database as the index and control system for the scanning programs.
¨ Built 36 Oracle servers for 21 of Hitachi's clients on Novell, NT 4.0, Sun Solaris/Unix and IBM OS/2 systems; prepared the backup and recovery methodology for each client; upgraded systems from Oracle 6.x to 7.x.; fine-tuned clients’ databases.
¨ Performed system maintenance and housekeeping using the following tools: Oracle SQL*Loader, Oracle PL/SQL, Oracle SQL*PLUS, Oracle export and import, Microsoft Quick Basic, Microsoft Visual Basic (3-4-5-6) and R&R report writer.
¨ Designed and delivered training in Oracle DBA, SQL*PLUS and PL/SQL.
¨ Converted the California Highway Patrol in Sacramento (CHiPS) legacy system to Oracle on a Sun-Solaris/Unix platform, and created a database that linked the scanned photographs of 10 million drivers in California with their licence details, which had never been done before.
¨ Upgraded the Orange County Central Courts system, enabling the Oracle system to handle all the correspondence from the Traffic Violation Court.
¨ Redesigned and upgraded the Union Bank of California’s database to allow the bank’s Oracle system to handle all the bank’s loan applications.
¨ Oversaw the re-design and upgrading of The Gap’s Oracle database to handle their HR functions, enabling them to dispense with 3 warehouses full of paper records.
¨ Dramatically improved the speed at which Turner Broadcasting could convert black and white movies into colour by a factor of six by designing an Oracle System that automated the transfer process between a mainframe and 30 workstations.
¨ Designed and implemented an Oracle system that controlled the entire operation of a trash compacter remotely.
¨ Set up and developed Prime's Oracle Training Department and as the Principal Oracle Lecturer / Trainer trained Fortune 500 companies nationwide.
¨ Advised the Parts Department of General Electric Jet Engines on the conversion of their system from Cobol to Oracle 5.0 and dramatically reduced the number of mini-computers running the system from 350 to 20.
¨ Designed an Oracle database for the Bureau of Land Management in Colorado and Alaska, converting their system from IBM RPG Cobol to Oracle 6.2.
¨ Advised the US Navy on converting a Cobol system to Oracle 6.2.
¨ Software / Programming Languages: Oracle versions 5.0, 6.x, 7.x, 8.1.x, 9i, 10g, 11g; SQL*PLUS; PL/SQL; Active Server Pages; Visual Basic; JavaScript; HTML; SQL*Forms; SQL*Reports; C; Cobol; Fortran; Prime-Info; Pick Data-Basic; Microsoft Quick-Basic; XML; XSLT; Xpath; DOM; Java; JSP.
¨ Hardware / Operating Systems: Windows NT, 95, 98, 2000; Linux; Solaris/Unix; Xenix; Irix; Primos; IBM; DOS; Novell; OS/2; Lanserver.
¨ Training Courses Offered: Oracle DBA, Oracle Performance Tuning, Oracle SQL*PLUS, Oracle Backup and Recovery, Oracle 9i new features.
¨ Citizenship: US citizen with the right to live and work in Britain.