Might be available
(Updated 1+ year ago)SQL Server-specialist
Enköping
Native Svenska, Fluent English
- 20 års erfarenhet av SQL Server-drift
- 20 års erfarenhet av programmering med T-SQL
- 20 års erfarenhet av prestandaoptimering i SQL Server
Skills (49)
SQL SERVER 2005
SMO
MS SQL Server
Database Administration
SQL
BATCH PROCESSING
Database Design
PERFORMANCE OPTIMIZATION
DATABASE MODELING
STORED PROCEDURES
SQL SERVER 2012
SQL SERVER 2000
DATA MODEL
DATABASE ENGINE
Database Development
SQL Server
PERFORMANCE TUNING
Microsoft SQL Server
DATABASE
DATABASE SYSTEMS
BEST PRACTICES
ENCRYPTION
Data Migration
SECURITIES
REPLICATION
MySQL
STATISTICS
AUDIT
STAFFING
USER INTERFACE
ACROBAT
PUBLISHING
TRANSLATIONS
AUDITING
NATIONAL ACCOUNTS
INSTRUCTOR
CREDIT
PROOF-READING
INVENTORY
ARCHITECTURE
ONBOARDING
ACCOUNTING
MAINTENANCE
AUDITS
TEACHING
REALTIME
WEB DATABASE
SHIPPING
Summary
Database specialist with 20 years experience of SQL Server, from technical/infrastructure
perspective as well as development and architecture. Over the years, Magnus has gained
experience and expertise within database administration, query optimization, database modelling
and infrastructural planning on the Microsoft Data Platform. Magnus loves sharing his knowledge,
with colleagues as well as on conferences and in classrooms. As Microsoft Certified Trainer,
Magnus is teaching most of the official Microsoft courses on SQL Server, from T-SQL querying to
administering and provisioning SQL Server.
CV
Database specialist SQL Server
Magnus Ahlkvist
Selected work life experience
2016 April - now Transmokopter SQL AB
Owner, consultant
SQL Server instructor and consultant on Transmokopter SQL AB. As instructor, Magnus teaches
SQL Server-courses, from beginners class on T-SQL querying to more advanced topics like Data
Warehousing on the Microsoft Data Platform and Database Administration. As a consultant,
Magnus has worked with performance optimization, database security, high availability/disaster
recovery, studies about outsourcing/insourcing database operations, designing and modelling
databases and database administration.
Technology: SQL Server 2005/2008/2008R2/2012/2014/2016/2017/2019, Powershell, Docker
Containers, C#
2015 December - 2017 September Employed, Folksam
Application DBA
DBA for the SQL Server platform on Folksam. Worked with database development, infrastructural
planning for the database platform, company internal training, counseling, administering the
"database hotel", usage analysis and enterprise architecture.
Technologies: SQL Server 2005/2008/2008R2/2012/2014/2016
2011 - 2015 Employed, Statistics Sweden (SCB)
Database architect, DBA, manager, IT-coordination
Magnus was employed in 2011 as a database architect. Main focus was on the project "Svensk
Värdepapperdatabas", a new system for collecting, analyzing and publishing statistical information
about financial securities (mainly Debt-related securities). Magnus designed the data model,
created the ETL flows, created stored procedures and worked on requirements within the project.
In 2013, Magnus was appointed manager for a development team responsible for developing and
maintaining systems for the economical statistics, national accounts and environmental statistical
departments within SCB.
A year later, Magnus returned to the Database Architect role, combined with IT-coordination within
the economical statistics area. The focus was on two new systems, VINN and KRITA, systems
being developed for Riksbanken.
Magnus was a part of the DBA-team within SCB all these years. The DBA team worked with
database security, database audits, counseling to development teams.
Magnus created the training material for a four day course "SQL Server for developers", a course he
taught at both SCB and to database developers in Kosovo.
Teknology: SQL Server 2005/2008/2008R2/2012/2014/2016(CTPs)
2001 - 2011 Employed, Bahco Group, SNA Europe
Developer, Solutions Architect, project manager, DBA
CV
Database specialist SQL Server
Magnus Ahlkvist
Magnus started out as a web developer for Bahco Group and was soon appointed System Manager
for the Web- and Windows platform, then Solutions Architect and Project Manager. Regardless what
the e-mail signature said, Magnus took the responsibility for the SQL Server platform within the
company. He took care of backups and restores, planned and performed upgrades, performance
optimization, database development and documentation.
Teknik: SQL Server 6.5, 7.0, 2000, 2005, VB6, C#, VB.NET
Professional Experience
2016-04 - Present
2015-12 - 2017-09
2011-01 - 2015-01
2001-01 - 2011-01
2000-01 - 2000-01
1996-01 - 1998-01
Technology, Systems, Tools and Methods
Methodology: Scrum, Lean
Tools: Visual Studio, Microsoft SQL Server Management Studio, TFS, Powershell
Programming: .NET, C#, T-SQL, VB
Databases: SQL Server 6.0/6.5/7.0/2000/2005/2008/2008R2/2012/2014/2016/2017, MySQL
Academic Background
2019-12 - 2010-01
1998-01 - 2000-01
1995-01 - 1996-01