CrawlJobs Logo
Bharath Cloud Logo Bharath Cloud · IT - Software Development

PostgreSQL Developer – L2

· Job Posted March 21, 2026
Apply Position
Job Link Share

Job Description

We are seeking a skilled and experienced PostgreSQL Developer (Level 2) with 4–5 years of hands-on experience in database development and optimization. The ideal candidate will be responsible for developing, maintaining, and improving PostgreSQL-based database solutions, supporting high-performance applications, and assisting with architecture and automation initiatives.

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

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

Nice to have

  • Scripting experience (Bash, Python, or Shell) for automation tasks
  • Familiarity with cloud-native PostgreSQL (AWS RDS, Aurora, GCP Cloud SQL, Azure PostgreSQL)
  • Exposure to Kubernetes-managed database environments
  • Experience working in Agile environments and participating in Scrum ceremonies
  • PostgreSQL certifications (optional but a plus)
Bharath Cloud - All Job Offers

Looking for more opportunities?

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

Suggested Tags: Frontend Developer Secretary Talent Manager Salesforce Administrator Data Analyst
Similar Jobs for

PostgreSQL Developer – L2

8 matching positions

Full Stack Developer – L2

We are seeking a skilled Full Stack Developer (L2) with 5+ years of professional...
Location
Location
Salary
Salary:
Not provided
bharathcloud.com Logo
Bharath Cloud
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • 5+ years of professional experience in Java-based backend development and modern frontend technologies including React.js, Vue.js, and TypeScript
  • Bachelor’s or Master’s degree in Computer Science, IT, or equivalent
  • Java
  • JavaScript (ES6+)
  • TypeScript
  • HTML5, CSS3
  • PHP (added advantage)
  • React.js
  • Vue.js
  • Angular
Job Responsibility
Job Responsibility
  • Develop scalable APIs using Java 8+, Spring Boot, and Spring Data JPA
  • Write service layers, business logic, and data access layers using Hibernate
  • Implement robust input validation, exception handling, and secure data processing
  • Integrate third-party APIs and work on pagination, filtering, and sorting
  • Build responsive and interactive user interfaces using React.js (Hooks, Context API), Vue.js (Vue 2 or 3, Vuex, Vue Router), Angular (v9+ with services and RxJS)
  • Develop applications using TypeScript, JavaScript (ES6+), HTML5, and CSS3
  • Manage component state, data bindings, form validations, and routing
  • Ensure cross-browser compatibility and optimize frontend performance
  • Use MySQL or PostgreSQL to write efficient SQL queries and stored procedures
  • Design and maintain relational schemas
Read More
Arrow Right

Technical Operations & AI Automation Engineer

Peakflo is a rapidly growing Agentic AI company. We are revolutionizing the way ...
Location
Location
Thailand , Bangkok
Salary
Salary:
Not provided
helpcare.ai Logo
Helpcare AI
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • 2+ years of hands-on experience in technical operations, backend engineering, or DevOps
  • Real fluency with PostgreSQL and/or MongoDB: you can read an explain plan and know what to do with it
  • Experience debugging payment flows, reconciliation failures, or financial data pipelines
  • Strong Python and bash scripting — you automate as a reflex, not an afterthought
  • Comfortable owning ambiguous, high-pressure incidents with limited documentation
  • Experience with Southeast Asian payment providers (GrabPay, PayNow, PromptPay, Xendit, etc.)
  • Practical use of AI coding agents (Claude Code, Cursor, Copilot) in day-to-day engineering work
  • LLMOps exposure: deploying, monitoring, or routing LLM APIs in production
  • Background in fintech, B2B SaaS, or finance operations tooling
  • Familiarity with NetSuite, Xero, or other ERP integrations
