Sql Server Oracle

Saïd Guettaf

DBA Oracle / SQL Server

***********@***********.***

HIGHLIGHTS OF QUALIFICATIONS:

Administration and development of Data Base Oracle v9i/10g/11g/12c and SQL Server 2000/ to 2017

Other databases : Mysql, Postgres, DB2, Mongodb

Experienced working with : Grid Control, Data Guard, TOAD, RMAN, OEM, ERwin

Administration Oracle (RAC, DATAGUARD) and SQL Server ( MIRRORING, LOGSHIPPING, ALWAYS ON) management save, update patch and service pack, security

Excellent working knowledge of UNIX AIX, HP-UX, SUN Solaris, Linux

Software : safeguards (TSM, TINA, NetBackup); Supervision (Nagios, Patrol, HP-OV); scheduling (DollarU, Control-M, OPcon), SSIS, Reporting Services

Development : Visual Basic, Pascal, C, C++, Perl, Java, Java Script, CSS, PHP, HTML, SHELL, SQL and PL/SQL

Ability to work effectively in a team by exercising strong written and verbal communications skills in three languages (French/English/Arab)

Strong analytical, planning, problem solving and decision making skills

EDUCATION

2018 Training DBA SQL Server 2017

2014 Training DBA Oracle 12c

2012 Training DBA SQL Server 2012

2008 OCP (Oracle Certified Professional) version 10g

2006 Training DBA SQL Server 2005

2005 Graduate Diploma in Computer Science, INSIA, France

2002 Bachelor in Computer Science, SIXUN Informatique, France

2001 Certification Microsoft Professional System Engineer (MCSE), France

2000 DUT Informatique spécialité GTR (Advanced diploma), France

1998 Baccalauréat Scientifique speciality SVT, France

PROFESSIONAL EXPERIENCE

2018 GROUPAMA

DBA Oracle/SQL Server/Mysql

Administration databases Oracle 9i to 12c

Administration databases SQL Server 2000 to 2017

Tools for administration: SQL Developper, GRID Cloud Control 12c, 13c, OEM, TOAD, SSMS

Set up procedure level 2 and 3

Automating task : rebuild index, statistics gathering, checkdb, save

Optimization/ Tuning SQL traitement ( analyse AWR )

Migration/ Update Version

Monitoring Cluster : DATAGUARD (oracle) + replication ALWAYS ON (SQL Server)

Configuration and automate traitement GOLDEN GATE

Other databases: Mysql, DB2, Mongodb

Availability 24h/24 week-end included

2017 POLE EMPLOI

DBA Oracle

Administration databases Oracle 9i to 12c in production and development environment. RAC and standalone

Tools for administration : SQL Developper, GRID Cloud Control 12c, 13c and TOAD

Optimisation/ tuning SQL traitement

Check whether the scheduled tasks on the production servers are running normally

Monitoring DATAGUARD

Scheduler : TWS and TWSD

Critical patch updates for Oracle products

Set up Standby database using Dataguard ( test switchover)

Migration databases 10g to 11g and 8i to 12c

Automate jobs and maintenance plans on the server (RMAN), integrity checks, automatic shrinking, transaction log backups

Monitoring tools : SuperG, BSM, NAGIOS

Spread backups across multiple backup devices residing on different hard disk drives. To improves the backup and restore performance

Ensure the evolution of technical infrastructures

Security

Installation with ORACLE VM

Connect to server using CyberArch

2016 CREDIT AGRICOLE

DBA SQL Server

Administation SQL Server 2005/2008/2012/2014

Installation, configuration new environment windows 2012 – SQL Server 2014

Supervision – ZABBIX

Solve incident ( REMEDY )

Migration ( 2005 -> 2008R2, 2008 -> 2014, Sharepoint 2010 -> 2013 )

Implement save of databases MSSQL

Develop procedures, put into production

Performing controls and operating report

New project tracking, migration and obsolescence

