Original listing text, shown exactly as published by the company.
The Role
As a Database Administrator (DBA) at Air Apps, you will be responsible for managing, optimizing, and securing large-scale, complex databases. You will work with engineering teams to design, implement, and maintain high-performance, scalable, and resilient database systems that power our AI-driven platform.
Your role will involve database tuning, backup and recovery strategies, monitoring, and ensuring data integrity while working with structured and unstructured data sources.
- This is a fully onsite position, based at our office in Lisbon, where you will collaborate closely with cross-functional teams in person and contribute to a dynamic and fast-paced environment. We are open to support with relocation efforts.
Responsibilities
- Design, implement, and maintain high-performance database systems to support large-scale applications.
- Optimize database queries, indexing strategies, and partitioning to enhance performance.
- Monitor database health, ensuring high availability, scalability, and disaster recovery.
- Manage and fine-tune SQL and NoSQL databases (e.g., PostgreSQL, MySQL, MongoDB, Redis, DynamoDB).
- Implement database security policies, encryption, and access control to protect sensitive data.
- Automate database backups, replication, and failover mechanisms.
- Work closely with developers to optimize queries, schema design, and data modeling.
- Perform capacity planning and monitor database growth trends.
- Ensure compliance with data governance, GDPR, and other regulatory requirements.
- Stay updated with the latest database technologies, trends, and best practices.
Requirements
- Around 4+ years of experience as a Database Administrator (DBA) or similar role.
- Expertise in relational databases (PostgreSQL, MySQL, SQL Server) and/or NoSQL databases (MongoDB, Redis, Cassandra, DynamoDB).
- Strong knowledge of database optimization, indexing, partitioning, and replication.
- Experience in performance tuning, query optimization, and troubleshooting slow queries.
- Familiarity with database backup, recovery, failover, and disaster recovery strategies.
- Experience with cloud database services (AWS RDS, Aurora, Google Cloud Spanner, Azure SQL).
- Knowledge of scripting for automation (Python, Bash, SQL scripts).
- Understanding of data security best practices, encryption, and compliance requirements.
- Experience working with large, complex datasets and high-traffic applications.
- Ability to work with DevOps teams to integrate databases into CI/CD workflows.
