2+ Query optimization Jobs in Bangalore (Bengaluru) | Query optimization Job openings in Bangalore (Bengaluru)

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.