Database Developer at Mastery Logistics Systems, Inc.

We need one to Design and implement highly available database architectures using proven frameworks and tools

Qualifications:

• Be a technical leader and show ownership of database design
• 5+ years of practical experience building and supporting Postgres and Microsoft SQL databases
• Extensive experience with query tuning and troubleshooting including indexing, ensuring proper join techniques, etc.
• Excellent SQL programming: writing, maintaining, and testing codes using “outside the box” approach
• Ability to understand complicated problems and craft into simple solutions that can
• be maintained by the rest of the team
• Ability to participate in and contribute to code management in GitHub including
• actively collaborating in peer-reviews, feature branches, and resolving conflicts and commits
• Provide technical leadership on database systems and solutions. Provide individual
• mentoring and training on databases and tools
• Ability to train and mentor applications developers on best database practices
• Adaptable to change and able to work independently and as part of a team
• Strong sense of responsibility with a bias towards action
• Comfortable self-directing and prioritizing your own work
• Excellent written and verbal communication skills
• Experience leading technical projects

Preferred Skills:

• Previous Database Migration and SSIS/ADF exposure a plus
• Azure experience a plus
• Exposure to NoSQL databases such as MongoDB a plus
• Experience with Kafka or similar distributed stream processing systems beneficial
• Experience with delivery database solutions through Continuous Integration/ Continuous Delivery
• Experience developing data stores in support of a microservice architecture

Description

About the Role:

The transportation industry has no shortage of complex problems requiring creative, data-intensive solutions in order to effectively and efficiently automate operations at scale. In this role, you will be expected to work autonomously and contribute to several high impact projects including optimizing all application touchpoints with the database systems.

Responsibilities:

Performance:

• Enhance and optimize existing databases for peak performance
• Find bottlenecks in high volume OLTP environments and deliver optimal solutions
• Understand database execution plans and how to use the information to optimize code
• Monitor and analyze database performance and ensure effective and efficient utilization of database systems/processes
• Skills for developing, deploying, & debugging cloud applications
• Maintain a high bar for quality and performance of your product with vigorous attention to detail and automated testing
• Experience with continuous integration, delivery, desired state processes tools and constraints
• Solve complex technical issues involving multiple technology stacks

Design:

• Set and maintain database standards
• Design and implement highly available database architectures using proven frameworks and tools
• Provide documentation and training to other Engineering stakeholders
• Write clean, maintainable, and well-tested code
• Strong verbal and written communication skills
• Excellent analytical, decision-making and problem-solving skills
• Closely collaborate with application developers and Product Managers and interact with stakeholders across the organization to optimize SQL code and database structures
• Continuously improve how we design, build, and ship software as a highly functional team
• Be a force-multiplier on the velocity and quality of your team

About Mastery

Mastery Logistics Systems is building the world’s first lovable Transportation Management System, or TMS.

Our customers – large transportation companies and shippers who need those companies – have struggled with systems that are outdated or inadequate. As shippers or transportation service providers, our customers have in the past been forced to use multiple systems to manage dedicated fleet operations, outsourced or insourced trans management, one way trucking, truckload brokerage, LTL, and Intermodal, or to sub-optimize one or more of those functions by attempting to fit it into a TMS that is adequate at another function.

Mastermind TMS allows our customers to bring all of these functions into a single platform, providing flexibility, visibility, control, and efficiency. Today’s unprecedented global supply chain upheavals underscore how important the transportation industry is. We are building a system to allow this industry to work faster, smarter and more efficiently.

The challenges in this industry are big and exciting! We are tackling everything from fast and efficient data input to ingesting large amounts of data and applying AI to looking at blockchain to securely digitize paperwork. If you are passionate about humanizing an industry, automating in innovative ways, building for quality and scale, helping make people's lives easier and touching every part of our economy then this is the place for you.

Mastery Logistics Systems is committed to continuing to build an incredible company. We are a masterful mosaic of incredible people. We are specialists and experienced in our respective fields. We are dedicated to continuous improvement both professionally and personally. We are a collective group of really good people. We have different interests, backgrounds & talents and we work together to create really cool stuff! We believe in diversity of thought and are mindful and inclusive. We have deep respect for each other and work diligently at adding the right people to our teams.

At this moment we are all working from home and doing our part to combat the Covid 19 virus. We are creatively building our new work habits. We are respectful of each other’s time and personal life. We have flexible schedules but share in the mission that we are building and need to get it done. We offer an excellent suite of benefits. We are dedicated to finding new ways to add perks as we live and work from home.

Our team has the domain knowledge and connections to make an impact, and we’re looking for experienced and thoughtful people to who thrive on creating and building great products. We want people who have a true passion for servicing and taking care of our customers. We need people who are flexible problem solvers, thrive on collaboration and consistently know how to communicate their solutions well. We are small and nimble – which is evident in how quickly we could pivot to our new reality. Each member of the team can make a tremendous impact both technically and culturally. While a start-up, we are well-funded, have an initial paying customer with which to test and launch, and are founded by top experts and veterans in the logistics industry.

Join us – you’ll love it – let’s build a masterpiece!

Benefits

Mastery takes great pride in providing our employees a robust and highly competitive benefit package. Our benefits include Medical, Dental and Vision insurance covering 90% of premium costs. Company paid life insurance for 1x salary. Legal, AD&D, Additional Life and other employee assistance benefits. We have a 401k savings plan with a 4% match. We provide opportunities for professional growth and development. We fully support our work from home initiative as we do our part to combat the Covid 19 crisis. We have a manage your life and schedule Paid Time Off program. We are fully devoted to finding creative perks and benefits since we cannot currently enjoy our cool office culture. Our philanthropic partner is St. Jude Children’s Research Hospital.

We are an equal opportunity employer and actively seek a diverse community of professionals. Veterans, Women, non-binary, people of color, LGBTQIA, we welcome all to apply!