3+ SQL tuning Jobs in India

Job Description for Database Consultant-I (PostgreSQL)

Job Title: Database Consultant-I (PostgreSQL)

Company: Mydbops

About Us:

Mydbops is a trusted leader with 8+ years of excellence in open-source database management. We deliver best-in-class services across MySQL, MariaDB, MongoDB, PostgreSQL, TiDB, Cassandra, and more. Our focus is on building scalable, secure, and high-performance database solutions for global clients. As a PCI DSS-certified and ISO-certified organisation, we are committed to operational excellence and data security.

Role Overview:

As a Database Consultant – I (PostgreSQL Team), you will take ownership of PostgreSQL database environments, offering expert-level support to our clients. This role involves proactive monitoring, performance tuning, troubleshooting, high availability setup, and guiding junior team members. You will play a key role in customer-facing technical delivery, solution design, and implementation.

Key Responsibilities:

• Manage PostgreSQL production environments for performance, stability, and scalability.
• Handle complex troubleshooting, performance analysis, and query optimisation.
• Implement backup strategies, recovery solutions, replication, and failover techniques.
• Set up and manage high availability architectures (Streaming Replication, Patroni, etc.).
• Work with DevOps/cloud teams for deployment and automation.
• Support upgrades, patching, and migration projects across environments.
• Use monitoring tools to proactively detect and resolve issues.
• Mentor junior engineers and guide troubleshooting efforts.
• Interact with clients to understand requirements and deliver solutions.

Requirements:

• 3–5 years of hands-on experience in PostgreSQL database administration.
• Strong Linux OS knowledge and scripting skills (Bash/Python).
• Proficiency in SQL tuning, performance diagnostics, and explain plans.
• Experience with tools like pgBackRest, Barman for backup and recovery.
• Familiarity with high availability, failover, replication, and clustering.
• Good understanding of AWS RDS, Aurora PostgreSQL, and GCP Cloud SQL.
• Experience with monitoring tools like pg_stat_statements, PMM, Nagios, or custom dashboards.
• Knowledge of automation/configuration tools like Ansible or Terraform is a plus.
• Strong communication and problem-solving skills.

Preferred Qualifications:

• Bachelor’s or Master’s degree in Computer Science, Engineering, or equivalent.
• PostgreSQL certification (EDB/Cloud certifications preferred).
• Past experience in a consulting, customer support, or managed services role.
• Exposure to multi-cloud environments and database-as-a-service platforms.
• Prior experience with database migrations or modernisation projects.

Why Join Us:

• Opportunity to work in a dynamic and growing industry.
• Learning and development opportunities to enhance your career.
• A collaborative work environment with a supportive team.

Job Details:

• Job Type: Full-time
• Work Days: 5 Days
• Work Mode: Work From Home
• Experience Required: 3–5 years

Role and responsibilities

·      Collect requirements, design, develop and test software code.

·      Fix bugs and provide production support.

·      Prioritize multiple tasks and manage time effectively.

·      Learn new technologies outside his/her primary skills.

·      Develop solutions to challenging problems.

·      Effectively communicate with team members, project managers and clients, as required.

Technical skills requirements

The candidate must demonstrate proficiency in,

·      SQL, PL-SQL & RICE Components.

·      Develop applications, reports and interfaces using standard Oracle development methodologies.

·      BI Publisher, RDF/XML & Discoverer Reports.

·      Form Personalizations.

·      Unit test the reports with standard E-Business suite application.

·      Performance Tuning & Optimization.

·      Table-level technical knowledge of OM, Inventory Management, Purchasing, GL, AR, AP, and FA.

·      SQL Developer, TOAD, SQL Loader

Nice-to-have skills

·         SQL Tuning

·         EBS Finance/SCM functional knowledge

·         Performance Improvements and External Integrations

·         Ability to develop applications and modules keeping scalability and performance in mind.

Primary Responsibilities

• Architect and drive complex software performance improvement projects that mitigate the performance challenges of the product and establish new guidelines for future product features
• Work with the development team, and database administrators to analyze performance bottlenecks, make recommendations to address performance concerns, and co-design performance into new feature development
• Efficiently working with various profiling and monitoring tools to identify performance and concurrency bottlenecks, propose and implement optimizations to improve cloud product
• Review end-user usage patterns and customer logged performance defects and enhance performance test coverage based on gaps identified.
• Understand database internals, server and storage system design, application interactions with database queries and stored procedures and with other downstream systems
• Troubleshoot issues experienced by users and propose solutions

Basic Qualifications

• 8+ years of experience in implementing and driving software performance engineering projects and solutions. Advanced level experience with concurrency, multithreading, and distributed system architectures
• Experience analyzing performance bottlenecks with application code interfacing with databases using ORM Frameworks, cache layers, data storage, servers, networking, and database query protocols including developing stored procedures, SQL queries, and database applications
• Working knowledge of relational database internals (locking, consistency, replication, serialization, failover, recovery)
• Comfortable with Windows, SQL Server, .NET Framework/Core, GIT, Nuget, SPA, Modern UI Frameworks, ORM Framework NHibernate in terms of both tools and application development
• Passionate about finding software performance bottlenecks and optimizing code to produce a better customer experience
• Experience with APM (Application Performance Monitoring), RUM (Real User Monitoring), and other Dev tools used for Performance monitoring and analysis
• Experience with performance bottleneck analysis, system design for scaling