Rida Dkair

Projects: - Support on Exadata, ZFS, ZDLRA, MSSQL, Sybase and PostgreSQL - Oracle NNE implementation - Oracle TDE implementation - ZDLRA redo transport - ZDLRA copy to tape Commvault - ZDLRA copy to tape ZFS S3 - ZFS patching and replication - Exadata GI upgrade to 23ai - OEM Cloud Control upgrade to 13cr25 - OEM Agent GoldImage 13cr25 creation and deployment - OAS installation & configuration with OEM repository - Oracle migration Nutanix to Exadata - Exadata KVM virtual disks creation - Oracle Audit Vault implementation - MSSQL on AIX

Systems: Exadata X7 and X8, Oracle RAC on AIX Databases: Oracle 11g to 19c Intervention following a major production incident (loss of dbnode dom0 Exadata): - Reimaging dbnode - Recreation of VMs via OEDA cloning Exadata X8 extension project: - Reimaging dbnodes and cellstorages - Creation of VMs via OEDA cloning - Extensions of clusters and diskgroups - Migration of connections

Systems: Exadata X4, Oracle on AIX, ODA X9 Databases: Oracle 11g to 19c, MSSQL 2016-2022 Projects: - Massive upgrade from 11.2.0.4 to 19.12 - Massive migration from Exadata X4-2 to ODA X9-2 using dataguard to minimize the downtime - MSSQL upgrade, administration and tunning

Systems: Exadata X7, Oracle on AIX Databases: Oracle (versions 11g to 19c, N3 support) and MongoDB (level 1) Projects: - N3 support (with N1 and N2 levels in India) - Critical migration project from 11c to 12.1 on Exadata - Migrations of critical 11c databases to Oracle 19c Exa in a multitenant architecture (CDB/PDB) - Patching campaign for Exadata (KVM): VMs, cells, dbnodes, RDBMS, and databases (CDB and PDB) - Migration of databases to and from the private cloud via DataPump and Transportable Tablespaces - Security project focused on Oracle data encryption: SSL (TLS) methods and NNE - Proposal and implementation of Dataguard solutions based on needs: Dataguard with 24-hour apply lag, Active Dataguard (read-only with apply), and Snapshot Standby - On-call support for MongoDB and Oracle GoldenGate

Systems: Oracle Exadata, Windows 2008, 2012, and 2016 (physical and virtual servers) Databases: Oracle 11gR2, Oracle 12c (standalone and RAC), SQL Server 2008, 2008R2, 2012, 2014, and 2016 (standalone, cluster, and AlwaysOn) SQL Server: High availability: MSSQL mirroring, Windows clustering, and AlwaysOn Standardization policy: normalization strategy (RIBDO compliance) Setup, security, and encryption of strategic data and their backups Oracle: High availability: Oracle MAA, Dataguard, and Oracle Real Application Cluster (with ASM) in production and non-production Exadata environments RMAN, DataPump Administration, reporting, and activity monitoring via Cloud Control 13c General: Operational maintenance (Zabbix monitoring tool) Oracle and SQL Server migrations Query and process optimization (missing indexes, partitioning, compression...) Setup of ISO development, testing, and pre-production environments (database refresh)

Systems: Exadata X4-2 (participation in its setup), Windows 2003, 2008, and 2012 (physical and virtual vSphere servers) Databases: Oracle 11gR2, SQL Server 2000, 2005, 2008, 2008R2, 2012, and 2014 SQL Server: - High availability: MSSQL replication and mirroring - Management of MSSQL replications, SSIS packages, and SSRS reports - Centralized administration of SQL Agent jobs via the MSX/TSX system - Standardization policy: maintenance plans, normalization strategy - Setup, security, and encryption of strategic data and their backups Oracle: - High availability: Oracle MAA, Dataguard, and Oracle Real Application Cluster (with ASM) in production and non-production Exadata environments - RMAN, DataPump - Best practices (exachk) - Patching with Oracle Platinum and Cloud Control - Administration, reporting, and activity monitoring via Cloud Control 12c (OEM / Grid Control) General: Design and implementation of high availability solutions Migrations, writing procedures Query and process optimization Setup of ISO development, testing, and pre-production environments Writing and implementing changes (ITIL) Other skills: ZFS administration (Oracle), Oracle RAC, Business Objects, Informatica, SSAS knowledge

Systems: Windows 2003 Server and Red Hat 5 Enterprise on physical and virtual servers Management of Oracle backups with RMAN on disks and tapes (TSM) and DataPump Responsibilities and completed projects: - Migration of production databases to an Oracle 10g RAC architecture with ASM - Securing critical databases: adding Dataguard databases as part of a DR plan - Creation of an Oracle 11g Grid Architecture RAC model with ASM on RedHat - Creation of dashboards (Business Object XI R2) and distribution of decision-making reports - Management of EAI, ETL, and EDI exchanges (TradeXpress Generix, DataExchanger, Talend)