15+ Query optimization Jobs in India

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 Summary:

We are seeking an experienced MS-SQL Server Database Developer with over 5+ years of hands-on experience in creating and managing database objects such as stored procedures, functions, triggers, and SSRS (Reports). The ideal candidate will be responsible for ensuring optimal performance, maintenance, and development of MS-SQL databases, including backup and restoration processes.

Key Responsibilities:

- Design, develop, and maintain stored procedures, functions, and triggers to support application functionality.

- Create and optimize complex queries for efficient data retrieval and manipulation.

- Develop reports using SQL Server Reporting Services (SSRS) or other reporting tools.

- Perform database backup, restoration, and recovery as per defined processes.

- Troubleshoot database-related issues and provide solutions for improving performance.

- Collaborate with development and QA teams to ensure database solutions meet business requirements.

- Ensure the security and integrity of data across all database environments.

Required Skills & Qualifications:

- 5+ years of experience working with MS-SQL Server (2016 or later).

- Strong expertise in writing complex T-SQL queries, stored procedures, functions, and triggers.

- Experience with report generation using SSRS or other reporting tools.

- Hands-on experience in backup, restoration, and database recovery processes.

- Familiarity with performance tuning and optimization techniques.

- Ability to work in a fast-paced environment and manage multiple tasks efficiently.

- Strong problem-solving and troubleshooting skills.

Role: Data Engineer

Industry Type: IT Services & Consulting

Department: Engineering - Software & QA

Employment Type: Full Time, 6M - 1Yr

Role Category: Software Development

Education

UG: BCA in Any Specialization, B.Tech/B.E. in Any Specialization

PG: M.Tech in Any Specialization

As a Customer Success Specialist, you’ll be the driving force behind exceptional learner experiences—from the moment they join to achieving their career goals. Your mission? Enhance user love and transform learning journeys into success stories!

What You'll Do:

• Manage the Learner Journey: Own the entire user lifecycle, from onboarding to post-course support, ensuring a seamless and rewarding experience.
• Be the Voice of LearnTube: Engage with learners via calls, chat, and email, resolving queries, offering guidance, and ensuring they get the most out of our courses.
• Drive Performance Excellence: Meet and exceed key performance metrics: quality, productivity, and user feedback, setting new standards for success.
• Build Strong Relationships: Go beyond solving queries: foster deep learner engagement and loyalty by actively listening and responding to their needs.
• Elevate the Learning Experience: Ensure every paid learner receives top-notch attention and support, making their upskilling journey smooth and enjoyable.
• Support Career Success: Help learners land their dream jobs by providing career guidance, insights, and expert assistance in job placements.

About Us: At LearnTube, we’re on a mission to make learning accessible, affordable, and engaging for millions of learners globally. Using Generative AI, we transform scattered internet content into dynamic, goal-driven courses with:

• AI-powered tutors that teach live, solve doubts in real time, and provide instant feedback.
• Seamless delivery through WhatsApp, mobile apps, and the web, with over 1.4 million learners across 64 countries.

Meet the Founders: LearnTube was founded by Shronit Ladhani and Gargi Ruparelia, who bring deep expertise in product development and ed-tech innovation. Shronit, a TEDx speaker, is an advocate for disrupting traditional learning, while Gargi’s focus on scalable AI solutions drives our mission to build an AI-first company that empowers learners to achieve career outcomes.

We’re proud to be recognized by Google as a Top 20 AI Startup and are part of their 2024 Startups Accelerator: AI First Program, giving us access to cutting-edge technology, credits, and mentorship from industry leaders.

What We Are Looking For:

• 1-2 years of experience in core operations/ customer success
• Strong communication & interpersonal skills
• MS Excel proficiency
• Detail-oriented mindset
• Passion for learning & helping others grow

Why Join Us?

• Fast-growing startup: Be part of something big, with real impact on people’s careers.
• High autonomy & ownership: Your ideas matter, and you’ll see them in action.
• Collaborative & transparent culture: Great teamwork.
• Endless learning opportunities: Upskill while helping others do the same.

