Application Developer

Our established consulting firm requires talented software developers to create customised applications to automate our work processes.

• We are seeking a Python / MySQL Developer with 3 - 5 years years of experience to join our team.
• The ideal candidate will have deep knowledge and hands-on experience in Python, MySQL and associated platforms.
• You will play a critical role in designing, developing, and implementing complex database solutions, while ensuring the performance and efficiency of database systems.
• We need someone who can work independently in a fast-paced environment and is excited about tackling new challenges

What you will do:

• Design, develop, and maintain Python-based applications that interact with MySQL databases.
• Write efficient and optimized SQL queries, stored procedures, and functions to retrieve, manipulate, and analyse data.
• Create logical data models and translate into physical database structures that integrate with proposed database structures.
• Design, develop, validate, and communicate Business Intelligence (BI) solutions like dashboards, reports, KPIs, instrumentation, and alert tools
• Design and implement scalable solutions leveraging cloud technologies
• Write clean, efficient, and reusable code following OOP principles and coding standards.
• Implement authentication mechanisms, including OAuth2, JWT, or Laravel Passport.
• Database tuning experience, database integration design and implementation, and management of database projects.
• Perform data validation, cleansing, and transformation to ensure data integrity and accuracy.
• Understanding of the threading limitations of Python, and multi-process architecture
• Work with version control systems such as Git for code management and collaboration.
• Conduct code reviews, testing, debugging, and troubleshooting to ensure the reliability and performance of applications.
• Develop data visualization tools and reports to present insights and findings to stakeholders.
• Translate technical database issues, requirements, limitations and parameters for management and staff, and understand business work processes and business impact

What we are looking for:

• Bachelor's degree in Computer Science
• Hands-on experience in Python development and SQL database management.
• Proficiency in writing complex SQL queries, including joins, subqueries, and aggregations.
• Strong understanding of Python programming concepts, data structures, and algorithms.
• Experience with Python frameworks such as Django, Flask etc .
• Familiarity with database systems such as MySQL, or SQL Server.
• Knowledge of data visualization tools and libraries
• Excellent problem-solving, analytical, and communication skills.
• Must be able to work independently with little to no daily supervision, is a team player, open to ideas and learning.
• Work in a distributed team environment where team members are spread across numerous locations and often communicate virtually to support clients.
• Strong command of PostgreSQL and Oracle SQL/PLSQL, including stored procedures, functions, triggers, and complex SQL statements.
• Proficiency in Unix shell scripting is a plus.
• Expertise in Core Python
• Familiarity with event-driven programming in Python
• Problem-Solving Skills: Excellent debugging and problem-analysis skills, able to resolve complex technical issues efficiently.
• Performance Optimization: Hands-on experience in tuning SQL queries for performance Self-Motivation: Ability to work independently and deliver high-quality results within tight deadlines.
• Solid database concepts and database design knowledge (ACID, abstraction levels, schemas and constraints, stored procedures, replication, etc.)
• Strong troubleshooting skill in database performance analysis and improvements.
• Good knowledge of storage, networking, and other systems directly impacting database performance.
• Solid experience in the administration and performance tuning of database-related tools and environments.
• Proven working experience in configuring and troubleshooting UNIX/Linux-based environments.
• MySQL Query Expertise: Strong ability to write complex SQL queries, optimize query performance, and create stored procedures, triggers, and views to handle business logic and reporting requirements.
• MySQL Administration: In-depth knowledge of MySQL database architecture, tools, and techniques.
• Backup & Restore Techniques: Extensive experience with database backup and recovery strategies, including point-in-time recovery and high availability setups.
• Database Performance Tuning: Knowledge of indexing, query optimization, and techniques for ensuring optimal database performance and resource management.
• Replication & Clustering: Experience in configuring and managing MySQL replication (master-slave, master-master) and clustering solutions (such as MySQL NDB or Galera Cluster).

You must have very good oral and written communication skills and be fully fluent in English