Senior Database Engineer

<p><span><b><b>Job Description:</b></b></span></p><p><b><b>Job Summary:</b></b></p><p></p><p><span>Aviation. It connects our world, brings people together, provides opportunities, accelerates economic growth, and is just so very cool!</span></p><p></p><p><span>Come work for NAVBLUE, a leading services company owned by Airbus, dedicated to Flight Operations, Air Traffic Management solutions and services for airlines, airports, and Air Navigation Service Providers (ANSPs). We combine aircraft manufacturer expertise, flight operations know-how, and agile development to enhance operational efficiency, optimize resources, and increase productivity for a safe and sustainable aviation future. Our global teams deliver a reliable, optimum, and customized user experience to more than 500 customers worldwide.</span></p><p></p><p><span>We are looking for a seasoned Software Engineer with extensive experience in designing, implementing, and optimizing database solutions in a microservices-based environment. As a member of our team, you will contribute to the full lifecycle of our data persistence layer, from schema design and performance tuning to ensuring robust replication, disaster recovery, and seamless integration within our cloud-native microservice ecosystem.</span></p><p></p><p><b><b>Responsibilities:</b></b></p><ul><li><p><u>Design &amp; Develop Database Solutions:</u><span> Architect, design, and implement highly optimized relational (e.g., MySQL, PostgreSQL, AWS Aurora, SQL Server) and NoSQL (e.g., MongoDB, DynamoDB, Redis) database schemas, ensuring data integrity, performance, and scalability for microservices.</span></p></li><li><p><u>Performance Optimization &amp; Tuning:</u><span> Proactively analyze and optimize complex queries, implement efficient indexing strategies, and manage <span>partitioning/sharding</span> to ensure peak database performance and handle high throughput.</span></p></li><li><p><u>Reliability &amp; Disaster Recovery</u>:<span> Design, implement, and maintain robust backup, disaster recovery, and high-availability solutions, including replication <span>(master-slave/multi-master)</span> and failover configurations, to ensure data durability and system uptime.</span></p></li><li><p><u>Cloud Database Management</u>:<span> Deploy, configure, and manage database instances within cloud infrastructure (e.g., AWS RDS, Aurora), leveraging cloud-native features for scalability and operational efficiency.</span></p></li></ul><p></p><ul><li><p><span>Focus on quality by promoting coding best practices, a test-first mindset and highest security standards.</span></p></li><li><p><span>Contribute to building new and improving existing development processes.</span></p></li><li><p><span>Work within a small agile teams delivering new features and fixing defects.</span></p></li><li><p><span>Lead technical designs, taking a holistic view of the product, and collaborate with multiple stakeholders to define the best approach to address upcoming challenges and deliverables.</span></p></li><li><p><span>Define and drive the team's technical direction, mentor junior engineers, and proactively identify, propose, and implement new processes or architectural improvements to enhance team efficiency, code quality, and timely delivery.</span></p></li><li><p><span>Contribute to software architecture discussions, translate system-level designs and architectural blueprints into robust, maintainable, and high-quality code, applying the latest best practices in software engineering.</span></p></li></ul><p><br/> </p><p><b><b>Required Skills/Experience:</b><span> </span></b></p><ul><li><p><span>6+ years in roles directly responsible for the availability, performance, and security of critical databases.</span></p></li><li><p><span>Expertise in Database Technologies: Strong command of MySQL, PostgreSQL, AWS Aurora, SQL Server and experience with MongoDB, DynamoDB, or Redis, including schema design and complex query writing.</span></p></li><li><p><span>Database Performance &amp; Scalability: Proven ability in query optimization (e.g., EXPLAIN plans), operating system optimization, advanced indexing strategies, and implementing <span>partitioning/sharding</span> and caching (Redis).</span></p></li><li><p><span>Cloud Database Operations: Hands-on experience deploying, managing, and optimizing databases within AWS infrastructure (RDS, Aurora) and virtual machine infrastructure (SQL Server).</span></p></li><li><p><span>Database Reliability &amp; Security: Experience with high availability (replication, failover), backup automation, PITR, and data security (encryption, SQL injection prevention).</span></p></li><li><p><span>Automation &amp; DevOps: Proficiency in integrating database changes into CI/CD pipelines using schema migration tools (DbUp, EF migrations, Flyway, Liquibase) and Git for version control.</span></p></li><li><p><span>Scripting &amp; Troubleshooting: Strong scripting skills (Python/Bash) for automation and abilit