CrawlJobs Logo

PostgreSQL Developer

India, Jaipur · Job Posted May 15, 2026
Apply Position
Job Link Share

Job Description

As a PostgreSQL Developer, you will be the backbone of our data layer. You will design, develop, and optimize complex database systems that support high-traffic applications. Your goal is to ensure data integrity, security, and peak performance across all our PostgreSQL environments.

Job Responsibility

  • Design and implement robust database schemas, tables, and dictionary structures
  • Write and maintain high-performance PL/pgSQL, including complex stored procedures, triggers, and views
  • Analyze query execution plans using EXPLAIN ANALYZE and implement optimizations such as indexing (B-tree, GIN, GiST) and partitioning
  • Ensure the consistency and reliability of data through proper normalization and constraint management
  • Monitor database performance, perform regular vacuuming, and manage bloating issues
  • Work closely with Backend Engineers and PMO to translate business requirements into efficient data models
  • Manage data migration, transformation, and scripting using Git for version control

Requirements

  • B.Tech or M.Tech in Computer Science, IT, or a related Engineering discipline
  • 3 to 5 years of dedicated experience in PostgreSQL development and administration
  • Expert-level knowledge of SQL, including window functions, CTEs, and complex joins
  • Strong experience in tuning slow queries and understanding PostgreSQL internals (WAL, Buffer Cache)
  • Proficiency with pgAdmin, DBeaver, and command-line psql
  • Knowledge of Role-Based Access Control (RBAC) and data encryption practices
  • Immediate Availability: Candidates who can join immediately or within 15 days
  • Analytical Mindset: Ability to troubleshoot complex data issues and provide scalable solutions
  • Strong verbal and written communication skills for internal team coordination

Nice to have

Experience with cloud databases (AWS RDS/Aurora) or NoSQL features within PostgreSQL (JSONB)

What we offer

  • Engage with cutting-edge technologies and diverse project domains
  • A transparent work culture focused on objective performance and growth
  • Competitive compensation package and employee-centric benefits

Looking for more opportunities?

Search for other job offers that match your skills and interests.

Similar Jobs for

PostgreSQL Developer

8 matching positions

PostgreSQL Developer – L2

We are seeking a skilled and experienced PostgreSQL Developer (Level 2) with 4–5...
Location
Location
Salary
Salary:
Not provided
bharathcloud.com Logo
Bharath Cloud
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Strong expertise in PostgreSQL SQL and PL/pgSQL programming
  • In-depth understanding of PostgreSQL internals: query planner, indexing, vacuum/analyze, and WAL
  • Experience with partitioning, parallel queries, table inheritance, and advanced types (JSONB, ARRAY)
  • Proficient with performance tuning, database normalization/denormalization, and query optimization
  • Experience with replication mechanisms: streaming replication, logical replication, or BDR
  • Good knowledge of PostgreSQL backup and recovery strategies using pg_basebackup, pgBackRest, or Barman
  • Experience with monitoring tools like pg_stat_activity, pgBadger, Prometheus + Grafana, or Zabbix
  • Bachelor’s degree in Computer Science, Information Technology, or related discipline
Job Responsibility
Job Responsibility
  • Design, develop, and optimize complex SQL queries, stored procedures, triggers, and PL/pgSQL functions
  • Collaborate with architects and application developers to define efficient schema designs and data models
  • Perform advanced performance tuning using EXPLAIN, ANALYZE, pg_stat_statements, and indexing strategies
  • Implement and maintain ETL processes for structured and semi-structured data
  • Manage large-scale data migrations and version-controlled schema deployments
  • Conduct capacity planning and monitoring to maintain database health and scalability
  • Implement and manage backup/restore policies, disaster recovery testing, and high availability configurations
  • Work with DevOps teams to integrate database changes into CI/CD pipelines
  • Mentor junior developers and participate in peer code reviews
  • Fulltime
Read More
Arrow Right

Senior PostgreSQL and Java Developer

Our client: Montrose Software has an ongoing relationship with one of the larges...
Location
Location
Poland
Salary
Salary:
16000.00 - 24000.00 PLN / Month
https://www.montrosesoftware.com/ Logo
Montrose Software
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Strong technical developer with 7+ years hands on experience
  • 5+ years of experience in Database technologies, including 2+ years with PostgreSQL
  • 3+ years of experience in Java 17+ with Spring, Spring-Boot, unit-tests
  • 5+ years of experience with version control systems like GitHub
  • 3+ years of experience with CD/CI pipeline tools like Jenkins, Maven, Ansible, GitHub Actions, etc
