7+ Database performance tuning 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.

Mammoth

Mammoth is a data management platform revolutionizing the way people work with data. Our lightweight, self-serve SaaS analytics solution takes care of data ingestion, storage, cleansing, transformation, and exploration, empowering users to derive insights with minimal friction. Based in London, with offices in Portugal and Bangalore, we offer flexibility in work locations, whether you prefer remote or in-person office interactions.

Job Responsibilities

• Collaboratively build robust, scalable, and maintainable software across the stack.
• Design, develop, and maintain APIs and web services.
• Dive into complex challenges around performance, scalability, concurrency, and deliver quality results.
• Improve code quality through writing unit tests, automation, and conducting code reviews.
• Work closely with the design team to understand user requirements, formulate use cases, and translate them into effective technical solutions.
• Contribute ideas and participate in brainstorming, design, and architecture discussions.
• Engage with modern tools and frameworks to enhance development processes.

Skills Required

Frontend:

• Proficiency in Vue.js and a solid understanding of JavaScript.
• Strong grasp of HTML/CSS, with attention to detail.
• Knowledge of TypeScript is a plus.

Backend:

• Strong proficiency in Python and mastery of at least one framework (Django, Flask, Pyramid, FastAPI or litestar).
• Experience with database systems such as PostgreSQL.
• Familiarity with performance trade-offs and best practices for backend systems.

General:

• Solid understanding of fundamental computer science concepts like algorithms, data structures, databases, operating systems, and programming languages.
• Experience in designing and building RESTful APIs and web services.
• Ability to collaborate effectively with cross-functional teams.
• Passion for solving challenging technical problems with innovative solutions.
• AI/ML or Willingness to learn on need basis.

Nice to have:

• Familiarity with DevOps tools like Docker, Kubernetes, and Ansible.
• Understanding of frontend build processes using tools like Vite.
• Demonstrated experience with end-to-end development projects or personal projects.

Job Perks

• Free lunches and stocked kitchen with fruits and juices.
• Game breaks to unwind.
• Work in a spacious and serene office located in Koramangala, Bengaluru.
• Opportunity to contribute to a groundbreaking platform with a passionate and talented team.

If you’re an enthusiastic developer who enjoys working across the stack, thrives on solving complex problems, and is eager to contribute to a fast-growing, mission-driven company, apply now!

Oracle OAS Developer

Senior OAS/OAC (Oracle analytics) designer and developer having 3+ years of experience. Worked on new Oracle Analytics platform. Used latest features, custom plug ins and design new one using Java. Has good understanding about the various graphs data points and usage for appropriate financial data display. Worked on performance tuning and build complex data security requirements.

Qualifications

Bachelor university degree in Engineering/Computer Science.

Additional information

Have knowledge of Financial and HR dashboard

Rajasthan Studio is looking for young and bright minds for its upcoming innovative, never-experienced-before app platform for virtual art experiences.

We are looking for programmers with problem-solving skills and critical thinking abilities for the position of Back End developer. Back End developers are responsible for creating a bridge between customers and business logic, optimizing applications for maximum efficiency, creating dashboards for internal teams, and maintaining brand consistency across the application, among other duties.

Backend Web Developers are responsible for managing the interchange of data between the server and the users. The role's primary focus will be the development of all server-side logic, definition, and maintenance of the central database, and ensuring high performance and responsiveness to requests from the front-end. A basic understanding of front-end technologies is necessary as well.

Responsibilities -

• Creating RESTful API/GraphQL to be consumed by Flutter developers
• Building reusable code and libraries for future use
• Optimization of the application for maximum speed and scalability
• Implementation of security and data protection
• Design and implementation of data storage solutions
• Participate in the entire application lifecycle, focusing on coding and debugging
• Write clean code to develop functional web applications
• Troubleshoot and debug applications
• Provide training and support to internal teams

Skill & Qualifications -

• Basic understanding of front-end technologies and platforms, such as JavaScript, HTML5, and CSS3
• Understanding accessibility and security compliances
• User authentication and authorization between multiple systems, servers, and environments
• Integration of multiple data sources and databases into one system
• Management of hosting environment, including database administration and scaling an application to support load changes
• Data migration, transformation, and scripting
• Setup and administration of backups
• Outputting data in different formats
• Understanding differences between multiple delivery platforms such as mobile vs desktop, and optimizing output to match the specific platform
• Creating database schemas that represent and support business processes
• Implementing automated testing platforms and unit tests
• Proficient understanding of code versioning tools, such as Git
• Proficient understanding of OWASP security principles
• Understanding of “session management” in a distributed server environment
• Knowledge of Yii framework - version 2 (preferred)

Essential duties and responsibilities include the following.

• Design, create and maintain databases through multiple product lifecycle environments, from development to production systems
• Configure and maintain database servers and processes, monitor system health and performance, to ensure high levels of performance, availability, and security.
• Convert complex business requirements into technical specifcations to build scalable and reliable data solutions 
• Apply data modelling techniques to ensure development and implementation support efforts meet integration and performance expectations.
• Independently analyse, solve, and correct issues in real time on production, providing problem resolution end-to-end.
• Refine and automate regular processes, track issues, and document changes.
• Develop complex query, performance tuning, stored procedures and triggers, scheduled jobs, schema refinement.
• Flexibility to work after office hours for any production issue or production deployment.
• Perform scheduled maintenance and support release deployment activities after hours.
• Share domain and technical expertise, providing technical mentorship and cross-training to other peers and team members.

Qualifications include:

• 4+ years of database and backend development experience
• Good understanding of database systems and architectures
• Expertise in writing complex SQL queries and stored procedures
• Hands on experience with RDBMS and NoSQL data stores like  MySQL and MongoDB
• Experience working with Python scripting and application development
• Experience working with Cloud applications and data stores like AWS RDS is a plus
• In-depth understanding of data management and ETL processes