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.

• 2 years of strong development background building complex applications.
• Proficiency in JavaScript, including DOM manipulation and the JavaScript object model.
• Experience building applications using NodeJS and frameworks such as Express.
• Thorough understanding of React.js and NodeJS including its core principles.
• Ability to understand business requirements and translate them into technical requirements.
• Familiarity with code versioning tools (such as Git, SVN, and Mercurial).
• Understanding the nature of asynchronous programming and its quirks and workarounds
• Strong experience with MongoDB, Postgres
• Developing new user-facing features using React.js
• Thorough understanding of React.js & popular Workflows (such as Flux or Redux)
• Building reusable components and front-end libraries for future use

Node.js, Java/Scala, C#/.Net, Go Lang, ReactJS/AngularJS, MySQL/PostgreSQL, Elastic Search/MongoDB, Hadoop/Spark, AWS/Azure, Docker/Kubernetes, Agile

Company Profile:

The company is World's No1 Global management consulting firm.

Job Summary:

What we are scouting for

• BS/MS in computer science or equivalent work experience in IT
• 2+ years’ experience designing and developing applications using Java EE platforms
• A strong hands-on programming knowledge in Core Java including Java 8. To solve the problem given in optimized way.
• Strong knowledge on the Data structure and algorithm.
• Experience developing and designing API integrations using SOAP/RESTful
• Should be able to understand the time complexity of the existing algorithm. Able to compare different algorithms available.
• Expert understanding of the object-oriented design and programming concepts
• Know the fundamentals of Object-Oriented Programming using Java;
• Used SQL & NoSQL solutions
• Experience in GIT/SVN, build tools such as Ant/Maven/Gradle
• Experience in JUnit, Sonarqube, Mockito, Jacoco, Maven & Jenkins

Technical Competency – Nice to have

• Experience in Dependency Injection, Annotation, Validations, Auto Wiring
• Good knowledge in internal working on Memory Management, Transaction management
• Knowledge on DevOps pipeline tools like Jenkins, tools for Code quality scan, tools for security scan
• Spring boot
• Spring MVC
• Any Java Certification

Behavioural Competency

• Strong interpersonal communication skills
• Ability to lead self and team toward common goals
• Excellent oral and written communication, presentation, and analytical skills
• Excellence in technical communication with peers and non-technical cohorts

What you will be doing

• As a self-motivated and enthusiastic member of our team, you will work with extremely talented peers in a fun environment building performance efficient payment authorization services that are highly scalable, configurable and available
• You’ll work in an Agile environment with a focus on problem solving and engineering excellence.
• Worked independently and as a member of a team, determined to make active contributions to the assigned Team
• Flexible and adaptable approach to the roles assigned to you
• Ability to coordinate and prioritize tasks, and work in a fast paced and challenging environment
• Deliver on time under dynamics with a high level of integrity and flexibility, sense of urgency, attention to detail and quality standards
• Make a large impact on the design, architecture, and implementation of cutting edge products
• Work with other team members to investigate design approaches, prototype new technology

and evaluate technical feasibility

• Work in an Agile/Scrum environment to deliver high quality software
• Establish architectural principles, select design patterns and then mentor team members on their appropriate application