Quick summary
🌎 This is a full-time, remote position.
🇪🇺 Looking for people in Europe or LATAM.
🇬🇧 Professional English is a must. All company and client communication is in English. Spanish is a strong bonus, as the project is for the Latin American market.
📊 Data Focus: You will architect the Multi-Tenant storage engine for a global HR & Payroll SaaS using Amazon Aurora PostgreSQL and Amazon QLDB.
😎 5+ years of experience in Database Engineering, with mastery of SaaS Architecture (Multi-Tenancy), PostgreSQL Internals, and Oracle-to-Postgres Migration.
💎 We are looking for the Keeper of the Ledger. You ensure that thousands of employees across multiple clients in the future are paid accurately. You design schemas that are scalable, compliant, and strictly isolated.
💸 Salary: Gross (B2B) 4000€ ~ 6000€ / month.
About us
BB Agency is a partner for digital evolution, blending creativity and technology to drive meaningful growth. We collaborate with companies focused on real human needs, shaping brands, experiences, and products that impact millions daily. Founded in 2012 on Island Krk, Croatia, we've grown into a fully remote agency with a global team of 40+ members. We believe in learning by doing, open communication, and pushing boundaries to deliver our best work. Our clients range from tech SMEs to corporations and funded startups in SaaS, finance, healthcare, and more. We’ve partnered with names like AWS, Deloitte, BNP Paribas, Intercorp, ShipBob, Crisp, and CloudZero, among many others.
Job description
We are seeking an uncompromising Senior Database Engineer to join the core engineering team. We are building a next-generation HR & Payroll Engine and replacing a massive legacy ecosystem (Oracle HCM / Ofiplan) with a modern, cloud-native Multi-Tenant Architecture. Data Integrity and Isolation are our products. Your job is to ensure that millions of financial transactions are stored with zero loss and retrieved with sub-second latency. You must solve the "SaaS Challenge": How to serve multiple enterprise clients from a single database cluster without ever leaking data between them. You will own the database architecture, transitioning us from "Stored Procedures in Oracle" to "Clean Microservices on Aurora." You will perform complex data modeling, tune heavy SQL queries for tax calculations, and manage the Immutable Audit Log using Amazon QLDB.
Your Responsibilities
- PostgreSQL Architecture: You own the schema design. You define Partitioning strategies for historical payroll data, manage Indexes, and tune Autovacuum settings on Amazon Aurora PostgreSQL (Serverless v2).
- Multi-Tenant SaaS Architecture: You design the isolation strategy. You decide between Schema-per-Tenant vs. Pool Model and implement PostgreSQL Row-Level Security (RLS) policies to ensure strict data isolation at the engine level.
- PostgreSQL Performance: You define Partitioning strategies (by Tenant and by Time) to ensure that one large client does not degrade performance for others.
- The Migration (Oracle to Postgres): You are the bridge. You will analyze legacy Oracle PL/SQL procedures (often with Spanish naming conventions) and help map that logic into our modern SaaS data structure. You will write the ETL scripts to move data from the old world to the new one.
- Immutable Ledger (QLDB): You will architect the "Audit Trail" using Amazon QLDB. Every change to an employee's salary must be cryptographically verifiable. You ensure our ledger is tamper-proof.
- Performance Tuning: You work with Backend Developers to analyze EXPLAIN plans. You spot N+1 query problems, missing indexes, and lock contention issues before they hit production.
- Database-as-Code: We do not manually create tables. You will manage schema changes using version control tools integrated into our CI/CD pipeline.
- Data Security & PII: Implement "Banking-Grade" protection. You enforce Column-Level Encryption for sensitive data (Tax IDs, Salaries) and ensure strict Role-Based Access Control (RBAC).
- Disaster Recovery: You design the backup strategy. You ensure we can survive a Region Failure with Cross-Region Replication and that our Point-in-Time Recovery (PITR) actually works.
Preferred experience
- 5+ years of Database Engineering: You have run high-traffic relational databases in production.
- SaaS Mastery: You have built Multi-Tenant systems. You understand the risks of "Noisy Neighbors" and Data Leaks in a shared database environment.
- PostgreSQL Internals: You know more than just SELECT *. You understand MVCC, how the Query Planner works, and how to debug a spiked CPU on RDS.
- Oracle Knowledge: You can read and understand PL/SQL. You aren't afraid of legacy schemas and know the differences between Oracle and Postgres data types.
- Financial Data Accuracy: Experience working with Fintech/Banking systems. You understand why we use DECIMAL types instead of FLOAT, and you are paranoid about rounding errors.
- Ledger DB: Experience with Amazon QLDB (Quantum Ledger Database)
- Infrastructure Awareness: You are comfortable reading AWS CDK (TypeScript/Java) to check how your database infrastructure is provisioned.
What to expect
- Flexibility - We already operate in multiple time zones and have been doing it for years. We have standard 40-hour work weeks. While our agency working hours are from 9 am to 7 pm CET, you’ll have the freedom to work flexible hours and maintain a healthy work-life balance. Just make sure the majority of your working hours fall within that time frame.
- Remote work - We like to think about ourselves as remote-natives. One of the perks of our remote team is that we genuinely trust you to get your job done. You can work from anywhere you see fit, as long as you have a decent internet connection and are available during our agency's working hours. We use HubStaff for time tracking and transparency into your work.
- Culture - We value collaboration, openness, a willingness to learn, lead, and a curious nature. Our approach encourages mistakes as long as we are willing to learn from them, fostering a culture where growth comes from understanding and overcoming challenges. If you like to work in teams that value great work over loud voices, you are in the right place.
- Autonomy and responsibility – You’ll be trusted to get things done efficiently and effectively.
Hiring process
- Pre-selection based on your application (Focus on PostgreSQL optimization and Migration experience).
- Introductory call with HR to get to know you better.
- Psychological evaluation.
- Leadership Interview: A deep dive into your past experiences and capabilities.
- Welcome to BB Agency.
CompensationGross (B2B) 4000€ ~ 6000€ / month
