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.

Job Title: Back-End Developer

Location: Bengaluru, India 

Open Positions - 5

Company Overview:

IAI Solution Pvt Ltd, operates at the edge of applied AI where foundational research meets real-world deployment. We craft intelligent systems that think in teams, adapt with context, and deliver actionable insight across domains.

We are seeking talented Back-End Developers to join our team, where you will play a key role in developing the infrastructure that supports our advanced AI technologies. If you are passionate about back-end development and have a keen interest in AI, this opportunity is perfect for you.

Position Summary: We are looking for an experienced Backend Developer with strong expertise in Python, object-oriented programming (OOP), and FastAPI. The ideal candidate will be responsible for designing, developing, and maintaining high-performance, scalable backend services and APIs using gRPC, REST, and Docker, websockets Protocol Buffers.

Proficiency in working with databases such as SQL, NoSQL, MongoDB, Supabase, and Redis is required. While prior experience in AI-related projects is not mandatory, preference will be given to candidates who have worked on or shown a strong interest in the AI/ML domain.

.

Key Responsibilities:

• Develop, test, and maintain scalable back-end systems that power our AI solutions.
• Design and implement RESTful APIs to support front-end applications and third-party integrations.
• Collaborate with cross-functional teams to define technical requirements and deliver high-quality products.
• Optimize back-end performance, ensuring systems are fast, reliable, and scalable.
• Manage and maintain various database systems, including SQL, NoSQL, MongoDB, SuperBase, and Redis.
• Troubleshoot and resolve complex technical challenges, leveraging strong problem-solving and critical thinking skills.
• Handle multiple projects simultaneously, ensuring deadlines are met and quality is maintained.
• 
  

Qualifications:

• 2+ years in backend software development.
• Strong proficiency in Python and object-oriented programming.
• Extensive experience with FastAPI  frameworks.
• In-depth knowledge of database technologies, including SQL, NoSQL, MongoDB, SuperBase, and Redis. 
• Demonstrated ability to manage multiple projects in a fast-paced environment.
• Strong analytical and problem-solving skills with a keen eye for detail.
• Interest or experience in AI projects is highly desirable.

Nice to have 

• Design, develop, and maintain high-performance, scalable backend services and APIs using gRPC, REST, and Protocol Buffers.

Perks & Benefits:

• Competitive salary with performance-based bonuses.
• Opportunity to work on cutting-edge AI projects within a talented and innovative team.
• Access to professional development resources, including AI training programs.

Job Requirements:

Intermediate Linux Knowledge

• Experience with shell scripting
• Familiarity with Linux commands such as grep, awk, sed
• Required

Advanced Python Scripting Knowledge

• Strong expertise in Python
• Required

Ruby

• Nice to have

Basic Knowledge of Network Protocols

• Understanding of TCP/UDP, Multicast/Unicast
• Required

Packet Captures

• Experience with tools like Wireshark, tcpdump, tshark
• Nice to have

High-Performance Messaging Libraries

• Familiarity with tools like Tibco, 29West, LBM, Aeron
• Nice to have

• 1-2 years experience - Manage MySQL on Linux/Windows environments (preferably Percona/MySQL Community/MySQL Enterprise).
• Perform routine maintenance including patching and schema management.
• Prior experience in query optimization, indexing strategies, and slow query analysis is a plus
• Strong Communication Skills

Guidewire developer-PAN India

Role : Guidewire developer

Location : Pan India

Years of experience : 3 - 15 years

Roles and Responsibilities :

• Candidate having at least 3+ years of experience as guidewire developer
• Candidate having experience in Policy center(PC) or Claim center(CC)
• Experience in configuration or integration
• Candidate having Specialist certificate of guidewire

Regards

Sundaravalli

Locations : Bangalore

Job Responsibilities

• Design and develop highly scalable, reliable and fault tolerant systems
• Understand the customer needs, design & implement
• Envision project goals, product architectural solutions with a high focus on detail to ensure successful implementation.
• Articulate complex problems communicating viable architecture and design approaches clearly and concisely.
• Enhance the agile SDLC within the Development Team through new learning, continued growth, and applying industry best practices and processes
• Keep optimizing & automating mundane tasks
• Problem solving in accounting modules.

Qualifications

• Minimum 2 years of software development experience in backend
• Hands on experience with PHP using CodeIgniter and Javascript (Angular/ React)
• Database technologies - SQL and/or NoSql
• Experience in developing REST APIs
• Knowledge of VCS using SVN/ GIT and Payment Gateways
• Expertise in design principles and their application
• Strong computer science fundamentals in data structures and algorithms
• Fast Learner & a Team Player

HRBP

1. Advise managers on organizational policy matters and recommend needed changes.
2. Analyze statistical data and reports to identify and determine causes of personnel problems and develop recommendations for improvement of the organization's HR policies and practices.
3. Conduct exit interviews to identify reasons for employee separation.
4. Maintain records and compile statistical reports concerning HR-related data such as hires, transfers, performance appraisals, and absenteeism rates.
5. Administer disciplinary procedures.
6. Plan and conduct new employee orientation and induction programs to foster a positive attitude toward organizational objectives.
7. Plan, direct, supervise, and coordinate work activities of subordinates and employee relations.
8. Provide current and prospective employees with information about policies, job duties, working conditions, wages, and opportunities for promotion and employee benefits.
9. Serve as a link between management and employees by handling questions, interpreting and administering contracts and helping resolve work-related problems.
10. Administer employee recognition awards.
11. Plan, organize, direct and coordinate the training activities of the organization.
12. Responsible for the successful implementation, monitoring and coordinating of all the activities regarding HR Software.
13. Preparation and maintenance of MIS related to Attrition.
14. Administer performance management systems and recreation programs.

Desired Candidate Profile

• Develop reusable, maintainable cross-platform HTML, CSS, and JavaScript for front-end web application components while adhering to web and team standards.
• Write unit tests to provide sufficient testing coverage for each developed component.
• Constantly review and improve frontend performance of the web application.
• Work with creative and business partners to understand, build and adjust web application functionality and visual presentation to support business goals.
• Work with server-side, infrastructure, and 3rd party technology partners to build, integrate and deploy web application functionality and visual presentation to support business goals.
• Work with project technical lead and/or FE architect to create technical designs and implementation plans.
• Ensure accuracy and attention to detail throughout the development process.
• Remain curious and current with new developments in the FE web development industry.

QUALIFICATIONS:

• Demonstrated 3-5 years of practical front-end web development experience.
• Expertise in writing and testing valid, web standards-based HTML, CSS, JS.
• Fluent in fundamentals of computer science such as:
• Object-Oriented Programming, Data Structures, Coding Patterns.
• Deep understanding and experience with the following standards and technologies is essential:
• DOM, JSON, AJAX, HTML5 Video, WCAG 2.0 AA, Git.
• Strong verbal and written communication skills are preferred.
• Bachelor’s Degree is preferred.
• Sample portfolio (code or public-facing web build) is a plus.
• Experience working for high-end brands or another environment with very high standards for the presentation layer is a plus; Ecommerce experience is a plus