Key Responsibilities Design, develop, and maintain robust backend systems using Python & Django • Work with MySQL stored procedures, views, and functions to support complex business logic. • Ensure high performance of data-heavy systems, managing historical data efficiently (retention: 1 year). • Handle file upload and download operations, integrating with GCP buckets and generating public/private URLs. • Generate analytical reports using Python, store them on GCP, and manage scheduled or event-based triggers. • Write modular, reusable Python scripts that support timeline-based business logic execution for various modules . • Perform data validations, transformations, and error handling with accuracy. Write and maintain Shell scripts to automate tasks and integrate with cron jobs or CI/CD pipelines. • Integrate with Microsoft Graph API to send email notifications with attachments or inline content. • Monitor, profile, and optimize queries and stored procedures for performance in large datasets. • Collaborate with frontend and DevOps teams to ensure smooth deployment and data flow. • Document workflows, validation rules, and deployment processes clearly Technical Skills Required: Backend & Frameworks: • Python 3.x • Django / Django REST Framework • Experience with Timeline/Workflow-driven modules Database : Expert in MySQL with: Stored Procedures ,Functions ,Views , Query Optimization for high-volume data Partitioning and Indexing strategies • Experience in data lifecycle management (archival, purging, etc.) Cloud Integration: GCP (Google Cloud Platform): File storage using GCS (Google Cloud Storage) URL generation (signed URLs or public links) Automation and Scripting : Shell Scripting (bash/zsh) Cron jobs or scheduling systems Email and Communication: Integration with Microsoft Graph API to send emails Others: Git / Version control Preferred candidate profile • Experience working in high-scale data environments. • Familiarity with GCP IAM permissions and secure bucket access control. • Experience in analytics/reporting tools or libraries like Pandas, Matplotlib, or Plotly. • Knowledge of log monitoring and alerting tools (e.g., Prometheus, ELK stack). • Ability to troubleshoot and tune MySQL under heavy load conditions. Soft Skills • Strong communication and documentation skills. • Ability to understand and implement complex business workflows. • Self-motivated and comfortable working independently or as part of a team. Strong problem-solving and analytical thinking.
Role & responsibilities Design, develop, and implement MYSQL databases and tables according to predefined specifications • Optimize MYSQL queries and procedures for performance • Troubleshoot and resolve database issues to ensure data integrity and availability Participate in the design and development of database-driven applications • Create and maintain documentation regarding database design, architecture, and configuration - • Develop and enforce database security policies and procedures - • Collaborate with software developers, system administrators, and other stakeholders to ensure smooth database integration Preferred candidate profile Bachelor's degree in Computer Science or related field • Proven working experience as a MYSQL developer • Strong understanding of relational database management systems (RDBMS) • Proficiency in SQL and MYSQL programming • Experience in database performance tuning and optimization • Knowledge of data modeling and database design principles • Familiarity with software development methodologies and best practices • Excellent problem-solving and analytical skills • Ability to work independently and in a team environment Strong written and verbal communication skills.