Sofiane Mebarki

Project: SQL Server + business applications deployment and migration for 50 public institutions

Context: Our clients are working on a Windows environment no longer maintained by Microsoft. We therefore recommend migrating their SQL databases and business applications to a more up-to-date version to secure their infrastructures, accompanying them from start to finish. Audit and technical advice phase for the new environment, installation and migration phase, then skills transfer and relationship with various external service providers also involved in the migration.

• Project piloting

• Coordination of technical teams

• Coordination of client teams

• SQL Server deployment and migration

• Database setup

• Backup / restore

• Creation of configuration scripts (user consoles)

• Database security

• Monitoring and high availability

• Creation of stored procedures

• Client audit

• Validation of technical choices

Project: Strengthening information system security for the 2024 Olympics

Networks and Firewalls:

• Firewall administration: Palo Alto/Checkpoint/Forcepoint/Fortinet

• Traffic management

• Troubleshooting

• VIP management

• Change implementation

• SD-WAN/MPLS

• NetScaler Load Balancer

• Proxy

• SSL VPN

• Site-to-site routing

• Documentation writing

Security:

• Zscaler

• TrendMicro Antivirus

• Beyondtrust Bastion Administration

• Alert monitoring

• Client updates

• Maintenance in operational condition monitoring

Virtualization (VMWARE/OLVM):

• Infrastructure update

• Deployment of new VMs

• Alert management

Backup (Netbackup):

• Backup policy management

• File/Server restoration

Windows/Linux:

• Qualification and production deployment of application patches (Azure, DB, Web etc…)

• User rights management

• Update

• Deployment of new applications

Level 3 Ticketing:

• Problem resolution

• Application administration

• Update

• Expertise support for Level 1 and 2 teams

Project: Strengthening the internal team / reducing workload

• Securing an IS

• Support for the network team in integrating Fortinet firewalls

• PRTG monitoring and mapping

• Workload reduction

• Integration of new tools

• Recurring operational tasks

• Technological and cybersecurity watch