1517 Query Optimization Jobs

Setup a job Alert
JobPe aggregates results for easy application access, but you actually apply on the job portal directly.

2.0 - 4.0 years

12 - 14 Lacs

bengaluru

Work from Office

Mandatory Skills : Backend - Node JS Database - PostGres Cloud - AWS Primary skills : Excellent grip on programming with Node JS PostGres database knowledge is a must AWS knowledge is a must Writing clean, optimized and modular code Good understanding of database concepts such as DB Normalization, Sharding, Indexing, Connection Pooling, Query Optimization, etc. Version control using Git Secondary Skills: Angular Work closely with other business systems analysts, global process owners, management, project managers, development team, and infrastructure team as required on projects and initiatives Participate and provide support during application / product validation activities. Coordinate wit...

Posted 17 hours ago

AI Match Score
Apply

3.0 - 6.0 years

7 - 8 Lacs

chennai

Work from Office

We are looking for an experienced SQL Database Administrator/Developer to support the project team from a database perspective. This role will be responsible for setting up the SQL database environment, creating tables, views, and stored procedures, and ensuring database performance, security, and integrity. This dedicated resource will provide the required backend database expertise throughout the project lifecycle. Key Design and set up the SQL Server database Develop and optimize database tables, views, stored procedures, and functions based on business and application requirements Manage database setup, configuration, and deployment in alignment with project requirements Ensure data inte...

Posted 18 hours ago

AI Match Score
Apply

2.0 - 5.0 years

6 - 12 Lacs

dombivli

Work from Office

We are seeking a highly skilled Senior Database Administrator (DBA) to design, manage, and optimize our PostgreSQL infrastructure with a focus on high availability (HA), zero downtime, and scalability . The ideal candidate will ensure data integrity, security, and performance across production systems while supporting 24x7 uptime. Key Responsibilities: Design and maintain PostgreSQL clusters with HA, replication, and failover (e.g., Patroni, repmgr, pgpool-II). Implement automated backup and disaster recovery strategies ensuring point-in-time recovery (PITR). Perform performance tuning, query optimization, and capacity planning . Manage monitoring and alerting using Prometheus, Grafana, and ...

Posted 20 hours ago

AI Match Score
Apply

8.0 - 13.0 years

7 - 11 Lacs

hyderabad, chennai, bengaluru

Work from Office

We are looking for 8+ Years of experienced Data Engineers with strong hands-on expertise in Python programming and the GCP data ecosystem Migration Projects. Candidates should be able to build scalable data pipelines, optimize data workflows, and work collaboratively with data science, analytics, and engineering teams. Mandatory Skills: Strong hands-on programming in Python Extensive experience working with the GCP stack , including: BigQuery Cloud Storage (GCS) Cloud Functions / Cloud Run Dataflow / Apache Beam Pub/Sub Proficient in building, deploying, and managing scalable data pipelines Solid understanding of data modeling, ETL/ELT processes, and data warehousing concepts Strong SQL skil...

Posted 21 hours ago

AI Match Score
Apply

3.0 - 6.0 years

5 - 8 Lacs

bengaluru

Work from Office

*About the Role Were seeking an experienced Java Backend Developer to join our team. As a Java Backend Lead Developer, youll design and develop scalable, efficient, and reliable backend solutions using Java, Spring Boot, and microservices architecture. *What You Will Do 1. *Backend Development*: Design and develop backend solutions using Java, Spring Boot, and microservices architecture. 2. *Cloud Deployment*: Deploy and manage applications on AWS Cloud, leveraging services like EC2, S3, and RDS. 3. *Containerization*: Use Docker and Kubernetes to containerize and orchestrate microservices. 4. *Technical Leadership*: Provide technical leadership and guidance to development teams. 5. *Code Qu...

Posted 21 hours ago

AI Match Score
Apply

3.0 - 4.0 years

9 - 10 Lacs

jaipur

Work from Office

Responsibilities: * Manage SQL databases: create, modify, optimize & back up. * Collaborate with dev team on database design & implementation. * Monitor performance & troubleshoot issues.

Posted 21 hours ago

AI Match Score
Apply

