11+ Query optimization Jobs in Bangalore (Bengaluru) | Query optimization Job openings in Bangalore (Bengaluru)

Position Title : Senior Database Administrator (DBA)

📍 Location : Bangalore (Near Silk Board)

🏢 Work Mode : Onsite, 5 Days a Week

💼 Experience : 6+ Years

⏱️ Notice Period : Immediate to 1 Month

Job Summary :

We’re looking for an experienced Senior DBA to manage and optimize databases like MySQL, MongoDB, PostgreSQL, Oracle, and Redis. You’ll ensure performance, security, and availability of databases across our systems and work closely with engineering teams for support and improvement.

Key Responsibilities :

• Manage and maintain MySQL, MongoDB, PostgreSQL, Oracle, and Redis databases.
• Handle backups, restores, upgrades, and replication.
• Optimize query performance and troubleshoot issues.
• Ensure database security and access control.
• Work on disaster recovery and high availability.
• Support development teams with schema design and tuning.
• Automate tasks using scripting (Python, Bash, etc.).
• Collaborate with DevOps and Cloud (AWS) teams.

Must-Have Skills :

• 6+ Years as a DBA in production environments.
• Strong hands-on with MySQL, MongoDB, PostgreSQL, Oracle, Redis.
• Performance tuning and query optimization.
• Backup/recovery and disaster recovery planning.
• Experience with AWS (RDS/EC2).
• Scripting knowledge (Python/Bash).
• Good understanding of database security.

Good to Have :

• Experience with MSSQL.
• Knowledge of tools like pgAdmin, Compass, Workbench.
• Database certifications.

Position Name : Senior Software Architect

📍 Location : UB City, Bengaluru (Hybrid – 3 days in office)

🕒 Experience : 11 to 18 Years

📅 Notice Period : Immediate to 1 month

👥 Open Positions : 2

Role Overview :

• We are looking for a Senior Software Architect to design, build, and scale high-performance SaaS B2B applications.
• The ideal candidate will have deep expertise in MERN stack (MongoDB, Express.js, React.js, Node.js), AWS, and microservices-based architectures.
• This role requires at least 3 Years of experience in an Architect position, with a strong background in building scalable products and handling daily releases.

Key Responsibilities :

• Architect and develop scalable SaaS B2B products using React, Node.js, GraphQL, Elasticsearch, and Micro Frontend Architecture (MFE).
• Design and implement microservices-based distributed systems and RESTful APIs.
• Optimize frontend interfaces using React, Redux, Next.js, HTML, and CSS.
• Develop robust backend APIs using Node.js, Express.js, and MongoDB/PostgreSQL.
• Utilize AWS services (EC2, S3, SQS, SNS, DocumentDB, OpenSearch) and containerization (Docker, Kubernetes).
• Implement scalable database schemas and ensure optimal performance.
• Work with GraphQL for efficient data querying and manipulation.
• Ensure security, reliability, and high availability of the platform.
• Lead and mentor development teams, conduct code reviews, and enforce best practices.
• Collaborate with cross-functional teams to deliver business-driven software solutions.

Required Skills & Experience :

✅ 3+ Years as a Software Architect and currently in an Architect role.

✅ 5+ Years of experience in full-stack development with the MERN Stack.

✅ Strong knowledge of scalable architectures, microservices, and cloud-native SaaS products.

✅ Experience in AWS deployment, cloud infrastructure, and DevOps.

✅ Hands-on experience with Micro Frontends (MFE).

✅ Experience in handling everyday releases and working in Agile environments.

✅ Strong problem-solving skills, logical thinking, and architectural decision-making.

✅ Bachelor’s or Master’s degree in Computer Science or related field.

Preferred :

• Experience in B2B SaaS product development.
• Background in product-based companies.
• No prior experience in Walmart or similar large enterprises.
• Candidates should be based in Bengaluru (Outstation candidates will not be processed).

Overview:

Join our team at YoHo Design as a Sales Associate and play a pivotal role in driving sales growth and enhancing customer satisfaction. As a Sales Associate, you will be responsible for providing exceptional service to clients, assisting them in selecting products and services that meet their interior design needs, and contributing to the overall success of our firm.

Key Responsibilities:

1. Customer Service: Provide exemplary customer service by greeting clients, assessing their needs, and guiding them through the selection process.

2. Product Knowledge: Develop a deep understanding of our products and services, including furniture, accessories, lighting, and design consultation services.

3. Sales Generation: Actively engage with clients to identify opportunities for sales, upselling, and cross-selling of products and services.

4. Consultative Selling: Utilize your knowledge of interior design principles to offer personalized recommendations and design solutions to clients.

5. Relationship Building: Build and maintain strong relationships with clients to foster repeat business and referrals.

6. Order Management: Assist clients with placing orders, processing payments, and coordinating delivery and installation.

7. Merchandising: Maintain a clean and organized showroom environment, ensuring that products are properly displayed and inventory levels are monitored.

8. Administrative Tasks: Perform various administrative duties, such as maintaining client records, generating sales reports, and responding to inquiries via phone, email, or in person.

9. Collaboration: Work closely with other team members, including designers, project managers, and administrative staff, to ensure a seamless customer experience.

10. Continuous Learning: Stay updated on industry trends, product developments, and best practices in interior design and sales techniques.

Must Have:

* Previous experience in retail sales, preferably within the interior design industry.

* Strong interpersonal and communication skills, with the ability to engage effectively with clients and colleagues.

* Passion for interior design and a keen eye for aesthetics.

* Proven track record of meeting or exceeding sales targets.

