-
Genivar
- MSSQL Server DBA
2011 - maintenant
-
BPR-Bechtel
- MSSQL Server DBA
2009 - 2011
•tDesign and testing of disaster recovery plans (DRP) on MSSQL production servers;•tManagement of operational incidents: server connectivity, disk space problems, log shipping, replication, database backups and recovery, any MSSQL server-specific operational incident;•tDevelopment and implementation of SQL Server tools in order to fulfill main SQLServer administrative tasks•tDevelopment of tools allowing real-time production of MSSQL security audit reports;•tMaintenance/improvement of Clustering, Log Shipping and Replication technologies (SQL2005)•tRedefining of the backup policy to take into consideration the natural evolution of client expectations and growth of database volume;•tDevelopment of parallel recovery tools in order to reinstate several backups at once.Technologies :MSSQL Server (2000, 2005, 2008), Microsoft Analysis and Reporting Services
-
CGI
- MSSQL Server DBA
Casablanca
2006 - 2009
•tManagement of a stock of around one hundred servers (approximately 1500 db) as part of an operational team of 4;•tOperational incidents management :Server connectivity, disk space problems, log shipping, backups and data recovery (TDP, TSM, Veritas Netbackup), any operational incident relating to MSSQL servers;•tPerformance diagnostics on MSSQL Servers: production of technical analysis reports aiming to pinpoint the causes of decreased SQL server performance.•tDevelopment of monitoring tools for MSSQL Server resources (database file size, server query/user load, etc.):Tools used to establish server activity growth prognoses and anticipate future hardware and software needs.•tDevelopment of tools enabling real-time MSSQL security audit reports: domain and database role listing, user access to database objects, etc.: approximately one hundred reports were generated and delivered to clients each year.•tImplementation of high-availability solutions: cluster installation, database mirroring (SQL2005)Technologies : SQL Server Management Studio, Profiler, Microsoft Analysis and Reporting Services, IBM Tivoli Data Protection (TDP) pour SQL Server, IBM Tivoli Storage Manager (TSM), Veritas NetBackup, Remedy IT Service Management 6.0, Infoman sur Mainframe, Microsoft Office 2003 (dont Visio 2003 et Project), Royal TS
-
BELL Canada
- MSSQL Server DBA
Montreal
2005 - 2006
•tDesign, development, documentation of three databases (Bell Canada Group revenue), used for financial analysis purposes within the Aliant project :otUser interviews ;otStandard database models design ;otTable creation script programming (Transact-SQL);otDefinition of database access rules : Windows users account management•tPerformance optimization : indexing of tables (which may contain up to 100 million records), implementation of archiving procedures of historical data in complementary databases;•tAutomation of monthly import tasks for the Bell group’s revenues : data import (csv files) via the DTS tool. Programming of triggers and active scripts;•tDevelopment of monthly financial analysis tools Transact-SQL queries, OLAP cubes programming;•tMaking results available through MSExcel or SQL Server Reporting services tools;•tImplementation of the data backup strategy : backups on server and on tape (Veritas NetBackup system)Technologies :SQL Server 2000 (DTS, Transact-SQL, Scripts activeX, Reporting services, Cubes OLAP), Visio, Excel, Access 2000
-
Relationnel Canada
- MySQL DBA
2004 - 2005
•tDesign, development, documentation of the information system :otProduction of a standardized data model based on the specifications of the CarrefourPME project;otDevelopment of SQL scripts and table creation ;otAdministration of the database (MySQL 4): definition of backup procedures, management of access rights, indexing, performance optimization.•tDevelopment of backoffices and e-mail alerts (PHP) ;•tImpact analysis on choosing Sharepoint Portal Server technology as development platform for the next version of the CarrefourPme product;•tData migration of the CarrefourPme platform from MySQL to SQL Server 2000;•tCreation of data normalization SQL scripts within rules of the new model;•tProgramming a C# migration application of MySQL to SQL Server 2000 which allows, via graphic interface :tManagement by the user of the properties relating to table fields (choice of data type, column indexing, manual control of primary and foreign keys);tGeneration of an XML file describing the structure and content of the information system in accordance with the standards of the new platform;tMigration of the database from MySQL towards SQL Server 2000 from the XML script;Technologies MySQL, Visio, SQLServer 2000, Sharepoint, C#
-
Artprice
- MSSQL Server DBA / MSAccess-VB Developer
2000 - 2003
•tDesign, maintenance, tuning and backup procedures of databases (MySQL, SQL Server 2000) within customer management projects of the www.Artprice.com website (900,000 clients, 4 million auctions)•tMigration of 60% of the company’s databases from Access 97 to SQL Server 2000 ;•tDatabase performance optimization, allowing productivity increases for data entry operators in the range of 40% compared to prior systems ;•tMaintenance of Oracle 8i databases : maintenance of existing applications (FORMS), database backup procedures for the www.artistbiography.com website, which indexes biographies of over 200,000 artists;•tASPNet backoffices development for the management of the Artprice.Com site client base (manage client profiles, edit statistical reports, e-mail alerts);•tDesign / fulfillment of ’Artprice Annual’ products (Access97, VB6) : CDROM, paper literature•tDevelopment (Access 97) of generation tools, in the XML format, of data used for the design of CDROMs and paper literature for ‘Artprice Annual’ and 'Conventions Collectives' commercial products. Over 80% reduction of production time for said products.•tVB6 development of software protection modules for CD-ROM (HASP locks)Technologies :Access 97, VB6, librairies HASP, SQL Server 2000, MySQL, Oracle 8i, ASP.Net
-
Artprice.com
- SQLServer DBA
St Romain au Mont D'or
2000 - 2003
-
LIPS S.A
- Access/VB Developer
1998 - 1999
•tComplete re-design of the company’s computer systems within the Y2K transition processotDesign/maintenance of management applications for stocks, cash registers, production cost calculations (Access 97, VB6) otDevelopment (Access97) of integration procedures of the sales data into the company’s accounting package (Compta SAARI)TechnologiesAccess 97, VB 6