5.0 - 8.0 years

27 - 42 Lacs

bengaluru

Work from Office

Job Summary As a Data Engineer and DBA, you will perform administration of our database and analytics platform, including MySQL, Postgres, MongoDB, Microsoft SQL server, and Oracle as well as collection of data lake in a large technology ecosystem. You will ensure the smooth operations of systems including uptime and performance. As a technical expert for our data and analytics ecosystem you will support the Engineering Organization. Job Requirements Core Responsibilities: Manage and optimize databases (performance tuning, troubleshooting, upgrades, patches). Ensure data security, backup, and recovery strategies. Handle incident management systems (e.g., ServiceNow). Automate recurring tasks...

Posted 1 day ago

AI Match Score
Apply

1.0 - 3.0 years

6 - 7 Lacs

ahmedabad

Work from Office

Previous working experience as a PHP/Laravel developer for a minimum of 1 year required. BS/MS degree in Computer Science, Engineering, or a similar relevant field. In-depth knowledge of object-oriented PHP and Laravel 5 PHP Framework. Hands-on experience with SQL schema design, SOLID principles, REST API design. Software testing (PHPUnit, PHPSpec, Behat). MySQL profiling and query optimization. Creative and efficient problem solver. A motivated PHP/Laravel developer, passionate techie, and quick learner does this sound like youExciting opportunities and great benefits await

Posted 1 day ago

AI Match Score
Apply

5.0 - 9.0 years

0 Lacs

haryana

On-site

As an MS-SQL Database Expert with 5-8 years of experience, your role will involve designing and managing database architectures to create efficient, scalable, and secure solutions. You should have a strong understanding of database design principles, performance tuning, and optimization. Key Responsibilities: - Design and develop scalable and high-performance database architectures. - Optimize database performance through indexing, query tuning, and partitioning. - Develop and maintain stored procedures, triggers, views, and functions. - Implement and manage database backup, recovery, and security policies. - Monitor and troubleshoot database performance, bottlenecks, and failures. - Collabo...

Posted 2 days ago

AI Match Score
Apply

5.0 - 10.0 years

0 Lacs

telangana

On-site

As a Database Tech Lead, you will play a crucial role in leveraging your 5+ years of Professional Experience as a MSSQL Developer or Database Developer to lead database-related projects. Your responsibilities will include: - Proficiency in writing complex SQL queries, stored procedures, and functions. - Strong expertise in query optimization, performance tuning, and database indexing. - Knowledge or experience in Duck Creek Data Insights. - Experience with ETL Processes (SSIS) and data integration techniques. - Experience with Power BI or SSRS. - Familiarity with database design principles and normalization techniques. - Hands-on experience with one or more relational database management sys...

Posted 2 days ago

AI Match Score
Apply

3.0 - 7.0 years

0 Lacs

kannur, kerala

On-site

You are a highly skilled and experienced Senior PHP Laravel Developer who will play a crucial role in the development and maintenance of a cutting-edge SAAS-based product. Your passion lies in building scalable, secure, and efficient applications by utilizing the full potential of AWS. **Key Responsibilities:** - Develop and maintain the SAAS-based product using PHP Laravel framework. - Design and implement scalable and secure applications on AWS for optimal performance and reliability. - Create and manage automated testing procedures to ensure the quality and functionality of the application. - Implement best practices in code development for clean, maintainable, and efficient code. - Colla...

Posted 3 days ago

AI Match Score
Apply

5.0 - 9.0 years

0 Lacs

hyderabad, telangana

On-site

As a part of Clean Harbors India, you will be working in a dynamic environment where industry and environment intersect. Clean Harbors, a NYSE listed company with a revenue of $6 billion, has a rich history dating back to its founding in 1980 near Boston by Mr. Alan S. McKim, who continues to serve as the Chairman and CTO. Your key responsibilities will include: - Providing premier environmental, energy, and industrial services on-site - Working alongside a dedicated workforce of 23,000 employees - Collaborating with over 450 service locations across the U.S., Canada, and Mexico - Addressing the environmental needs of more than 300,000 customers - Participating in emergency response events s...

Posted 3 days ago

AI Match Score
Apply

