Job Summary: Analyst/Programmer to support the IT department, responsible for maintaining and developing applications. Key Highlights: 1. Focus on C# (.NET) for Sage 50 and MS SQL Server integrations 2. PHP development for online stores and portals (Joomla MVC) 3. Knowledge of databases (MySQL/MariaDB) and JavaScript ANALYST / PROGRAMMER (M/F) A national company producing and distributing sports articles and sportswear seeks to select an Analyst/Programmer to support its IT department. The selected candidate will be responsible for maintaining and developing the company’s IT applications. Programming Languages: C# (.NET)     Highly relevant for:    Sage 50 (SDKs and local integrations)    Integrations with MS SQL Server       Key Knowledge Areas:   .NET Framework, .NET   Classes, interfaces, DTOs    REST API consumption (HttpClient)    JSON manipulation    Windows consoles and services Functional source code covering various Sage-related features will be provided. PHP (mandatory – intermediate/advanced level) ·        Highly relevant for: o   UIN SPORTS online store o   Sublime Portal o   New version of Sublime Portal Essential Knowledge PHP 7.4, 8.x Object-Oriented Programming (OOP) Namespaces Autoload (PSR-4) Exceptions Strict typing Traits (useful but not mandatory) Joomla-Specific Knowledge JFactory (legacy) Factory, Application, Session JModelLegacy, JViewLegacy, JControllerLegacy Joomla MVC Helpers and Libraries Overrides vs Core Joomla MVC Architecture Ability to build a component from scratch: com_exemplo/ admin controllers models views tables site controllers models views script.php exemplo.xml Required mastery: Controllers (admin vs site) Models (getItem, getListQuery) Views (tmpl default.php) Tables (bind, check, store) ACL (permissions) Component installation and update Database (MySQL / MariaDB) Mandatory Queries using JDatabaseDriver JDatabaseQuery Complex joins Subqueries Indexes Schema migrations (update SQL) VirtueMart Familiarity with tables: virtuemart_products virtuemart_product_prices virtuemart_product_medias virtuemart_orders virtuemart_order_items virtuemart_customfields JavaScript (required) Common stack Modern JavaScript jQuery (still widely used in Joomla VM) AJAX (index.php option=com_ajax) Frontend validations Interaction with VM checkout HTML + CSS (professional level) Bootstrap 4 / 5 Grid and responsiveness Compatibility with commercial templates Custom CSS without breaking updates Debugging JS/CSS conflicts Security CSRF (JSession::checkToken) XSS SQL Injection Sanitization (InputFilter) ACL (access levels) Permission management in admin