FHFreelancer profile translated to English.
Back to original languageAbout Faycal
With 19 years of experience as a database developer and administrator, I assist companies in creating robust, high-performing, and scalable solutions. My dual profile allows me to manage the entire lifecycle of your systems: from technical design to production deployment, and ongoing maintenance.
What I offer you:
- Optimized and secure databases
- Reliable and custom applications
- Responsiveness to incidents and ability to solve complex problems
- A global vision to anticipate your future needs
My typical deliverables:
- Design and deployment of relational databases (SQL Server, PostgreSQL, etc.)
- Development of business applications connected to databases
- Automation of administrative tasks (backups, monitoring, scripts)
- Performance optimization and technical audits
What sets me apart:
My technical versatility and my ability to communicate effectively with business teams to transform your needs into concrete solutions.
Arabic
Native or bilingual
French
Native or bilingual
English
Conversational
Can work on-site
Paris (up to 50km), Cergy (up to 50km)
Experience
- NEWREST WAGONS-LITS,Database Developer and AdministratorTRANSPORTATIONJanuary 2024 - July 2025 (1 year and 6 months)Paris, France- Design the target architecture on SQL Server (schemas, tables, indexes, etc.).- Migrate databases (2 DB instances, multiple schemas).- Convert Oracle objects to SQL Server objects (tables, views, packages, functions, procedures, triggers, sequences, scheduled tasks).- Convert Oracle packages to SQL Server stored procedures or functions.- Adapt SQL queries (syntax, Oracle-specific functions like TO_DATE, NVL, etc.).- Convert Oracle jobs (DBMS_SCHEDULER) to SQL Server Agent jobs.- Adapt SQL and BATCH scripts to work with SQL Server.- Convert Oracle Reports to SSRS (SQL Server Reporting Services) reports.- Adapt report queries and parameters. Clean up data (remove duplicates, correct errors, etc.).- Back up data before migration. Use the SSMA (SQL Server Migration Assistant) migration tool.- Database administration: Configure backup and restore on SQL Server.- Implement monitoring and performance optimization.- Manage users and permissions.- Secure ORACLE access and connections (LDAPS).- Analyze the performance of queries and stored procedures, optimizing indexes and queries if necessary.- Resolve issues encountered after migration. Document existing processes and the migration procedure.Create and document Product Backlog Items (PBIs) on Azure DevOps
- CELAD,Consultant in Database Development and AdministrationSeptember 2023 - December 2024 (1 year and 3 months)Paris, France- Undertake further training. Explore new technologies, database management.- Collaborate with other developers and strengthen my professional network. Participate in discussion forums related to my area of expertise.- Share my knowledge with the community and increase my online visibility.
- SATIM,Database Developer and AdministratorBANKING AND INSURANCEMay 2017 - August 2023 (6 years and 3 months)Alger, Algeria- Collaborate closely with development teams to integrate new features and resolve database-related issues.- Proactively manage databases to align with Scrum iterations.- Play a key role in managing crisis situations by providing immediate temporary solutions and working on long-term corrective measures.- Design and implement database schemas to meet specific business application requirements.- Collaborate with developers to integrate new features and optimize application performance.- Optimize the performance of queries and ETL processes, reducing response times.- Implement an effective backup and recovery policy to ensure business continuity.- Develop technical and functional documentation, as well as user manuals.- Design and implement comprehensive maintenance plans to ensure database stability and performance.- Provide user support for the payment ERP system (SMART VISTA)
Recommendations
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
- Application Engineer Diploma in Computer Science Option: Information SystemsThe Training Department of the Algerian Chamber of Commerce and Industry2012Diplôme Ingénieur d'application en informatique Option : Système d'information
- Higher Technician Diploma in Management Information Systems.The National Specialized Institute for Vocational Training2004Diplôme de Technicien supérieur en informatique de gestion.