Robert Koros Email & Phone Number

London, Ontario

Working with a myriad of clients to assist them with their SQL Server database performance / architecture or implementation concerns. Perform migrations of database servers to new servers and upgrading existing databases.

London, Ontario

Scarborough, Ontario

Originally hired as Manager, Information Systems with mandate to lead an international team of 20 Technology Architects and Senior DBA’s responsible for managing customer database infrastructure for over 3000 databases within highly diverse environments (SQL Server, Oracle, MySQL, Sybase and DB2).Key Responsibilities & Achievements:• Ensure that the team met a myriad of compliance standards: PCI, SOX and Health Record Retention.• Collaborate with several teams to deliver a… Show more Originally hired as Manager, Information Systems with mandate to lead an international team of 20 Technology Architects and Senior DBA’s responsible for managing customer database infrastructure for over 3000 databases within highly diverse environments (SQL Server, Oracle, MySQL, Sybase and DB2).Key Responsibilities & Achievements:• Ensure that the team met a myriad of compliance standards: PCI, SOX and Health Record Retention.• Collaborate with several teams to deliver a complete outsourcing model to our customers, based upon their specific requirements unique to their industries spanning medical records, financial services and recreation.• Work with Marketing to expand team’s role beyond traditional backup and recovery to further include performance tuning, capacity planning, data migration and resiliency solutions. Show less

Airdrie, Alberta

Managed team that ran all aspects of the database infrastructure including network/hardware and software performance optimization, and ERP system performance management and support. Supported over 1200 global end-users.Key Responsibilities & Achievements:• Initiated purchase of SAN (Storage Array Network) for database servers as the ERP was demanding more performance than direct attached hard drives could deliver.• Implemented custom audit trail of mission-critical data… Show more Managed team that ran all aspects of the database infrastructure including network/hardware and software performance optimization, and ERP system performance management and support. Supported over 1200 global end-users.Key Responsibilities & Achievements:• Initiated purchase of SAN (Storage Array Network) for database servers as the ERP was demanding more performance than direct attached hard drives could deliver.• Implemented custom audit trail of mission-critical data without adversely impacting ERP performance.• Designed, built and managed Windows and SQL Server Clustering, which hosted the SharePoint Portal.• Ensured that all database servers had a documented and tested, backup and restoration plan so that in the event of a critical failure the recovery process was reliable and efficient.• Designed new databases and correlating data flow for custom applications while ensuring the data that already existed within Visual Manufacturing ERP was utilized efficiently.• Lead DBA/PM for implementation of SQL Server Reporting Services, which replaced Crystal Reports.• Lead DBA/ PM for SQL database upgrade, including moving from DTS (Data Transformation Services) to SSIS (SQL Server Integration Services) with no impact to the operation of the business. Show less

Calgary, Alberta

Managed several database and website servers within Canada, United States, Australia and the United Kingdom. Prepared the rollout of new websites and the associated database schema alterations. Resolved network communication issues, specifically communication with out-of-country servers.