We're seeking an experienced Senior Full Stack Engineer to join our engineering team. You'll be responsible for building and maintaining scalable web applications across our technology stack, contributing to architectural decisions, and mentoring junior team members. A strong understanding of SQL optimization, database performance, and technical SEO principles is essential for this role.
Key Responsibilities
- Design, develop, and maintain full stack web applications using our modern technology stack
- Build robust backend services with PHP (Yii2, Laravel) and Node.js/TypeScript
- Develop responsive, SEO-optimized frontend applications using React, Next.js, and Razzle
- Implement technical SEO best practices including server-side rendering, meta tags, structured data, and sitemap generation
- Optimize database performance through query optimization, proper indexing strategies, and efficient schema design
- Analyze and improve slow queries, implement database performance monitoring, and resolve bottlenecks
- Design and maintain scalable database architectures for both MySQL and MongoDB
- Deploy and manage applications on AWS infrastructure (EKS, Lambda)
- Implement caching strategies using Redis and Memcache to reduce database load
- Configure and maintain search solutions with Typesense, Solr, or Elasticsearch
- Containerize applications using Docker for consistent deployment
- Troubleshoot complex technical issues and provide innovative solutions
- Participate in code reviews and contribute to technical documentation
- Work with cross-functional teams to deliver high-quality features
- Mentor junior engineers and contribute to team growth
Requirements
- 5+ years of professional software development experience
- Strong proficiency in PHP with hands-on experience in Yii2 and/or Laravel frameworks
- Solid experience with Node.js and TypeScript
- Expertise in React and familiarity with Next.js or similar SSR frameworks
- Strong SQL skills with proven experience in query optimization, indexing strategies, and performance tuning
- Deep understanding of MySQL including query execution plans (EXPLAIN), index types (B-tree, Hash, Full-text), and table optimization
- Experience with MongoDB including aggregation pipelines, indexing, and query optimization
- Ability to identify and resolve N+1 query problems, implement efficient joins, and optimize complex queries
- Experience with database profiling tools and performance monitoring
- Strong understanding of technical SEO principles and implementation
- Experience with server-side rendering (SSR) and static site generation (SSG) for SEO optimization
- Knowledge of SEO best practices including meta tags, Open Graph, structured data (JSON-LD, Schema.org), canonical URLs, and XML sitemaps
- Proven experience with AWS services, particularly EKS and Lambda
- Experience implementing caching layers with Redis and/or Memcache
- Hands-on experience with at least one search engine (Typesense, Solr, or Elasticsearch)
- Proficiency with Docker and containerization practices
- Excellent problem-solving skills and ability to debug complex issues
- Strong understanding of RESTful API design and microservices architecture
- Experience with version control systems (Git)
- Bachelor's degree in Computer Science or equivalent practical experience