Job Title: Database Administrator (PostgreSQL) 

Experience: 3 to 6 years 

Location: Gurgaon (Hybrid) 

Employment Type: Full-time 

Job Description: 

We are seeking a skilled Database Administrator (DBA) with expertise in PostgreSQL and strong RDBMS concepts. The ideal candidate will be responsible for database performance monitoring, optimization, automation, and interaction with development teams to support business requirements. 

Key Responsibilities: 

1. Database Administration & Management 

• Manage, configure, and maintain PostgreSQL databases ensuring high availability and reliability. 
• Implement Primary-Slave replication architecture and ensure smooth data synchronization. 
• Work with AWS RDS for PostgreSQL database hosting. 
• Automate database backups and manage release versions for database changes. 
• Implement point-in-time recovery (PITR) backups in AWS RDS to ensure data integrity and disaster recovery. 

2. Performance Monitoring & Optimization 

• Regularly monitor database health and performance metrics. 
• Analyze and optimize slow queries to enhance application performance. 
• Fine-tune database performance using configuration parameters, buffers, connections, Disk IOPs, and memory. 

3. SQL Development & Optimization 

• Write, optimize, and maintain stored procedures, SQL functions, and SQL Views. 
• Implement indexing strategies to improve query performance. 

4. Collaboration & Requirement Analysis 

• Work closely with application developers and business analysts to understand new product requirements. 
• Provide recommendations on database design and architecture for scalable solutions. 

5. Database Security & Compliance 

• Implement best practices for database security, access control, and data integrity. 
• Ensure compliance with data governance and security policies. 

6. Automation & Maintenance 

• Automate database maintenance tasks such as backups, indexing, and archiving. 
• Establish monitoring and alerting systems to proactively address database issues. 

Technical Expertise Required: 

• 3 to 6 years of experience as a Database Administrator (DBA). 
• Strong knowledge of PostgreSQL and RDBMS principles. 
• Experience in writing stored procedures, SQL functions, and SQL Views. 
• Hands-on experience in query optimization and performance tuning. 
• Understanding of Primary-Slave architecture and replication setup. 
• Knowledge of database configuration tuning (buffers, connections, Disk IOPs, Memory, etc.). 
• Experience in automating database backups and version control for DB changes. 
• Familiarity with AWS RDS for PostgreSQL and point-in-time backup (PITR). 
• Experience in cloud-based database solutions (AWS RDS, Azure, GCP). 
• Strong problem-solving and analytical skills. 

Preferred Qualifications: 

• Experience in high-availability solutions and disaster recovery strategies. 
• Exposure to NoSQL databases is a plus. 
• Experience with database migrations and upgrades. 

Position: Lead Database Engineer

Experience: 3+ Years

Mandatory Skills: Amazon Aurora PostgreSQL, MySQL, NoSQL, AWS RDS, DMS, Performance Tuning, Replication Strategies, Query Optimization

Job Description:

• Database Administration: Manage and administer Amazon Aurora PostgreSQL, MySQL, and NoSQL databases, ensuring high availability, performance, and security.
• AWS Expertise: Proficient in AWS services such as RDS, Aurora, and DMS, with a strong understanding of cloud database architectures.
• Optimization: Implement optimization strategies at the database, query, collection, and table levels for PostgreSQL/MySQL. Expertise in performance monitoring and tuning.
• Configuration Management: Configure and fine-tune RDS parameter groups to enhance database performance and security.
• Monitoring & Troubleshooting: Proactively monitor database performance, identify bottlenecks, and perform root cause analysis (RCA) for issues.
• Access Control: Manage PostgreSQL/MySQL user permissions and roles, ensuring strict data security and access control protocols.
• Replication Strategies: Hands-on experience with master-master and master-slave replication setups.
• Collaboration: Work closely with development teams to provide guidance on database design, query optimization, and performance tuning.
• Backup & Recovery: Establish and maintain robust backup and recovery procedures to ensure data integrity and availability.
• Database Upgrades: Perform major version upgrades for MySQL and PostgreSQL to leverage new features and improvements.
• Problem Solving: Troubleshoot and resolve complex database performance issues, implementing innovative and effective solutions.

