Peut être disponible
(Mis à jour 2020-04-25)Erfaren databasutvecklare
Åstol, Västra Götalands län, Sverige
Natif Svenska, Courant English
- Kan BI via t.ex QlikView
- 11 års erfarenhet av Oracle
- 20 års erfarenhet av SQL
Compétences (23)
STORED PROCEDURES
DATABASE ADMINISTRATOR
Data Migration
Database Administration
SQL
Database Development
DATABASE MODELING
Database Design
DATABASE
PL/SQL
Oracle
Microsoft Access
MS SQL Server
Jira
MySQL
Git
STATISTICAL SAMPLING
CRM
LOGISTICS
QlikView
WMS
WAREHOUSE MANAGEMENT
PERFORMANCE TUNING
Résumé
Jan has worked since 1998 with the development of information systems. Among the assignments include development assignments on the General Council of the judiciary, as well as a long-term commitment on the newspaper Dagens industi with further development of Di.se and DBA/System Manager for Dagens Industri subscription system. Latest assignment is at Volvo Trucks as a part of a large migration from several old systems to one global system in the warehouse management area.
Jan has database development/database administration and development in .net as a special area.
Jan is self-propelled and focused and thrives in project groups which together working toward common goals.
Jan likes technical challenges, especially regarding databases, and the development of multilayered information systems.
Personal & social characteristics
Responsible, humble, comfortable enough, analytic.
Expérience professionnelle
2014-01 - Actuel
Place of residence: Åstol
2020-04 - 2020-04
Technological environment consisted of: Oracle 11 g, Oracle 12 c, PL/SQL, JDA Dispatcher, Unix, JIRA, Toad for Oracle, QlikView
Mission statement:
The Database Administrator implements and maintains Database(s) for a dedicated application, the application is a WMS (Warehouse Management System). The main tasks are database design, technical construction, development and data migration.
1998-01 - 1999-12
Customer/Department: Sysdeco Mimer AB
Technological environment consisted of: JavaScript, HTML 2.x, Tango, Mimer SQL, Interbase, C, Linux
Mission statement:
Education - preparation of course materials and teaching Tango. Support - First line support at Tango towards end customers Presale - technical support to vendors, demonstrations at trade shows. Development of an extranet where selected customers can login, leave support requests and read the news about the company and its products. Evaluated and tested the Interbase and compared with Mimer in competition monitoring.
Assignments: Database developer, Tester, trainer, Web developer
2007-07 - 2015-06
Technological environment consisted of: Oracle 9i, Oracle 11 g, PL/SQL, SQL Server 2012, SQL Server 2008, SQL Server 2005, T-SQL
Mission statement:
The database administrator is responsible that the subscription database is in good trim and table space is optimized.
The work involves administrative jobs in the database such as address selection, correction of incorrect transactions and the installation of new software delivery, service packs and upgrades. DBA also serves as a support to employees in the form of statistical sampling and interpretation of these.
The DBA is responsible for the external file dispatch software exporting materials to external partners.
If need be developed or maintained script/program for automatically executed selections/reports from the database or when periodic changes in the data needs to be done.
The DBA also serves as technical contact for suppliers/partners.
2006-10 - 2007-06
Customer/Department: Dagens industri - di.se
Technological environment consisted of: ASP, vbscript, XML, XSLT, SQL Server 2000, T-SQL
Mission statement:
Maintenance and further development of the webiste for the rapport and statistics of newspaper distribution.
2005-03 - 2007-06
Customer/Department: Dagens industri - di.se
Technological environment consisted of: Windows Server 2003, Microsoft Active Directory, IIS, .NET 1.x, .NET 2.0
Mission statement:
Operation and monitoring of the servers in the Microsoft environment for di.se and dinapengar.se
Role/title/system: System Administrator
Mission duration: 2005-03 - 2007-06
Customer/Department: Dagens industri - di.se
Technological environment consisted of: Visual Studio 2003, Visual Source Safe, .NET 1.x, .NET 2.0, IIS
Mission statement:
Deployment and update of the .Net Web applications on load-balanced servers. The applications consist of various components in the online magazine Di.se
2005-03 - 2007-06
Customer/Department: Dagens industri - di.se
Technological environment consisted of: SQL Server 2000, T-SQL and DTS
Mission statement:
SQL Server installation, operation, backup, configuring the system databases for Di.Se
2006-01 - 2007-06
Customer/Department: Dagens industri - di.se
Technological environment consisted of: VB.NET, SQL Server 2000, T-SQL and Visual Studio 2003
Mission statement:
Maintenance and new development for the sites di.se and dinapengar.se.
2006-10 - 2007-06
Customer/Department: Dagens industri - di.se
Technological environment consisted of: Visual Studio 2003, VB.NET, XML, XSLT, SQL Server 2000, T-SQL
Mission statement:
The development of windows service to take care of incoming data feeds in xml format.
2011-01 - 2014-01
2000-01 - 2011-01
2004-12 - 2005-02
Customer/Department: House of Brands AB - webshop
Technological environment consisted of: ASP.NET, C #, SQL Server 2000, T-SQL
Mission statement:
Design and implementation of online shop and related administrative tools.
2004-11 - 2004-11
Customer/Department: Engineering Sciences - EPiServer
Technological environment consisted of: EPi Server 4, ASP.NET Webforms, C #, SQL Server 2000
Mission statement:
Implementation of intranet in EpiServer
2004-11 - 2004-11
Customer/Department: Bergslagen's Environmental and Construction Management, time reporting
Technological environment consisted of: ASP.NET, C #, SQL Server 2000, T-SQL and XML
Mission statement:
Customization, development of Traci time reporting system.
2004-06 - 2004-08
Customer/Department: Nier-time reporting
Technological environment consisted of: C #, ASP.NET, SQL Server 2000, T-SQL, XML
Mission statement:
New version of the NTier Solutions time reporting system TRACI in .NET environment using data warehouses in SQL Server 2000. Stored procedures exclusively used for communication with the database to and from the data layer which is written in C #. The presentation layer consists of an ASP.NET application with WebForms and that uses C # as a scripting language.
2004-02 - 2004-05
Customer/Department: NTier Solutions AB-time reporting
Technological environment consisted of: C #, ASP.NET, SQL Server 2000, T-SQL, XML
Mission statement:
Customization, development of Traci time reporting system.
2003-11 - 2004-01
Customer/Department: Vägbyggarna HB - Management system
Technological environment consisted of: Access, VB.NET, T-SQL, SQL Server 2000 and Crystal Reports
Mission statement:
Conversion of systems to manage various reports in the construction industry from MS Access to VB.NET and SQL Server. Also included to manage report generation using Crystal Reports.
2003-06 - 2003-10
Customer/Department: Dagens industri AB - Danish trader.net
Technological environment consisted of: NET 1.x, C #, ASP.NET, XML, SQL Server 2000, T-SQL
Mission statement:
To Dagens Industri Danish sister magazine Börsen was developed an application to display stock information via Web interface. It provides stock quotes, news, portfolio and watchlist. In addition, there is support for personalization. Stock quotes are available via a custom dll from SIX (Scandinavian Information Exchange) as well as from its own databases.
2003-02 - 2003-05
Customer/Department: Dagens industri AB - DiTrader.net
Technological environment consisted of: NET 1.x, C #, ASP.NET, XML, SQL Server 2000 and T-SQL
Mission statement:
The previously DiTrader application was rewritten to work in. NET environment as well as to obtain information from other sources than previously.
2003-01 - 2003-01
Customer/Department: NTier Solutions AB
Technological environment consisted of: C #, ADO.NET And SQL Server
Mission statement:
A CRM application for managing the company's customer database in a SQL Server 2000 database
Role/title/system: Database Administrator, Database Designer, Database Developer, Web Developer, User Support
2002-01 - 2002-12
Technological environment consisted of: Visual Basic 6, ASP, JavaScript, vbscript, SQL Server 2000, T-SQL
Mission statement:
Further development, maintenance and optimization of the site Di.se. Overall responsibility for DiTrader. Database optimizations, further development and maintenance of interfaces and the middle tier. Development of administrative components for maintenance of the system. Support of Web services to external users.
2001-07 - 2001-12
Customer/Department: Dagens industri AB-di.se
Technological environment consisted of: Visual Basic 6, SQL Server 2000 and T-SQL
Mission statement:
A component that can be called via the network. You can via the properties set, besides the obvious recipient, subject and message text; mail server, sender and if the email is in HTML format or not. In the context of these was written a number of stored procedures that communicate with component which allows to send emails via the database.
2001-03 - 2001-07
Customer/Department: Dagens industri AB-di.se
Technological environment consisted of: Oracle 9i, PL/SQL, SQL Server 2000, T-SQL
Mission statement:
Stored procedures to import subscription data from Oracle to SQL Server. Imports is scheduled to run once per minute, 24 hours a day. Data from Oracle to either update existing data in SQL server or add new data depending on what the data shows.
2000-08 - 2001-02
Customer/Department: Dagens industri AB-di.se
Technological environment consisted of: ASP, vbscript, SQL Server 2000, T-SQL
Mission statement:
A portfolio service within the framework of DiTrader. The portfolios are located in a database and via web interface allows to simulate trading of stocks. There is also a search function and cash management
2000-03 - 2000-07
Customer/Department: Dagens industri AB-di.se
Technological environment consisted of: Visual Basic 6, SQL Server 2000, T-SQL
Mission statement:
Programs for dealing with files that either comes from external ftp or from the network. The files are in different formats (XML, comma-separated) and will be processed in order to be saved in the databases.
1998-01 - 2000-01
1998-05 - 1999-12
Customer/Department: Domstolsverket - internal statistics
Technological environment consisted of: Java, Javascript, C, SQL, Tango, Unix
Mission statement:
Design and implementation of internal statistics system. The system is used at all district and regional courts. The work was to develop a datawarehouse solution where a number of C programs running daily and aggregate input into a Web application, written in Tango.web application that uses a distributed database per court.
Parcours scolaire
1994-01 - 1997-01