Installation, configuration cluster SQL Server 2008 / 2012 / 2014

Recurring tasks : checking jobs (quick3270), backup ( litespeed ), reboot, reindexation, statistcs, checkdb

Establishment job using TWS (ZOS)

Update and create execution script (SMTTraitement)

Tuning

Availability 24h/24 week-end included

2015 PUBLICIS

DBA Oracle\SQL Server\Postgres (Paris)

Administration of SQL Server databases 2012 to 2014, Oracle databases 10g to 12c and Postgres

Installation, Configuration, maintain databases environnement development, integration, pre production and production

Setting up procedure for level 1 and 2

Performance optimization

Monitoring and management of SQL Server databases ( SQL Monitor )

Save databases and environment ( Netbackup )

Management environment SSIS SSRS SSAS

Set up, test cluster, shared server

Administration databases SQL Server mirroring

Participation meeting setting infrastructure

Check scheduled maintenance task (job)

Responsible for problems related to software for web and portals (sharepoints)

Assistance in setting up a complete platforme enabling organizations to dreate and deploy solutions Business Intelligence

2014 BARCLAYS

DBA Oracle\SQL Server\DB2 (Monaco)

Administration Databases Oracle 9i to 10g, SQL Server 2000 to 2008, DB2

Application compatibility study / update database version

Installation / set up / administration GRID Control (OEM 12c)

Database High Availability (DATAGUARD – LOGSHIPPING)

Report, solve daily incident (morning check)

Performance optimization / Tuning

Set up script (LINUX ans WINDOWS) for centralization information on all database environments Oracle and SQL Server ( Production, Pre-Preoduction, Developpment, UAT )

Configuration monitoring (Nagios – Cacti - Netcool – Script alert mail)

Installation configuration maintenance DBAUtils Oracle / SQL Server

Development, integration, production launch of new applications

Architecture Documention databases / Set up procedure

Work in close collaboration with international team ( swiss, England, Singapore )

Operation carried out under control and validation of the managers and in the rules and standard cards published by Barclays

Support Level 2 and 3

Help set up databases Mysql and DB2

Availability 24h/24 week-end included

2013 MONACO TELECOM

DBA Oracle\SQL Server (Monaco)

Management integration/ development/ pre production / production

Maintain perimeter infrastucture

Monitoring using cactis, Nagios

Implementation of platform and model for test, ST, STA, SIT, UAT

Administration Databases Oracle 9i to 10g and SQL Server 2000 to 2012 (toad, oem)

Administration Virtual Machines (VMWare, VSphere)

Coordination Technical and functional support of projects and team

Setting up and provision of documentation and procedure

Setting up meeting organization with project manager / application / developer / architect

Script planning ( unix and windows ) and job SQL Server and Oracle databases for optimization of use

Decision support ( Business Intelligence )

Report, organization and study of the daily existence

2012AREVA

DBA Oracle\SQL (Chambery, France)

Installing and updating the Oracle Database server and application tools. Allocating system storage and planning future storage requirements for the database system.

Creating primary database storage structures (tablespaces) after application developers have designed an application.

Creating primary objects (tables, views, indexes) once application developers have designed an application.

Creating and managing Standby Database or other High availibility procedure if needed.

Creating and managing Oracle RAC cluster.

Understanding and analyzing PL/SQL code.

Modifying the database structure, as necessary, from information given by application developers.

Ensuring compliance with Oracle license agreements.

Controlling and monitoring user access to the database.

Monitoring and optimizing the performance.

Planning for backup and recovery of database information.

Maintaining archived data on tape.

Backing up and restoring the database.

Management of Microsoft SQL server and My SQL.

2011-2012 IBM

DBA Oracle\SQL (Nice, France)

Installing, configuring, patching, troubleshooting and supporting Oracle 9i/ 10g /11g R2 (database for Oracle eBusiness Suite R12), SQL Server 2000/2005/2008.