Note: Expertise in database performance tuning, AWS database services, and advanced replication strategies is essential.

Job Title : Lead Database Engineer

Location : Gurgaon Sector-43

Experience Required : 4+ Years

Employment Type : Full-Time

Summary :

We are seeking a highly skilled Lead Database Engineer with expertise in managing and optimizing database systems, primarily focusing on Amazon Aurora PostgreSQL, MySQL, and NoSQL databases. The ideal candidate will have in-depth knowledge of AWS services, database architecture, performance tuning, and security practices.

Key Responsibilities :

1. Database Administration :

• Manage and administer Amazon Aurora PostgreSQL, MySQL, and NoSQL database systems to ensure high availability, performance, and security.
• Implement robust backup and recovery procedures to maintain data integrity.

2. Optimization and Performance:

• Develop and execute optimization strategies at the database, query, collection, and table levels.
• Proactively monitor performance and fine-tune RDS parameter groups for optimal database operations.
• Conduct root cause analysis and resolve complex database performance issues.

3. AWS Services and Architecture :

• Leverage AWS services such as RDS, Aurora, and DMS to ensure seamless database operations.
• Perform database version upgrades for PostgreSQL and MySQL, integrating new features and performance enhancements.

4. Replication and Scalability:

• Implement and manage various replication strategies, including master-master and master-slave replication, ensuring data consistency and scalability.

5. Security and Access Control:

• Manage user permissions and roles, maintaining strict security protocols and access controls.

6. Collaboration:

• Work closely with development teams to optimize database design and queries, aligning database performance with application requirements.

Required Skills :

• Strong Expertise: Amazon Aurora PostgreSQL, MySQL, and NoSQL databases.
• AWS Services: Experience with RDS, Aurora, and DMS.
• Optimization: Hands-on experience in query optimization, database tuning, and performance monitoring.
• Replication Strategies: Knowledge of master-master and master-slave replication setups.
• Problem Solving: Proven ability to troubleshoot and resolve complex database issues, including root cause analysis.
• Security: Strong understanding of data security and access control practices.
• Collaboration: Ability to work with cross-functional teams and provide database-related guidance.

Preferred Qualifications :

• Certification in AWS or database management tools.
• Experience with other NoSQL databases like MongoDB or Cassandra.
• Familiarity with Agile and DevOps methodologies.

Job Title: ELK Stack Engineer

Position Overview:

We are seeking a skilled and experienced Senior Elasticsearch Developer to join our team. The ideal candidate will be responsible for designing, developing, and maintaining data pipelines using the ELK Stack (Elasticsearch 7.1 or higher, Logstash, Kibana). The Senior Elasticsearch Developer will play a key role in managing large datasets, optimizing complex queries, and maintaining self-hosted Elastic Search clusters.

Responsibilities:

• Design, develop, and maintain data pipelines using the ELK Stack.
• Handle large datasets (3 billion+ records, 100+ fields per index) with efficiency and accuracy.
• Develop and optimize complex Elasticsearch queries for efficient data retrieval and analysis.
• Manage and maintain self-hosted Elastic Search clusters.
• Implement DevOps practices, including containerization with Docker.
• Perform backups, disaster recovery, and index migrations to ensure data security and integrity.
• Execute data processing and cleaning techniques, including writing custom scripts to extract and transform data into usable formats.
• Collaborate with the engineering team to integrate Elastic Search with other systems.

Requirements:

• Bachelor's degree in Computer Science, Engineering, or related field.
• Minimum 5+ years of experience in designing, developing, and maintaining data pipelines using the ELK Stack.
• Hands-on experience handling large datasets (3 million+ records, 50+ fields per index).
• Strong proficiency in developing and optimizing complex Elasticsearch queries.
• Experience managing and maintaining self-hosted ElasticSearch clusters.
• Proficiency in DevOps practices, including containerization with Docker.
• Knowledge of security best practices, including backups, disaster recovery, and index migrations.
• Experience with database administration and data processing techniques.
• Excellent communication and teamwork skills.

