SQL Server Technical Specialist
Du kommer ofta att höra Göran säga: ”Låt oss först automatisera allt som går. Det blir robust. Sedan övervakar vi det hela, och hjälper Er fram! Marknaden utvecklas ständigt, och vi vill se till att ni ligger i framkant. Till marknadens bästa villkor.”
Med 20 år i branschen i ryggen och en ständig drive att effektivisera, kommer Görans erfarenhet att passa väl in när Du söker en senior konsult till rådgivarrollen, men även för rollen som Senior DBA i de kritiska dag-till-dag-processerna.
Som Civilekonom i botten har Göran en uppskattad förståelse och intresse för Kundens Affär, och att resurser används så effektivt som möjligt.
SQL Server Tech Lead/Senior DBA
112 SOS Alarm HK, Stockholm
In its ongoing work on the improvement of IT infrastructure, SOS Alarm identified the need for a thorough analysis and consolidation of the organization’s SQL Server environments.
This affects the entire operation, from the Alarm Sector to Data Marts and business database management.
As one of the foremost in his field of knowledge, Goran was engaged as responsible for carrying out this complex and critical mission.
The complete SQL Server environment is migrated and updated to keep SOS Alarm on the technical forefront of the market.
Top design goals are automation, "hands-off" management and top performance.
As a consequence of this, there is increased quality in the areas of safety, robustness and transparency of the systems.
The Consolidation Project is expected to be fully implemented before Q4, 2019.
SQL Server Lead Developer/Tech Lead
During 2017 there was a request for a SQL Server Lead Developer to take the total technical responsibility for the development of Bisnode's “Synced Marketing” Software.
Göran filled that role, working closely with marketing lead. He developed business cases, code and methods.
Göran also refactored existing code and developed new business modules software code. The main programming language was TSQL, and some C#.
The mission also included to develop methods for regression testing and secure and automated data transfer.
Senior SQL DBA / Project Lead /Advisor
CRAMO HQ Stockholm
Göran was assigned the task of designing and delivering a complete SQL Server Operations Model for CRAMO, including all aspects as Life Cycle management, deployment, monitoring, security, patching, incident/problem management, as well as to operating the SQL environment on an automated basis.
During 2013 Göran was Technical Lead for migrating production SQL Clusters geographically without system outages and without modifications to the application end. Project had 100% success rate.
During 2016 a new D/R solution based on Windows Azure SQL Server and a modern MS FCI OnPrem was built by and on design by Göran. No Business downtime was experienced. As a by-product, all systems were upgraded to SQL Server 2014 on a system-by-system basis for continuous delivery.
Senior SQL DBA/Technical Specialist
Acne Studios HQ IT Stockholm
To support strong business growth, Göran was assigned to design and implement a new HA Model for the business’ SQL Infrastructure, consolidating the most important system. The solution comprised upgrading to SQL Server 2014, migration of Microsoft Dynamics and Biz Talk. The assignment included both SQL Design/Technical Lead and implementation.
Göran was given the assignment to redesign and implement a new HA Model for an online-payment solution, based on geo-clustering. The solution chosen was to upgrade to SQL2012 and implement AlwaysOn on a virtual platform. The assignment included both SQL Design/Technical Lead and implementation.
Göran was given the assignment to help SOBI (Swedish Orphan Biovitrum) upgrade Infrastructure SQL Servers to SQL2012 on the HyperV-platform.
The assignment included both disk consolidation and database consolidation.
Senior SQL DBA / Project Lead / Advisor
Klintberg & Way Stockholm
Göran was asked to take on the task of designing and delivering a complete SQL Server Operations Model for K&W, including Life Cycle management, deployment, monitoring, security, patching, incident/problem management, as well as to operating the SQL environment on an automated basis.
Technical Specialist / Project Lead
CRAMO HQ Stockholm
Göran was the Project Lead for consolidating and upgrading CRAMO’s SQL based systems up to the SQL 2008 R2 level.
In the assignment was also to design an optimized technical operations model, comprising HA.
The systems were upgraded and consolidated into the new production cluster, designed and configured by Göran.
HP Stockholm / Major insurance company
Göran was assigned as acting Advisor in the project for a major insurance company consolidating their complete SQL environment into a Virtual Platform. Göran covered all technical aspects, such as overall design-, deployment- and system integrations issues.
System Design / Project Lead
Swedish SOS Authorities
The project goal was to design and implement a Super-High-Availability distributed SQL system with the highest goals set by the most demanding “blue light” authorities in Sweden.
The technical specification included “No downtime allowed, and built-in self-reconciliation with complete data integrity”.
The customer have deployed the system with 100% success rate.
Senior SQL DBA
Rikskuponger HQ Stockholm
Göran exercised the roles as Technical Project Lead as well as Solution Design and Implementing, in the respective stages during the assignment.
The assignment was to build a new consolidated SQL operations environment from the ground up, maintaining Rikskuponger’s high demands for performance and security. The system is a banking system based on issuing & redemption of vouchers.
The existing systems was analyzed and documented, all systems were upgraded to SQL Server 2008 R2 and a SQL dedicated SAN was set up, maintaining the new production cluster.
Senior SQL DBA, System Manager and Technical Specialist
Trygg Hansa, Volvo IT, Unisys, IBMA/Astra Zeneca R&D
2003 - 2010
2009 – 2010 Trygg Hansa HQ Stockholm – Nordic SQL Team - Senior SQL DBA
2007 – 2009 Volvo IT – Global 3rd line SQL Team - Senior SQL DBA
2006 Unisys – North Europe Server Center - Senior SQL DBA
2003 – 2008 IBM/AstraZeneca R&D – System Management - SQL DBA
Examples of typical assignments: consolidating hundreds of SQL Server systems, maintaining global SQL Systems, designing and building Microsoft Clusters, writing global Clustering White Papers, migrate Oracle to SQL Server, upgrade old/flawed systems, responsible for new snapshot based backup technology, technical resource in projects, plus all daily SQL DBA chores.
Kompetenser & erfarenheter
Göran Peterson är en rutinerad och trygg konsult att ha med sig när viktiga steg skall tas, eller när man behöver förstå om, och i så fall hur, man behöver modernisera sitt datasystem.
Ditt företags affärsverksamhet utgör grunden för bedömningen om hur SQL Server bäst gör nytta i företaget. Ibland behöver det inte vara särskilt märkvärdigt, och ibland krävs det tung komplexitet, när många system är inblandade. Oavsett vilket, hjälper Göran verksamheten fram till den mest effektiva lösningen på marknaden. Erfarenheten av hundratals uppdrag i de mest skiftande typer av företagsstorlekar och typer är idag en sällsynt och eftertraktad merit som vi är glada att kunna erbjuda våra kunder. Var beredd på att uthärda rätt mycket göteborgska ordvitsar och mycket musik bara.
Göran har hjälpt Microsoft Sverige vid lanseringen av SQL Server 2014 och agerat som Partner Seller (teknisk pre-sale) under 2014 - 2016.
Svenska, modersmål. Affärsengelska flytande i tal och skrift.
Göran har varit en uppskattad konsult på följande företag
2016 – GetItNordic AB – Senior SQL Server DBA
2010 – 2016 B3IT Connexions AB – Senior SQL Server DBA
2004 – 2010 QBranch – Senior SQL Server DBA
2001 – 2004 Border Consulting – Senior Consultant and Project Lead
1997 – 2001 Endero – Senior Consultant and Project Lead
Utbildning & Certifikat
- #Microsoft SQL Server
- #SQL Server Azure Cloud
- #Windows Failover Clustering
- #SQL Failover Clustering
- #Data Security
- #Database Design
- #Disaster Recovery (D/R) Configuration
- #AlwaysOn Availability Groups
- #Data Migration/Upgrade
- #Business Intelligence (infrastructure)
- #Windows Server
- #Name Resolution Protocol
About GetIT Nordic
GetIT Nordic is a consulting and advisory company that started in 2012 by Alfred Ström. We have operations in Sweden and Norway, with its head office in Gothenburg. We assist our customers with advice and delivery of projects to improve efficiency and create opportunities to invest in a more efficient manner than has been done historically. Today's IT is extremely agile , therefore GetIT Nordic chosen to be completely disconnected to suppliers when we want to be completely independent and unbiased in our recommendations .
GetIT Nordic has since had a good performance , we are now about 25 employees in Sweden and Norway.
We believe that success does not come out of itself, but through hard work and by giving that little extra. Therefore, the additional involvement is a core value at GetIT Nordic.