Job Responsibility
Job Responsibility
  • L2 Investigation & Incident Response: Own escalated production issues, database anomalies, failed transactions, data corruption, ghost records
  • Deep-dive PostgreSQL/MongoDB query analysis: explain plans, slow query logs, lock contention, index misuse
  • Triage and resolve payment failures across Southeast Asian rails, PSP integrations, and reconciliation gaps
  • Lead complex data migrations: schema changes, multi-tenant data moves, backfills with zero data loss
  • Write post-mortems and build runbooks
  • AI-Powered Automation: Build internal AI agents and tools that automate repetitive investigation and support workflows
  • Deploy LLM-powered diagnostics: log summarization, anomaly detection, automated root cause drafts
  • Instrument production systems with observability tooling
  • Identify any task done manually more than twice and automate it
  • Platform & Developer Tooling: Build and maintain CLI tools, internal dashboards, and scripts
What we offer
What we offer
  • Competitive compensation package
  • Comprehensive health and wellness benefits
  • Direct access to leadership — you'll work closely with the CTO from day one
  • Collaborative and innovative work environment
  • Flexible work hours and remote work options
  • A platform with real engineering depth — payments, AI agents, ERP integrations, multi-tenant SaaS
  • The opportunity to automate an entire operations function from the ground up
  • Fulltime
Read More
Arrow Right

Application Support Engineer (L3)

Be the voice of the customer in a fast-paced SaaS team. Help solve complex issue...
Location
Location
United States; Canada
Salary
Salary:
Not provided
phorest.com Logo
Phorest
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Application support experience for high traffic web / cloud based systems, or experience in other technical roles like QA or software engineering
  • Experience with relational databases (MySQL, PostgreSQL, etc.)
  • Experience working with APIs (REST/JSON, GraphQL)
  • Ability to read and analyse application and/or database logs
  • Demonstrated ability to exercise judgement to determine appropriate solutions to complex customer technical issues
  • Ability to effectively collaborate with folks across multiple disciplines to ensure that key business needs are addressed
  • Ability to adapt quickly to changing priorities and customer needs
  • Growth mindset - willingness to hone and develop your skills
  • Basic understanding of fundamentals of programming
Job Responsibility
Job Responsibility
  • Delivering a high standard of technical customer service and building strong customer relationships
  • Production issue troubleshooting, resolution, and root cause analysis
  • Be part of a team of software engineers, attending stand-ups, and planning sessions
  • Investigation of reported issues in the system to make sure we are responding to clients needs in a timely manner
  • Escalation of appropriate issues to the Product and Development teams
  • Creating and maintaining concise and clear knowledge articles
  • Mentoring for Level 2 (L2) engineers to help them progress in their career
What we offer
What we offer
  • Fully employer-paid benefits including Medical, Dental, Life, AD&D, Short Term Disability, an EAP, and wellness perks
  • Optional extras, such as a 401(k) and a range of upgraded insurance options
  • Career development: in-house Learning and Development/Business coach and online resources including LinkedIn learning
  • Regular social events
  • Employee Resource Groups
  • Fulltime
Read More
Arrow Right

Arc Support Engineer - L3 (Software)

ARC Support Engineer - L3 (Software). This role has been designed as ''Onsite' w...
Location
Location
India , Bengaluru
Salary
Salary:
Not provided
https://www.hpe.com/ Logo
Hewlett Packard Enterprise
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Minimum of 10 years experience with one or more of the following Juniper/Aruba products: IAPs/Controllers, Airwave, ClearPass, Edgeconnect, Central, Aruba switches, Juniper Contrail, CSO, Junospace, Juniper Northstar or also non-Aruba security products like Cisco ISE is an added advantage
  • Knowledge of authentication protocols and servers required (802.1x, RADIUS)
  • Complete understanding of authentication methods (EAP-PEAP, EAP-TLS, EAP-MSCHAPv2)
  • Installation and configuring of Linux systems, shell scripting
  • Understanding of Docker containers is preferred
  • Good understanding of Database concepts (RDBMS), SQL, PostgreSQL
  • Knowledge on Certificates (X.509), SSL symmetric and asymmetric encryption
  • Skilled in network design and implementation (knowledge and hands on preferred)
  • Working knowledge of AD-domains, Forests, 2-way transitive trust
  • Bachelor's degree in computer engineering or electrical engineering is preferred
