Es En Fr Languages     .txt .pdf .docx Formats
Avigaël Lévy	email Contact me

---

Profile

Graduated from Épita (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: Object Developer and Designer Software Architect Consultant Technical Project Manager RDBMS Developer, Designer and DBA DevOps Database Administrator Enterprise Architect Bilingual (French/English)

Projects and teams from 1 to more than 100 people Diverse hardware and software architectures, languages, IDE, databases, middleware 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: Software Architect Senior Designer/Developer Technical Project Manager Database Administrator 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	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
Languages C, C++, Java, XML, Fortran, Ada Lisp, Prolog, Smalltalk SQL, PL/SQL, Pro*C, O2 C, OQL Shell, DCL, sed, awk, Ant Perl, PHP, HTML, CSS	Design, Development, BI and Enterprise Architecture 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 Objects, Cognos Connection, Framework Manager, Powerplay Transformer Iteraplan
Systems/Network Configuration, Administration and Monitoring CA TNG Unicenter, HP OpenView, BMC Patrol, Remedy, Nagios, Cfengine Oracle Enterprise Manager	Database Backup and Restoration Legato NetWorker Oracle Recovery Manager (RMAN)

Career path

Since Nov. 2009:	DevOps DBA and Enterprise Architect Loto-Québec, development and operations of provincial lotteries – over 7,000 people
Sept. 2008 – Oct. 2009:	Senior Database and Product Architect Interfacing Technologies, BPM software editor – 25 people
Feb. 2007 – July 2008:	Senior Developer and DBA Radialpoint, VAS solutions provider for the largest North American and European BSPs – 130 people
Apr. 2006 – Feb. 2007:	Senior Developer and DBA Jesta I.S., apparel and footwear industry software editor – 85 people
Oct. 2005 – Apr. 2006:	Business Intelligence Technical Analyst Loto-Québec
June 2000 – Sept. 2005:	Oracle Operational DBA – Technical Architect – Business Analyst Equant, the leader in worldwide business communications, subsidiary of France Télécom – over 9,000 people
Nov. 1998 – Apr. 2000:	Oracle Developmental DBA Société Générale, the third French bank – 93,000 people
Sept. 1996 – Oct. 1998:	Oracle Designer and Developer Adways, joint venture Havas / Reuters, advertising market software editor – 50 people
May 1996 – Aug. 1996:	Consultant Bull, computer manufacturer and IT service integrator (customer services) – 8,000 people
	Technical Architect EDF GDF Services, service subsidiary of French national electricity and gas operators – 200,000 people in total
Jan. 1995 – Apr. 1996:	Systems Analyst – Technical Project Manager Caisses d’Épargne, the fifth French bank – 55,000 people
Mar. 1994 – Dec. 1994:	Design Engineer – Technical Expert – Repository Manager France Télécom, historic French national telecom operator – 200,000 people
Jan. 1993 – Feb. 1994:	Development Engineer Bull (insurance division)
Jan. 1992 – Dec. 1992:	Development Engineer CEA, French government-funded technological research organisation managing and supervising civil and military nuclear energy programs – 15,000 people

Loto-Québec, Montreal

DevOps DBA and Enterprise Architect

• Member of a central team of developmental/operational, BI-oriented DBAs
  • Mainly in charge of database setup, design, maintenance, support for a strategic development project
  • Participate in several other projects and support activities, including a technological migration to Oracle 11g / HP-UX
  • Create a “Swiss Army Knife” DevOps 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
  • Pilot for the design and the deployment of an enterprise architecture repository based on Iteraplan EAM software
  • 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

[ Career path ]

Interfacing Technologies, Montreal

Senior Database and Product Architect

• Single point of contact for all database-related activities, for two BPM products, and three different RDMS, notably:
  • Participate in product architecture brainstorming sessions
  • Review current database model and propose a gradual approach for implementing major enhancements
  • 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
  • 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
  • Bring in the use of stored procedures
  • Help development by centralizing database changes, discussing design and answering coding questions
  • Help marketing by redesigning and implementing reporting databases and related BI framework models
  • Help QA and support by checking/fixing/migrating specific customer databases

• Windows XP, 2003 Serveur
• RDBMS: Oracle 9i/10g, MySQL 5.0, SQL Server 2005
• PowerDesigner, JBoss Application Server, Cognos Framework Manager, Cygwin, Ant, Java, Eclipse, CVS

[ Career path ]

Radialpoint, Montreal

Senior Developer and DBA

• As an Oracle DBA
  • Achieve day-to-day operational database administration, proactive monitoring and support
  • Participate in 24/7 on-call rotation
  • Plan and execute database server upgrades, and database backup and recovery
  • Design and implement new standards, procedures and supporting scripts for Oracle installation and administration
  • Test, review and execute major applicative upgrades in a highly concurrent transactional environment
  • Set up a large replication and data warehouse database
  • Help the development team with performance tuning and code rewrites
  • Create, maintain and upgrade development, QA, integration and pre-production database environments

• As a Senior Developer, within the BI development team
  • Participate in collaborative design discussions, development process decisions, architecture choices, and peer code reviews
  • Standardize BI tool usage; rewrite and streamline existing code, for better quality and maintainability
  • 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, Framework Manager

[ Career path ]

Jesta I.S., Montreal

Senior Developer and DBA

• 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

[ Career path ]

Loto-Québec, Montreal

Business Intelligence Technical Analyst

• Analysis, design and development of a generic utility purging Loto-Québec 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

[ Career path ]

Equant, London

Operational DBA – Technical Architect – Business Analyst

• Oracle database administration related activities
  • Design and implement in several data centers a standardized operational environment for Oracle production databases on Unix platforms: develop a comprehensive set of DBA scripts and utilities and implement a CVS version control system repository for organizing, centralizing, updating and deploying generic or specific modules onto production database servers;
  • Design, code and maintain an industrial cross-platform backup management tool based on Oracle Recovery Manager and Legato Networker (RMAN catalog fail over, automatic compilation of RMAN stored scripts, single parameter file per data center, archived log backup validation, monitoring and troubleshooting scripts...);
  • Clone, migrate, tune and optimize Oracle databases;
  • Periodically install and upgrade database and application server software;
  • Within the framework of a global DBA team, coordinate Oracle backup standardization across all Equant data centers worldwide;
  • Implement a standby database and a Weblogic application server for a critical disaster recovery project;
  • Realize day-to-day DBA tasks: database administration, proactive monitoring and support.
• Other projects and achievements
  • 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;
  • Lead the development of an internal hardware/software inventory application for London data center, combining manual and automated data loading/access tools;
  • 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
  • Give recommendations to internal and external development teams regarding database and software upgrade procedures;
  • Assist (level 2 support) UK end-users with local groupware and document management software.

• Context: UK Data Center
• 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 Recovery Manager

[ Career path ]

Société Générale, Paris

Oracle Developmental DBA

• 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

[ Career path ]

Adways, Paris

Oracle Designer and Developer

• Design and implement a multimedia database merging different providers’ data (TV, radio, press), accessed by ad 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

[ Career path ]

BULL, Paris

Consultant

• Pre-sales
• Technical architecture and studies
• Technical audit
• Developers’ mentoring and coaching

[ Career path ]

EDF GDF Services, Paris

Technical Architect of a telecom and data management system

• 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

[ Career path ]

Caisses d’Épargne, Paris

Systems Analyst – Technical Project Manager

• 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

[ Career path ]

France Télécom, Paris

Design Engineer – Technical Expert: NSDK/2 – Repository Manager

• 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

[ Career path ]

BULL, Paris

Development Engineer

• Design, develop, install and present a multilingual customer care database intended for banking and insurance companies

• Object Database Management System: O₂
• Unix server (DPX/20) and X Terminals (X11/Motif)

[ Career path ]

CEA, Paris

Development Engineer

• Develop a program for checking the validity of French nuclear stations security control software

• Constraint Programming
• VAX/VMS
• Fortran, Prolog, Assembler

[ Career path ]

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

---