In charge of leading report structure refactoring, handle things related to database, e.g. designing appropriate table relationships, performance tuning, making custom role structure combined with the way of project deployment for defending the attack. Additionally, making the website safe even under the DDoS attack by zero-database-IO captcha library which is rewritten by me and defense mode.
⦁ Microservice projects (with Django Rest Framework) development and maintenance
⦁ Design database role structure combined with project deployment for data security
⦁ Design multi-language translation structure
⦁ Design multi-database structure with Django Ninja for data integration (ETL) project
⦁ Rewrite django-simple-captcha library from database IO version to fully cache involved version.
⦁ Sentry integration with performance, query optimization, distributed tracing, release, deploy and issue tracking
⦁ Refactor report structure, modeling the way to build reports, tuning the performance with cache
⦁ Dealing with PostgreSQL related things, e.g. tuning performance by customizing system variables, database upgrading, designing appropriate indexes, and managing the connection pool with PgBouncer
⦁ Prevent the server from being attacked (CC Attack) by setting Nginx ModSecurity WAF, throttling APIs with one-click defense mode
⦁ Stress testing, performance testing and generating related reports with Locust
⦁ Kubernetes with Drone CI and Helm
⦁ Broadcast messages to pods dynamically with Google Cloud Pub/Sub
⦁ Handle async tasks with Celery and RabbitMQ
⦁ Analysis of over 1 billion-level rows of data in PostgreSQL for reports
⦁ Third-party APIs integration