Job Responsibility
Job Responsibility
  • Provide pre and post sales Design and consulting services to Aruba-HPE teams, customers and partners for various technologies and solutions
  • Provide Complete services lifecycle for the customers including Plan, Design, Implementation, Migration and Optimization
  • Plan: Creating customer requirement document and business outcome plan
  • Design: Creating high level and low-level design documents based on customer requirements
  • Implementation: Preparing the installation plan includes Network implementation plan and Network ready for use plan
  • Migration: Preparing migration including Method of Procedure and migration validation checks
  • Optimization: Working on continuous improvement of network operations, uptime and security conformance
  • Ability to multitask and work independently when required, with little supervision or direction
  • Excellent oral and written communication skills, presentation and interpersonal skills, and the ability to interface to senior levels of the customer organization
  • Formulate action plans (technical and operational) for analysing and resolving reported issues
What we offer
What we offer
  • Health & Wellbeing
  • Personal & Professional Development
  • Unconditional Inclusion
  • Fulltime
Read More
Arrow Right
New

Backend Architect - Ontology + Python + AI/ML - Afternoon

We are seeking a Backend Architect to lead the design and evolution of a next-ge...
Location
Location
Pakistan , Islamabad
Salary
Salary:
Not provided
10pearls.com Logo
10Pearls
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • 5–8 years building production backend systems in Python (FastAPI, SQLAlchemy, AsyncIO) or equivalent
  • Deep hands-on PostgreSQL: schema design, query optimisation, RLS, pgvector, migrations
  • Strong API design skills — GraphQL (Strawberry, Apollo, Hasura) or REST at scale
  • Experience with event-driven architectures using Kafka or equivalent (topic design, exactly-once semantics, consumer groups)
  • Proven experience owning architecture for a multi-tenant SaaS or platform product
  • Strong grasp of distributed-system fundamentals: consistency, idempotency, observability, failure modes
  • Kubernetes-native development: containers, health probes, config-as-code, secret management
  • Excellent written communication — ADRs, design docs, API specs
Job Responsibility
Job Responsibility
  • Ontology backend architecture — design the multi-tenant PostgreSQL schema (object_types, link_types, object_properties, tool_catalog, action_proposals, audit_events) including Row-Level Security and indexing strategy
  • GraphQL API surface — architect the Strawberry-GraphQL API for reads, mutations and subscriptions, and define resolver patterns for tenant isolation and authorisation
  • Action Registry & governance — own the propose → simulate → approve → execute state machine, blast-radius classification, dual-approval workflow, and SHA-256 binding hash for approval proofs
  • Cross-layer contracts — define the contracts between L2 (data plane), L3 (ontology), L4 (agent runtime) and L5 (governance) — Kafka topic schemas, MCP Truth API, event formats
  • Code ownership — write the reference implementation for at least one core module per quarter
  • review backend PRs
  • set coding, testing and observability standards
  • Mentorship — technically lead a squad of 3–5 backend engineers, pair-program with juniors, run design reviews and architecture decision record (ADR) sessions
  • Performance & reliability — set and defend SLOs for L3 services, drive load-testing and capacity planning
Read More
Arrow Right

Database Engineer

Our client is an innovative company that has been dynamically contributing to th...
Location
Location
Poland , Warszawa
Salary
Salary:
18000.00 - 22000.00 PLN / Month
teamquest.pl Logo
TeamQuest Sp. z o. o.
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • At least several years of experience working with SQL, PL/SQL, or PostgreSQL
  • Working with structures containing billions of records and terabytes of data, understanding how to ensure their efficient processing
  • Optimizing queries and long-running processes, even those lasting many hours
  • Ability to analyze query execution plans and quickly identify bottlenecks
  • Familiarity with working with stored procedures and the ability to use them effectively
  • Good knowledge of Python
  • Ability to handle L2-level performance problem solving
  • Ability to analyze data and problems from various sources
  • Ability to analyze system logs and use extensions such as pg_stat_statements to identify blocking processes and bottlenecks
  • Knowledge of data partitioning (especially by date) to optimize searches in terabyte-sized tables
