Senior Database Engineer

Summary

Join PartsBase Inc., the world's largest online aviation marketplace, as a Senior Database Engineer and work in a fully remote environment. You will design, implement, and maintain robust database systems supporting mission-critical applications. This role requires expertise in database architecture, performance tuning, and security. You will collaborate with various teams, lead large-scale migrations, and mentor junior DBAs. The ideal candidate is a motivated, well-organized individual with a deep understanding of prospecting and developing strong customer relationships. PartsBase offers a team-focused culture and competitive benefits.

Requirements

• US Citizenship required due to data export control restrictions
• Proficient in Spanish and English
• Bachelor’s or Master’s degree in Computer Science, Information Systems, or related field
• Proven experience in high-availability (HA) and disaster recovery (DR) strategies, including Always On Availability Groups and cloud-based failover solutions
• Expert knowledge of SQL, T-SQL, stored procedures, indexing strategies, and execution plans
• 5+ years of experience in database engineering or administration
• Proficiency in SQL and experience with relational databases (e.g., PostgreSQL, MySQL, SQL Server, Oracle)
• Strong understanding of data modeling, normalization, and indexing strategies
• Hands-on experience with cloud platforms (AWS, Azure, or GCP) and database services
• Familiarity with CI/CD pipelines, version control (Git), and infrastructure-as-code tools
• Excellent problem-solving, communication, and collaboration skills

Responsibilities

• Architect, manage, and optimize multiple Microsoft SQL environments and database instances, ensuring high availability, security, and performance
• Design and implement advanced performance tuning strategies, index optimizations, query rewrites, and automated monitoring systems
• Create and modify databases, write complex queries, develop stored procedures, and collaborate with other teams to integrate databases with applications
• Develop and enforce database security policies, access controls, and auditing measures to maintain compliance with industry standards
• Lead large-scale migrations and upgrades of SQL Server databases, ensuring minimal downtime and high data integrity
• Develop and maintain high-availability (HA) and disaster recovery (DR) solutions, including Always On Availability Groups, clustering, and failover strategies
• Optimize complex queries and stored procedures to enhance database efficiency and scalability
• Oversee and enhance SSRS and SSIS development, ensuring robust ETL pipelines and data reporting processes
• Collaborate with cloud engineers to design and maintain cloud-based database architectures in AWS, Azure, or Google Cloud
• Implement automation for database monitoring, maintenance, backups, and performance tuning
• Provide leadership and mentorship to junior DBAs and developers, sharing best practices and fostering database expertise within the team
• Stay ahead of industry trends and implement innovative database technologies to improve efficiency and scalability
• Document database architectures, processes, and security policies for ongoing maintenance and compliance

Preferred Qualifications

• Experience with NoSQL databases (e.g., MongoDB, Cassandra, DynamoDB) is a plus
• Certifications in database technologies or cloud platforms
• Experience with data warehousing and business intelligence tools
• Knowledge of data governance and compliance frameworks (e.g., GDPR, HIPAA)
• Scripting skills in Python, Bash, or PowerShell

Benefits

• Competitive salary and performance bonuses
• Health, dental, and vision insurance
• 401(k) with company match
• Flexible work hours and remote options
• Professional development and training opportunities