Leads the team this role joins
In-house, owns the opening
Put the opening up
From your own Gmail and LinkedIn.
About the role
SCRY AI is hiring a full-time database specialist based in Pune, Maharashtra, with remote work, for candidates with at least two years of database development experience. The role suits a developer who designs schemas and writes complex SQL, and who can pick the right relational, document or vector database for each workload. SCRY AI describes itself as an AI-driven technology company that builds software, AI and data products.
What you’ll do
- Design and maintain schemas, tables, collections, indexes, views and relationships.
- Write, tune and troubleshoot complex SQL with joins, CTEs, window functions and aggregations.
- Build and maintain stored procedures, functions, triggers and views.
- Work with PostgreSQL, MySQL, SQL Server, MongoDB, Redis and vector stores for embedding storage and similarity search.
- Improve performance through execution plans, indexing and workload analysis.
- Manage schema changes and migrations with Alembic, including review and rollback.
- Write scripts for data migration, transformation, reconciliation and validation.
- Connect databases to Python backends, REST APIs and data pipelines.
- Document database designs and take part in code reviews.
What they’re looking for
- Two or more years in database development, SQL programming or a related engineering role.
- Strong SQL, including complex queries and query optimization.
- Hands-on work with relational databases, preferably PostgreSQL, MySQL or SQL Server.
- Working knowledge of non-relational databases such as document or key-value stores.
- Familiarity with a vector database such as pgvector, Qdrant, Milvus, Weaviate or Pinecone.
- A solid grasp of normalization, indexing, transactions, constraints and data integrity.
- Experience with Alembic and safe migration practices.
- Knowledge of execution plans, isolation levels, locking and deadlock troubleshooting.
- Working knowledge of Git and Linux.
- Good analytical, problem-solving and communication skills.
Nice to have
- Python and an ORM such as SQLAlchemy.
- Replication, partitioning, caching, backup and recovery, or high-availability setups.
- Cloud database services on AWS, Azure or GCP, and database performance monitoring tools.
- Experience with AI/ML, GenAI or RAG applications and embedding pipelines.
What’s on offer
- Full-time position.
- Pay of 12-16 LPA, which is INR 12,00,000 to 16,00,000 a year.
- Remote work.
Skills
Questions about this role
How much does this job pay?
The listing gives a range of 12-16 LPA, or INR 12,00,000 to 16,00,000 a year.
How much experience is needed?
At least two years of database development, SQL programming or a related role.
Is the job remote?
Remote work is offered, with the position listed in Pune, Maharashtra.
Which databases does the role use?
PostgreSQL, MySQL, SQL Server, MongoDB, Redis and vector databases.