Job Responsibility
Job Responsibility
  • Working on projects based on PostgreSQL, data warehouses, and systems processing very large volumes of information
  • Co-developing a key banking application responsible for revenue management and stock reconciliation, working in a unique multi-cloud environment (AWS and GCP)
  • Developing competencies in DWH, data integration, and database solutions
  • Working on advanced PostgreSQL engine management, including MVCC mechanisms (Xmin/Xmax), Vacuum processes, and the selection of custom indexes such as BRIN
What we offer
What we offer
  • Attractive salary
  • Clear plan and support for professional development
  • Technological and development challenges, including in the areas of data and data analysis
  • Benefits package: medical care, insurance, sports card
  • Unrivaled working atmosphere
Read More
Arrow Right

Senior Java Support Engineer

Wissen Technology is Hiring for Senior Java Support Engineer. We are seeking an ...
Location
Location
India , Mumbai
Salary
Salary:
Not provided
votredircom.fr Logo
Wissen
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • 8+ years of experience in Java development or production support roles
  • Strong knowledge of Java, Spring / Spring Boot, and RESTful APIs
  • Experience troubleshooting issues in distributed or microservices-based applications
  • Strong experience with log analysis and debugging production issues
  • Experience working with relational databases (SQL, PostgreSQL, MySQL, Oracle)
  • Familiarity with Linux/Unix environments and command-line troubleshooting
  • Understanding of application monitoring tools and log aggregation platforms
  • Experience with Git and CI/CD pipelines
Job Responsibility
Job Responsibility
  • Provide Level 3 production support for enterprise applications built using Java-based technologies
  • Investigate and resolve complex production issues escalated from L1 and L2 support teams
  • Perform detailed root cause analysis (RCA) and implement permanent fixes where applicable
  • Work closely with the client’s onsite team in Canada to troubleshoot incidents and coordinate resolutions
  • Monitor application logs, performance metrics, and system health to proactively detect issues
  • Debug issues related to application code, APIs, database queries, and integrations
  • Support application deployments, configuration updates, and production releases
  • Identify opportunities for automation and operational improvements to reduce recurring incidents
  • Maintain support documentation, knowledge base articles, and runbooks
  • Participate in incident management, change management, and problem management processes
  • Fulltime
Read More
Arrow Right

Technical Support L1 & L2 Engineer

We are on the quest to find a new team member who will take over some of key res...
Location
Location
Salary
Salary:
Not provided
loriot.io Logo
Loriot
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Holder of at least a bachelor's degree in Computer Science or related field, or have an equivalent, demonstrable, relevant work experience
  • Solid bases on network protocols (OSI model, RSA, VPN configuration)
  • Linux deep knowledge (console, troubleshooting)
  • Experience managing databases as (MongoDB, Redis, Postgresql, Elasticsearch)
  • Script development languages (Python, Bash)
  • Cloud architecture mindset
  • Customer success oriented
  • Systematic and analytical thinking
  • Fluent in English
  • 3 to 4 years of experience in a similar role
Job Responsibility
Job Responsibility
  • Respond to customer inquiries and technical issues in a timely and professional manner
  • Provide technical guidance and support to customers using our LPWAN platform
  • Identify, diagnose, and troubleshoot technical issues related to our platform
  • Prioritize and manage several open issues at one time
  • Ability to provide step-by-step technical help, both written and verbal
  • Work collaboratively with cross-functional teams to resolve complex technical issues
  • Ensure customer satisfaction by following up with customers to confirm the successful resolution of technical issues
  • Support the creation of technical documentation and user manuals
  • Participate in product testing and validation activities
  • Stay up-to-date with industry trends and emerging technologies related to LPWAN and IoT
What we offer
What we offer
  • Flexible compensation matching your experience, perks and benefits
  • Flat hierarchy and appreciation of individual work
  • Trust, autonomy, and space for personal initiatives
  • Visibility of your work world-wide
  • Partially remote work
  • Working with motivated, passionate people and an international environment
  • Working with exciting, state-of-the-art technology for the Internet of Things
  • Udemy unlimited access
Read More
Arrow Right