Database Application Architect

About Air Space Intelligence

ASI's mission-critical technology powers decision-making across aviation, defense, energy, and other critical infrastructure domains. Backed by top-tier investors including Andreessen Horowitz, Spark Capital, and Renegade Partners, ASI delivers operational decision superiority—compressing days of analysis into seconds of action. ASI is leading the way and pushing the boundaries of what’s possible.

What you will do:

As a Database Application Architect, you will be the technical leader ensuring that engineering teams use PostgreSQL/AWS Aurora in an optimal, scalable, and safe way as we grow our product footprint across mission-critical environments. This is not a DBA role—your focus is on how applications should use the database, not on administering infrastructure.

You will design application-side database patterns, guide teams on proper schema design and query modeling, and prevent outages by ensuring developers understand how to work effectively with relational systems at scale. You’ll partner closely with backend, platform, and SRE teams to architect robust data-access layers, improve performance across query paths, and introduce best practices around migrations, indexing, and data lifecycle.

You’ll also build internal tooling, documentation, and training that help engineers avoid pitfalls and ship database-backed features with confidence.

What we value

• Mastery of PostgreSQL/ AWS Aurora from an application-development perspective, including query planning, indexing strategies, schema design, performance tuning, and transaction management

• Experience architecting data-access layers and guiding engineering teams on efficient use of relational databases

• Expertise in geospatial data and PostGIS, including optimizing spatial queries, indexing strategies for geospatial workloads, and architecting solutions for large-scale geospatial datasets

• Strong knowledge of ORM behaviors, application-layer caching patterns, and common anti-patterns that impact DB scale or reliability

• Ability to solve and prevent production incidents by analyzing query load, access patterns, and system bottlenecks

• Familiarity with modern backend languages and frameworks (e.g., Python 3, Go, Java, or similar)

• Understanding of cloud environments and managed database services (AWS RDS / Aurora, monitoring, observability)

• Collaborative mindset and ability to work across multiple teams, influencing without authority

• Flexibility to adjust to changing business priorities in a rapidly evolving, mission-critical environment

What we offer

• Flexible Working Hours - With a global team supporting 24/7 mission-critical operations, we have to be at our best, so we’ve adopted flexible hours to allow for balance.

• Premium Healthcare and Health Insurance - Health and wellness are critical to living a happy and resilient life. We provide first-class medical, dental, and vision coverage to you and your dependents.

• Competitive Salary & Equity - Our team is our biggest asset. We value the hard work that each person commits to us, so we provide competitive, transparent compensation packages.

• Relocation Support - Generous relocation package to ensure a smooth transition to the Tricity area.

• High-Energy Environment - We live by the mantra that now is better than never. You will find yourself surrounded by peers who constantly challenge the status quo.

• Flexible Time Off - We encourage you to take time off as you need it. While our team is hard-working, our success is measured by output—not time spent.

• Office, Equipment & Tools - We bring the best tools to the mission—from ergonomic desk setups to modern productivity software. We have a freshly prepared team breakfast and lunch every day.

How we hire:

We see the interview process not as a screening test but as an opportunity to simulate what working together will look like.

We tailor the interview process around you and the strengths you bring.