Skip to main content

Senior Backend Engineer (PostgreSQL & Integrations)

Technology
Lahore, Pakistan3 weeks ago
Full time

Job description

Job Description

What You’ll Do

  • Take technical ownership of the existing Airtable-based backend, including scripts, automations, integrations, credentials, dependencies, production troubleshooting, and recovery procedures.
  • Design and implement production PostgreSQL schemas and backend services from approved data models and system requirements, including tables, data types, keys, constraints, indexes, audit/history structures, and migrations.
  • Build and maintain APIs, adapters, and integrations with internal and third-party systems, with appropriate handling for authentication, retries, idempotency, synchronization, concurrency, and partial failures.
  • Plan and execute migration from Airtable to PostgreSQL, including data transformation, source-to-target validation, reconciliation, cutover, and replacement of legacy scripts and automations.
  • Own backend reliability in production through automated testing, observability, logging, monitoring, deployment controls, rollback, backup/recovery, performance management, security, and data-integrity controls.
  • Maintain clear technical documentation so system knowledge, dependencies, deployment steps, and recovery procedures are not concentrated in one person; improve inherited systems without disrupting ongoing operations.
Required Experience

PostgreSQL and Relational Database Engineering: Strong hands-on experience designing, building, migrating, troubleshooting, and operating production PostgreSQL systems. This should include relational schema design, transactions, constraints, indexing, schema migrations, audit/history structures, query performance, data integrity, security, and backup/recovery.

Senior Backend Engineering: Demonstrated experience building and operating production backend systems using at least one modern server-side language. Strong understanding of backend services, APIs, automated testing, deployment, production debugging, and maintainable software design.

APIs and Integration Engineering: Experience building reliable integrations across multiple systems using APIs, webhooks, authentication, retries, idempotency, synchronization, and appropriate failure handling, including the ability to diagnose issues that cross system boundaries.

Data Migration and Reconciliation: Experience moving important production data between systems, including transformation, source-to-target validation, reconciliation, parallel operation or cutover, and recovery from failed or partial migrations.

Production Ownership and Reliability: Experience operating systems after they go live, including observability, logging, monitoring, incident response, root-cause analysis, deployment and rollback, performance, security, and recovery. This role is accountable for the reliability of the backend it operates.

Legacy-System Takeover: Ability to inherit systems built by other people, trace partially documented code and workflows, identify hidden dependencies, distinguish intended behavior from defects or workarounds, and make changes safely in production.

Technical Judgment: Ability to evaluate implementation options, identify risks early, explain trade-offs clearly, challenge a design when there is a genuine technical concern, and provide realistic implementation estimates once requirements and dependencies are understood.

AI-Assisted Engineering: The engineering workflow will incorporate a controlled, self-correcting AI-assisted development process. The engineer must be comfortable directing AI-assisted development, reviewing and debugging generated code, validating automated tests and corrections, and taking full responsibility for production output rather than treating generated code as a black box.

JavaScript and Engineering Practices: Must be able to read, troubleshoot, and safely modify the existing JavaScript-based Airtable scripts during transition. Strong working knowledge of Git, version-controlled development, automated testing, technical documentation, and disciplined production change management is also required.

Nice to Have

Airtable | Zapier | n8n | Xero or accounting integrations | NocoDB | Financial or payment systems | Airtable or low-code platform migrations to PostgreSQL

Keywords
Black boxJavaScriptPostgresqlDebugger

Interested in this role?