6.0 - 10.0 years

0 Lacs

pune, maharashtra

On-site

You will be responsible for overseeing the robustness and security of the database infrastructure at FPL Technologies as a Lead Database Administrator (PostgreSQL DBA). Your key responsibilities will include: - Collaborating with stakeholders and cross-functional teams to identify database system requirements and performance objectives. - Scheduling and coordinating database maintenance activities, such as backups, upgrades, and patch deployments. - Designing and implementing database schemas, indexes, and query optimization strategies to maximize performance and scalability. - Planning and executing database security measures, including access controls, encryption, and auditing, to protect ...

Posted 3 days ago

AI Match Score
Apply

8.0 - 12.0 years

0 Lacs

hyderabad, telangana

On-site

Role Overview: As a Geospatial Data Engineer, your main responsibility will be to utilize your knowledge of GIS, data modelling, and data engineering to ensure that geospatial data is validated, standardized, and enriched with contextual attributes. Your role will involve domain expertise for geospatial data validation, enrichment, and optimization to meet business-ready requirements. Key Responsibilities: - Design and implement geospatial data models. - Develop and optimize data ETL processes. - Validate incoming geospatial datasets for geometry correctness and CRS compliance (EPSG:4326). - Implement distributed spatial joins using Apache Sedona/GeoSpark to enrich parcels with supporting la...

Posted 3 days ago

AI Match Score
Apply

3.0 - 7.0 years

0 Lacs

ahmedabad, gujarat

On-site

Role Overview: As a Database Developer, you will be responsible for designing, developing, and maintaining T-SQL procedures, functions, and scripts. Your role will involve optimizing queries for performance and scalability, as well as implementing data migration scripts and data transformation processes. Additionally, you will work closely with software developers and analysts to understand requirements and provide database solutions. Collaboration with IT teams for database infrastructure planning and implementation will also be a key aspect of your role. Key Responsibilities: - Design, develop, and maintain T-SQL procedures, functions, and scripts - Optimize queries for performance and sca...

Posted 3 days ago

AI Match Score
Apply

10.0 - 14.0 years

0 Lacs

karnataka

On-site

As an experienced SQL Server DBA / Database Engineer at our company, you will play a crucial role in maintaining the availability, performance, and integrity of our SQL Server databases. Your responsibilities will include: - **Database Administration:** Installing, configuring, and upgrading SQL Server instances. Monitoring and maintaining SQL Server databases to ensure high availability and performance. - **Performance Tuning:** Identifying and resolving performance issues. Optimizing queries, indexes, and database schemas to enhance database performance. - **Backup and Recovery:** Implementing and managing backup and recovery strategies. Performing regular database backups and restore oper...

Posted 3 days ago

AI Match Score
Apply

6.0 - 10.0 years

0 Lacs

karnataka

On-site

As a Test Lead for ETL Testing at CGI, you will work independently under limited supervision in Applications Development. Your role involves applying your knowledge and skills to develop simple application solutions and dealing with issues within your field of specialization. You will have a direct impact on results and outcomes. Here is a breakdown of your future duties and responsibilities: - Work in an agile environment and collaborate with the development team to develop unit test scripts. - Demonstrate an understanding of enterprise data warehousing best practices and standards. - Lead QA Analysts on a project team and ensure effective communication through excellent verbal and written ...

Posted 3 days ago

AI Match Score
Apply

5.0 - 10.0 years

0 Lacs

chennai, tamil nadu

On-site

As a Senior Power BI Engineer at Ford Motor Company, you will play a crucial role in modernizing and transforming the PLM landscape by migrating legacy, datacenter-based BI solutions to Power BI. Your responsibilities will include designing, developing, deploying, and maintaining BI applications to ensure seamless integration and optimal performance. You will collaborate closely with architects, engineers, and operations teams to deliver high-quality cloud-based solutions. Key Responsibilities: - Utilize your expertise in Web FOCUS 8.* reports application to create reports, dashboards, and visualizations, and migrate Web Focus 8.* to Web Focus 9.* - Apply knowledge of data modeling, schema d...

Posted 3 days ago

AI Match Score
Apply

