Overview
Database Administrator (DBA) role at Air Apps. Air Apps is a family-founded company building an AI-powered Personal & Entrepreneurial Resource Planner (PRP) with offices in Lisbon and San Francisco.
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.
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.
Qualifications
- 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.
Benefits
- Apple hardware ecosystem for work.
- Annual Bonus.
- Medical Insurance (including vision & dental).
- Disability insurance - short and long-term.
- 401k up to 4% contribution.
- Air Stipend of $3,120/year, paid over 12 monthly installments (for home office, learning, wellness, etc.).
- Air Conference – an opportunity to meet the team, collaborate, and grow together.
Diversity & Inclusion
Air Apps is committed to fostering a diverse, inclusive, and equitable workplace. We welcome applicants from all backgrounds and perspectives. Diverse voices and experiences make us stronger.
Application Disclaimer
Air Apps values transparency and integrity in our hiring process. Applicants must submit their own work without any AI-generated assistance. Any use of AI in application materials, assessments, or interviews will result in disqualification.
#J-18808-Ljbffr