John Olsen

Creative solutions to data needs using SQL Server is my passion. Extensive experience with database analysis and design, normalization, Transact-SQL, stored procedures, functions, constraints, indexes, maintenance, backups and more both as a developer and database administrator.

Senior Database Administrator (DBA) responsible for managing and maintaining the replication, availability, and recovery of all production and non-production SQL Server database servers across multiple geographically separated data centers. Supervise, manage and coordinate efforts of database team members. Architect the design, performance, replication, security, integrity, disaster recovery and high availability requirements for large complex databases

Work in conjunction with Independent Software Vendors (ISV) on implementation, optimization and maintenance of application suites. Optimize solutions utilizing new database features and functionality. Deploy changes to production systems in accordance with change control process. Troubleshoot database problems using a variety of diagnostic tools including trace, profiler, extended events. Development and maintenance of data integration and Extract-Transform-Load (ETL) processes between a variety of database and application platforms, both on and off premises