Database Project : • Carried from A to Z : Requirements and analysis, architecture, design, construction/integration and test implementation, user training sessions & lead of meetings to present the projets and new features • Daily updates of the databases with SQL queries and Powershell scripts • MRO (maintain, repair and operations) • Create and maintain the procedure up-to-date
Security : • Administrator/Users own Interface, database protected with password • Set up logs • Set up backup with PowerShell scripts & automatic save of databases
Transverse : • Set up reportings, KPI, reports with Access/Excel and Business Objects • Incident Response: Identification, investigation, eradication, recovery, follow-up, communication and reporting • Level 2-3 support • Proposal to switch to MySQL : purchase of dedicated server, study of needs • Knowledge transfer
Environment : Windows, MS Access/Excel, PowerShell, SQL/VBA, MySQL, Business Objects