Benefits:

• Competitive salary and benefits package between 20 to 35 LPA.
• Opportunities for professional development and growth.
• Collaborative and inclusive work environment.
• Flexible work hours and remote work options.

The Inside Sales Specialist is a key player in our organization, responsible for nurturing existing client relationships and creating new ones. This role involves converting pre-qualified leads, upselling, and ensuring an exceptional customer experience.

Responsibilities:

• Source Opportunities: Identify new sales prospects through inbound lead follow-up, outbound cold calls, and emails.
• Understand Customer Needs: Listen to customer requirements and understand their needs and preferences.
• Route Qualified Opportunities: Pass qualified leads to the appropriate sales executives for further development and closure.
• Achieve Quotas: Close sales deals and meet quarterly targets.
• Research and Identify Key Players: Understand the client landscape, identify decision-makers, and generate interest.
• Maintain Prospect Database: Keep your database of prospects up-to-date within your assigned territory.
• Collaborate with Channel Partners: Work closely with channel partners to build a strong sales pipeline and close deals.
• Conduct Effective Online Demos: Showcase our products/services to potential clients.

Requirements:

• Proven Inside Sales Experience: Demonstrated success in inside sales.
• Strong Phone Presence: Comfortable making numerous calls daily.
• Proficiency with CRM Tools: Familiarity with Salesforce.com or similar CRM systems.
• Excellent Communication Skills: Both verbal and written.
• Effective Listening and Presentation Skills: Ability to understand client needs and present solutions.
• Time Management and Multitasking: Prioritize tasks effectively.
• Bachelor’s Degree or Equivalent: Educational background in business or related field.

Why Join Us?

• Be part of a dynamic team in the engineering industry.
• Opportunity to make a significant impact on our growth.
• Collaborate with channel partners and contribute to our success.

If you’re passionate about sales, building relationships, and contributing to an engineering company’s success, we’d love to hear from you! Apply now and let’s create something great together!

Bachelor’s degree in Computer Science,

Information Systems or related field and/or equivalent relevant experience  Three years of progressively challenging experience working as a CC&B suite Senior Developer in solution architecture, project management, system design, development testing, implementation and support  Advanced knowledge in CC&B Java, C2M, Oracle Database, CC&B data model and Oracle Utilities Application Framework  Proficient in usingHibernateQuery Language, XAIIWSWeb Services, CCB Configuration Tools, web-based languages(e.g., HTML, XML, SOAP, JavaScript, etc.) and UNIX • Extensive experience with Oracle Utilities SDK and Eclipse 3.7 and with writing high performance, multi-threaded, critical java applications over large databases including Oracle 10g and Oracle 11g.  Proficient working knowledge of SQL and relational database concepts and developing stored procedures in Oracle 10g and Oracle 11g  Knowledge and understanding of software development life cycle and industry best practices  Proficient in the use of MicrosoftOffice applications  Experience should include multi-product implementations (CC&Bintegrations with MWM, MDM, WAM, CSS, etc).  Must have experience with otherintegrationsinvolvingthe XAI IWS interfaces  Must have in-depth knowledge of field order and field activities workflow, configuration and writing custom services  Must have prior experience implementing (mobile workforce) any other third party workforce tool with CC&B  Must have prior experience implementing CC&Bwith a customer portal 

