In short
Senior backend engineer in Lahore who takes ownership of an Airtable-based backend, migrates it to PostgreSQL, and then builds and operates backend services, APIs, and integrations (auth, retries, idempotency) for Novus's products. Core stack: PostgreSQL, server-side backend services, API/webhook integrations, Git, plus automation tools like Zapier and n8n.
About the role
What You’ll Do
Initial Priorities
Take technical ownership of the existing Airtable-based backend, developing a thorough understanding of its scripts, automations, integrations, credentials, dependencies, failure modes, production troubleshooting, and recovery procedures.
Design and implement the PostgreSQL replacement based on approved data models and system requirements, including schemas, tables, data types, keys, constraints, indexes, audit/history structures, and database migrations.
Plan and execute the migration from Airtable to PostgreSQL, covering data transformation, source-to-target validation, reconciliation, cutover planning, and replacement of legacy scripts and automations.
Ongoing Responsibilities
Build, maintain, and extend backend services, APIs, adapters, automations, and integrations as Novus’s products, systems, and operational requirements evolve. Ensure appropriate handling of authentication, retries, idempotency, synchronization, concurrency, and partial failures.
Operate, maintain, and continuously improve the production backend through automated testing, observability, logging, monitoring, deployment controls, rollback procedures, backup and recovery, performance optimization, security, and data integrity.
Maintain comprehensive technical documentation covering system architecture, dependencies, deployment procedures, and recovery processes to ensure knowledge is accessible and not concentrated in a single individual.
Assess and improve inherited systems while ensuring that changes are implemented safely without disrupting ongoing business operations.
Required Experience
PostgreSQL and Relational Database Engineering
Strong hands-on experience designing, developing, migrating, troubleshooting, and operating production PostgreSQL databases.
In-depth understanding of relational schema design, transactions, constraints, indexing, schema migrations, audit/history structures, query optimization, data integrity, database security, and backup/recovery procedures.
Demonstrated experience building, maintaining, and operating production backend systems using at least one modern server-side programming language.
Strong understanding of backend architecture, services, APIs, automated testing, deployment processes, production debugging, and maintainable software design.
APIs and Integration Engineering
Proven experience developing and maintaining reliable integrations across multiple systems using APIs and webhooks.
Strong understanding of authentication, retries, idempotency, synchronization, and failure-handling mechanisms, with the ability to diagnose issues across interconnected systems.
Data Migration and Reconciliation
- Experience migrating critical production data between systems, including data transformation, source-to-target validation, reconciliation, parallel operations, cutover planning, and recovery from failed or partially completed migrations.
Production Ownership and Reliability
Experience operating and maintaining production systems, including observability, logging, monitoring, incident response, root-cause analysis, deployment management, rollback procedures, performance optimization, security, and recovery.
Ability to take end-to-end accountability for the reliability, stability, and operational performance of the backend systems under their ownership.
Legacy-System Takeover
Ability to take ownership of systems developed by other engineers, understand partially documented code and workflows, identify hidden dependencies, and distinguish intended functionality from defects or temporary workarounds.
Demonstrated ability to introduce changes to inherited systems safely while minimizing production risks and operational disruptions.
Technical Judgment
Ability to evaluate technical approaches, identify potential risks at an early stage, communicate implementation trade-offs clearly, and challenge proposed designs when justified by technical considerations.
Ability to provide realistic implementation estimates after evaluating requirements, dependencies, and technical constraints.
Comfortable working with AI-assisted development tools and workflows, including directing AI-generated development, independently reviewing and debugging generated code, validating tests, and ensuring production-level quality.
Ability to remain fully accountable for the reliability, security, and maintainability of AI-assisted implementations.
Strong working knowledge of Git, version control, automated testing, technical documentation, and disciplined production change management.
Nice to Have
Hands-on experience with Airtable.
Familiarity with Zapier and n8n automation platforms.
Experience with Xero or other accounting system integrations.
Familiarity with NocoDB.
Experience working with financial, payment, or transaction-processing systems.
Previous experience migrating Airtable or other low-code platforms to PostgreSQL.