Database Specialist With Postgres

3 days ago


India Two95 International Full time ₹ 12,00,000 - ₹ 24,00,000 per year

Title: Database Performance Specialist

Location: Remote

Duration: 6+Months Contract

Salary: Open (INR).

Requirements
About the Role

We are seeking an experienced Database Performance Specialist with strong expertise in PostgreSQL and PgBouncer to support our team on a 4–6 month remote contract engagement. You will be responsible for ensuring optimal database performance, improving efficiency, and supporting mission-critical environments.

Key Responsibilities
  • Perform in-depth PostgreSQL performance tuning, including query optimization, indexing strategy, and resource tuning.
  • Configure, optimize, and maintain PgBouncer connection pooling in production.
  • Monitor and analyze database metrics to identify bottlenecks and performance issues.
  • Troubleshoot slow queries, locking/blocking, replication lag, and transaction contention.
  • Implement or refine database architecture for scaling, HA, replication, and failover.
  • Collaborate with engineering teams to improve schema design and application database interactions.
  • Create automation for performance monitoring, analysis, and recurring maintenance tasks.
  • Document best practices, configurations, and performance recommendations.
Required Qualifications
  • 5+ years hands-on experience managing and optimizing PostgreSQL in production environments.
  • Proven experience with PgBouncer configuration, tuning modes, sizing, and troubleshooting.
  • Expert-level SQL performance tuning and understanding of PostgreSQL internals (planner, optimizer, WAL, MVCC).
  • Experience with monitoring tools such as pg_stat_statements, pgBadger, Prometheus/Grafana, or APM tools.
  • Strong understanding of replication, HA strategies, and disaster recovery planning.
  • Experience working in Linux-based server environments.
  • Ability to work independently and deliver results quickly in a contract setting.
Preferred Qualifications
  • Experience with cloud-hosted PostgreSQL (AWS RDS/Aurora, GCP Cloud SQL, etc.).
  • Knowledge of connection pool architectures in distributed systems.
  • Familiarity with automation tools (Ansible, Terraform) or scripting languages (Python, Bash).
  • Experience supporting high-traffic, low-latency systems.
Benefits

If Interested please send your updated resume include your rate/Salary requirement along with your contact details with a suitable time when we can reach you. If you know of anyone in your sphere of contacts, who would be a perfect match for this job then, we would appreciate if you can forward this posting to them with a copy to us.

We look forward to hearing from you at the earliest.



  • Bengaluru, India Infosys Full time

    Job Description Candidate should have an experience of 5 years in DB2 database administration with in-depth knowledge of DB2 database architecture and should have worked on latest versions of db2 databases like 10.5,11.1,11.5 etc. Troubleshoot database issues using tools such as db2diag, db2pd, db2dart, and db2support. - Monitor databases using snapshots and...


  • Pune, India NiCE Full time

    Job Description At NiCE, we don't limit our challenges. We challenge our limits. Always. We're ambitious. We're game changers. And we play to win. We set the highest standards and execute beyond them. And if you're like us, we can offer you the ultimate career opportunity that will light a fire within you. So, what's the role all about As Specialist Cloud...

  • Database Developer

    3 weeks ago


    Mumbai, India SID Global Solutions Full time

    Job Description Job Title : PostgreSQL Developer Job Location : Mumbai Job Typer : Permanent Experience : 4-6 Years Someone who can join within 15-20 Days. Mandatory: Postgres DB / Timeseries DB(QuestDB). Strong knowledge in Indexing, Portioning, Performance Optimization etc. We are seeking a skilled PostgreSQL DBA with deep expertise in PostgreSQL to...


  • Mumbai, India Go Digital Technology Consulting LLP Full time

    Job Description We are seeking a skilled PostgreSQL Database Administrator (DBA) with 36 years of experience to manage, maintain, and optimize our database systems. The ideal candidate will have hands-on expertise in PostgreSQL administration, database performance tuning, and backup strategies, along with working knowledge of AWS database services (such as...


  • Pune, India Xpressbees (BusyBees Logistics Solutions Pvt. Ltd.) Full time

    Job Description About the Role: We are looking for a qualified Database developer cum administrator to design stable and reliable databases as per our company's need. You will be responsible for developing, testing, improving, and maintaining new and existing databases to help retrieve data effectively. As part of our team, you will work closely with...


  • Bengaluru, India ClickHouse Full time

    Job Description About ClickHouse Recognized on the 2025 Forbes Cloud 100 list, ClickHouse is one of the most innovative and fast-growing private cloud companies. With over 2,000 customers and ARR that has more than quadrupled over the past year, ClickHouse leads the market in real-time analytics, data warehousing, observability, and AI workloads....


  • India Ciklum Full time

    Description **Ciklum** is looking for a **Database Administrator** to join our team full-time in **India**. We are a custom product engineering company that supports both multinational organizations and scaling startups to solve their most complex business challenges. With a global team of over 4,000 highly skilled developers, consultants, analysts and...


  • Hyderabad, India Infor Full time

    Job Description We are looking for a SQL Server Database Administrator with strong performance tuning and TSQL skills to help manage a large enterprise fleet in the cloud. The successful candidate will have deep database knowledge, Performance Tuning skillset, very strong problem-solving skills, and project management skills. Experience with other database...


  • Chandigarh, , India YD Talent Solutions Full time ₹ 12,00,000 - ₹ 24,00,000 per year

    Senior Safety Database Specialist - Chandigarh, India Company Overview Our Client is a contract research organization offering Pharmacovigilance, Regulatory, Evidence Evaluation and Technology Solutions, which are phase dependent. These verticals cover planning, launch and lifecycle management of Pharmaceutical, Consumer products and Medical devices. We are...


  • Pune, India Deloitte Full time

    Job Description Summary Position Summary Artificial Intelligence & Engineering AI & Engineering leverages cutting-edge engineering capabilities to help build, deploy, and operate integrated/verticalized sector solutions in software, data, AI, network, and hybrid cloud infrastructure. These insights are powered by engineering for business advantage, helping...