Arnaud Degraeve

Technical Lead on Teradata development User Story development according client needs and Tests. Optimization of queries and assistance to other developers TPT import / export Technical validations Teradata 16.20 / Linux / Shell Scripting

Database tuning – queries optimization / development help and advice. Users training about Teradata Troubleshooting. Incidents and changes management for clients Interface with Teradata CS support Management of backups with Symantec Netbackup (v7) - Control-M 7.5/ Teradata 15.20 / Linux / Shell Scripts

Database tuning – queries optimization / development help and advice Troubleshooting. Incidents and changes management for clients Interface with Teradata CS support Implementation of solutions in client context (bank) Metrology development – Space management, resources usage, reports about users and inconsistencies On call duty on nights and week end on production systems Software development in Shell script to block /unblock users / reset and change password of accounts Management of backups with Symantec Netbackup (v7) - Control-M DSA implementation DRP implementation between 2 Teradata systems Netbackup 7.5/ Teradata 14.10 / Linux / Shell Scripts

Tuning and problems resolutions on production SQL server – Teradata databases and applications Management of crisis – failure of exploitation on the critical databases – Conference calls with clients and providers Merge replication (Tuning on e-Ticket project in order to solve, locks replications problems, response time about a merge between SQL servers and thousands of PDAs) – SNCF one of the three valuable client in the world using merge replication with more than 10.000 clients SQL Server 2008R2 implementation (Best practices, integration of the product within the company, Advice about databases migration) – Documentation SQL Server 2012 implementation (Best practices, integration of the product within the company, Advice about databases migration) – Documentation Management / implementation of monitoring with Tivoli (analysis / checking of the consistency of alerts / creation of script for features non covered by Tivoli) BI Databases optimization / Code review / Process review for importation and transformation of data Clustering deployment an use in productions systems– MSCS - version 2000 – 2005 – 2008 – 2008R2 (5 nodes clusters for e-tickets project Mirroring high performance / high availability mode(Principal, recovering, witness) in SQL Server 2008R2 Analysis / code and design review of e-ticket project (merge replication / C# / assemblies / Broker) Interface with Microsoft premier support on the overall projects Teradata management – On call duty on production systems (backups – restore – performance analysis) Teradata development – Best practices management (based on problems met on production system) Management of backups with Symantec Netbackup (v7) Documentation on installation, deployment, best practices, for packaging and deployment Planning and internal projects organization / project management SSIS / SSRS / Dot net / SQL Server 2008 / 2000 / 2005 / Clusters / Merge Replication / Mirroring / SAN / Nexus / Tivoli / Netbackup / Broker / Teradata 13.10 / MVS / Linux