Summary
Overview
Work History
Education
Skills
Career Experience
Personal Information
Work Availability
Work Preference
Languages
Timeline
Generic
Jan Ahlin

Jan Ahlin

Database Developer

Summary

Systematic Database Developer with over 20 years of experience in designing, engineering architecture, and data modeling. Proven track record managing all phases of the software development lifecycle (SDLC). Skilled in SQL, data modeling, and performance tuning to ensure reliability and efficiency in data management. Experienced in maintaining data integrity, managing backups, and developing automation scripts for streamlined workflows. Proficient in troubleshooting complex database issues and enhancing security protocols. Committed to delivering robust database solutions that improve scalability and support organizational growth. Adaptable as a quick learner and skilled as a collaborative team player, consistently contributing to high-performance teams and driving project success.

Overview

25
25
years of professional experience
2
2
Languages
3
3
years of post-secondary education

Work History

Database Developer /Oracle DBA

Volvo Trucks
01.2015 - 11.2024
  • Design and implement complex database structures to optimize data storage and retrieval processes
  • Contribute significantly to a global team to orchestrate advanced database solutions encompassing design, development, and data migration
  • Formulate and implement action database framework in alignment with business goals
  • Supervise development and seamless execution of data migration strategies, elevating system efficiency and data integrity
  • Conduct regular data audits and quality checks to identify and resolve anomalies, ensuring data integrity and reliability
  • Created and updated database designs and data models.
  • Spearheaded the setup and upkeep of Oracle 19c databases catering to a multinational Warehouse Management System, ensuring peak performance across EU, USA, and Canada regions
  • Identified issues within databases, performed troubleshooting and implemented effective solutions.
  • Succeeded in an Agile environment, utilizing Scrum methodologies and Azure DevOps for streamlined project management and timely delivery
  • Optimized database performance by implementing efficient indexing strategies and query optimizations.
  • Enhanced WMS uptime by 15% through strategic database supervision and performance enhancement
  • Wrote and maintained technical and functional specifications to document database intentions and requirements.
  • Oversaw the transformation of warehouse management across 20 global warehouses, resulting in significant cost savings
  • Resolved critical production issues within established SLAs, thus minimizing the impact on end-user experience and business operations.
  • Led the charge in adopting agile methodologies like Scrum and Azure DevOps, demonstrating adaptability and assisting team members in the process
  • Evaluated, designed, implemented, and modified databases and database applications.
  • Improved performance and data quality to reduce SLA breaches from high levels to nearly zero consistently
  • Created technical documentation for database technologies, providing updates.
  • Developed scripts and processes for data integration and maintenance.
  • Modified databases to meet needs and goals determined during planning process.
  • Built databases and table structures for web applications.
  • Provided training sessions for junior developers on best practices in SQL programming techniques aimed at improving code efficiency.
  • Collaborated with system architects, design analysts and others to understand business and industry requirements.
  • Developed and delivered business information solutions.
  • Reduced query execution time by analyzing and fine-tuning SQL statements in complex applications.
  • Contributed significantly to the organization''s productivity by maintaining high availability and reliability of critical database systems.
  • Diagnosed and resolved critical database issues promptly, minimizing the impact on business operations.
  • Developed custom scripts for automating routine tasks, increasing productivity and reducing manual labor.
  • Worked closely with developers to optimize SQL queries for better query performance across various applications utilizing Oracle databases.
  • Reviewed database design to recommend enhancements or improvements.
  • Ensured smooth application deployment by effectively managing version control systems and coordinating with system administrators during release cycles.
  • Followed standard methodologies on coding to write clean and self-documenting code.
  • Actively participated in project planning, resource allocation, and project management activities to ensure timely delivery of high-quality solutions.
  • Enhanced user satisfaction by providing timely support, resolving technical issues, and offering solutions to complex problems.
  • Streamlined data migration processes for seamless system upgrades and reduced downtime.
  • Conducted data modeling, performance and integration testing.

Database Administrator/Oracle DBA

