Freelancer profile translated to English.
Back to original languageAbout 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 ConservateurSenior DBA / Data ManagerBANKING AND INSURANCEApril 2020 - Today (6 years and 2 months)Boulogne-Billancourt, FranceSQL 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.
- BNP Paribas CardifStudy & Development EngineerFebruary 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.
- Groupe L'ArgusStudy & Development EngineerNovember 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.
Recommendations
Be the first to recommend Youssef
Help this freelancer shine by sharing your experience working together.
These freelancer profiles also match your criteria
Agatha Frydrych
Backend Java Software Engineer
4.7
(3)
2
Baptiste Duhen
Fullstack developer
4.6
(4)
5
Amed Hamou
Senior Lead Developer
4
(2)
7
Audrey Champion
Web developer
4.3
(3)
4
Education
- Advanced Technician Certificate in Management Information SystemsIRIS, Higher Institute of Computer Science2011BTS Informatique de gestion
- Baccalauréat STI (Scientific and Technological)Lycée Léonard de Vinci2009Baccalauréat STI