Tomas Helgi Johannsson
Database Administrator / Software Engineer
  • Garðabæ,
  • Iceland
Member Since: 1999/04/06
Industry: Finance
Top Skills:
Tech Certifications:
View All
CERTIFIED EXPERT

Over 20 years of experience as an Application Architect/Developer, a Database Administrator, and a PM focusing on performance.

More bio
Activity
Points this month2,141
Total points2,435,366
Questions: 74
Solutions: 1445
Articles: 6
Videos:
Tutorials:
Posts:
Group Discussions: 13
Professional Background
No Professional Background shown
More
Education
University of Iceland
Bachelor of Science
Computer Science
1995 – 1998
Peer Counsellor for the C.S. in 1996-1998
More
Full Biography

I have over 20 years of experience as an Application Architect/Developer, a Database Administrator, and a Project Manager in a wide variety of business applications with a primary focus on performance.

During the past 15 years, my main focus has been on becoming a performance expert. In doing so, I have accumulated extensive experience and knowledge in programming in Java, Delphi, and C++, as well as gaining a deep and extensive expert knowledge in database design on DB2 (both on LUW and z/OS ) , Oracle and  MySQL/MariaDB databases. Not to mention expertise in SQL language with a main focus on queries in medium to larger, database, and data-warehouse environments.

Additionally, throughout the past decade, I have done independent research on best application and database design practices to enhance optimal performance.  I thoroughly enjoy researching various aspects of Database performance and technologies in my free time and often share my findings with coworkers and colleagues around the world.  
Through my research, I have obtained a broad understanding of development best practices and gained extensive experience in UML/RUP and other technical development/project management standards such as Prince2, Kanban, and Agile.

My main interest lies in client/server programming and distributed relational database design using DB2, Oracle, or  MySQL/MariaDB.

Overall, I am an extremely self-motivated individual and have demonstrated an exceptional aptitude for new/current/legacy technologies and problem-solving skills in every project in which I have taken part.

I have experience in the following programming languages
C/C++
Delphi
Java
SQL and PL/SQL
Visual Basic
Perl / PHP
and
Ada

and following Groupware-applications
Lotus Notes
Outlook

Experience and worked with the following databases
Oracle
MySQL
MariaDB
MS SQL
BTrieve
Pervasive SQL
PostgresSQL
DB2 UDB v. 8.2.x, 9.x, 10.1, 10.5, 11.1 , 11.5 on LUW
DB2 for z/OS v. 7.1, 8.1, 9.1, 10, 11, 12

Platforms that I have experience in
Unix
Linux
Windows
Macintosh (MacOS)
RiscOS
z/OS

More
Languages
Icelandic
Native or Bilingual Proficiency
Swedish
Native or Bilingual Proficiency
English
Native or Bilingual Proficiency

Level Progress

Current: Level 34
Tomas Helgi needs 14,634 points to level up.
LVL 35
  • Overall
    34
  • MySQL Server
    22
  • Databases
    17
  • SQL
    14
  • Java
    13
  • DB2
    12
  • Linux
    11
  • Java EE
    10
  • Oracle Database
    9
  • Microsoft SQL Server
    8
  • PHP
    8
  • Windows OS
    7
  • PostgreSQL
    7
  • JSP
    6
  • Delphi
    6
  • Linux Distributions
    6
  • Python
    4
  • Percona
    4
  • Web Development
    4
  • Apache Web Server
    3
  • Windows Server 2012
    3
  • Windows Server 2008
    3
  • Linux OS Dev
    3
  • Editors IDEs
    3
  • Microsoft Access
    3
  • Programming
    3
  • Ubuntu
    3
  • Windows 10
    3
  • Web Servers
    3
  • Installation
    3
  • Big Data
    3
  • Visual Basic.NET
    3
  • Unix OS
    3
  • Virtualization
    3
  • Mainframe OS
    3
  • Redhat
    2
  • NoSQL Databases
    2
  • LXC
    2
  • AWS
    2
  • MongoDB
    2
  • Programming Languages-Other
    2
  • Linux Networking
    2
  • Security
    2
  • .NET Programming
    2
  • Web Applications
    2
  • Microsoft Excel
    2
  • Storage Software
    2
  • Microsoft SQL Server 2008
    2
  • Java App Servers
    2
  • Scripting Languages
    2
  • Encryption
    2
  • Mainframe Languages
    2
  • Networking
    2
  • Android
    2
  • Shell Scripting
    2
  • Content Management
    2
  • Application Servers
    2
  • Software
    2
  • Web Languages and Standards
    2
  • REST
    2
  • Images and Photos
    2
  • JSON
    2
  • WordPress
    2
  • Regular Expressions
    2
  • Operating Systems
    2
  • VB Script
    2
  • C#
    2
  • SSIS
    2
  • HTML
    1
  • Web Components
    1
  • Web Services
    1
  • Chat / IM
    1
  • Cloud Services
    1
  • Email Servers
    1
  • ASP
    1
  • Windows Batch
    1
  • SSL / HTTPS
    1
  • Sybase Database
    1
  • Microsoft Development
    1
  • VBA
    1
  • Cloud Computing
    1
  • Linux Security
    1
  • Statistical Packages
    1
  • C
    1
  • ASP.NET
    1
  • Networking Protocols
    1
  • COBOL
    1
  • XML
    1
  • Docker
    1
  • Microsoft IIS Web Server
    1
  • OS Security
    1
  • Storage
    1
  • Microsoft SQL Server 2005
    1
  • C++
    1
  • Windows 7
    1
  • Azure
    1
  • JavaScript
    1
  • Miscellaneous
    1
  • Microsoft Office
    1
  • E-Commerce
    1
  • Desktops
    1
  • ColdFusion Language
    1
  • Adobe Acrobat
    1
  • Email Clients
    1
  • Web Development Software
    1
  • Windows Networking
    1
  • Power BI
    1
  • Web Browsers
    1
  • Windows Server 2003
    1
  • Powershell
    1
  • Algorithms
    1
  • SSH / Telnet Software
    1
  • DNS
    1
  • R
    1
  • IBM System i
    1
  • Microsoft Server OS
    1
  • Google
    1
  • Math / Science
    1
  • Adobe Dreamweaver
    1
  • WCF
    1
  • Active Directory
    1
  • CSS
    1
  • Enterprise Software
    1
  • Joomla
    1
  • Node.js
    1
  • Remote Access
    1
  • Smartphones
    1
  • VMware
    1
  • Web-Based CMS
    1
  • PDF
    1
  • WSUS
    1
  • Windows Server 2016
    1
  • AWS RDS
    1
  • Disaster Recovery
    1
  • Mobile
    1
  • iOS
    1
  • Visual Basic Classic
    1
  • Facebook
    1
  • Google Workspace
    1
  • Ruby
    1
  • Perl
    1
  • Assembly
    1
  • DB Reporting Tools
    1
  • Microsoft 365
    1
  • SolarWinds
    1
  • Windows Server 2019
    1
  • .NET App Servers
    1
  • Crystal Reports
    1
  • Email Software
    1
  • Firefox
    1
  • GIS/GPS Programming
    1
  • Mac OS X
    1
  • Microsoft DOS
    1
  • Pascal
    1
  • Raspberry Pi
    1
  • System Utilities
    1