Senior Odoo Code and Performance Optimization Expert

Il y a 1 jour

Kairouan, Tunisie Norconsult Telematics Temps plein
This is a full-time on-site job, based in Riyadh, Saudi Arabia. Position Objective: Improve the performance, scalability and reliability of the company’s Odoo platform by identifying and resolving bottlenecks across application code, PostgreSQL databases and supporting infrastructure. Deliver measurable improvements in response times and concurrent-user capacity while maintaining functionality, security and data integrity, and strengthen the development team’s performance optimization practices.

Job Description
&

Responsibilities:
• Establish performance baselines for priority user journeys, distinguishing system processing time from user waiting time, and agree measurable response-time targets with relevant stakeholders.
• Profile Odoo, Python, PostgreSQL and infrastructure components to identify the underlying causes of latency, lock contention, excessive memory consumption and repeated processing.
• Develop and maintain a prioritized optimization backlog, identifying specific code, database and infrastructure changes based on business impact and technical findings.
• Refactor custom Odoo modules and Python code to reduce unnecessary database queries, repeated computations and inefficient processing, batching or caching.
• Optimize PostgreSQL queries, indexes, execution plans and transaction handling while preserving application correctness, security and data integrity.
• Review and tune Linux/RHEL, Nginx and Docker configurations to address resource constraints, connection limits, timeouts and host or container bottlenecks.
• Conduct repeatable performance and load testing in a representative preproduction environment to validate response times, peak-load concurrency and the impact of migrations.
• Deliver changes through peer-reviewed pull requests, automated regression testing, controlled releases and post-release verification.
• Establish agreed baselines, a ranked optimization backlog and validated initial fixes within the first 30 days; implement priority improvements and demonstrate comparable before-and-after results within 60 days.
• Demonstrate sustained performance improvements within 90 days, supported by monitoring, regression checks and documented optimization practices.
• Document findings, implemented changes and measured outcomes, and coach developers to prevent recurring performance issues. Qualifications &

Experience:
• Bachelor’s degree in Computer Science, Software Engineering, Information Technology or a related discipline, or equivalent practical experience.
• Minimum 7 years of software engineering experience, including at least 5 years of hands-on Odoo development and a proven track record of optimizing production environments.
• Experience with recent Odoo versions; Odoo 18 experience is preferred.
• Advanced Python development skills, including debugging, algorithm optimization and memory analysis.
• In-depth knowledge of the Odoo ORM, including inheritance, domains, computed and stored fields, dependency tracking, caching, scheduled jobs, access rights and record rules.
• Advanced PostgreSQL skills, including SQL, execution-plan analysis using EXPLAIN ANALYZE with BUFFERS, indexing, query statistics, transactions, locking, deadlocks and connection management.
• Strong understanding of PostgreSQL planner statistics and autovacuum, with the ability to trace database bottlenecks to application code.
• Hands-on experience with Odoo SQL and Periodic profiling, Python profiling using cProfile or equivalent tools, and memory profiling.
• Ability to interpret call stacks and flame graphs and correlate findings with PostgreSQL statistics, including pg_stat_statements, pg_stat_activity and pg_locks, and ELK logs.
• Strong Linux/RHEL administration and Nginx configuration skills, including CPU, memory and I/O diagnostics, reverse proxies, load balancing, TLS, request and upstream timing, connection limits and timeouts.
• Hands-on Docker experience covering Dockerfiles, image builds, Compose, networking, volumes, health checks, logs and resource limits, including troubleshooting CPU throttling and out-of-memory events.
• Experience with API integrations, Git, CI/CD pipelines, automated testing and load-testing tools such as Locust, JMeter or k6.
• Strong analytical, documentation and communication skills, with the ability to implement production fixes and transfer knowledge to the development team.
• Ability to present two production performance optimization case studies demonstrating the problem, personal contribution and measurable before-and-after results.