**Job Description:** **1. Architecture, Patterns and Technologies** * **Analyze, define and implement software architecture patterns** and technologies to be used. * **Analyze, define and implement solutions using emerging technologies** (e.g., Blockchain, Cloud, Artificial Intelligence - AI, Machine Learning - ML, Big Data). * **Conduct studies and Proof of Concepts (PoC)** for new technologies and patterns, seeking best practices and market trends. * **Document** architectural definitions and patterns. * **Analyze** the **impact of version and system migrations**. * **System Patterns:** Custom MVC architecture (Controller, Service, Model), Layered pattern: Controller Service Model, Modular directory structure (multiple independent modules), Custom include system and autoloading **2. Engineering and Operations (DevOps/DevSecOps)** * **Define and implement DevOps/DevSecOps solutions**, collaborating with the Infrastructure team. * **Automate deployment pipelines** (Continuous Integration/Continuous Delivery - CI/CD) for applications across various environments and languages. * Perform **integration, packaging** and merges of software versions. * **Manage and configure Cloud environments**, including service management and architectural aspects on platforms such as AWS. * Implement and configure **configuration management tools**. * Build and update **Jobs**, and monitor software versions. * **Audit code quality and security** in solution source code (DevSecOps). **3. Development and Maintenance** **Core Languages and Technologies:** PHP 7.4+ (object-oriented programming, namespaces, traits), PostgreSQL (complex queries, stored procedures, triggers, optimization), Advanced SQL (joins, subqueries, window functions, indexes) **Data Access:** ADODB (ActiveX Data Objects Database), PDO (PHP Data Objects) for PostgreSQL, Multiple database connections, Transactions and concurrency control, **Frontend and Libraries:** jQuery (versions 1.x and 3.x), Bootstrap 3 and 4, DataTables for listings, AJAX for asynchronous requests, Vanilla JavaScript and ES5/ES6, HTML5, CSS3, Libraries: Chosen, jQuery UI, Highcharts, Font Awesome **Tools and Version Control:** Subversion (SVN) for version control, Composer for PHP dependency management, Docker for development environments, Apache as web server **Analysis and Diagnosis:** Analysis of undocumented legacy code, Debugging multi-layered systems with dependencies, Identification of failure points in legacy integrations, Tracing complex data flows between modules, Understanding business logic implemented over years **Maintenance and Refactoring:** Gradual refactoring of legacy code, Migration from legacy patterns to modern patterns, Preservation of existing functionality during upgrades, Backward compatibility with previous versions, Handling procedural code mixed with OOP **System Integration:** Integration with legacy systems via SOAP, Consumption and creation of Web Services, Integration with government systems (SIAFI, SIOP, etc.), Handling of legacy data formats (XML, CSV), Custom authentication/authorization (GovBr, LDAP) **Performance and Optimization:** Optimization of complex PostgreSQL queries, Execution plan analysis, Identification and resolution of N+1 queries, Caching of frequent queries, Optimization of legacy PHP code **Code:** Follow existing naming conventions, Maintain compatibility with legacy code, Document changes in undocumented code, Create tests for critical functionalities, Avoid unnecessary breaking changes **Quality and Security:** Input data validation (SQL injection, XSS prevention), User data sanitization, Proper exception and error handling, Logging of critical operations, Review of legacy code for vulnerabilities **IDEs and Editors:** IDEs supporting PHP (PhpStorm, VS Code, NetBeans), Extensions for SVN, Debuggers (Xdebug), Static code analysis tools **Testing:** Unit testing (PHPUnit), Integration testing, Manual testing in staging environments, Validation of complex business rules **Monitoring and Logs:** Analysis of system logs (simec-access.log, simec-error.log), Performance monitoring, Identification of production errors, Tracing integration issues **4. Technical Leadership and Collaboration** * **Provide technical guidance and mentoring** to less experienced team members. * Collaborate with the development team and the Product Owner to **define, size and prioritize user stories**, and support sprint and release planning. * **Guide teams** on project standards to be adopted. **5. Contractual Requirements:** **Professional Experience:** * Minimum of 12 (twelve) years of professional experience in the relevant technical specialty area, **OR** * Minimum of 10 (ten) years of cumulative professional experience plus at least 4 (four) professional certifications in the candidate’s field of expertise and/or agile methodologies, issued by a recognized certification body. **Academic Qualifications:** * Completed undergraduate degree in IT or related fields **OR** * Undergraduate degree in any field + postgraduate degree in IT (minimum 360 hours) **Alternative Qualifications:** * Postgraduate degree/MBA in IT **OR** * 6 professional certifications in the candidate’s field of expertise or agile methodologies ### **Employment Type:** CLT ### **Department:** Government