Dba Sybase : Principaux consultants dispos et missions récentes déposées

Exemple de missions de Kamel,
Dba Sybase habitant le Val-d'Oise (95)

• DBA ORACLE

  to date SAP CONCUR France
  Jan 2019 - aujourd'hui

  Repairing the infrastructure RAC database 11.2.0.4 Linux Redhat 6
  Administration, Installation and Configuration of ORACLE instances
  Installation of RAC database 19c infrastructures from scratch
  Migration of Oracle RAC databases from 11gR2 to 19c
  Database backup configuration and strategy review
  Writing shell scripts for database maintenance
  Setup for the switch from PROD to DR Database in case of failover.
  Application of system patches on VM and Linux physical machines (CentOS/Rhel)
  Application of Oracle patches
  System administration of Linux machines hosting RAC 11gR2 and 19c instances
  Writing wiki documents for the DBA Concur team
  Training and presentation of the Oracle Concur environment to the new Oracle DBAs

  technical environment: 0racle11gR2 and 19c (Grid Infrastructure: ASM, Clusterware) Linux Redhat 6 and 7 (x86_64), Linux Cent0S 7 SolarWinds for monitoring New Relic Monitoring Tool

• DBA ORACLE-SYBASE and SQL SERVER

  NATIXIS DOSI / DSI / DFO / SAP
  Jan 2018 - Jan 2019

  Administration, Installation and Configuration of SYBASE ASE, ORACLE and SQL Server instances
  - Incident treatment and corrective measures to avoid their recurrence
  - Control, validation and delivery of structural and data changes to databases,
  - Support for production start-up requests,
  - Considering requests for specific interventions on the various DBMS technologies
  - Support for installation, administration and optimization with performance analysis of DBMS servers
  - Assistance to design teams for the control and optimization of data models and SQL queries and stored procedures
  - Participation in the system of recurrent on-call duty and shifted hours.
  - Participation in business projects
  SQL Server AlwaysOn replication setup

  Technical environment: 0racle 12c (Grid Infrastructure: ASM, Clusterware) Exadata X5.2 (full rack EF 66 TB), Sybase ASE 15.5, Sybase RS 15 SQL Server 2014 to 2017 (32 and 64 bit), OEM 12c, Windows, Linux Redhat 6 (x86_64), DBArtisan 9.5