Implementing above server software in High Availability or cluster configuration on Unix (AIX, SUN), Windows (2003, 2008) and SAN.

Using other HA approach (eg. RAC, DataGuard)

Configuration oracle databases using Oracle Enterprise Manager, Oracle Management Packs (Diagnostics Pack, Tuning Pack and Change Management Pack) and Oracle utilities.

Oracle database performance tuning in High Available Unix and Windows environments

Unix shell scripting and utilities, tuning PL/SQL and T/SQL

Migration databases Oracle 10g -> 11g and SQL Server 2005 -> 2008

Supervision Monitoring using NAGIOS (configuration centreon)

Backup/Restore using RMAN, TSM (plug tdp for sql server) and VEEAM.

Knowledge of multiple Software Development Life Cycles

Experience with ITIL/ITSM, change management, release management

Experience with needs assessment/requirements analysis

Provide on-call support in 24/7 environment.

2010/2011 SILCA

DBA Oracle\SQL Server (Kremlin Bicetre, FRANCE)

Install, configure, troubleshoot, monitor, patch, and administrate MSSQL instances.

Consult development project leaders, architects, and Oracle administrators on database development issues.

Design and/or implement new and existing database structures.

Improve existing databases by determining users' information requirements and system performance and functional requirements.

Control and coordinate changes to the testing and production servers.

Develop and implement procedures that will ensure the accuracy, integrity, and completeness of data stored in the databases.

Develop and implement security procedures, including access control and user management.

Verify database consistency and replication of databases.

Develop and implement backups and disaster recovery procedures.

Provides solutions to complex database problems or to specific design constraints.

Provide on-call support in 24/7 environment.

Conduct performance and tuning reviews.

Assist (if required) in building databases within all environmental states (unit test, system integration, user acceptance, operational testing and production).

Monitor performance, space management, and database optimization techniques.

Develop, document and promote standards and procedures.

Evaluate new database products or versions / migration

2009/2010 AXA

DBA Oracle (6 month, LaDefense, FRANCE)

ensure performance, recoverability, integrity, security, and availability

Create and clone databases, trouble-shoot and resolve database problems.

Implement vendor packages and in-house developed databases, design and elevate database modifications, monitor and tune database availability and performance, trouble-shoot application problems.

Design, test, implement, document, and maintain database strategies and processes.

Create and maintain procedural, operational, and disaster recovery documentation.

Plan and perform database software installs, major upgrades and maintenance patches.

Work closely with application and technical analysts.

Regular on-call shifts, some evening/weekend work.

2008/2009 EXTELIA (2 years)

DBA Oracle/SQL Server (Arcueil, Aix-En-Provence, FRANCE)

Provide database administration support and tune performance of databases oracle 9i/10g and SQL Server to give optimum throughput

Analyzed the database objects using OEM and assigning and altering the profiles of the Database schemas for security purpose

Installation monitoring databases oracle and sql server using Zabbix, locally managed tables using with PL/SQL

Ensuring backups are complete using RMAN for Oracle and maintenance plans for SQL Server 2000/2005 and 2008

Migration, update of databases oracle 9i to 10g, backup optimization using with RMAN

Plan and develop efficient databases designs based on analysis of user requirements.

Writing, Modify packages containing procedures and function using with TOAD 8.5.

Analyzing and optimizing the SQL queries unto 16th level through SQL Analyzer and observing top sessions.

Reorganization of database using export/import used this feature in OEM and as well Shell scripts.

Administration Oracle RAC and SQL Server Cluster

Scheduled jobs using the cron like taking full database backup, password aging check on SQL Server 2000/2005/2008, SSIS 2005/2008, DTS 2000, Reporting Services.

Identifying and fixing performance issues related to client applications and following up with respective vendors to provide patches for identified problems.

Coordinated with developers in reviewing code for optimizing database performance during development and before going into production.

Developed complex PL/SQL functions procedures, packages and triggers to handle complicated business logic

