10+ Query optimization Jobs in India

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