Adil ANDALOUS

DBA referent within database administrators team composed of 10 people: • Administration and maintenance of open source databases for Non-production and production environments • L2 & L3 support for dev teams including performance troubleshooting and support for writing efficient SQL & NoSQL queries. • Migration and version upgrading of database from/to PostgreSQL Community & EDB • Administration and maintenance of replicaset & sharded MongoDB clusters • Tuning & performance troubleshooting of PostgreSQL & Mongodb clusters • Monitoring & alerting with Graphite/Prometheus/Grafana and Checkmk • Participation of project of aws cloud s3 backups (PostgreSQL archive WALs) in buckets with s3cmd and s5cmd • Terraform & Ansible deployments for the Openstack Canonical infrastructure. • Participation of migration from OpenstackSalt to Private Cloud Openstack Canonical. • Participation of new deployments of some PostgreSQL and MongoDB databases with Kubernetes. TECHNICAL ENVIRONMENT: LINUX UBUNTU, REDHAT LINUX, OPENSTACK CANONICAL, BASH, SQL, PL/PGSQL, PL/SQL, ORACLE 12/19C, RMAN, AWR, OEM, POSTGRESQL 11/14, ENTREPRISEDB POSTGRESQL, POSTGRESQL LOGICAL REPLICATION, ANSIBLE, TERRAFORM, GITHUB, GITLAB, DOCKER, KUBERNETES, GRAFANA, GRAPHITE, PROMETHEUS, CHECKMK, PGBADGER, MONGODB 4/5, MONGODB HATCHET, MONGODB REPLICASET & SHARDING, AWS S3

Database referent within the Digital Technical Division, a unit that builds all the digital projects: Within the SRE (Site Reliability Engineering) team composed of 5 people, which integrates aspects of software engineering and applies them to infrastructure and operational problems, I was required to work independently or in a team on various projects: • SQL Database optimization (PostgreSQL, MySQL, MariaDB), • Schema modeling, assistance to developers to write powerful queries, • PostgreSQL architecture migration from Google’s compute Engine to Cloud SQL, a service managed with PG logical replication, • Maintenance of Redis machines on the Google Memorystore Cloud • Monitoring PostgreSQL servers with Google Stackdriver • Implementation of logging management with Google-fluentD • Implementation of Google alerting from the analysis of data from Stackdriver and FluentD • Project study of migration of monitoring and alerting to Grafana/Prometheus • Migration of GCP databases resources to AWS platform, AWS RDS and Amazon Aurora PostgreSQL & MySQL • Development of PL/pgSQL scripts for automation of DDL replication through PostgreSQL schemas • Automation of backup/restore within GCP of PostgreSQL database dumps, with Google Cloud Scheduler, Cloud Function, Pub/Sub topic and Python functions • Automation of getting OS info of remote servers by writing Python script. TECHNICAL ENVIRONMENT: LINUX DEBIAN, REDHAT, CENTOS, BASH, GOOGLE CLOUD PLATFORM (GCP), COMPUTE ENGINE, CLOUD SQL, AMAZON WEB SERVICES (AWS), AWS RDS, AURORA, MEMORYSTORE, POSTGRESQL 10/11/12/13/14, POSTGRESQL LOGICAL REPLICATION, ANSIBLE, KEEPALIVED, HAPROXY, MYSQL 5.7, GITHUB, DOCKER, REDIS, RABBIT MQ, GOOGLE PUB/SUB, GOOGLE STACKDRIVE1R, FLUENTD, GRAFANA, PROMETHEUS (PMM)

Database referent within the infrastructure team composed of 7 people: • Administration and exploitation of Linux servers which hosting databases, • Provide support and optimization of databases and linux servers, • PostgreSQL cluster setup in all environments until production, • Implementation of high availability PostgreSQL, with backups, "streaming replication" and archiving of WALs, • Maintenance of MySQL / MariaDB servers with high availability: « Master/Slave » and Percona Xtrabackup backups • Development of the PMM solution, to centralize the monitoring of PostgreSQL, MariaDB, MySQL and MongoDB databases as well as alerting under PMM and Icinga • Maintenance of some Oracle database servers 11g, 12c, study migration to PostgreSQL • Internal technical documentation on Github • Automatic deployment of database servers with Ansible • Upgrading of the MariaDB databases to 10.5, implementation of partitioning. • Migration of several INFORMIX databases to PostgreSQL • Study of an architecture with MongoDB 4.2 for the implementation of a NoSQL database with high availability. • Built databases architectures with Docker • Test of RMAN recovery scenarios as part of migration from EMC Networker to Cohesity TECHNICAL ENVIRONMENT: LINUX REDHAT 6/7/8, VMWARE, POSTGRESQL 12/13, PROXYSQL, PERCONA MONITORING AND MANAGEMENT (PMM), ANSIBLE, KEEPALIVED, REPMGR, MARIADB 10.1, 10.5, MYSQL 5.7, ICINGA, ORACLE 11G/12C,RMAN, GITHUB, PERCONA XTRABACKUP, MONGODB 4.2, DOCKER