Bachelor’s degree in Computer Science, Information Systems or related field and/or equivalent relevant experience  Three years of progressively challenging experience working as a CC&B suite Senior Developer in solution architecture, project management, system design, development testing, implementation and support  Advanced knowledge in CC&B Java, C2M, Oracle Database, CC&B data model and Oracle Utilities Application Framework  Proficient in usingHibernateQuery Language, XAIIWSWeb Services, CCB Configuration Tools, web-based languages(e.g., HTML, XML, SOAP, JavaScript, etc.) and UNIX • Extensive experience with Oracle Utilities SDK and Eclipse 3.7 and with writing high performance, multi-threaded, critical java applications over large databases including Oracle 10g and Oracle 11g.  Proficient working knowledge of SQL and relational database concepts and developing stored procedures in Oracle 10g and Oracle 11g  Knowledge and understanding of software development life cycle and industry best practices  Proficient in the use of MicrosoftOffice applications  Experience should include multi-product implementations (CC&Bintegrations with MWM, MDM, WAM, CSS, etc).  Must have experience with other integrations involving the XAI IWS interfaces  Must have in-depth knowledge of field order and field activities workflow, configuration and writing custom services  Must have prior experience implementing MWM (mobile workforce) or any other third party workforce tool with CC&B  Must have prior experience implementing CC&Bwith a customer portal 

Who We are?

At e6data (https://e6x.io/" target="_blank">https://e6data.io) we’re building core algorithms that make querying 25 - 200X more performant (i.e. faster and/or cheaper) than every other analytics platform in the world. This results in billions of dollars of value unlocked across faster analytics, savings on computing/infra, and new use cases become possible.

Our core team has 100+ years of combined experience and 10+ patents across diverse but complementary disciplines like real-time databases, time-series databases, SQL OLAP engines, distributed computing platforms, stream processing, and log analytics. Two of the founding team are second-time founders with past exits.

We are passionate about solving the deepest and most important problems in computer science and believe in making our technology available to customers regardless of their location, size, or budget. Our vision is for e6data to power every analytical workload in the world - regardless of deployment scenario (cloud, on-premise, edge), across every use case (end-user queries, ETL / data pipelines), and every latency requirement (batch, streaming / real-time).

What you will do?

• Write awesome code
• Your primary focus will be on building our product around our core algorithms. You will collaborate with our Performance Engineering and DevOps teams.
• Identify tactical and long-term product improvements (could be code, script, etc.) so that e6data development is based on frictionless onboarding of customers
• Build our internal Data Platform using e6data
• Adding scalable functionality to the core e6data engine for new features like UDFs, SQL functions, etc

What we are looking for?

• Worked with Java for a minimum of 4 years
• Knowledge of SQL Query planning will also be good to have
• A passion for continuous learning and growth (both at a personal and team level)
• Strong team player
• Experience (or enjoys) working in a startup will be an added advantag

Office Location: Goregaon Mumbai

Position description:

4+ years of experience in database development.

Primary Responsibilities:

• Understand requirements from front end applications developers
• Write advanced queries, stored procedures, cursors, functions & triggers
• Conduct code reviews
• Work with high-traffic application servers
• Complete understanding of various DB like Postgresql, Mongo DB, MySQL 
• Ability to identify root cause and mitigate issues
• Ability to lead a team of DB developers

Required Skills:

Mandatory: Passionate about sports, Problem solving, Team player, Target & Result oriented, Strong communication skills

Functional: Oracle SQL, PostgreSQL Development - TSQL, Advance Queries, Query Optimization, Stored Procedures, Triggers & Cursors, Database Design, Indexes, Joins, ETL tools like SSAS, SSIS, High Data Volume Processing, DB Backup/Recovery.

Purpose: We are looking for React Native Application Developer who possesses a passion for mobile technologies.

Roles & Responsibilities:

• Ideal candidate should have Working knowledge of React Native and React JS is a must.
• Over 3+ years of React Native experience with strong basics.
• At least have done 4/5 projects using React Native.

• Strong passion for Programming in general and Android and IOS App development.

• Strong problem solving skills.
• Strong system design and architecture skills.
• Curiosity to tinker around, explore new paradigms and strong zest for continuous improvement.
• Over 3+ years of Mobile development experience with strong basics.
• E2E App development and/or experience of developing SDKs is good to have.

Expected Start Date: 1/4/2021

Job Type: Full-time