BACKEND + DATABASE ENGINEER ( SQL & NoSQL)

Overview

About: Perception & Quant Research Pvt. Ltd is media monitoring & analytics company based on innovation and committed to excellence in technology and solutions. We foster a collaborative environment that values diversity and empowers individuals to achieve their full potential. Overview: We are seeking for an experienced and proactive Backend + Database Engineer to design, develop, and maintain our scalable backend infrastructure. The ideal candidate will have a strong foundation in Python, Typescript, and database management systems, including MongoDB and Postgres, as well as experience with Elasticsearch. Someone passionate about building efficient, scalable, and well-documented backend systems Key Responsibilities 1. Design, develop, and maintain our backend infrastructure using Python (Flask, FastAPI) and Typescript (Express, NestJS). 2. Develop scalable database designs and implement efficient indexing, full-text search, vector search, caching, aggregation, and triggers. 3. Work with MongoDB and Postgres to ensure data consistency, reliability, and performance. 4. Implement in-memory caching using Redis and message queuing systems. 5. Ensure seamless API integration with proper API documentation, DTOs, and version control. 6. Design and implement Elasticsearch indices, mappings, and queries to support efficient data retrieval and analysis. 7. Collaborate with the team to identify and resolve technical issues, optimize performance, and improve overall system reliability. 8. Develop and maintain technical documentation for database design, API documentation, Elasticsearch configuration, and other relevant technical details. Required Qualifications 1. Programming languages: Proficiency in Python and Typescript. 2. Frameworks: Experience with Python Flask, FastAPI, and Typescript Express or NestJS. 3. Databases: Strong knowledge of MongoDB and Postgres, including indexing, full-text search, vector search, caching, aggregation, and triggers. 4. Search Engine: Experience with Elasticsearch, including index design, mapping, querying, and aggregation. 5. Caching: Experience with in-memory caching using Redis. 6. Message queuing: Knowledge of message queuing systems. 7. Database design: Strong understanding of scalable database design principles and documentation using tools like (link unavailable) or similar. 8. API documentation: Ability to create proper API documentation with DTOs. 9. Version control: Familiarity with Git version control. 10. Containerization: Basic understanding of Docker. 11. Database migrations: Experience with database migrations.Nice to Have 1. Experience with cloud platforms like AWS, GCP, or Azure. 2. Knowledge of cloud-native Elasticsearch services like Amazon Elasticsearch Service or Google Cloud Elasticsearch. 3. Familiarity with CI/CD pipelines. Soft Skills: • • • • To Apply: Leadership and mentoring capabilities Strong problem-solving and analytical thinking. Effective communication and collaboration in cross-functional teams. Adaptability to dynamic environments and shifting priorities. Please submit your resume and a cover letter outlining your relevant experience and skills. Perception & Quant Research is an equal opportunity employer committed to diverse

Job Type: Full-time

Pay: ₹200,000.00 - ₹280,000.00 per year

Schedule:

• Day shift

Work Location: Remote