Job Responsibility
Job Responsibility
  • PostgreSQL database configuration, optimization and schema designing
  • Writing well tested java code
  • Configuring and working with database cluster and others like docker, kubernetes
What we offer
What we offer
  • High-quality equipment
  • Flexible working hours
  • Remote work possibility
  • International project teams
  • English lessons
  • Training budget
  • Clear career path
  • Private medical insurance
  • Multisport card
  • Lunch budget
  • Fulltime
Read More
Arrow Right
New

Staff-Level Full-Stack Engineer

Staff-Level Full-Stack Engineer – Remote with travel to Mclean, VA a few days/mo...
Location
Location
United States , McLean
Salary
Salary:
Not provided
weareorbis.com Logo
Orbis Consultants
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • TypeScript
  • React
  • Next.js
  • modern frontend architecture
  • Python
  • FastAPI
  • Flask
  • PostgreSQL
  • MySQL
  • SQLAlchemy
Job Responsibility
Job Responsibility
  • full-stack product engineering
  • feature ownership
  • customer-driven development
  • frontend plus backend implementation
  • ambiguous start-up environment
  • take a feature from customer request through to production deployment
What we offer
What we offer
  • equity
  • Fulltime
Read More
Arrow Right
New

Senior Credit Systematic Trading Developer

We're partnering with a global financial institution that is expanding its front...
Location
Location
United Kingdom , London
Salary
Salary:
Not provided
weareorbis.com Logo
Orbis Consultants
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Strong commercial experience with Java and Python
  • A background building electronic or systematic trading platforms
  • Experience with distributed systems, concurrent programming and event-driven architectures
  • Knowledge of FIX protocol and electronic market connectivity
  • Experience with technologies such as Kafka, KDB+, PostgreSQL, Docker and Kubernetes is highly desirable
Job Responsibility
Job Responsibility
  • Designing and developing high-performance trading systems for global credit markets
  • Building pricing, risk and P&L services used by front-office trading teams
  • Developing FIX connectivity to electronic trading venues
  • Creating real-time market data and analytics applications
  • Working closely with traders and quants to deliver new features from concept through to production
  • Driving engineering best practices across performance, scalability and reliability
What we offer
What we offer
  • Competitive compensation
  • Long-term career progression within a global organisation
  • Fulltime
Read More
Arrow Right
New

Director Of Engineering

I’m working with a global investment bank that is investing heavily in its Front...
Location
Location
United Kingdom , London
Salary
Salary:
200000.00 GBP / Year
weareorbis.com Logo
Orbis Consultants
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • 7+ years’ experience building electronic or systematic trading platforms
  • Strong Java and Python development skills
  • Experience building low-latency, distributed systems
  • FIX protocol experience
  • Experience developing Front Office trading applications
  • Credit trading experience would be advantageous, although candidates from other electronic trading environments are encouraged to apply
Job Responsibility
Job Responsibility
  • Designing and building low-latency electronic trading systems
  • Developing pricing, quoting, risk and PnL services
  • Building FIX connectivity with leading electronic trading venues
  • Developing high-throughput distributed systems and real-time dashboards
  • Productionising quantitative research and deploying trading models
  • Working closely with Front Office traders to deliver new functionality
What we offer
What we offer
  • Bonus
  • Fulltime
Read More
Arrow Right
New

Software Engineer

Salt is currently hiring a Software Engineer for a client of ours in Amsterdam. ...
Location
Location
Netherlands , Amsterdam
Salary
Salary:
Not provided
welovesalt.com Logo
Salt
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Bachelor's degree in Computer Science, Engineering, or a related field, or equivalent practical experience
  • Proven experience designing, building, and maintaining microservices-based architectures
  • Strong proficiency in Java with hands-on experience using frameworks such as Spring Boot and Hibernate
  • Experience developing and deploying applications on Amazon Web Services (AWS)
  • Strong experience with relational databases (e.g., MySQL, PostgreSQL) and NoSQL databases (e.g., DynamoDB, Cassandra)
  • Experience with Kubernetes and containerized application deployment
  • Strong understanding of software engineering best practices, including automated testing, CI/CD, and code quality
  • Excellent analytical and problem-solving skills
  • Strong written and verbal communication skills
  • Ability to work effectively both independently and within cross-functional teams
