John Koster Email & Phone Number

Amsterdam, Nh, Nl

Amsterdam

SQL Server database administration, migration, monitoring, performance tuning, security and supporting junior DBA within an environment with 140 independent SQL Server instances and over 1000 databases raging from SQL 2000 to SQL 2008.• Database optimization and tuning using SQL Server Profiler, DMV’s and Database Engine Tuning Advisory. • Setup SQL Server 2008 servers.• Development of database monitoring system.• Database migration to SQL 2008.

Within this real estate company I am responsible for the management of multiple SQL Server clusters based on SQL Server 2008, 2005 and 2000. The datastorage is based on NetApp SAN storage with usage of snapshot technology.• Database optimization and tuning using SQL Server Profiler, DMV’s and Database Engine Tuning Advisory. This tuning is done on internal developed databases as well as external developed databases like AFAS, GenSys and TopDesk.• Setup SQL Server 2008 R2… Show more Within this real estate company I am responsible for the management of multiple SQL Server clusters based on SQL Server 2008, 2005 and 2000. The datastorage is based on NetApp SAN storage with usage of snapshot technology.• Database optimization and tuning using SQL Server Profiler, DMV’s and Database Engine Tuning Advisory. This tuning is done on internal developed databases as well as external developed databases like AFAS, GenSys and TopDesk.• Setup SQL Server 2008 R2 cluster.• Improved residence search/display on the www.Ymere.nl website Show less

Within this international trading house I was responsibility for the management of all SQL Database servers, instances and databases in a SQL Server 2008 environment.• Inhousing datawarehouse and sharepoint database environment.• Optimizing and tuning databases.• Multiple database and database server migrations and consolidations.• Development database monitoring system.• Implemented improved database backup strategy.• Setup fall-back environment based on database… Show more Within this international trading house I was responsibility for the management of all SQL Database servers, instances and databases in a SQL Server 2008 environment.• Inhousing datawarehouse and sharepoint database environment.• Optimizing and tuning databases.• Multiple database and database server migrations and consolidations.• Development database monitoring system.• Implemented improved database backup strategy.• Setup fall-back environment based on database mirroring and snapshot (reporting)• Database security improvements Show less

Joint responsibility for the management of all SQL Database servers, instances and databases.• Managing SQL 2000 and SQL 2005 database servers including backup/restore, OTAPS environment, tuning, security, maintenance• Microsoft Clustering with SAN and local storage.• Database migration and consolidation from SQL 2000 to SQL 2005.• Development of data interfaces based on SSIS, DTS and linked servers between different database systems like SQL Servers, Oracle, Excel, CSV files… Show more Joint responsibility for the management of all SQL Database servers, instances and databases.• Managing SQL 2000 and SQL 2005 database servers including backup/restore, OTAPS environment, tuning, security, maintenance• Microsoft Clustering with SAN and local storage.• Database migration and consolidation from SQL 2000 to SQL 2005.• Development of data interfaces based on SSIS, DTS and linked servers between different database systems like SQL Servers, Oracle, Excel, CSV files and foxpro.• Development and review of T-SQL code (also dynamic), stored procedures, views, functions and SQL Server Agent jobs. Show less

Employed with the ABN-AMRO at the Department Distributed Systems (section Installation) with joint responsibility for the management of multiple Windows 2000 domains with a total of 750 domain controllers, 1800 Windows 2002/2003 based terminal servers and 30,000 workstations and multiple SQL Servers.• Managing Windows 2000/2003 network, Domain controllers (Active Directory) and terminal servers• Managing multiple SQL Server 2000 databases, in combination with development of T-SQL… Show more Employed with the ABN-AMRO at the Department Distributed Systems (section Installation) with joint responsibility for the management of multiple Windows 2000 domains with a total of 750 domain controllers, 1800 Windows 2002/2003 based terminal servers and 30,000 workstations and multiple SQL Servers.• Managing Windows 2000/2003 network, Domain controllers (Active Directory) and terminal servers• Managing multiple SQL Server 2000 databases, in combination with development of T-SQL, stored procedures, views and DTS packages and clustering.• Design and implementation of VbScripts and other scripts to collect domain wide and active directory information into a SQL Server database to automate system engineers tasks• SQL Server 7.0 to SQL Server 2000 datamigration and implementation of SQL Server 2000 logshipping. Show less

Employed with the ABN-AMRO at the Department LAN-management, part of Holan, with joint responsibility for managing multiple NT domains with a total of 450 servers and 12,000 workstations. I was also responsible for designing, developing and maintaining multiple SQL databases, intranet sites and VBScript tools.• Managing Windows NT network/domain in combination with VbScripting to automate system engineer tasks.• Managing SQL resource domain in combination with development of T-SQL… Show more Employed with the ABN-AMRO at the Department LAN-management, part of Holan, with joint responsibility for managing multiple NT domains with a total of 450 servers and 12,000 workstations. I was also responsible for designing, developing and maintaining multiple SQL databases, intranet sites and VBScript tools.• Managing Windows NT network/domain in combination with VbScripting to automate system engineer tasks.• Managing SQL resource domain in combination with development of T-SQL code, stored procedures and DTS packages.• Design and maintenance of a SQL database which collect network/domain information using different available tools.• Design and maintenance of intranet site and other reports about system wide information about servers and workstation for departments.• Development of tooling to automate system engineers and DBA tasks.• Development of ASP intranet site with user application usage information, which is used for the migration from NT to Windows 2000. Show less

Employed with Randstad Nederland participate in the setup of a new first line ITIL based skilled support desk.

Employed with IBM NWSS by KLM Cargo with responsibility for on-site execution of different management tasks on a Windows NT network with additional coordinating functions on a team of 5 people. I was also responsible for coordinating and implementing a rollout within a migration path from windows 3.11 to Windows NT.

In the Dutch department of this American flower freeding company I was responsible for the purchase, installation and maintenance of all hardware and software and the development of various custom applications in Foxpro. I was also responsible for the design, implementation and reporting of various technological and seed germination studies.

Ing (Bachelor), Tuinbouw

Education record