Andrew S.

Design microservices architecture and database; Managing the day-to-day activities of the team; Providing technical leadership to the application development team; Full-stack development; Implementing designer layouts; Turning UI/UX designs into prototypes, creating excellent interactions from designs, writing reusable content modules and maintainability of the code; Implement dynamic React components; Set up Server-Side Rendering (SSR) using Next.js; Tuned Redshift performance by optimizing query performance; Store and manage unstructured data, such as blobs, files, and queues, using AWS S3; Using AWS SNS to receive notifications when metric threshold breached in AWS CloudWatch; Integration with ChatGPT; Created endpoint for image analysis using GPT4-V and content generation using GPT3.5; AWS RDS database performance monitoring; Building AWS infrastructure with Terraform; Automate the deployment process of AWS EKS cluster using Terraform; Implementing AWS Lambda function to process AWS SNS notifications; Connect AWS Lambda to events in AWS Cognito; Configuring Kafka replication; Kafka configuration for communication between services; Create and implement SQL database structures to meet application requirements; Analyze SQL query performance using query execution plans and optimize as needed; Designing and configuring CI/CD pipelines using Jenkins; Following TDD principle; Mentoring newcomers; Code review.

Full-stack development; Creating adaptable web layouts; Streamlining development workflow and bundle size with Webpack; Build serverless part of the application; Set up AWS Lambda triggers to execute additional tasks whenever an AWS DynamoDB table is updated; Build data lake on AWS S3; Enable automatic backups on AWS RDS; Integrate external services with the application; Identify and resolve performance issues with SQL queries, including high resource usage and slow response times; Implement Kubernetes (k8s) load balancing; Develop complex integration tests; Automate the build, test, and deployment processes; Creating and configuring Jenkins jobs for different stages of the CI/CD pipeline (e.g. building, testing, deploying); Implement notifications using AWS SNS; Create complex migrations in raw SQL; Write bash scripts for deployment tasks.

Full-stack development; Conduct security and penetration testing on the application; Creating adaptable web layouts; Form creation and configuration using Formik; Asset optimization; Implementing serverless part using Cloud Functions; Establish Cloud Engine instances and troubleshoot any issues that may arise; Optimize SQL databases for performance; Document the API using Swagger; Create scripts and files for automating tasks, as well as packaging and deploying applications in containers; Inspect and optimize stored procedures and SQL queries; Split Celery tasks by priority; Participate in the configuration of CI/CD processes; Write technical documentation to aid in the development and maintenance of the application.

Full-stack development; Creating flexible components from Figma; Refactor existing state management; Create technical and API documentation that meets required standards; Integrate the application with third-party services; GCP Cloud Storage configuration for storing images and other files; Scaling Compute Engine instances; GCP BigTable data migration; Monitor SQL server performance using tools and scripts; Following CDD principle of development; Create and manage indexes to improve the performance of SQL queries; Write automated tests to ensure quality and prevent regressions.