* Ability to multitask and prioritize tasks in a fast-paced environment.

* Proficiency in using computer software and point-of-sale systems.

* Flexibility to work weekends and evenings as needed.

* Complete Sales background with 2 years experience

Education:

Bachelor’s degree in interior design, marketing, business administration, or a related field preferred.

Job Responsibilities :

- Lead design projects and contribute to product strategy

- Plan and design memorable user interfaces that are elegant and usable across our iOS, Android, and web platforms.

- Deliver wireframes and prototypes to help people visualize  design ideas.

- Push the bounds of creativity using the latest design techniques and languages.

- Good knowledge of graphic/visual design

- Work closely with the Engineering team to get crazy ideas to life.

Requirements :

- Proficiency in Sketch (Component system), Adobe XD, Illustrator or any other tool that helps you churn out great design!

- Updated portfolio.

- People who can solve problems & create engaging experiences.

Key Responsibilities

🧪 AI/ML Research & Development

• Develop AI models to identify learning difficulty patterns based on multi-domain assessments.
• Train models to classify LD categories (e.g., dyslexia, dysgraphia) from scoring + qualitative inputs.
• Build recommendation logic for intervention strategies based on child profiles and educator feedback.

📊 Data Processing & Pipeline

• Design data pipelines to preprocess structured and semi-structured data (scores, observations, logs).
• Work with educator-generated reports and build logic to convert qualitative insights into ML-readable formats.

🔎 Model Evaluation & Iteration

• Perform evaluation using accuracy, recall, precision; but also focus on interpretability and ethical AI.
• Use techniques like SHAP, attention weights, or decision trees for explainability in recommendations.

🤝 Collaboration & Integration

• Work closely with frontend/backend teams to integrate AI insights into the assessment tool UI.
• Sync with special educators to validate model predictions and continuously improve the output quality.

We are seeking a skilled and experienced Senior Backend Engineer proficient in Java to join our dynamic team. The ideal candidate will have 4-7 years of hands-on experience in Java development, particularly in building robust backend systems and microservices architecture. As a Senior Backend Engineer, you will collaborate with cross-functional teams to design, develop, and deploy scalable and efficient backend solutions to support our products and services.

Responsibilities:

1. Design, develop, and maintain high-performance backend systems and microservices using Java.
2. Collaborate with product managers, frontend engineers, and other stakeholders to understand requirements and translate them into technical specifications.
3. Implement best practices in software development, including code reviews, testing, and documentation.
4. Optimize and refactor existing codebase for improved performance, scalability, and maintainability.
5. Troubleshoot and debug issues in production environments and provide timely resolutions.
6. Stay updated with industry trends and emerging technologies to propose innovative solutions and improvements.
7. Mentor junior engineers and contribute to their professional growth and development.
8. Participate in agile ceremonies such as sprint planning, stand-ups, and retrospectives.

Requirements:

1. Bachelor's degree in Computer Science, Engineering, or a related field.
2. 4-7 years of professional experience in backend development with a focus on Java.
3. Strong proficiency in Java programming language and its ecosystem.
4. Experience with building scalable and distributed systems using microservices architecture.
5. Proficiency in Spring Framework (Spring Boot, Spring MVC, Spring Data, etc.).
6. Solid understanding of relational and NoSQL databases (e.g., MySQL, PostgreSQL, MongoDB).
7. Experience with RESTful API design and implementation.
8. Familiarity with cloud platforms such as AWS, Azure, or Google Cloud Platform.
9. Knowledge of containerization and orchestration tools like Docker and Kubernetes is a plus.
10. Excellent problem-solving skills and attention to detail.
11. Strong communication and collaboration skills.
12. Ability to work independently and in a team-oriented environment.
13. Experience with Agile/Scrum methodologies.

Preferred Qualifications:

1. Master's degree in Computer Science or a related field.
2. Experience with DevOps practices and CI/CD pipelines.
3. Knowledge of reactive programming frameworks like Akka or Vert.x.
4. Familiarity with message broker systems such as Kafka or RabbitMQ.
5. Contributions to open-source projects or active participation in the developer community.

Job Details: 

• Three plus years of experience in IT systems analysis and application program development
• Experience in an Object Oriented Programming language such as Java is a must
• The candidate must be a hands-on coder doing active development
• Extensive experience programming in Java Application Development & RESTful API
• Experience in AWS Cloud technologies is optional but good to have
• Proficient in Object-Oriented Programming (OOP) concepts, workflows, and design patterns

• Discover & Scale New Offline Sales Channels to Fuel Growth.
• Monitor Daily / Weekly Business Conversion Funnels and Drive Improvements to Improve Funnel Shape and Deliver Monthly Target.
• Create Granular Bottom-Up Plans, Basis Experiments and Initiatives and Ensure Adherence.
• Hire, Train, Mentor, And Drive Sales Teams Across Geographies.
• Plan, Participate and Represent Company in Trade Shows and Events
• Review Teams and Improve Sales Effectiveness by Using Data-Backed Insights.
• Coordinate And Plan with Cross-Functional Operations, Central Teams to Ensure Smooth Transactions.

Eligibility

• Experience: - 6-9 Years of Operational Experience in Sales/Revenue Delivery Roles
• Strong Academic Pedigree
• Exposure To Fast-Paced Environment of Execution Preferred
• B2C Technology Startup
• Telecom / FMCG /NBFC/Insurance - New Initiatives Team
• Led Teams in Sales / Delivery

Skills Required

• High Level of Ownership, Execution Rigor and Span Control
• Comfortable With Ambiguity
• Ability To Engage and Influence People Cross Functionally

What you need to have: