You're seeing this page as if you were . The main menu is still yours, though. Exit from immersion
Youssef M’sallaYM

Youssef M’salla

Senior DBA · SQL Server · PostgreSQL · IBMi DB2

€680/day
Paris, FR
15+ years

Average response time: 1 hour

Freelancer profile translated to English.
Back to original language

About Youssef

Senior DBA 15 years | SQL Server · PostgreSQL · IBMi DB2
I work on critical environments to administer, optimize, and secure your SQL Server, PostgreSQL, and IBM DB2 for i (AS/400) databases. My daily tasks include: resolving complex performance issues (slow queries, high CPU, degraded execution plans), ensuring backup reliability, automating DBA operations, and designing robust data models adapted to business constraints.
  • French

    Native or bilingual

  • English

    Fluent

  • Spanish

    Basic

Can work on-site
Paris (up to 50km)

Experience

  • Le Conservateur
    Senior DBA / Data Manager
    BANKING AND INSURANCE
    April 2020 - Today (6 years and 2 months)
    Boulogne-Billancourt, France
    SQL Server
    ▪ Administration of SQL Server instances in production: configuration, monitoring, resource management.
    ▪ Implementation and supervision of maintenance plans: integrity checks, index rebuild/reorganize, statistics updates.
    ▪ Backup and restore strategy: definition of full/differential/log backup plans, regular restore tests.
    ▪ SQL Agent job management: creation, scheduling, monitoring, and alerting of automated tasks.
    ▪ Performance tuning: execution plan analysis, identification of costly queries, index optimization, and T-SQL rewriting.
    ▪ Security: management of logins, server and database roles, authentication policies, access audits.
    ▪ Proactive monitoring: implementation of supervision dashboards, alert management, and production incident resolution.

    PostgreSQL
    ▪ Administration of PostgreSQL instances: configuration (postgresql.conf, pg_hba), extension management, connection monitoring.
    ▪ Performance optimization: WAL analysis, VACUUM/ANALYZE, creation of composite indexes, rewriting complex views (resolution of a view causing ~10h of CPU/day).
    ▪ Design and implementation of a nightly reconciliation workflow between PostgreSQL and DB2 via n8n
    ▪ Development of PL/pgSQL stored procedures for data control automation.


    IBM DB2 for i (AS/400)
    ▪ DB2 for i Administration: object management, performance monitoring, user profile and access rights management.
    ▪ Development of SQL stored procedures following conventions
    ▪ Mastery of AS/400 commands: system diagnostics, object dependency analysis, CCSID management.
    DBA Postgresql DBA SQL Server DBA DB2 Python AI Automation
  • BNP Paribas Cardif
    Study & Development Engineer
    February 2017 - April 2020 (3 years and 2 months)
    Paris, France
    • ▪ Design and modeling of SQL Server databases: schemas, relationships, integrity constraints for business applications connected via ODBC using VBA.
    • ▪ T-SQL Development: views, stored procedures, triggers for over 100 users (membership management, headcount, revenue deductions).
    • ▪ Design and development of VBA Access & Excel tools for operational management.
    • ▪ Supervision of maintenance task distribution for a team of 6 developers.
    • ▪ Writing operational documents, user manuals, and GDPR documents.
    SQL Server VBA Data Modeling
  • Groupe L'Argus
    Study & Development Engineer
    November 2012 - September 2016 (3 years and 10 months)
    Paris, France
    • ▪ Design, development, and maintenance of the Oracle data layer: modeling, PL/SQL, performance optimization.
    • ▪ Development of Oracle ETLs feeding Excel VBA tools (>20 users): repository, accounting calculations, headcount.
    • ▪ Proactive monitoring of production incidents, writing resolution procedures.
    Oracle VBA

Recommendations

Be the first to recommend Youssef

Help this freelancer shine by sharing your experience working together.

These freelancer profiles also match your criteria

AgathaA

Agatha Frydrych

Backend Java Software Engineer

4.7

(3)

2

BaptisteB

Baptiste Duhen

Fullstack developer

4.6

(4)

5

AmedA

Amed Hamou

Senior Lead Developer

4

(2)

7

AudreyA

Audrey Champion

Web developer

4.3

(3)

4

Education

  • Advanced Technician Certificate in Management Information Systems
    IRIS, Higher Institute of Computer Science
    2011
    BTS Informatique de gestion
  • Baccalauréat STI (Scientific and Technological)
    Lycée Léonard de Vinci
    2009
    Baccalauréat STI

Skill set

Categories