Dagens Industri - Customer Service/Marketing
01.2007 - 01.2015
  • Orchestrated the design and implementation of database systems to meet specific organizational needs and requirements effectively
  • Conducted accurate data checks and rectified transactional discrepancies
  • Oversaw software deployments, updates, and patches to boost database efficiency and security
  • Collaborated with IT teams to monitor database performance, troubleshoot issues, and optimize system functionality
  • Optimized database performance by 20% through maintenance and optimizing storage usage
  • Administered systems for subscriptions and newspaper delivery at Dagens Industri, ensuring reliability and efficiency
  • Administered, supported, and monitored databases by proactively resolving database issues and maintaining servers.
  • Built databases and table structures for web applications.
  • Established proactive monitoring solutions that alerted administrators to potential issues before they escalated into major problems.
  • Implemented BI solution framework for business intelligence projects.
  • Empowered end-users with creation of user-friendly reports and dashboards, enhancing decision-making processes.
  • Optimized database performance by monitoring health and implementing tuning recommendations.
  • Enhanced reporting capabilities by designing efficient ETL processes that improved data accuracy and completeness.

Web Developer

Dagens Industri
02.2000 - 06.2007
  • Coded websites using HTML, CSS, JavaScript, and jQuery languages.
  • Planned website development, converting mockups into usable web presence with HTML, JavaScript, AJAX, and JSON coding.
  • Provided front-end development support, creating visually appealing designs that aligned with brand standards.
  • Enhanced user experience by implementing responsive web design and optimizing website performance.
  • Enhanced website performance by optimizing ASP.NET code and streamlining database queries.
  • Integrated third-party APIs to extend functionality and improve overall user experience for clients'' websites.
  • Contributed to the development of reusable code libraries, expediting future projects and enhancing overall efficiency.
  • Troubleshot and resolved complex technical issues, resulting in improved website functionality and reduced downtime.
  • Optimized web applications for speed, scalability and security.
  • Proved successful working within tight deadlines and a fast-paced environment.
  • Improved website responsiveness by implementing mobile-first design principles, increasing accessibility for users across various devices.

Education

No Degree - Computer Science

Uppsala University
Uppsala. Sweden
08.1994 - 12.1997

Skills

Database Architecture

undefined

Career Experience

  • Volvo Trucks, Gothenburg, Sweden, 01/01/15, Present, Database Engineer, 01/01/20, Present, Design and implement complex database structures to optimize data storage and retrieval processes., Contribute significantly to a global team to orchestrate advanced database solutions encompassing design, development, and data migration., Formulate and implement action database framework in alignment with business goals., Supervise development and seamless execution of data migration strategies, elevating system efficiency and data integrity., Manage a team of database administrators, providing leadership and guidance in database design, maintenance, and troubleshooting., Conduct regular data audits and quality checks to identify and resolve anomalies, ensuring data integrity and reliability., Database Engineer, 01/01/15, 12/31/19, Spearheaded the setup and upkeep of Oracle 19c databases catering to a multinational Warehouse Management System, ensuring peak performance across EU, USA, and Canada regions., Succeeded in an Agile environment, utilizing Scrum methodologies and Azure DevOps for streamlined project management and timely delivery., Enhanced WMS uptime by 15% through strategic database supervision and performance enhancement., Oversaw the transformation of warehouse management across 20 global warehouses, resulting in significant cost savings., Led the charge in adopting agile methodologies like Scrum and Azure DevOps, demonstrating adaptability and assisting team members in the process., Improved performance and data quality to reduce SLA breaches from high levels to nearly zero consistently.
  • Dagens Industri - Customer Service/Marketing, Stockholm, Sweden, 01/01/07, 12/31/15, Database Administrator, Orchestrated the design and implementation of database systems to meet specific organizational needs and requirements effectively., Conducted accurate data checks and rectified transactional discrepancies., Oversaw software deployments, updates, and patches to boost database efficiency and security., Collaborated with IT teams to monitor database performance, troubleshoot issues, and optimize system functionality., Optimized database performance by 20% through maintenance and optimizing storage usage., Administered systems for subscriptions and newspaper delivery at Dagens Industri, ensuring reliability and efficiency.

Personal Information

Willing To Relocate: True

Work Availability

monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse

Work Preference

Work Type

Contract WorkFull Time

Work Location

RemoteHybridOn-Site

Languages

Swedish
Bilingual or Proficient (C2)
English
Advanced (C1)

Timeline

Database Developer /Oracle DBA

Volvo Trucks
01.2015 - 11.2024

Database Administrator/Oracle DBA

Dagens Industri - Customer Service/Marketing
01.2007 - 01.2015

Web Developer

Dagens Industri
02.2000 - 06.2007

No Degree - Computer Science

Uppsala University
08.1994 - 12.1997
Jan AhlinDatabase Developer