We’re building an AI-powered clinic assistant that actually gets things done—booking appointments, managing vaccine records, handling FAQs, and even sounding like the clinic itself. This is multi-modal AI in the real world, not a demo.
⸻
We’re looking for product-minded engineers who want to push the boundaries of generative AI, RAG, and intelligent automation. You’ll ship fast, solve real user problems, and help us make AI feel magical, not clunky. Tech stack: TypeScript, NestJS, React, React Native, AWS. Bonus: AI experience, but what matters most is product intuition and the drive to build useful things.
Hey wmonk.
I am a full-stack software engineer with experience developing mobile applications doing my master's degree at the University of Illinois Urbana-Champaign, one of the top schools in the country for computer science, and our university is hosting a new venture challenge that you might benefit from.
It is called Cozad New Venture Program and is Illinois’ largest venture creation program (https://tec.illinois.edu/programs/cozad). Basically, it is for startups and only open to current students, and winners can get investments of up $60,000+.
I am a current student there and would love to work with you as a Full-Stack Software Developer and represent PetsApp in that challenge cause I love your idea. You can look at my quality of work and if you like it, you can hire me as a Full Stack Software Developer at PetsApp. It is a win-win for both as I can bring both investment and skill, and can get a job in return if I am worth it.
Happy to talk about it more. Let's connect.
My email: agarwalkeshav8399@gmail.com
PetsApp – The future of pet care | Remote (US/UK/EU)
Open roles:
- Full Stack Engineer $150k–$230k | Full-time
We’re building an AI-powered clinic assistant that actually gets things done—booking appointments, managing vaccine records, handling FAQs, and even sounding like the clinic itself. This is multi-modal AI in the real world, not a demo.
⸻
We’re looking for product-minded engineers who want to push the boundaries of generative AI, RAG, and intelligent automation. You’ll ship fast, solve real user problems, and help us make AI feel magical, not clunky.
Tech stack: TypeScript, NestJS, React, React Native, AWS. Bonus: AI experience, but what matters most is product intuition and the drive to build useful things.
Apply here: https://forms.gle/5fww8HDwRrP6c6Fo9
The section of using functions on indexes could do with more explicit and deeper explanation. When you use the function on the index it becomes a full scan of the data instead as the query runner has to run the function on every row and column, effectively removing any benefit of the index.
The given solution (create an indexed UPPER(name) column) is not the best way to solve this, at least not on MS SQL Server. Not sure if this is equally supported in other databases, but the better solution is to create a case-insensitive computed column:
ALTER TABLE example ADD name_ci AS name COLLATE SQL_Latin1_General_CI_AS;
It depends on the database system, but for systems that support functional indexes, you can create an index using the same function expression that you use in the query, and the query optimizer will recognize that they match up and use the index.
For example, you define an index on UPPER(name_column), and in your query you can use WHERE UPPER(name_to_search_for) = UPPER(name_column), and it will use the index.
PetsApp – The future of pet care | Minneapolis | Remote (US/EU)
Open roles:
- Full Stack Engineer $150k–$230k | Full-time
We’re building an AI-powered clinic assistant that actually gets things done—booking appointments, managing vaccine records, handling FAQs, and even sounding like the clinic itself. This is multi-modal AI in the real world, not a demo.
⸻
We’re looking for product-minded engineers who want to push the boundaries of generative AI, RAG, and intelligent automation. You’ll ship fast, solve real user problems, and help us make AI feel magical, not clunky.
Tech stack: TypeScript, NestJS, React, React Native, AWS. Bonus: AI experience, but what matters most is product intuition and the drive to build useful things.
We’re building an AI-powered clinic assistant that actually gets things done—booking appointments, managing vaccine records, handling FAQs, and even sounding like the clinic itself. This is multi-modal AI in the real world, not a demo.
⸻
Engineering & design
We’re looking for product-minded people who want to push the boundaries of generative AI, RAG, and intelligent automation. You’ll ship fast, solve real user problems, and help us make AI feel magical, not clunky.
Tech stack: TypeScript, NestJS, React, React Native, AWS, Figma.
Bonus: AI experience, but what matters most is product intuition and the drive to build useful things.
PetsApp | Product Engineer (AI) / Full Stack Engineer | London or Remote (US/EU) | $150k–$230k | Full-time
We’re building an AI-powered clinic assistant that actually gets things done—booking appointments, managing vaccine records, handling FAQs, and even sounding like the clinic itself. This is multi-modal AI in the real world, not a demo.
We’re looking for product-minded engineers who want to push the boundaries of generative AI, RAG, and intelligent automation. You’ll ship fast, solve real user problems, and help us make AI feel magical, not clunky.
Tech stack: TypeScript, NestJS, React, React Native, AWS, Figma.
Bonus: AI experience, but what matters most is product intuition and the drive to build useful things.
PetsApp is redefining pet care in a hybrid physical-digital world. Join us and work on AI that directly impacts clinics, pet owners, and their pets—every day.
PetsApp | Remote (UK, EU) or in office London UK | Full-time | Software eng BE + Full stack | https://petsapp.com/careers | £70-100k
We're on a mission to help a billion pets. That's a heck of a lot, but we've got great ambitions. So far we've made a decent dent into that across the UK and US, helping over 400k pets get access to care more easily.
We're looking for mid-senior engineers who love to ship clean code, quick. We're still a small eng team, so you'll be helping us shape our ways of working being impactful from day 0. We've got interesting product problems across our stack, from ETL pipelines handling data about millions of pets, to product recommendation engines.
PetsApp | Full-time | Remote (or on-site London or Minneapolis)
PetsApp is the team building the future of pet care. Our platform gives veterinary teams the tools to improve the way they communicate with the pets they keep healthy, improving the accessibility of care.
We're a small and mighty team, working at pace, and producing incredible results. Want to have impact and work with smart people?
We’re the team building the platform that allows veterinary clinics and pet owners to communicate quickly and easily.
Pet owners use PetsApp to chat with the vet team that they know and trust. They can get advice on any issues their furry friends are having, as well as make appointments, pay outstanding bills and order medication.
* Strong experience with Typescript or another statically typed language
* Strong experience building frontend apps with React (React native experience is a bonus but not required)
* Experience and views on how to design and build APIs (serverless experience is a bonus but not required)
* Experience working with databases in production (we use DynamoDB and Postgres and Elasticsearch at the moment)
* Contributed to or owned a component library (our library, Chameleon uses styled-components)
* Owned code running in production and you have views about the tools you need to make sure it's running as intended
* Worked with databases of different kinds
* A very user centric way of approaching problems
* Experience or the desire to work at a fast pace, where you can make change happen in days, not months
* Prior experience in other startups (not needed, but it’s a bonus)
The package
* 33 day paid holiday a year (including public holidays)
* Remote friendly team
* £75-100k salary | This is the value for this role, so even if it’s not what you’re on now, it’s what we’re offering!
PetsApp (https://petsapp.com) | REMOTE | EU | North America | UK | Full stack / backend / frontend engineers | Node/Typescript/AWS/React/React Native
PetsApp is a platform that allows pet owners to communicate with their veterinarians (vets) more easily. The means that more potential issues are seen by the vet leading to our furry friends having better health. The tooling provided to the team in the vet clinic means that they have improved efficiencies which means there is less burn out and more opportunities to provide better care to their patients.
We have had an amazing 12 months:
* >£2 million in payments
* >300k virtual care interactions
* 140k pets
* 8k iOS App Store reviews
* 4.9/5 iOS Rating
* Top 10 rated Medical iOS app
And now we're looking for more engineers to come and join us! We are hiring across the three roles of frontend, backend and full stack. Depending on the role you apply for you should expect to work on problems like these:
* Building a free text search service that can scale from hundreds of thousands to millions of pets
* Integrating with third parties where there isn’t an API (this is that sweet spot of very hard, very interesting, and very impactful)
* Building a push notification service that can send tens of thousands of notifications without impacting our production stack
* Scaling our stack to handle the traffic of millions of pets
* Building a real time recommendation engine
* Building a system to ingest the data for millions of pets
* Owning our component library for both web and native
* Contributing to the product roadmap and how we can make high impact changes often
Open roles:
- Full Stack Engineer $150k–$230k | Full-time
We’re building an AI-powered clinic assistant that actually gets things done—booking appointments, managing vaccine records, handling FAQs, and even sounding like the clinic itself. This is multi-modal AI in the real world, not a demo.
⸻
We’re looking for product-minded engineers who want to push the boundaries of generative AI, RAG, and intelligent automation. You’ll ship fast, solve real user problems, and help us make AI feel magical, not clunky. Tech stack: TypeScript, NestJS, React, React Native, AWS. Bonus: AI experience, but what matters most is product intuition and the drive to build useful things.
Apply here: https://forms.gle/5fww8HDwRrP6c6Fo9