• DBA SYBASE SQL SERVER and ORACLE

  HSBC ASSURANCE GAM & GBM
  Jan 2015 - Jan 2018

  Administration, Installation and Configuration of SYBASE ASE, ORACLE and SQL Server instances
  Study and resolution of ASE 15.0.3 / ESD # 4.4 server performance problems
  Administration Instance SYBASE IQ 12.5
  Cross-platform migration study of SYBASE instances from ASE 15.03 / Solaris10 to ASE 15.7 / Linux Redhat
  Solving performance problems on ORACLE 11gR2 instance
  Development support
  Writing technical documents
  PROD and Relief inter-site role swap operations [switch SRDF]
  Shell script and stored procedures development
  Support on SQL SERVER projects on virtualized machines:
  Applications: ASSIMA / CAPTIVA / VDI (Virtual Desktop), UNICIA

  Technical environment: Sybase ASE (12.5 15.0.3-ESD # 4.4 et 15.7 SP135), Sybase IQ 12.5/7.0.4 MS SQL Server2000 à 2014 (32 et 64 bits), 0racle [9i et 11gR2] Windows 2003, Solaris SPARC M5000/Solaris 10, DBArtisan 9.2

• Audit and Consulting SYBASE ASE Performance Problem Report (Murex)

  (2 weeks) BNP CIB
  Jan 2014 - aujourd'hui
  Technical environment: Sybase ASE (12.5.x, 15.7), Sun Solaris Sparc 64 bit, Linux Redhat

• DBA ORACLE-SYBASE and SQL SERVER

  BNP-ARVAL
  Jan 2012 - Jan 2015

  Administration, Installation and Configuration of SYBASE ASE, ORACLE and SQL Server instances
  SYBASE ASE 12.5.4 to 15.5-ESD # 2 migration under Linux Redhat
  Performance study of ASE 15.5 servers ESD # 2
  Installation and configuration of ORACLE 10gR2, 11gR2 instances
  Oracle Cassiopeia migration from 9i to 10g [cross-platform from Windows to Linux]
  Migration of Oracle 10gR2 to 11gR2 instances under Linux Redhat
  Migration of instances on the Exadata architecture [11.2.0.3 to 11.2.0.4]
  Dataguard implementation [physical on StandAlone Instance and RAC on Exadata]
  Exadata Database Machine: administration and operation
  Impact study of « unpartitioning » on a migration to the Exadata [Application: MONAC0: DWH of 1.7 TB] (Additional cost of the license on the Exadata)
  Implementation of an Automatic Schema Refresh procedure via Data Pump [DAYTONA]
  Put into production on MySQL databases
  Development support
  Resolution of production incidents
  Writing technical documents
  Shell script and stored procedures development
  On-call ORACLE, SYBASE and SQL SERVER

  Technical environment : Sybase ASE (12.5.4 and 15.5-ESD # 2), SQL Server 2000 to 2008 (32 and 64 bits), 0racle [9i, 10g and 11gR2 (Grid Infrastructure: ASM, Clusterware) Exadata X4-2 (1/4 rack HC 4TB), OEM 12c, MySQL 5.6 Windows 2000, Linux Redhat 5 and 6 (x86_64), DBArtisan 9.5

• Audit and Consulting SYBASE ASE Travel to Ghana (Accra)

  Horus Development Finance
  Jan 2012 - aujourd'hui

  SYBASE ASE 12.5.x production dataserver performance study
  Installation and configuration of a monitoring system (Deployment in other countries of the African continent)
  Infrastructure changes and tips

  technical environment: Sybase ASE (12.5.4 on HP DL380G7 - 2.66 GHz)

• DBA SYBASE ASE RS

  Crédit Agricole-CIB
  Jan 2010 - Jan 2011

  Administration of SYBASE ASE, RS servers
  Performance study of ASE servers
  Installation, Upgrade (Patches) Server ASE 15
  Portfolio DBA referent: Kondor, Murex
  Delivery of scripts from development teams on certification and production environments
  Development support
  Resolution of production incidents
  Writing technical documents
  Shell script and stored procedures development
  Penalties

  Technical environment: Sybase ASE (12.5.4, 15.0.3, 15.5), SYBASE RS 12.6, SYBASE IQ 12.7, SQL Server2005 (32 and 64 bit), 0racle 9i, Windows 2000, HP Itanium, DBArtisan 8.5

• DBA SYBASE: Migration from Sybase 12.5.4 towards Sybase 15.0.2

  HSBC PRIVATE BANK
  Jan 2009 - Jan 2020
  Technical environment: Sybase ASE (12.5.4, 15.5.x), SQL Server2005 (32 and 64 bit), Windows 2003 (32 bit) and 2008 (64 bit)

• DBA SYBASE: Audit and Consulting

  HSBC Private Bank
  Jan 2009 - aujourd'hui
  SYBASE ASE 12.0 Crossplatform migration project on 64-bit Sun Solaris to SYBASE ASE 15.0.3 on 32-bit Windows 2003

• DBA SYBASE ASE RS and IQ / MS SQL Server

  CA Cheuvreux
  Jan 1999 - Jan 2009

  Administration of SYBASE ASE, RS and MS SQL SERVER servers
  Delivery of scripts from development teams on certification and production environments
  Development support
  Resolution of production incidents
  Writing technical documents
  Penalties

  Technical environment: Sybase ASE, 12.5.4, SYBASE RS 12.6, SYBASE IQ 12.7, SQL Server2005 (32 and 64 bits), 0racle 9i, Windows (2000,2003), Linux Redhat 4 AS / ES (64 bits), Power AMC V. 9.0.0