5.0 - 9.0 years

0 Lacs

karnataka

On-site

As a MongoDB expert with over 5 years of experience, you will be responsible for architecting MongoDB databases and utilizing the aggregation framework to optimize query performance. Your expertise in Data Sharding, MongoDB replication, Aggregation pipeline, and MongoDB Atlas will be crucial in ensuring efficient database operations using JavaScript. Key Responsibilities: - Architect MongoDB databases to meet the requirements of the organization - Utilize the aggregation framework for query optimization and performance tuning - Implement Data Sharding and MongoDB replication strategies - Work with MongoDB Atlas for scalable and secure database solutions Qualifications Required: - 5+ years of...

Posted 3 days ago

AI Match Score
Apply

4.0 - 6.0 years

7 - 12 Lacs

jaipur

Work from Office

Senior Dotnet Fullstack Developer Experience: 4 6 Years Location: Indore, Jaipur, Gurgaon Job Description: We are looking for a skilled Dotnet Developer with 4 6 years of professional experience in developing and delivering web applications and software solutions. The ideal candidate should have a strong background in Angular , ASP.NET, MVC, .NET Core, and MS SQL Server , along with a proven ability to adapt to diverse project requirements and deliver high-quality results within deadlines. Key Responsibilities: Design, develop, and maintain scalable web applications using .NET Core, ASP.NET MVC, and Angular . Collaborate with cross-functional teams to define, design, and ship new features. W...

Posted 3 days ago

AI Match Score
Apply

4.0 - 6.0 years

7 - 12 Lacs

gurugram

Work from Office

Senior Dotnet Fullstack Developer Experience: 4 6 Years Location: Indore, Jaipur, Gurgaon Job Description: We are looking for a skilled Dotnet Developer with 4 6 years of professional experience in developing and delivering web applications and software solutions. The ideal candidate should have a strong background in Angular , ASP.NET, MVC, .NET Core, and MS SQL Server , along with a proven ability to adapt to diverse project requirements and deliver high-quality results within deadlines. Key Responsibilities: Design, develop, and maintain scalable web applications using .NET Core, ASP.NET MVC, and Angular . Collaborate with cross-functional teams to define, design, and ship new features. W...

Posted 3 days ago

AI Match Score
Apply

3.0 - 8.0 years

4 - 7 Lacs

chandigarh

Work from Office

Backend Developers proficient in Java and PostgreSQL to join our team You will be responsible for implementing core business logic and backend APIs based on approved designs and user flows This role requires strong problem-solving skills, attention to detail, and the ability to work collaboratively with front-end developers, designers, and other stakeholders Key Responsibilities: Develop, test, and maintain backend services and APIs using Java Design and optimize database schemas and queries in PostgreSQL Implement business logic aligned with project requirements and workflows Ensure scalability, security, and performance of backend systems Collaborate with the front-end team to integrate AP...

Posted 3 days ago

AI Match Score
Apply

3.0 - 8.0 years

4 - 7 Lacs

mohali

Work from Office

Backend Developers proficient in Java and PostgreSQL to join our team You will be responsible for implementing core business logic and backend APIs based on approved designs and user flows This role requires strong problem-solving skills, attention to detail, and the ability to work collaboratively with front-end developers, designers, and other stakeholders Key Responsibilities: Develop, test, and maintain backend services and APIs using Java Design and optimize database schemas and queries in PostgreSQL Implement business logic aligned with project requirements and workflows Ensure scalability, security, and performance of backend systems Collaborate with the front-end team to integrate AP...

Posted 3 days ago

AI Match Score
Apply

5.0 - 8.0 years

13 - 18 Lacs

pune

Work from Office

Title and Summary Lead Software Engineer Overview The Database Engineering team is looking for a Lead Database Engineer to drive our customer experience strategy forward by consistently innovating and problem-solving. The ideal candidate is passionate about the customer experience journey, highly motivated, intellectually curious, analytical, and possesses an entrepreneurial mindset. Provide Oracle Database support for MasterCard Application databases in On-Prem and Cloud databases. As a Database Engineer, will play a critical role in designing, implementing, and maintaining Mastercards database systems. Collaborate with cross-functional teams to understand data requirements, optimize databa...

