Freelancer profile translated to English.
Back to original languageAbout Jonathan
I am a DBA (Database Administrator) specializing in PostgreSQL, PostGIS
With over 9 years of experience in strategy, operations, and data, I help companies structure, validate, and enhance their data, from infrastructure to visualization.
🎯 My Goal
Ensure high-performing, reliable, and usable data environments, and transform your data into operational and strategic assets.
🛠️ What I do today
- DBA Database administration on PostgreSQL/PostGIS (performance, indexing, sequences, rights management, monitoring, version upgrades)
- Creation of GIS projects on QGIS
- Log management and monitoring via bash scripts
- Implementation of robust data architectures: views, materialized views, automated scripts, triggers in a lakehouse environment
- Automation of complex ecosystems using pgAgent, SQL scripts, bash, powershell
- Production of Power BI dashboards (PL-300 certified)
📊 What I bring you concretely
- An optimized, clean, and secure database
- Automated pipelines to ensure operational reliability
- Clear and relevant Power BI dashboards
- Strong business understanding
- Comprehensive support: from SQL engineering to Power BI reporting
🤝 Looking for a versatile PostgreSQL data expert?
Whether it's to optimize a database, industrialize your workflows, or strengthen your steering, I will support you with a technical, business, and results-oriented approach.
Let's discuss your needs!
French
Native or bilingual
English
Fluent
Spanish
Conversational
Can work on-site
Paris (up to 50km), Lille (up to 50km), Lyon (up to 50km), Toulouse (up to 50km), Marseille (up to 50km)
Experience
- Altitude infraDBATELECOMMUNICATIONSSeptember 2025 - Today (9 months)Val-de-Reuil, France• Administration and maintenance of PostgreSQL and PostGIS environments and version upgrades• Optimization of database performance and PowerBI reports• Implementation and monitoring of scheduled tasks for automated jobs via pgAgent• Creation, refactoring, and security of tables, views, triggers, sequences, etc...• Management and documentation of dependencies between SQL objects (procedures, views, functions, tables)• Contribution to the security of user and group access• Technical support and coordination with business and data teams via JIRA ticketing tool• Implementation of optimization and monitoring scripts (analysis of errors, locks, table sizes, active dependencies) via bash and powershell scripting• Administration of the PostGIS geodatabase (GIST indexes, spatial queries, geographic aggregates, buffers).• Participation in the structuring of project schemas and normalization of table/column names for better data governance.
- Noxia securityDBAPUBLIC SAFETYJanuary 2025 - August 2025 (7 months)Saint-Thibault-des-Vignes, France• Administration and maintenance of PostgreSQL and PostGIS environments• Optimization of database performance and PowerBI reports• Implementation and monitoring of scheduled tasks for automated jobs via pgAgent• Creation, refactoring, and security of tables, views, triggers, sequences, etc...• Management and documentation of dependencies between SQL objects (procedures, views, functions, tables)• Implementation of optimization and monitoring scripts (analysis of errors, locks, table sizes, active dependencies) via bash and powershell scripting• Administration of the PostGIS and QGIS geodatabase• Participation in the structuring of project schemas and normalization of table/column names for better data governance.
- Free (société sous-traitante)DBATELECOMMUNICATIONSMay 2021 - December 2024 (3 years and 7 months)Seine-et-Marne, France• Administration and maintenance of PostgreSQL and PostGIS environments• Optimization of database performance and PowerBI reports• Implementation and monitoring of scheduled tasks for automated jobs via pgAgent• Implementation of optimization and monitoring scripts (analysis of errors, locks, table sizes, active dependencies) via bash and powershell scripting• Administration of the PostGIS and QGIS geodatabase• Participation in the structuring of project schemas and normalization of table/column names for better data governance.
Recommendations
Be the first to recommend Jonathan
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
- Professional Bachelor's degree in Commercial Development ManagementUnivérsité Paris Est Marne La Vallée2016Licence professionnelle responsable de développement commercial
- Work-study Technical Sales DiplomaDUT technique de commercialisation en alternance