(Parisian Transport I was in charge of the administration of the company databases.
In the production site, as senior database administrator, I was responsible for:
maintaining and supporting multiple Oracle instances 7 to 9i
installing Oracle RDBMS 8.1.7 9.2 on UNIX / W2000,
Migrating Oracle databases 7.3.4 to 8.1.7.
Monitoring and tuning Pro-active scripts + BMC tools.
Backup and recovery (tivoli + rman).
Some SQL-SERVER 6.5/7 tasks, Installing / Monitoring).
UNIX HP/SOLARIS/AIX. Windows NT/2000.
Oracle Ver 9.2, 8.17, 7.3.4
Philip Morris (Melbourne, Australia)
mai 2000 - janvier 2002
With Philip Morris Information Systems for ASIA, our team looked after the Oracle, SQL Server and SYBASE databases.
- 50 Oracle instances (300G) on AIX, NT, W2K version 7.3.4 and 8i.
- 15 SQL Server databases version 6.5 and 7.
- 5 SYBASE on Unix AIX.
My position was as DBA for both production and development environments. Specific duties included:
- Installation of Oracle 8.1.6 and 8.1.7 on Unix (AIX) and NT. Design set up sizing for DEV/TEST/PROD.
- Migration of Oracle 7.3.4 to 8i and Designer 1.3.2 and 2.1.2 to 6i.
- Backup and recovery, I implemented/designed/developed a backup strategy using Control/M, TIVOLI.
- Monitoring of database, security, tuning, and performance.
- Sizing and space monitoring.
- Support / consultant for the development teams.
- Maintenance and support for forms 4,4.5 and reports 2.5.
- Database installation for software like SIEBEL/DATASTAGE/BO/LIMS.
- SQL Server.
- Installations version 6.5/7
- Set up/sizing
- Monitoring (performance)
- I created and maintained backup procedures and implemented this functionality across all SQL Server databases to comply with company requirements.
- Validation Schema.
- SYBASE – I provided second level support.
In addition to the above I also designed applications using Designer 2000 (data modeling).
Oracle versions 7.3.4, 8.1.X Designer 2000 (version 2.1.2,6i),
SQL Server versions 6.5 and 7, SYBASE version 11.9.2.
BMC: SQL backtrack, Patrol, Control M
IBM: ADSM / TIVOLI
OS: NT UNIX AIX
IBM / SSIA (Riga, Latvia)
février 1999 - novembre 1999
On this project I was a team leader in charge of the development for the National Social Security of Latvia.
I performed the analysis for both the Contribution System and the Personal Account System for use by the entire country (2.5 million people). Then I took charge of the database administration for the Development team and Designer 2000 administration. This function also included version control.
Windows NT oracle version 8.05 and Designer 2000 version 2.1.2
EDS / PPG SUN Micro systems
septembre 1998 - janvier 1999
At EDS, I assisted the DBA team in the maintenance and installation of ORACLE FINANCIALS.
During my time at Sun Micro systems in France, I performed the auditing of different Databases, ORACLE Version 7 or 8. The audit was done in order to improve the performance and the security of the databases. My role also included providing assistance to the DBA.
UNIX SOLARIS,
Oracle versions 7/8.
France Telecom (Paris)
novembre 1997 - juillet 1998
- As a consultant, I was in the maintenance team as a DBA solving all problems on ORACLE (administration).
- I also performed/monitored the loading of the different Data warehouses for the company.
- Maintenance of many applications including programs in C and Forms 2.3.
- Production support for the rating and billing system for the network services 200G database
System ARIA module in pro-c and PL/SQL.
UNIX HP/SCO, BULL, NT Oracles versions 6/7.
Step To Web (Tremblay En France)
janvier 1997 - octobre 1997
As I was very interested by the Web, I created Step To Web, an entity to provide services on the INTERNET. I was in charge of the network, the Web server (Netscape) and the development of the applications.
Windows NT: IIS Web server
Netscape Web Server
Perl /HTML / Java
Hannover Insurance (Paris)
septembre 1993 - octobre 1996
Software integration: POLIS 2000.
Migration from databases ORACLE to INGRES, VMS to Unix.
I integrated this German insurance company to recreate the whole insurance application (SIEMENS, COBOL) to Digital, ORACLE tools forms V2 V3 reports. As a data modeler and developer with the direction of accounting management, I developed the cashing system and the legal reports for the insurance premium. Then I developed the application for the claim department and the broker’s accounts for the company, and also the premium statistics application.
ORACLE V6 forms 2,3, RPT,
VAX VMS
INGRES
UNIX Digital / OSF /
COSI SSII (Clichy Sur Seine)
septembre 1990 - décembre 1991
For COSI Company (IT) and for OPAC (estate Agency) I performed a programmer role. I participated in the integration of DOMUS Estate software. I also completed the statistics for the tenants and the applicants along with water management
Software integration: DOMUS.
ORACLE V6 forms 2,3, RPT,
VAX VMS.
ORACLE
aujourd'hui
Installation D’Oracle 8.1.6 et 8.1.7 sur serveurs Unix (AIX 4.3) et NT/2000.
Backup et recovery, J’ai créé une procedure de backup pour les serveurs “stand alone”.
Monitoring , sécurité, tuning, performance, migration 7.3.4 vers 8i.
support des équipes de developpement data warehouse/OLTP / internet.
SQL-SERVER
aujourd'hui
J’ai été responsable de plusieurs bases 6.5/7 sur serveurs NT/2000.
J’ai créé une procédure de backup (batch) pour répondre aux normes de Philips Morris utilisation de Control-M et TIVOLI ADSM.
l’installation et les backups.
Contrôle des versions.
SYBASE J’ai fournis un support pour l’administration des databases, sizing, refresh.
Langues
Anglais - C2
Autres compétences
Education
University computer diploma
High school
Languages
English
French
Technical Knowledge
SYSTEMS: DPS7, OPEN VMS, Win NT 4 Server, UNIX, and Linux
LANGUAGES: C, COBOL, SQL-PLUS, PL-SQL, T-SQL, and JAVA
RDBMS: ORACLE version 5,6,7,8,8i (PRO*C, PRO*Cobol, FORMS, RPT.)
DBA Production development.
DESIGNER 2000 /Administration version 2.1, 6i.
SQL-SERVER version 6.5 and 7
SYBASE version 11.9.2