PostgreSQL referent within a team of 7 DBA production: • Keeping some twenty PostgreSQL 9.6, 10 and 11 instances in operational condition with several Terabytes of data, • Upgrading PostgreSQL clusters, • Implementation of the backup and restore and PITR with pgbackrest, Xtrabackup and mariabackup, • Referee and trainer of the new industrialization process (Liquibase / Docker / TFS) • Setting up a connection pool manager with SSL (PgBouncer) • Implementation of "Streaming Replication", "Archive log shipping" and "Replication slots" for high availability with repmgr tool • Setting up secure tcp/ip connections with SSL and LDAP authentications • Manage the performance of PostgreSQL instances using pgbadger. • Scripting recurring tasks (Creation of Databases, Users, Tool Installation). • Implementation of monitoring and alerting with Zabbix and Percona monitoring management using Grafana, • Maintenance of an internal tool written in Python for the routine automation of tasks of the DBA, in an extension of POWA, the DALIBO tool for monitoring databases. • Implementation of automatic configuration deployment of platforms hosting PostgreSQL databases with Ansible. • System Optimization, PostgreSQL and SQL • Creation, implementation, and documentation of PostgreSQL architectures • Optimization of SQL queries and stored procedures, query plan analysis, advanced PL / pgSQL writing • Maintenance of MariaDB databases servers for 1001pneus.fr • Migration of MySQL databases to mariaDB for upgrading Zabbix server • Designed, Installed, and configured a multi-node MongoDB sharded cluster and replica sets on Linux. TECHNICAL ENVIRONMENT: POSTGRESQL 9.6, 10, 11, KORN SHELL SCRIPT (KSH), PYTHON, LINUX DEBIAN, PL/PGSQL, PGADMIN, ZABBIX, PERCONA MONITORING AND MANAGEMENT (PMM), GRAFANA, POWA, ANSIBLE, REPMGR, PGBADGER, SQL SERVER, POSTGRES-XL, CITUS, MYSQL 5.7, MARIADB 10.4, MONGODB 4.0

4 people team Intervention in the Product Integration in Production (IPP) department, which deploys different components of the products on the environments from recipe to production, coordinates repetitions in pre-production and installations of functional and technical versions in production. • Management, migration and administration of more than 400 Oracle databases dedicated to different environments (from development to production), • Experience with the administration and maintenance of about 50 database servers hosting PostgreSQL clusters, • Installation, configuration and administration of some MongoDB instances on Linux. Technical environment: SQL, PL/SQL, PL/PGSQL, KORN SHELL SCRIPT (KSH), AIX, LINUX, ORACLE 12C / 11G, RAC, ASM, GRID, POSTGRESQL 10.1, PGADMIN, OEM CLOUD CONTROL 12C, SQL DEVELOPER, SQL PLUS, RMAN, DATAGUARD, GOLDEN GATE 12C, MONGODB 3.X

6 people team Within Information, Technology and Process Department (ITP), which consists of more than 600 project managers working on information technologies, within the "Methods, Engineering and Support" department, the DBA supports the application teams from the preliminary study to the start of production, to provide long-lasting, efficient applications and control of operating costs. • Management, migration, and administration of more than 150 Oracle databases dedicated to different environments (from development to production), • Management and administration of some PostgreSQL instances migrated from Oracle Technical environment: SQL, PL/SQL, PL/PGSQL, UNIX SHELL SCRIPTING, AIX, LINUX, ORACLE 11G/12C, RAC, RMAN, DATAGUARD, POSTGRESQL 9/10.X, PGADMIN, ORA2PG, SQL DEVELOPER, OEM CLOUD CONTROL (12C), GOLDEN GATE 12C, SQL PLUS, MEGA.

20 people team Intervention in the DBA team where I was responsible for the administration of the development and validation databases, Involved in the development team which manages batches for stolen vehicle tracking and usage-based insurance solutions, I’m also responsible for different technical deliveries in development database environments including database administrator tasks. Technical environment: SQL, PL/SQL, KORN SHELL SCRIPT, AIX, LINUX, ORACLE 11G, RAC/ASM, EXADATA X2, TOAD, SQL PLUS, CRONTAB, POWERAMC, OEM CLOUD CONTROL 12C, RMAN, DATAGUARD, GOLDEN GATE 12C

15 people team Intervention in the Cobalt team which control all the operations carried out by the traders of the SGCIB Technical environment: ORACLE 11G, TOAD, SQL-PLUS, ORACLE SQL DEVELOPER, RMAN, DATAPUMP, LINUX, SQL, PL-SQL, SQL SERVER 2012(2008), ORACLE DATA INTEGRATOR 11G, TRANSACT-SQL, AUTOSYS, VBA

5 people team Involved in the development team of the Riskcube software which consists in matching authorizations and utilizations with various algorithms, it allows the business to check the respect of exposure limits (Java/Oracle/Access application) Technical environment: SQL, PL/SQL, KORN SCRIPT SHELL, ORACLE 10G, ORACLE SQL DEVELOPER, SQL PLUS, SQL LOADER, VBA, JAVA, CONTROL-M SCHEDULER, RMAN, DATAGUARD