About Craig
BDD / SQL Server/MySQL/PostgreSQL expertise
Devops and Cloud (Azure/Google/AWS)
Recommendations and reviews available on the French version of Malt.
Bilingual English French
French-American DBA Expert for more than 15 years, I specialize in the administration and optimization of database performance.
Rigorous, responsive and available, I mainly intervene to resolve performance problems and provide lasting solutions to recurring errors.
My area of intervention and achievements :
Auditing, Monitoring and Analysis of SQL Instances
Configuration
Security
Performance
Monitoring: Our BDD clients benefit from the implementation of a monitoring system, CMM Monitoring Tool developed by us.
Installation, Migration, Configuration and Maintenance :
Installing and configuring SQL instances
Management, optimization and administration of database servers
Drafting and implementation of a global database administration and security policy
Implementation of monitoring probes with real-time overview of the BDD fleet.
Identification of performance bottlenecks and application of corrective solutions.
Industrialization of complex tasks.
HA and Cloud solutions :
Disaster recovery (RTO/RPO).
Load distribution on read-only instances.
Archiving backups/old data on the Cloud.
Cloud & System Architecture :
Cloud hosting development, security advice.
Design and manage web hosting architectures, develop security and deployment strategies for diverse clients.
Implement vulnerability and penetration testing services. Develop defensive security policies for our clients to meet regulatory and auditing requirements.
Supervise system administrator projects, consultant training and monitoring of skills development objectives.
English
Native or bilingual
French
Native or bilingual
Can work on-site
London (up to 50km)
Experience
- TransportStafSQL Audit and Technical supportTRANSPORTATIONMay 2024 - Today (2 years and 1 month)Paris, FranceTransportStaf asked us for an audit of their SQL Server 2022, recently migrated from SQL Server 2008.Thanks to our expertise and our CMM Metric Manager diagnostic tool, the audit revealed several problems :1. All database files were hosted on the same disk.2. Database collation and SQL Server collation were not the same, resulting in implicit conversions for each query3. Faulty security / needs to be strengthened.4. Performance issues caused by:- a lack of indexing,- incorrect configuration and alignment of the processor,- a lack of usable memory,- poorly written and resource-intensive queries.5. A SQL Server Enterprise trial license about to expire.Consequences: customers/users were very impacted and unhappy with performance and wanted a viable and permanent solution quickly.First, we searched for and selected for the TransportStaf client, a version of SQL Server Standard 2022 allowing a better CPU configuration at minimal cost. We guided and supported the client step by step in the installation phase, thus allowing their team to increase their skills while ensuring an efficient, professional and stable installation of SQL Server.Then we were able to quickly move forward with a new deployment and adding the required cumulative updates.On this reliable and qualitative basis, maintenance tasks were added using maintenance scripts recommended by the DBA community and the new SQL Server 2022 standard server could thus be deployed in one day.Users are now very satisfied.Monitoring of the TransportStaf client database is now ensured by us, with CMM Metric Manager as well as technical support, from the client's IT team.
- AvizzeoFailed Application Update on CloudEDUCATION AND E-LEARNINGFebruary 2022 - Today (4 years and 4 months)France, FranceInitial and problematic context :Avizzeo's production environment ran on its cloud service using Kubernetes.Frequent application version upgrades (deployed via automated updates by their cloud service provider), prevent Avizzeo applications from starting and functioning correctly after deployment. This situation requires a manual redeployment of the application components (for each environment) on the part of Avizzeo then a restart.Method and expertise :Following discussions with their developers and an in-depth analysis of themalfunction and various tests, we were able to identify a DNS resolution error.The latter prevented Avizzeo's servers from downloading updates, completing their deployment process and correctly restarting application services after the deployment of automated cloud updates.Resolution and assessment :We then activated the DNS cache on each of the clusters in order to resolve theupdate issues.From now on, we are continuing the collaboration with Avizzeo by assisting them with their future development and IT support needs.
- TotalEnergies FluidsPostgreSQL performance auditENERGY AND UTILITIESJanuary 2024 - February 2024 (1 month)France, FranceWe carried out a PostgreSQL performance audit for TotalEnergies. This customer uses PostgreSQL as the caching database for its data integration and management platform application. The audit identified and analyzed various performance issues with the caching database and generated queries. Issues noted included server configuration settings, indexing, resource consumption, and inefficient consumption of column data types.With the help of this audit, we were able to propose recommendations and efficient solutions to resolve the problems identified.
Recommendations
Be the first to recommend Craig
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
- AWS Solutions SysopsAmazon Web Services2015Deploy, manage, and operate scalable, highly available, and fault-tolerant systems on AWS Implement and control data flow to/from AWS Select the appropriate AWS service based on compute, data, or security requirements Know the proper use of AWS operating best practices Estimate the costs of using AWS and identify cost control mechanisms Migrate on-premises workloads to AWS Understanding AWS principles: creating architecture for the cloud Hands-on experience with AWS CLI tools and SDK/API tools Knowledge of networking technologies and how they relate to AWS Understanding of security concepts with hands-on experience implementing security controls and compliance requirements Knowledge of virtualization technology Experience with monitoring and verification systems Knowledge of networking concepts (e.g. DNS, TCP/IP and firewalls) Ability to translate architectural requirements