Freelancer profile translated to English.
Back to original languageAbout Paulo
Expert SQL Server & Data Platform - Architecture, Automation
I intervene when SQL Server goes beyond standard administration: architecture, high availability, automation, performance, migration, observability, and governance.
SQL Server expert with over 20 years of experience, I evolved from a DBA role to a Data Platform architect and technical referent for the reliability of critical platforms.
At Criteo, for 10 years, I worked as DevOps Data & Lead DBA on large-scale SQL Server environments: migration and upgrade of 100+ instances, automation of operations, CI/CD, monitoring, access governance, internal standards, and high availability.
My expertise mainly focuses on critical on-prem or virtualized SQL Server platforms. I also intervene on modernization and hybridization trajectories when it's necessary to ensure the reliability of existing systems, prepare for a migration, or choose between on-prem, SQL Server on VM, and managed services.
Areas of intervention:
- Audit & Scoping: analysis of existing systems, risks, target architecture, roadmap, HA/DR/BCP, RPO/RTO.
- HA/DR/BCP: Always On, clustering, replication, backup/restore, failover plans.
- Industrialization: DBA automation, PowerShell, C#, Python, Ansible, Chef, database CI/CD, Git workflows.
- Performance: SQL Server tuning, execution plans, indexing, partitioning, contention, high volume.
- Observability: Prometheus, Grafana, runbooks, documentation, operational indicators.
- Governance: permissions, SQL standards, environment separation, automated controls, traceability.
I prefer assignments with a genuine improvement project: architecture, automation, reliability, migration, advanced performance, or industrialization.
I am not looking for pure DBA support, on-call duty, or daily operations without leverage for improvement.
French
Native or bilingual
English
Fluent
Portuguese
Native or bilingual
Spanish
Basic
Can work on-site
Bessancourt (up to 15km), Paris (up to 40km)
Experience
- Ski Loisirs DiffusionSQL Server Audit & ReliabilityJuly 2025 - Today (1 year and 1 month)- Audit of SQL Server practices and reliability of critical operations.- Review of backups, restores, integrity checks, index maintenance, and RPO monitoring.- Prioritized recommendations to reduce operational risks
- CitizenPlane SASSQL Server & Automation ConsultantTRAVEL AND TOURISMMay 2025 - February 2026 (9 months)- Audit of SQL Server environments and identification of technical risks.- Automation of SQL Server deployments using Ansible.- Development of a C# tool for SQL Server operations: backup, restore, transactional replication.- Performance optimization and implementation of good administration practices
- Data AurisConsultant / Data Platform ArchitectCONSULTING AND AUDITSJanuary 2025 - Today (1 year and 6 months)Bessancourt, France- Consulting, auditing, and automation for critical SQL Server platforms.- Technical scoping, reliability of operational processes, performance, security, and governance.- Focus: SQL Server on-prem / virtualized / hybrid, automation, CI/CD, observability, and reduction of manual work.
Recommendations
Be the first to recommend Paulo
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 PostgreSQL Administration (Online)Dalibo20261. Connaître les composants d’une instance 2. Savoir configurer PostgreSQL de façon optimale 3. Comprendre les mécanismes de cache et de journalisation 4. Appréhender le concept MVCC et le moteur transactionnel 5. Connaitre les étapes du VACUUM et configurer l’autovacuum 6. Réaliser ses premières sauvegardes et restaurations physiques (PITR) 7. Réagir face à une avarie 8. Découvrir le partitionnement avec PosgreSQL
Certifications
- SQL Server 7 AdministrationMicrosoft2002