Database Specialist With Postgres

5 days ago


India Two95 International Full time

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.



  • Chennai, India Antal International Network Full time

    Job Description Job Description Role: PostgreSQL Database Developer Experience: 5-7 Years Location: Chennai Qualification: BE / BTech / ME / MTech / MCA What You'll Do - Design, implement, and optimize scalable PostgreSQL database schemas. - Build and fine-tune partitioning, indexing, and stored procedures. - Optimize complex SQL queries for performance. -...


  • India CAI Full time

    **Req number**: R5569 **Employment type**: Full time **Worksite flexibility**: Hybrid Who we are CAI is a global technology services firm with over 8,500 associates worldwide and a yearly revenue of $1 billion+. We have over 40 years of excellence in uniting talent and technology to power the possible for our clients, colleagues, and communities. As a...


  • Shimla, Himachal Pradesh, India, Himachal Pradesh People Prime Worldwide Full time

    Job Title: Postgres Database DeveloperEducation Qualification: BE/B. Tech/MCAExperience: 5+ yearsLocation: Shimla, Himachal PradeshJob SummaryWe are looking for a highly skilled PostgreSQL Database Developer to design, develop, optimize, and maintain our database systems. The candidate will work closely with software engineers, data analysts, and DevOps...


  • Shimla, Himachal Pradesh, India, Himachal Pradesh People Prime Worldwide Full time

    Job Title: Postgres Database DeveloperClient : QuantellaExperience: 5+ yearsLocation: Shimla, Himachal PradeshRequired Skills: • 5+ years of hands-on experience with PostgreSQL in a production environment.• Strong SQL skills, including query optimization and performance tuning.• Experience with PostgreSQL internals and explain plans.• Proficiency in...

  • Database Specialist

    1 week ago


    Bengaluru, India L&T Technology Services Full time

    Job Description Database Migration Expert Location: Bangalore Exp: 6-8 Yrs skills: Ora2PG utility handson or knowledge is a must. SQL Server Integration Services (SSIS) handson is a must Expertise and Skills - Database Migration, Data Migration Experience in MS SQL to Postgre migration is a must. Good to have any other DB migration like Oracle to Postgre 6-8...


  • Bengaluru, Karnataka, India, Karnataka SumCircle Technologies Private Limited Full time

    Skill: DBA – MYSQL/PostgresRole: L3Number of engineers: 1Job briefA professional Database Administrator (DBA) will keep the database up and running smoothly 24/7. The goal is to provide a seamless flow of information throughout the company, considering both backend data structure and frontend accessibility for end-users.ResponsibilitiesBuild database...


  • Hyderabad, India HSBC Full time

    Job Description Some Careers Have More Impact Than Others. If you're looking for a career where you can make a real impression, join HSBC and discover how valued you'll be. HSBC is one of the largest banking and financial services organisations in the world, with operations in 64 countries and territories. We aim to be where the growth is, enabling...


  • Navi Mumbai, Maharashtra, India, Maharashtra SumCircle Technologies Private Limited Full time

    Skill: DBA – MYSQL/PostgresRole: L2/L2+Number of engineers: 1Job briefA professional Database Administrator (DBA) will keep the database up and running smoothly 24/7. The goal is to provide a seamless flow of information throughout the company, considering both backend data structure and frontend accessibility for end-users.ResponsibilitiesBuild database...


  • 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....

  • Database Engineer

    2 weeks ago


    Mumbai, Maharashtra, India, Maharashtra Credila Financial Services Limited Full time

    Credila Financial Services Limited (Formerly known as HDFC Credila Financial Services Limited) is one of India’s largest education loan non-banking financial companies (NBFCs) offering education loans to Indian students. With an in-depth understanding of the higher education domain in India as well as overseas, Credila offers tailor-made education loan...