Launch AWR stat to resolve problem, Troubleshooting and crisis management methods

Provide 7x24 support when required

2007 CARREFOUR

DBA Oracle (Massy, FRANCE)

Resolve technical incidents / Analysis of traces / Monitoring

Enforce processes, procedures and standards

Administration and maintenance of facilities and foundations of database Oracle 9i

Realization programs PLSQL and SQL *Plus/ creation script

Management of batch night by DOLLARU / Setting up report of activity

Installation of Oracle 10g on server NT&UNIX

Installation, configure and upgrade Oracle software products

Implement and enforce security for all Oracle databases

Control system capacity for existing requirements and plans for future needs

2006-2007 UNISYS (2 years)

DBA Oracle/SQL (7 months mission to BOUYGUES TELECOM in Colombes, FRANCE)

Manage and administrate databases Oracle and SQL

Formulate and implement database architecture, database standards and policies

Assist with writing procedure for support document / Phone Assistance

Develop and maintain key project deliverables such as the Applications setup documents, user roles and responsibilities

Support level 2 and 3 on Oracle 9i/ 10g and SQL server 2000 /2005

Perform database backups using both online & offline methods

Tracking and resolving bugs in the Application via the Oracle TAR process using Metalink

System Engineer (10 months mission to ORANGE in Paris, FRANCE)

Lead, coach and mentor other team member

Coordinated with developers in reviewing code for optimizing database performance during development and before going into production

Implementing databases according to production standards mostly in high availability environments

Providing support to solve production database problems and engineer production database changes

Supervise stains (job performed under Oracle) with tools Patrol

Launching batch using with DollarUniverse for backup with TINA, Net Backup

Intervention in modelling of data and optimization of requests PLSQL

Assist in performance tuning SQL / ORACLE in UAT and production environments

Provide support for database critical incident, hotline

Provide 7x24 support when required

2003-2004 TRIGONE (1 an )

DBA Oracle/SQL (4 months mission at the main office in Paris, FRANCE)

Transfer technical competences towards other members of the team

Teleprocessing of databases Oracle 9i different customers Plans

Set up script; ensure it is “user friendly”

Establish and maintain backup and recovery policies and procedures

Pulled out the DDL script to create the tables in database using ERwin.

DBA Oracle/SQL (1 year mission to CREDIT AGRICOLE in Guyancourt, FRANCE)

Install tools for reporting and monitoring of performance

working using OEM to do most of the tasks like monitoring sessions, checking sql's, database links, table space storage usage and also used oracle expert for SQL history, session tuning and Query optimizing techniques on databases.

Check on the good sequence of job under Oracle / SQL, management of databases

Communicating regularly with technical applications, and operational staff, to ensure the database integrity and security

Implements enhancements to production database

Identify improvements to perform Level 3 support

Assist users in understand Oracle Support procedures and operation

Provide database technical expertise to application developers, operations, etc. for systems development and production support

2002 ST MICRO ELECTRONIQUE

DBA Junior (Crolles, FRANCE)

Strong involvement in the project of evolution of Facilities System

Build architecture of database and optimization of requests SQL

Monitor and troubleshoot performance problems and other issues reported by clients through the Product Support organization

Installation of Oracle 9i, 8i, and 8.x databases on SUN, HP and Linux to the latest patch set in 9i (9.2.0.5)

Performed database upgrades to bring databases to the latest Oracle release levels

Implemented shell scripts to run the job schedules on crontab and experience in to setup job-scedular using with pl/sql job scheduler

Incorporate Security of facilities

Installation of database Oracle, creation of count, operational help

2000-2001 ALIS INFORMATIQUE (1 year in Paris, FRANCE)

Service Engineer (contract of qualification: stage)

Provide input to the Project Manager in the development of the Project plan and identify process mapping, gaps and customization requirements

Resolution technical / coherent incident

Write procedures about architecture SQL server 2000

Provide Telephone Assistance

Contact this candidate