Design, develop, and maintain robust and scalable backend applications and services using Python and relevant frameworks (e.g., Django, Flask, FastAPI).
Design, implement, and optimize MySQL databases, including schema design, table creation, and view management.
Write and optimize complex SQL queries for data retrieval, manipulation, and reporting.
Integrate Python applications with MySQL databases, ensuring efficient data exchange and integrity.
Collaborate with front-end developers to define API specifications and integrate backend services.
Perform testing, debugging, and performance tuning of Python applications and MySQL queries.
Implement data processing pipelines and ensure data security and integrity.
Participate in code reviews, contribute to architectural discussions, and adhere to best practices.
Monitor database performance, identify bottlenecks, and implement solutions for optimization.
Stay updated with the latest Python and MySQL technologies and trends.
Required Skills and Experience:
Proficiency in Python programming language and its core concepts.
Experience with Python web frameworks like Django, Flask, or FastAPI.
Strong understanding of relational database concepts and extensive experience with MySQL.
Expertise in writing and optimizing complex SQL queries.
Experience with database design, modeling, and administration.
Familiarity with RESTful APIs and microservices architecture.
Knowledge of version control systems, preferably Git.
Understanding of data structures, algorithms, and object-oriented programming (OOP).
Experience with testing frameworks and debugging tools.