Laila Filali

• Maintenance of a large Oracle Database infrastructure in a Unix Environment using Solaris Clusters.
• Database configuration, backup-restore +copy (online copy).
• Migration (10.2.0.4), moving database (between servers)
• Tuning of SQL statements executed by applications of Oracle IFS
• Support of additional software components (RMAN, Oracle Names, Oracle Internet Directory) including the usage of ITIL / Best Practice Methods
• Installation, Maintenance a Linux system (Red Hat)
Tools: Putty,Refexion, KDE, Sqlplus, SMT,dbua, dbca

• Administration Oracle10g: management & tuning / AIX & Solaris
• Troubleshoot connection problems on the client, middle tier, monitor and tune the database (traces, stats)
• Configure RMAN backup settings (TDP, BackupExec TNG, script shell)
• Implementing recovery operations
• Business Intelligence: BODI X, MEGA, Business Object (Report and Designer)
• Migration DB Oracle 9i to 10g (DBUA)
Tools: Grid Control, Toad, Sqlplus, Norad,TNG, dbua, dbca,BI V7.5

• Administration Oracle 8i, 9i & 10g / Sybase 12.5 ASE /True 64
• Installing and configuring oracle 10g software on Solaris 10 and AIX 5.3 Server
• Database management and services 10g (user, tablespace, role, permissions)
• Developed and documented procedures to monitor and reclaim fragmented space in Oracle databases
• Planned and co-ordinated monthly schema changes and data updates for all development projects and
• Database Migration Oracle from 8i to 9i and application (Sungard GPII)
• Improvement problematic issues/operations and support staff to ensure deadlines met and guaranteed
Tools: OEM, Statspack, Oracle Performance, Tuning Pack,Toad, Sqlplus, Sybase Central, SqlAdvantage

• Administration Oracle 8i, 9i & 10g / Sybase 12.5 ASE /True 64
• Installing and configuring oracle 10g software on Solaris 10 and AIX 5.3 Server
• Database management and services 10g (user, tablespace, role, permissions)
• Developed and documented procedures to monitor and reclaim fragmented space in Oracle databases
• Planned and co-ordinated monthly schema changes and data updates for all development projects and
• Database Migration Oracle from 8i to 9i and application (Sungard GPII)
• Improvement problematic issues/operations and support staff to ensure deadlines met and guaranteed
Tools: OEM, Statspack, Oracle Performance, Tuning Pack,Toad, Sqlplus, Sybase Central, SqlAdvantage

Mission: Oracle 9i Administration: Database (9i) maintenance and tuning (cpu, response time)
• Monitoring, query performance, tuning, analysis and design (StatsPack, OraPerf)
• Data processing supervision, specific improvements (Reuters), alert script processing (shell)
• Implementation of PL/SQL packages (Toad)
• Improvement of the performances by global area system tuning, datafiles, partitioning
• Reorganization of all the schema table spaces and indexes
• Writing of requirements and specifications (MSProject, Rational Rose)
Tools: OEM, Statspack, Oracle Performance, Tuning Pack, Toad, Sqlplus

Mission: Oracle 8i-9i administration: Oracle Production under AIX (4.5)
• Monitoring database system heath, identifying bottlenecks and improving system performance
• Database cloning, table level data refreshes
• Upgrading (8.1.7-> 9i), patches and cross functions issues resolution
• Investigation of Oracle Net Trace files to debug Oracle Net protocol errors
• Monitoring and logging, troubleshooting, security and script processing
• Backup and recovery (RMAN), sizing and capacity planning
• Oracle periodic patch set application
• Database standards and procedures improvement
Tools: OEM, Spotlight, Toad, Putty

Mission 1: Creation, maintenance, configuration of Oracle8i and 9i databases (Oracle reporting)
• Script development in shell and PL/SQL for data refreshment (snapshots)
• Creation of procedures, stored functions, packages, triggers in PL/SQL
• Development of Oracle alert strategy to react to database problems
• Script import/export, data load in and out of a database (SQLoader)
• Oracle tuning: SQL*DBA and Explain Plan
• Database backup, restoration and recovery

Mission 2: Maintenance and evolution of a data warehouse for telephony equipment
• Modeling of design concepts with Business Objects
• Business Objects: Users, Managers modules
• Debugging of JAVA, JSP and Servlet applications
• AIX 4.3 management

Mission: Project management CDISC
• Study to select tools to generate reports of data warehouse
• Analysis of existing architecture to gather business requirements (UML modeling)
• Requirements document (UML Methodologies, CSV)
• Responsible for the development of ETL procedures with Oracle warehouse Builder
• Creation of advanced processes to include execution of pre-defined non-Oracle scripts
• Importing of existing PL/SQL, optimization and tuning of the produced packages
• Validation tests and writing of guidelines in English
Tools: ETL (OWB), Oracle (9i), Enterprise Manager (OEM), SQL Plus

Mission: Design & administration of a Sybase database to manage user rights enabled by multiple applications
• Development of scripts (Transact-SQL), stored procedures for a web interface (PHP4)
• Creating indexes and collecting oracle optimizer statistics
• Monitoring CPU utilization and sizing the various database buffers
Tools: PHP4, TOMCAT/Linux, ODBC