Posted 3 days ago

AI Match Score
Apply

4.0 - 9.0 years

15 - 19 Lacs

bengaluru

Hybrid

Hands-on experience SQL development and data warehousing Strong proficiency in SQL Server, SSIS, SSRS, SSAS, and Visual Studio Expertise in ETL design, data integration, data quality assurance, performance tuning & query optimization Excellent Comms Required Candidate profile Relevant experience: 4-6 Years in SQL Shift Timings: Australian shift (3 AM-12 PM) – Mostly remote with 1-2 days of office visit in a month to meet the team Notice period: Immediate Joiners preferred.

Posted 3 days ago

AI Match Score
Apply

Exploring Query Optimization Jobs in India

Query optimization is a crucial skill in the field of database management and software development. In India, the demand for professionals with expertise in query optimization is on the rise as companies strive to improve the performance of their databases and applications. Job seekers with a strong understanding of query optimization principles and techniques are well-positioned to secure lucrative opportunities in the Indian job market.

Top Hiring Locations in India

  1. Bengaluru
  2. Pune
  3. Hyderabad
  4. Chennai
  5. Mumbai

These cities are known for their vibrant tech ecosystems and offer numerous job opportunities for query optimization professionals.

Average Salary Range

The salary range for query optimization professionals in India varies based on experience and location. On average, entry-level professionals can expect to earn between INR 4-6 lakhs per annum, while experienced professionals with advanced skills can command salaries upwards of INR 12-15 lakhs per annum.

Career Path

The career progression in query optimization typically follows a trajectory from Junior Developer to Senior Developer to Tech Lead. As professionals gain experience and expertise in query optimization, they may take on more challenging roles that involve designing and implementing complex optimization strategies for databases and applications.

Related Skills

In addition to query optimization, professionals in this field are often expected to have proficiency in the following related skills: - Database Management - SQL - Performance Tuning - Data Modeling - Programming Languages (e.g., Python, Java)

Interview Questions

  • What is query optimization and why is it important? (basic)
  • Explain the difference between clustered and non-clustered indexes. (medium)
  • How do you identify and resolve performance bottlenecks in SQL queries? (advanced)
  • What tools do you use for query tuning and optimization? (basic)
  • Can you explain the concept of query execution plans? (medium)
  • What are the common challenges faced in query optimization? (medium)
  • How would you optimize a query that is running slow? (advanced)
  • Describe the process of index selection for query optimization. (medium)
  • What are the different types of join operations in SQL and when would you use each? (medium)
  • Have you worked on any projects where you implemented query optimization techniques? If so, can you provide an example? (advanced)
  • What are the best practices for writing efficient SQL queries? (medium)
  • How do you handle large datasets in query optimization? (medium)
  • Explain the concept of parameter sniffing in query optimization. (advanced)
  • How do you measure the performance of a query? (basic)
  • What are the advantages and disadvantages of denormalization in database design for query optimization? (medium)
  • How do you ensure data consistency while optimizing queries? (advanced)
  • What is the role of indexing in query optimization? (basic)
  • Describe a scenario where you had to optimize a query for a high-traffic website. What approach did you take? (advanced)
  • How do you handle query optimization for real-time data processing? (medium)
  • Can you explain the concept of query caching and how it impacts query optimization? (advanced)
  • How do you approach query optimization for a distributed database system? (advanced)
  • What are the key metrics you consider when evaluating the performance of a query? (medium)
  • How do you optimize queries for multi-tenant databases? (advanced)
  • What are the limitations of query optimization tools? (medium)
  • How do you stay updated with the latest trends and advancements in query optimization? (basic)

Closing Remark

As you prepare for interviews and explore job opportunities in query optimization, remember to showcase your skills and experience confidently. With the right knowledge and expertise, you can make a significant impact in optimizing database performance and driving efficiency in software applications. Good luck on your job search journey!

cta

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

Job Application AI Bot

Job Application AI Bot

Apply to 20+ Portals in one click

Download Now

Download the Mobile App

Instantly access job listings, apply easily, and track applications.

Featured Companies