Company: SCRY AI

Location:
Multiple Locations

Experience:
Software Development Employment Type: Full-time

About Us
SCRY AI is an innovative AI-driven technology company focused on building intelligent, scalable, and high-performance solutions. We work with modern technologies across Software Engineering, AI/ML, and Data to solve real-world business problems and deliver impactful digital products. Role Overview We are looking for a skilled Software Developer – Database Specialist with 2+ years of experience in database development, data modeling, SQL programming, and performance optimization. The ideal candidate should have hands-on experience with relational, non-relational, and vector databases, understand their appropriate use cases, and follow best practices for database design, security, scalability, performance, and maintainability.

Key Responsibilities
• Design, develop, and maintain database schemas, tables, collections, indexes, views, and relationships based on application requirements.
• Write, optimize, and troubleshoot complex SQL queries involving joins, subqueries, CTEs, window functions, and aggregations.
• Develop and maintain stored procedures, functions, triggers, and database views where applicable.
• Work with relational databases such as PostgreSQL, MySQL, and SQL Server; non-relational databases such as MongoDB and Redis; and vector databases for embedding storage and similarity search.
• Select appropriate database technologies based on data structure, access patterns, consistency, scalability, and application requirements.
• Design efficient data models and implement database best practices for normalization, indexing, data integrity, schema evolution, and query efficiency.
• Optimize database performance using execution plans, indexing strategies, profiling tools, and workload analysis.




• Implement and optimize vector search workflows, including embedding storage, metadata filtering, similarity search, and retrieval performance.
• Develop scripts for data migration, transformation, reconciliation, bulk processing, and data validation.
• Identify and resolve database bottlenecks, locking issues, deadlocks, transaction conflicts, and performance problems.
• Integrate databases with Python backend applications, REST APIs, and data processing pipelines.
• Manage database schema changes, version control, and migration workflows using Alembic, including migration generation, review, execution, and rollback.
• Follow best practices for database security, access controls, transactions, backup and recovery, versioning, and environment-specific deployments.
• Collaborate with Backend Engineers, Data Engineers, QA, and Product teams to translate requirements into reliable database solutions.
• Document database designs, participate in code reviews, and ensure maintainable, testable, and well-documented database implementations. Key Qualifications
• 2+ years of experience in database development, SQL programming, or a related software engineering role.
• Strong proficiency in SQL, including complex queries, joins, CTEs, window functions, aggregations, and query optimization.
• Hands-on experience with relational databases, preferably PostgreSQL, MySQL, or SQL Server.
• Working knowledge of non-relational databases,



including document, key-value, or similar database models.
• Familiarity with vector databases such as pgvector, Qdrant, Milvus, Weaviate, or Pinecone, and their use in embedding storage and similarity search.
• Strong understanding of database design principles, data modeling, normalization, indexing, transactions, constraints, and data integrity.
• Experience with Alembic and database migration best practices, including schema versioning, migration scripts, dependency management, and safe upgrades or rollbacks.
• Understanding of database-specific best practices for schema design, query patterns, indexing, security, scalability, consistency, and performance.
• Experience with stored procedures, functions, views, database migrations, and data validation.
• Knowledge of execution plans, connection pooling, transaction isolation, concurrency, locking, and deadlock troubleshooting.
• Familiarity with Python and database connectivity tools or ORMs such as SQLAlchemy is preferred.
• Working knowledge of Git, Linux, testing, debugging, and software development best practices.
• Robust analytical, problem-solving, communication, and collaboration skills. Good to Have
• Experience with database replication, partitioning, caching, backup/recovery, and high-availability configurations.
• Exposure to cloud database services on AWS, Azure, or GCP and database performance monitoring tools.
• Experience supporting AI/ML, GenAI, RAG applications, embedding pipelines, and retrieval systems. If this role interests you, follow our page to stay updated on more job opportunities and insights into how AI companies design, manage, and optimize secure, scalable database systems to support enterprise applications and data-driven operations.

📌 Database Specialist (Pune)
🏢 Scry AI
📍 Pune