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 analyse 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 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 Requirements: Be a technical leader and show ownership of database design 5 years of practical experience building and supporting 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. Recommend, test, and evaluate new technologies, software tools, and required skill sets; recommend and implement improvements. 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
