Freelancer profile translated to English.
Back to original languageAbout Jonathan
I am a DBA (Database Administrator) specializing in SQL, Postgres, 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 levers.
🛠️ What I do today
- DBA Database administration on Postgres/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 via pgAgent, SQL, bash, powershell scripts
- Production of Power BI dashboards (PL-300 certified)
📊 What I bring you concretely
- An optimized, clean, and secure database
- Automated pipelines to ensure reliable operations
- Clear and relevant Power BI dashboards
- Strong business understanding
- Complete 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 management, 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 (11 months)Val-de-Reuil, France• Administration and maintenance of PostgreSQL and PostGIS environments and version upgrades• Optimization of database performance and Power BI 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)• Data migration to SQL Server as well as major PostgreSQL upgrades• 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 structuring project schemas and normalizing table/column names for better data governance.
- Noxia securityDBAPUBLIC SAFETYJanuary 2025 - August 2025 (7 months)Saint-Thibault-des-Vignes, France• Administration and maintenance of Postgres environments• Optimization of database performance and Power BI 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 structuring project schemas and normalizing 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 Power BI 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 structuring project schemas and normalizing 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 License in Commercial Development ManagementUnivérsité Paris Est Marne La Vallée2016Licence professionnelle responsable de développement commercial
- Technical Commercialization Diploma (work-study)DUT technique de commercialisation en alternance