5 Query optimization Jobs in Bangalore (Bengaluru) | Query optimization Job openings in Bangalore (Bengaluru)

About the role

We are hiring a Principal Engineer to own the hardest technical problems in our product and see them through from first sketch to stable production. You will set technical direction, design systems that scale, and raise the engineering bar through your own work and the people around you. This is a hands-on leadership role: you write code, review designs, and ship.

What will you do?

You will own outcomes, not just tasks. Expect to spend your time on the following.

• Own projects end to end. Take an ambiguous problem, shape the requirements, design the solution, break down the work, deliver it to production, and stay accountable for how it runs afterwards.

• Lead system design. Author and review architecture for services, data pipelines and integrations, with clear trade-offs on scale, latency, cost, consistency and reliability.

• Write and review critical code. Build the hardest components yourself, and set standards for code quality, testing and maintainability through code and design reviews.

• Own deployment and operations. Design CI/CD, infrastructure and release strategies. Drive observability, on-call readiness, incident response and post-incident learning.

• Solve hard problems. Debug production issues across the stack, and find root causes in performance, concurrency, data and scaling problems.

• Mentor and multiply. Coach senior and junior engineers, grow future tech leads, and make the whole team faster and more confident.

• Partner across functions. Work with product, design, data and business teams to turn goals into technical plans, and to say no or reshape scope when needed.

• Shape technical strategy. Guide build-versus-buy decisions, manage tech debt, evaluate new technologies, and contribute to the engineering roadmap.

• Raise the bar. Help define engineering practices, hiring standards and culture, and take part in interviewing.

What are we looking for?

• Bachelor's degree in Computer Science or a related field, or equivalent practical experience.

Core engineering

• 10+ years of professional software engineering, with a track record of shipping and running production systems.

• Strong computer science fundamentals: data structures, algorithms and complexity, operating systems, networking, databases and concurrency.

• Fluency in at least one major backend language (for example Python, Go, Java, or Node.js/ TypeScript) and the ability to pick up others quickly.

• Deep knowledge of relational and NoSQL data stores: schema design, indexing, transactions, query tuning and replication.

System design and problem solving

• Proven ability to design distributed systems that are scalable, fault tolerant and cost aware, and to explain the trade-offs clearly.

• Experience with APIs, event-driven and asynchronous architectures, queues, caching and service-to-service communication.

• A structured approach to ambiguous problems: break them down, test assumptions, decide with incomplete data, and measure results.

• Strong debugging instincts, including performance profiling and production troubleshooting.

Delivery and operations

• Have led at least two significant projects from inception to production, including planning, milestones, risk management and launch.

• Hands-on experience with deployment: CI/CD pipelines, containers (Docker, Kubernetes), a major cloud (AWS, GCP or Azure), and infrastructure as code.

• Practical experience with monitoring, logging, alerting, SLOs and incident management.

• Habit of writing tests and automation, and of leaving systems more reliable than you found them.

Leadership and communication

• Experience leading engineers without formal authority, through influence, mentoring and clear technical writing.

• Excellent written and verbal communication: design docs, RFCs and concise updates to non-technical stakeholders.

• Ownership mindset, sound judgment on priorities, and comfort working in a fast-moving environment.

Nice to have

• Experience in fintech, lending or another regulated, data-heavy domain.

• Exposure to AI/ML or LLM-based systems in production: model serving, evaluation, retrieval, and cost and latency management.

• Deep experience with data engineering: streaming, batch pipelines, warehouses or search systems.

• Security and compliance awareness: authentication, encryption, audit trails, secure SDLC.

• Experience with multi-tenant SaaS, high-throughput systems or zero downtime migrations.

• Open-source contributions, conference talks, or technical writing.

• Experience scaling an engineering team or helping set up hiring and onboarding practices.

About AbleCredit:

AbleCredit is on a mission to solve the Credit Gap of emerging economies. In India alone, the Credit Gap is over USD 5T (Trillion!). This is the single largest contributor to poverty, poor genie index and lack of opportunities.

Ablecredit is a rare startup because we are probably the only revenue generating GenAI startup in India.

Key Responsibilities:

● Solving highly complex technical challenges and driving large-scale projects; developing robust and scalable web applications using Node.js, MongoDB

● Participate in system design, architecture, and help build scalable, high-performance systems

● Mentor junior engineers (SDEs and SDE-2s), driving technical decisions, and leading entire projects or initiatives

