Nicolas Souquet
Senior Performance Database Administrator
Having passion for databases, and focused on their optimization, particularly SQL Server, I have been rewarded SQL Server MVP in 2009 for my publications and daily participations on a development reference French website ( http://sqlserver.developpez.com/, http://blog.developpez.com/elsuket/ )
Through my working experience, I keep my career centered on the data quality and look after the databases performances.
I'm now working at Microsoft in Thailand, and help to grow a SQL Server community by animating public SQL Server performance focused sessions.
56 contacts- Monitoring database performance, usage, and perform tuning and high-availability related tasks
- Provide technical support and recommendation to developers, and work with them to deliver applications to the production environment
- Review, enhance, and maintain compliance of database coding standards and security
- Administrate and maintain SQL Server geo-replicated instances, including their installation, migration, copy, ...
- Maintain consistency across all the the databases
- Handle changes and develop either business or database administration procedures
- Make recommendation to management for further improvement
2010 - 2011- Test and deploy production OLTP databases, sized up to 3TB
- Build and test a performance baseline for customer production SQL Server instances monitoring, including reporting
- Review and tune T-SQL code, advice developers
- Manage database versions, reference data and structure
- Maintain, update and tune development and client database
- Write client specific scripts
- Develop and document internal procedures
2008 - 2009Database administration and monitoring of 15 OLTP and ROLAP servers for public transports network real-time monitoring and analysis.
General design and T-SQL development.
Performance tuning and queries rewrite.
Disaster recovery implementation and tests.
Building SQL Server Reporting Services 2005 reports, for internal or customer usage.
Development of simple applications and SQL Server assemblies, in C Sharp
2005 - 2007------------------------------
September 2005 - February 2007
------------------------------
Expatriation in Thailand in the local subsidiary of Index Multimedia : SamClick
Java development of games for SMS and Audiotex medias.
Implementation of subscription services for 4 countries (2 million subscribers, 5 million SMS per day)
Subscriber database management and coordination with Index Multimedia DB team.
Statistics for marketing team.
--------------------------
March 2007 - November 2007
--------------------------
Creation and administration of the database that is used by the whole company to manage SMS, WAP, and Audiotex applications.
Design and implementation from scractch of the database. Organizing data migration.
Performance tuning, monitoring and general maintenance of the database
- Test and deploy production OLTP databases, sized up to 3TB
- Build and test a performance baseline for customer production SQL Server instances monitoring, including reporting
- Review and tune T-SQL code, advise developers
- Manage database versions, reference data and structure
- Maintain, update and tune development and client database
- Write client specific scripts
- Develop and document internal procedures