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

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.

Delivery Solutions is a Retail eCommerce OXM Platform that provides retailers with out-of-the-box solutions to power Same-Day Delivery, Curbside, In-Store Pickup, Shipping, and Post Purchase experiences. We are trusted with some of the biggest names in multiple verticals of retail like Sephora, AT&T, Footlocker, Michael's, Office Depot, GameStop, Total Wine, Sally Beauty, Abercrombie & Fitch Co. Belk, Loblaw, Vineyard Vines etc.

Our SAAS-based solution is highly flexible and interacts seamlessly with E-commerce properties, OMS, WMS, and POS systems for a highly scalable experience and a delighted customer base.

Delivery Solutions is a wholly-owned subsidiary of UPS | We are a certified Great Places To Work Company

Role: Senior Software Engineer - MEAN Stack

Reports to: Team Lead

Division/Department: Product

Work Location: India - Remote / Pune

We are seeking highly skilled and experienced Senior Software Engineers to join our SaaS company. As a Senior Software Engineer, you will play a pivotal role in the development and enhancement of our cutting-edge software products. You will work closely with cross-functional teams to design, develop, and deploy scalable software solutions using the MEAN stack (MongoDB, Express.js, Angular, Node.js) and related technologies.

Responsibilities:

• Collaborate with product managers, designers, and other stakeholders to define software requirements and translate them into technical specifications.
• Design and develop robust and scalable software solutions using the MEAN stack and other relevant technologies.
• Take ownership of feature development and deliver high-quality code on time.
• Participate in code reviews to ensure code quality and adherence to coding standards.
• Troubleshoot and debug software issues, and identify and implement effective solutions.
• Collaborate with DevOps teams to ensure smooth deployment and operation of software applications.
• Stay up-to-date with the latest industry trends, tools, and technologies and make recommendations for process improvements.

Qualifications:

• Bachelor's degree in Computer Science, Software Engineering, or a related field. (Master's degree preferred)
• 4+ years of hands-on experience in MEAN stack development, including MongoDB, Express.js, Angular (version 2 or higher), and Node.js.
• Proven experience working in a product-based company, delivering software solutions to customers.
• Strong understanding of Agile methodologies and Agile development practices.
• Proficient in front-end technologies such as Angular, HTML, CSS, and responsive design principles.
• Solid understanding of back-end technologies including Node.js, RESTful APIs, and server-side frameworks.
• Experience with cloud platforms, specifically AWS, and familiarity with related services.
• Knowledge of JSON, Kibana, JIRA, and Jenkins is a plus.
• Strong problem-solving skills and the ability to work independently as well as in a team.
• Excellent communication and interpersonal skills, with the ability to effectively collaborate with cross-functional teams.

• Has led engineering teams before with full-stack developers preferably and can contribute to building the team as per requirement
• Lead the team to plan, deign and build solutions
• Work closely with the founders to decide the direction of the product
• Have experience redefining the MSME sector
• Have worked on digitizing the supply side of the organization
• Have an experience of 6-8 years in the industry
• Preferable SaaS experience with a B2B set up

Accounting and Compliances

• Responsible for day to day accounting function of the organization 
• Responsible for monthly/ yearly book closing
• Responsible for all statutory compliances including TDS, RBI, MCA etc.
• Ensuring adequate controls are in place
• Managing the payroll process

Lender Management

• Accurately calculating the billing amounts 
• Managing the invoicing & collection process

Financial Planning and Analysis

• Responsible for the weekly/monthly MIS Reporting – internal as well as investor reporting 
• Analysing the variances from the forecasted numbers

Taxation

• Managing the Corporate taxes including the tax audit
• Managing in the Indirect taxes including Goods and Service Tax

Treasury

• Monitoring the day-to-day cash and bank movements to calculate the free cash flows

Required Skills:

• 3+ years of experience in the Development of JAVA technology.
• Strong Java Basics
• SpringBoot or Spring MVC
• Hands-on experience in Relational Databases (SQL query or Hibernate) + Mongo (JSON parsing)
• Proficient in REST API development
• Messaging Queue (RabitMQ or Kafka)
• Microservices
• Any Caching Mechanism
• Good at problem-solving

Good to Have Skills:

• 4+ years of experience in using Java/J2EE tech stacks
• Good understanding of data structures and algorithms.
• Excellent analytical and problem-solving skills.
• Ability to work in a fast-paced internet start-up environment.
• Experience in technical mentorship/coaching is highly desirable.
• Understanding AI/ML algorithms is a plus.

• Design, architect, and build high-quality scalable systems
• Review system design and architecture, code, and test plans
• Handle technical questions and escalations from clients
• Own projects end-to-end, including gathering requirements, solutioning and designing architecture, developing, testing, deploying, and maintaining systems
• Interact and collaborate with our high-quality technical team across India and the US

• 2 + years of software development experience utilizing Java based frameworks and technologies to build enterprise grade product solutions.
• 2+ years of experience designing, developing and documenting RESTful APIs.
• Strong understanding of concepts/technologies like Spring MVC, Spring boot, J2EE, EJB, application/API security, API governance/gateway platforms like apigee or kong.
• Good understanding of RDMS concepts and development preferably using MS SQL Server.
• Experience using test automation technologies like cucumber, selenium is a big plus.
• Partner with scrum masters to address technical blockers/impediments to progress.
• Prior experience working with agile scrum-based development methodology. Participate in sprint planning and estimate development efforts for features and stories.
• Partner with DevOps to install and configure/tune application containers like embedded Spring boot tomcat and webserver technologies preferably nginx or apache.
• Partner with cloud engineering group to outline the infrastructure provisioning requirements/needs for new product development.
• Design and develop CI/CD tools and process preferably using Jenkins to configure build jobs for APIs and design pipeline to promote artifacts from development all the way to production
• Experience with messaging technologies like kafka is a huge plus
• Work with Test Automation engineering team to integrate test automation scripts as part of the CI/CD process.
• Prior proven experience of utilizing and productionizing container/container orchestration technologies like Docker, kubernetes.
• Participate and Resolve issues related deployments, application performance etc.

BitClass, a VC funded startup in edtech, is looking for a React Native developer interested in building performant mobile apps on both the iOS and Android platforms. You will be responsible for architecting and building these applications, as well as coordinating with the teams responsible for other layers of the product infrastructure. Building a product is a highly collaborative effort, and as such, a strong team player with a commitment to perfection is required.

• Build pixel-perfect, buttery smooth UIs across both mobile platforms.
• Leverage native APIs for deep integrations with both platforms.
• Diagnose and fix bugs and performance bottlenecks for performance that feels native.
• Reach out to the open source community to encourage and help implement mission-critical software fixes—React Native moves fast and often breaks things.
• Maintain code and write automated tests to ensure the product is of the highest quality.
• Transition existing Android app to React Native.

• Firm grasp of the JavaScript language and its nuances, including ES6+ syntax
• Ability to write well-documented, clean Javascript code
• Rock solid at working with third-party dependencies and debugging dependency conflicts
• Familiarity with native build tools, like XCode, Gradle, Android Studio/IntelliJ
• Understanding of REST APIs, the document request model, and offline storage
• Experience with automated testing suites, like Jest or Mocha

Your Responsibilities :