Job Responsibility
Job Responsibility
  • Design, build, and maintain scalable software applications using modern programming languages, frameworks, and development tools
  • Write clean, readable, reusable, and maintainable code following established engineering standards and best practices
  • Refactor and simplify existing codebases by applying appropriate design patterns and software engineering principles
  • Ensure application quality through comprehensive unit, integration, and automated testing
  • Maintain data security, integrity, and quality by adhering to organizational standards and security practices
  • Own services throughout their lifecycle, including development, deployment, monitoring, and ongoing maintenance
  • Monitor application health, performance, and operational metrics to ensure system reliability
  • Reduce operational risk by implementing best practices, maintaining documentation, and creating operational runbooks
  • Support continuous delivery practices, experimentation, and safe production releases
  • Independently manage deployments and production operations
  • Fulltime
Read More
Arrow Right
New

Senior Analytics Engineer

Bamboo Health is the leader in Real-Time Care Intelligence™ solutions aimed at i...
Location
Location
United States
Salary
Salary:
Not provided
bamboohealth.com Logo
Bamboo Health
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • A Bachelor’s Degree in a quantitative or technical discipline, such as mathematics, economics, computer science, statistics, or a similar quantitative field, is required.
  • 5+ years of professional experience in data analytics.
  • Experience in designing user-friendly analytics solutions with Tableau, Looker, or similar data visualization software.
  • Ability to write SQL for collecting, cleaning, and aggregating data.
  • Solid understanding of database technologies (PostgreSQL, MySQL, DynamoDB) and ability to code for data collection.
  • Understanding data warehousing concepts and experience with platforms such as Amazon Redshift.
  • Solid working knowledge of Tableau, with experience in creating user-facing analytics solutions.
  • Solid understanding of Python, GitHub, and other standard development tools.
  • Comfort using or learning AI-supported tools (e.g., ChatGPT, CoPilot, or role-specific tools) to improve daily workflows.
  • A forward-thinking, curious mindset with an openness to experimenting with new technologies.
Job Responsibility
Job Responsibility
  • Design and manage data pipelines essential for supporting reporting solutions.
  • Develop innovative dashboards and reporting features to improve customer and user satisfaction.
  • Establish yourself as the technical authority on the reporting components of our product suite.
  • Foster collaboration among Agile teams and across functions to promote solution implementation.
  • Use data and advanced analytical methods to provide actionable insights to stakeholders.
  • Support a variety of business-aligned projects to meet organizational objectives.
  • Identify repetitive tasks and partner with team leads to implement scalable automation solutions.
  • Stay curious about emerging AI tools and how they can streamline or enhance work within your function.
What we offer
What we offer
  • health
  • dental
  • vision
  • other benefits
  • Fulltime
Read More
Arrow Right
New

Senior Java Engineer

Intellias is partnering with a Fortune 100, Midwest-based industrial manufacture...
Location
Location
Salary
Salary:
Not provided
Intellias
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • 6+ years of experience designing, developing, deploying, and maintaining backend services and distributed systems in production using Java 21, Spring Boot 3.x, Docker
  • Minimum of 2 years of experience with AWS (core services and cloud-native development)
  • Advanced SQL expertise, including writing, optimizing, and troubleshooting complex queries against large and complex datasets
  • Experience working with data-intensive applications and complex data models, including data analysis, transformation, aggregation, and optimization
  • Hands-on experience with complex query development, performance optimization, data modeling, and analytics workloads
  • Strong ownership and self-management in a fast-paced Agile environment, with the ability to independently deliver end-to-end solutions, resolve blockers, and communicate effectively in English
  • Strong experience with microservices, MVC, and event-driven architectures
  • Strong experience with JPA / Hibernate
  • Strong database design skills with PostgreSQL (advanced SQL) and DynamoDB, including schema design, optimization, and performance tuning
  • Strong experience building and operating event-driven systems (e.g., Kafka, Kinesis)
Job Responsibility
Job Responsibility
  • Design, develop, and maintain scalable Spring Boot-based microservices in a distributed architecture
  • Build and operate event-driven data processing pipelines, including ingestion, transformation, and enrichment of streaming data
  • Work extensively with complex datasets, focusing on data analysis, transformation, validation, and optimization
  • Develop and maintain advanced SQL queries and data workflows to support business and platform requirements
  • Collaborate closely with data engineering, analytics, and business stakeholders to understand and solve complex data challenges
  • Contribute to data warehousing and analytics initiatives, including Snowflake-based solutions where applicable
  • Develop and maintain robust APIs for internal and external consumers
  • Work with AWS cloud services to design and support reliable, scalable backend systems
  • Design, optimize, and maintain PostgreSQL and DynamoDB schemas, ensuring performance and data integrity
  • Implement and maintain automated testing strategies (unit and integration)
Read More
Arrow Right