Avigael Levy message@avigael.info http://cv.avigael.info/CV-Avigael-en.html ======= Profile ======= * Graduated from Épita, Paris (School of Computer Science and Advanced Technologies) in 1992 - IT Engineer, AI major (equiv. Master's in Computer Science) * Oracle DBA Certified Professional * More than 20 years IT experience: o Object Developer and Designer o Software Architect o Consultant o Technical Project Manager o RDBMS Developer, Designer and Administrator o DevOps DBA o Enterprise Architect * Bilingual (French/English) * Projects and teams from 1 to more than 100 people * Diverse hardware and software architectures, languages, IDE, databases, tools * Industries - Telco, Banking, Insurance and Communication * Employers - start-ups, medium-size companies, blue chips * Full project life cycle, from pre-sales and requirements definition to operational support and monitoring ===================== Amongst my objectives ===================== * Manage people and/or be a technical reference and a mentor * Assume a transversal or support role in a development project as a: o Software Architect, o Senior Designer/Developer, o Technical Project Manager, o DBA, o QA Expert... or act as a Consultant * Work for an IT provider (Software editor, Consulting firm, Integrator, R&D company, ISP, ASP) or at least for a company for which information systems play a strategic role (Telco, Finance, Logistics...) * Company size indifferent =================== Professional skills =================== * Very fast learner * Problem solver * Quality driven * Self-motivated * Well organized * Goal oriented * Customer focused * Committed * Calm under pressure * Can do attitude * Interpersonal skills * Team spirit ================ Technical skills ================ Operating Systems ----------------- * Unix (AIX, Tru64, Solaris, HP-UX, Linux, Mac OS X) * Windows (3.1 to 7) * VMS, OS/2, Mac OS, MS/DOS Languages --------- * C, C++, Java, XML, Fortran, Ada * Lisp, Prolog, Smalltalk * SQL, PL/SQL, Pro*C, O2C, OQL * Shell, DCL, sed, awk, Ant * Perl, PHP, HTML, CSS Systems/Network Administration and Monitoring --------------------------------------------- * TNG Unicenter, HP OpenView, BMC Patrol, Remedy, Nagios, Cfengine * Legato NetWorker, Oracle OEM & RMAN Database Management Systems and Middleware ------------------------------------------ * Oracle 7/8/8i/9i/10g/11g/12c (Developer, Designer, DBA) * MS SQL Server, MS Access, MySQL * AIRS (Multimedia Retrieval System) * O2 (Object DBMS) * Tuxedo, Apache, OAS, OC4J, WebLogic, JBoss, WebSphere Design/Development tools ------------------------ * NSDK, NSDK/2, Natstar, PowerBuilder * Eclipse, Visual C++, Visual Basic, Hypercard * Confluence, JIRA * SQL*Plus, Toad, PL/SQL Developer * Visual Source Safe, ClearCase, CVS, PVCS, Git * PowerDesigner, ERwin, Objecteering/UML Business Intelligence, Reporting and Enterprise Architecture ------------------------------------------------------------ * Business Objects * Cognos Connection, Framework Manager, Powerplay Transformer * Iteraplan =========== Career path =========== Since Nov. 2009: DevOps DBA and Enterprise Architect (Montreal) ---------------------------------------------------- Loto-Québec, development and operations of provincial lotteries - over 7,000 people * Member of a central team of developmental/operational BI-oriented DBAs o Mainly in charge of database setup, design, maintenance, support for a strategic development project o Participate in several other projects and support activities, including a technological migration to Oracle 11g / HP-UX o Create a "Swiss Army Knife" Ant-based Perl tool for Oracle database structure configuration and change management, taking into account various needs and constraints such as environment type diversity, technological resource shortage requiring schema consolidation and/or duplication, database component dependencies, OS/database setup discrepancies, protean project team * Enterprise Architect o Pilot for the design and the deployment of an enterprise architecture repository based on Iteraplan EAM software o Participate in business-oriented and technology-oriented enterprise architecture round tables * Windows XP/2003/2008/7, HP-UX 11i, Red Hat Linux * Oracle 11g/12c, PowerDesigner, ClearCase, ClearQuest, PL/SQL Developer * Agile development, DevOps, IBM WebSphere, Cygwin, Perl, Git Sept. 2008 - Oct. 2009: Senior Database and Product Architect (Montreal) ------------------------------------------------------------- Interfacing Technologies, Business Process Management software editor - 25 people * Single point of contact for all database-related activities, for two BPM products, and three different RDMS, notably: o Participate in product architecture brainstorming sessions o Review current database model and propose a gradual approach for implementing major enhancements o Industrialize database build and deployment processes and fix and consolidate database initialization scripts: ensure data type and naming consistency while managing database peculiarities, improve DB script maintenance using a combination of templates and properties, review database security and storage o Reengineer database upgrade process within the context of Agile Scrum development constraints: create DB version repository; implement a nested, nonlinear and automated approach of database changes, allowing to apply individual changes on distinct project branches, and executing pre- and post-upgrade tasks using database system dictionaries; create database catalog export scripts, producing comparable outputs for every RDBMS, helping to ensure the equivalence between a newly created database and a database having been migrated from a previous version o Bring in the use of stored procedures o Help development by centralizing database changes, discussing design and answering coding questions o Help marketing by redesigning and implementing reporting databases and related BI framework models o Help QA and support by checking/fixing/migrating specific customer databases * Windows XP, 2003 Server * RDBMS: Oracle 9i/10g, MySQL 5.0, SQL Server 2005 * PowerDesigner, JBoss Application Server, Cognos Framework Manager, Cygwin, Ant, Java, Eclipse, CVS Feb. 2007 - July 2008: Senior Developer and DBA (Montreal) ----------------------------------------------- Radialpoint, Value Added Service solutions provider for the largest North American and European Broadband Service Providers - 130 people * As an Oracle DBA o Achieve day-to-day operational database administration, proactive monitoring and support o Participate in 24/7 on-call rotation o Plan and execute database server upgrades, and database backup and recovery o Design and implement new standards, procedures and supporting scripts for Oracle installation and administration o Test, review and execute major applicative upgrades in a highly concurrent transactional environment o Set up a large replication and data warehouse database o Help the development team with performance tuning and code rewrites o Create, maintain and upgrade development, QA, integration and pre-production database environments * As a Senior Developer, within the BI development team o Participate in collaborative design discussions, development process decisions, architecture choices, and peer code reviews o Standardize BI tool usage; rewrite and streamline existing code, for better quality and maintainability o Implement new features, write documentation, help with applicative builds and QA testing * Oracle Unbreakable Linux (Red Hat based), Windows XP * Oracle 9i/10g, MySQL 5, Oracle E-Business Suite, BEA WebLogic, Apache, Perl, PHP, Nagios, Cfengine * Agile development, JIRA, Confluence, J2EE, Ant, Java, XML, Eclipse, CVS * Cognos Connection, Powerplay Transformer and Framework Manager Apr. 2006 - Feb. 2007: Senior Developer and DBA (Montreal) ----------------------------------------------- Jesta I.S., apparel and footwear industry software editor - 85 people * Involved in the development of a web-based accounting application (GL, AP, AR), integrated with core retail and sourcing and demand systems: design, coding, patch creation... * Participate in addressing corporate technical challenges: choice of design/development tools, development process improvement, technical architecture, generic utilities, etc. * Support and training on Oracle tools * Internal and external database creation/cloning (Unix, Windows) * AIX 5.3, Windows XP * Oracle 10g (database, application server), Oracle Containers for J2EE (OC4J), PVCS, ERwin, PL/SQL Developer Oct. 2005 - Apr. 2006: Business Intelligence Technical Analyst (Montreal) -------------------------------------------------------------- Loto-Québec, development and operations of provincial lotteries - over 7,000 people * Analysis, design and development of a generic utility purging Loto-Québec's data-warehouse databases, based on numerous PL/SQL packages for: monitoring, logging and debugging treatments; parsing and executing dynamic SQL code, especially DDL statements; querying database's dictionary; etc. * Windows NT4 & XP * Oracle 9i, PowerDesigner, ClearCase, ClearQuest, PL/SQL Developer June 2000 - Sept. 2005: Operational DBA - Technical Architect - Business Analyst (London) -------------------------------------------------------------------------------- Equant, the leader in worldwide business communications - over 9,000 people * Oracle database administration related activities o Design and implement in several data centers a standardized operational environment for Oracle production databases on Unix platforms, using a CVS repository for organizing, centralizing, updating and deploying chosen scripts and utilities onto each server node; o Design, code and maintain an industrial cross-platform backup management tool based on Oracle RMAN and Legato Networker; o Clone, migrate, tune and optimize Oracle databases; o Periodically install and upgrade database and application server software; o Within the framework of a global DBA team, coordinate Oracle backup standardization across all Equant data centers worldwide; o Actively participate in a critical disaster recovery project; o Realize day-to-day DBA tasks: database administration, proactive monitoring and support. * Other projects and achievements o Define requirements, evaluate and choose design/development tools, perform business analysis and technically sketch out an in-house groupware application to be used by customer-facing teams setting up and upgrading network hardware and services for UK business clients; o Lead the development of an internal hardware/software inventory application for London data center, combining manual and automated data loading/access tools; o Design and develop a cross-platform application-monitoring tool, interfaced with an alert notification system and a KPI database. * Internal consultancy and support for the UK business unit o Give recommendations to internal and external development teams regarding database and software upgrade procedures; o Assist (level 2 support) UK end-users with local groupware and document management software. * Context: UK Data Center (Equant) * Working language: English * Unix (HP-UX, SUN Solaris, Red Hat Linux), Windows NT4, Windows 2000 * Oracle 8/8i/9i, PowerDesigner, PL/SQL Developer, Netscape Communicator, Livelink, Netscape Web Server, Oracle Application Server, BEA Weblogic, HP OpenView, BMC Patrol, Legato Networker, Oracle Enterprise Manager and Recovery Manager Nov. 1998 - Apr. 2000: Oracle Developmental DBA (Paris) ----------------------------------------------- Société Générale, the third French bank - 93,000 people worldwide * Install and upgrade Oracle server on several Unix systems * Create, configure, backup, tune database instances * Help analysts to design Oracle/SQL Server databases, centralize conceptual and physical models changes * Define a common logical architecture for Oracle databases and develop low-level technical PL/SQL packages * Support the development team (design, daily DBA, coding) * Strategic project: replacement of Société Générale branches information system * Key figures: 150 people - 3 years - 35,000 MS Exchange end-users - 2,500 Intranet Web servers * Unix clusters (Compaq True64, Sun Solaris, IBM AIX), NT4 servers * Oracle 8, MS SQL Server, MS Exchange, IIS, Tuxedo, BMC Patrol, TNG Unicenter, SSO Sept. 1996 - Oct. 1998: Oracle Designer and Developer (Paris) ----------------------------------------------------- Adways, advertising market software editor - 50 people * Design and implement a multimedia database merging different providers' data (TV, radio, press), accessed by advertising agencies, helping them to choose best available marketing offers * Develop server-side data conversion and integration tools * Manage the 'server' team * Project of European standing; working language: English * Unix (HP/UX), Windows 95 and NT * Oracle 7, Exceed, Desktop DBA, S-Designor, Access, Visual C++, Visual Basic, Visual Source Safe May 1996 - Aug. 1996: Consultant - customer services (Paris) ---------------------------------------------------- BULL, computer manufacturer and IT service integrator - 8,000 people * Pre-sales * Technical architecture and studies * Technical audit * Developers' mentoring and coaching May 1996 - Aug. 1996: Technical Architect of a telecom and data management system (Paris) --------------------------------------------------------------------------------- EDF GDF Services, subsidiary of French national electricity and gas operators - 200,000 people * In charge of the technical architecture of an automated billing system for EDF GDF professional customers, interfaced with electricity meters * Object analysis and design, 3-tier Client/Server, TP Monitor, real-time processing * Unix (DPX/20 and ESCALA) and NT servers * Objecteering, AMC*Designor, Sybase SQL Server, PowerBuilder, Tuxedo, Access Master, PVCS Jan. 1995 - Apr. 1996: Systems Analyst - Technical Project Manager (Paris) ------------------------------------------------------------------ Caisses d'Épargne, the fifth French bank - 55,000 people * Design several user-friendly tools for Caisses d'Épargne marketing, around an electronic documents database to present their banking products in comparison to their competitors' offers * Manage a team of 2 developers * Client/Server Information Retrieval System * Unix (AIX), OS/2 PM, Windows NT, Windows for Workgroup and 3.x * AIRS DBMS, AMC*Designor, Visual C++, Visual Basic, MS Access, MS Word Mar. 1994 - Dec. 1994: Design Engineer - Technical Expert: NSDK/2 - Repository Manager (Paris) -------------------------------------------------------------------------------------- France Télécom, historic French national telecom operator - 200,000 people * Within a team of twelve developers, involved in the development of a client/server logistics and billing software for managing items sold or rented in France Télécom commercial branches * Second Generation Client/Server * Unix (DPX/20 AIX and PC SCO), OS/2 PM * Oracle 6, Oracle 7, NSDK/2 Jan. 1993 - Feb. 1994: Development Engineer - insurance division (Paris) ---------------------------------------------------------------- BULL * Design, develop, install and present a multilingual customer care database intended for banking and insurance companies * Object Database Management System: O2 * Unix server (DPX/20) and X Terminals (X11/Motif) Jan. 1992 - Dec. 1992: Development Engineer (Paris) ------------------------------------------- CEA, public research organization managing French civil and military nuclear energy programs - 15,000 people * Develop a program for checking the validity of French nuclear stations security control software * Constraint Programming * VAX/VMS * Fortran, Prolog, Assembler ============== Personal touch ============== Personality ----------- * Open-minded * Creative * Curious (horizontally) * Curious (vertically) Hobbies ------- * Classical and contemporary literature * Philosophy, Sci fi * Cognitive sciences * Classical, jazz and world music * Clarinet playing * Independent and art-house cinema * Mathematical and logical games * Yoga * Cycling