Job description
Company Overview:
PartsBase Inc. is the world’s largest online Aviation Marketplace and Community. Our global community is comprised of over 7,600 companies accessing our technology in over 217 countries & territories. We work with some of the biggest brands in aviation including Delta, Northrop Gruman, AvAir, Heico, Chevron, Air France Industries, and Air Australia.
PartsBase offers a FULLY remote environment where one can work at the forefront of where the aviation business meets technology. Imagine getting to work with peers worldwide, implementing business technology projects that challenge the boundaries.
Life at PartsBase:
One of the top benefits of working at PartsBase is the culture. We are a TEAM-focused organization, and everyone celebrates each other’s successes. Our inclusive culture welcomes all employees and values their unique contributions to our success. Our clients tell us time and time again that our people set us apart from the competition. We naturally strive to hire the very best talent. The ideal candidate is a motivated, well-organized individual who has a deep understanding of prospecting and developing strong relationships with customers.
We are seeking a highly skilled and experienced Senior Database Engineer to join our growing team. This role is responsible for designing, implementing, and maintaining robust, scalable, and secure database systems that support our mission-critical applications. The ideal candidate will have deep expertise in database architecture, performance tuning, and data security, with a passion for innovation and continuous improvement.
Key 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.
Qualifications:
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).
Experience with NoSQL databases (e.g., MongoDB, Cassandra, DynamoDB) is a plus.
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.
Preferred Skills:
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