● Conduct code reviews and provide constructive feedback to team members.

● Architect efficient and reusable back-end systems and optimize applications for maximum speed and scalability.

● Implement security and data protection measures.

● Stay updated on emerging technologies and best practices in web development.

Qualifications:

● Bachelor' s degree in Computer Science, Engineering, or a related field.

● Minimum of 5 years of experience in backend web development.

● Proficiency in Node.js and typescript along with their core principles.

● Experience with server-side frameworks such as Express.js.

● Familiarity with database systems such as MongoDB, or PostgreSQL.

● Knowledge of RESTful APIs and asynchronous request handling.

● Excellent problem-solving and troubleshooting skills.

● Ability to work independently and as part of a team in a fast-paced environment.

● Effective communication skills and the ability to collaborate with stakeholders.

● Bonus: can whip up a front end or UI with AI agents or all by yourself.

Job Title : Report (Power BI) Engineer / Developer

Experience : 5+ Years

Work Mode : Remote (4 days/month office visit)

Locations : Noida, Hyderabad, Chennai, Pune, Bengaluru

Job Summary :

We are looking for an experienced Report (Power BI) Engineer / Developer to design and develop business-critical reporting solutions. The ideal candidate should have strong expertise in Power BI dashboards and paginated reports, along with hands-on experience in SQL Server, Snowflake, and Databricks.

Mandatory Skills :

Power BI, Power BI Dashboards, Paginated Reports, SQL Server, T-SQL, Snowflake, Databricks, Data Warehousing, ETL, SQL Query Optimization.

Key Skills Required :

• 5+ years of experience in Power BI development.
• Strong hands-on experience with Power BI Dashboards and Paginated Reports.
• Excellent knowledge of SQL Server and T-SQL development.
• Experience with Snowflake and Databricks.
• Understanding of data warehousing concepts, ETL processes, and SQL performance optimization.
• Strong communication and collaboration skills.

Preferred Skills :

• Experience with cloud data modernization projects.
• Knowledge of data security and compliance practices.

Note : Comprehensive background verification, including education, employment, criminal, credit, and drug screening, is mandatory.

Job Title : Analytics Engineer

Experience : 6+ Years

Location : Gurgaon | Bangalore | Ahmedabad | Chennai

Work Mode : Work From Office

Employment Type : Contract (6 Months)

About the Role :

We are looking for an experienced Analytics Engineer to design, develop, and optimize scalable data models and analytics solutions that drive business decision-making. The ideal candidate should have strong expertise in SQL, dbt, data modeling, data quality, and modern analytics engineering practices.

Mandatory Skills :

SQL, dbt, Data Modeling, Data Warehousing, ETL/ELT, Query Optimization, Data Quality, Git, CI/CD, Analytics Engineering, Data Transformation, Data Governance, Stakeholder Management.

Key Responsibilities :

• Design and maintain scalable data warehouse models, data marts, and analytical datasets.
• Build and optimize data transformation pipelines using SQL and dbt.
• Develop high-performance SQL queries using CTEs, Window Functions, Complex Joins, and Analytical Functions.
• Implement data quality checks, testing frameworks, and governance best practices.
• Manage end-to-end analytics development lifecycle, from requirement gathering to deployment.
• Work with Git, CI/CD pipelines, and version control best practices.
• Collaborate with business and technical stakeholders to deliver reliable analytics solutions.
• Troubleshoot and optimize data pipelines, models, and query performance.

Required Skills :

• 6+ years of experience in Analytics Engineering, Data Engineering, or related roles.
• Strong expertise in SQL and query performance optimization.
• Hands-on experience with dbt (Data Build Tool).
• Strong understanding of data modeling and data warehousing concepts.
• Experience with Git, CI/CD, and software development best practices.
• Knowledge of data quality frameworks, testing, and validation techniques.
• Ability to independently manage design, development, testing, documentation, and deployment.

Preferred Skills :

• Experience with cloud-based data platforms.
• Exposure to orchestration and scheduling tools.
• Understanding of data governance and compliance frameworks.
• Experience in performance tuning and cost optimization.
• Prior mentoring or technical leadership experience.

What We're Looking For :

• Strong analytical and problem-solving skills.
• Excellent communication and stakeholder management abilities.
• Ability to work independently in a fast-paced environment.
• Passion for building scalable, reliable, and high-quality analytics solutions.

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.