Sign in to see your fit: the skills, experience and location this job asks for, checked against your profile.
Job description
Sr Tech Lead-GenAI - VectorDBand MySQL India Job Description Sr Tech Lead-GenAI - VectorDBand MySQL Noida, Uttar Pradesh Job Summary This role is accountable for delivering advanced Generative AI solutions by leveraging expertise in Large Language Models (LLMs), prompt engineering, and modern Python frameworks. The individual applies advanced proficiency in designing, developing, and optimizing AI-driven applications, ensuring technical excellence and strategic alignment with project goals. They guide teams in implementing robust architectures and best practices, contributing to the successful execution of complex development projects. Key Responsibilities
Lead solution development using GenAI, LLMs, and prompt engineering to architect and implement scalable AI applications, ensuring alignment with project requirements. 2. Develop and optimize RESTful APIs with Python frameworks such as Flask, Django, and FastAPI to enable seamless integration of AI models and data sources. 3. Design and maintain data pipelines utilizing MySQL, PostgreSQL, and VectorDB technologies (e.g., Pinecone), ensuring efficient storage and retrieval of embeddings and model outputs. 4. Implement advanced prompt engineering techniques to enhance LLM performance, tailoring prompts for specific use cases and optimizing model responses. 5. Oversee code quality and performance by conducting comprehensive code reviews and enforcing best practices in Python and AI model development. 6. Integrate Azure AI Search and other cloud-based tools to support retrieval-augmented generation and scalable deployment of GenAI solutions. 7. Collaborate within the development team to resolve technical challenges, provide guidance on architectural decisions, and ensure process compliance throughout the project lifecycle.
Skill Requirements
Advanced Proficiency In Genai, Llms, And Prompt Engineering For Solution Design And Implementation. 2. Solid Experience With Python And Frameworks Such As Flask, Django, And Fastapi. 3. Advanced Knowledge Of Restful Api Development And Integration. 4. Indepth Expertise In Relational And Vector Databases, Including Mysql, Postgresql, And Pinecone. 5. Advanced Skills In Embeddings, Retrievalaugmented Generation, And Cloud Ai Services (E.G., Azure Ai Search). 6. Strong Understanding Of Code Optimization, Performance Tuning, And Quality Assurance In Aicentric Projects.
Other Requirements
Optional but valuable: 2. Microsoft Certified: Azure AI Engineer Associate 3. - Google Professional Machine Learning Enginee
This guide is for Indian job seekers preparing for SQL rounds in data analyst, data engineer, backend developer and database roles, from freshers to experienced professionals. It has 60 questions in three levels: easy covers joins, grouping and NULLs; medium covers window functions, CTEs, indexes and isolation levels; hard covers locking, MVCC, query tuning and classic puzzles such as login streaks and medians. Answers use ANSI SQL, with MySQL 8 and PostgreSQL notes where the two differ. Write each query against your own sample tables first, then compare your result with the sample answer.
Questions you may be asked
What is the difference between WHERE and HAVING?
What is the difference between DELETE, TRUNCATE and DROP?
What is the difference between an INNER JOIN and a LEFT JOIN?
What is the difference between a primary key and a unique key?
