Architect, build, and maintain high-performance microservices (using Java/Go) that interact seamlessly with our PostgreSQL infrastructure.
Execute code reviews and other peer review processes (e.g., pair programming) to ensure code quality and security practices.
Design efficient database schemas, data models, and complex queries to support distributed microservice architectures.
Implement efficient table partitioning strategies (e.g., declarative partitioning) and data retention models to support low-latency querying at high volume.
Diagnose and resolve database execution bottlenecks in production, analyzing EXPLAIN ANALYZE query plans, locking issues, and table/index bloat.
Triage product and systems issues, including debugging and monitoring, aiming to resolve problems and identify root causes.
Research new technologies, including hands-on technical evaluation and POCs.
Collaborate with software engineers, architects, UI/UX designers, and product managers to deliver high-quality solutions.
Produce and contribute to high-quality documentation.
Participate in conversations and workshops with stakeholders to understand requirements and identify solutions and opportunities.
Lead technical design reviews and cultivate a culture of engineering excellence through proactive mentorship and knowledge sharing.