Senior SQL Server DBA

Job Title

Location: Fountain Street, Manchester

Rideways is a new ground transportation service launched by Rentalcars.com, and is rapidly growing to be a significant B2B and B2C player in this space.

Rideways is a multi-skilled group of over 25 people, working as a separate group within Rentalcars.com to build and deliver the technology, commercial relationships and operations for a new ground transportation business. We have a fast-paced, “start-up” environment co-located within, and part of, the broader Rentalcars.com business – sharing all the upsides of a bigger business, but with the speed, drive and autonomy of an independent, early-stage start-up.

We have an exciting product vision, a rapidly growing team, and a learning environment where you will constantly be challenged to develop your understanding of how a business comes together from the “nuts and bolts”. Our focus is to provide a fantastic customer experience across web, mobile, phone and chat while scaling to become globally relevant (languages, locations, product offering) – and we are only at the start of our journey. Join our team to be a part of one of the most rewarding and challenging, growth journeys around; this is one of those rare opportunities to be a part of something big from the start.

Where we are going
• Cross functional agile teams who own their products in a Continuous Delivery DevOps environment
• Revolutionise our online customer experience through a great web site and mobile app
• Data driven decisions using Kibana, monitoring, Big Data, MI and MVT testing
• Continuous improvement, keeping it simple and developing the team
• Great engineering practices with a focus on TDD and BDD principles and a strong focus on non-functional requirements at the beginning rather than an afterthought
• Decoupled, cloud-based service orientated architecture with resilience and adaptability built in

What we offer in return
• Ownership of your work and a great technical challenge
• A great new office to work in the heart of Manchester
• Great facilities including subsidised canteen and Starbucks, free breakfast & fruit and cycle hub
• An exciting and dynamic place to work
• 25 days paid holiday plus bank holidays
• Great discounts on car rentals and other group benefits
• Opportunity to shape the future of the team
• Software development kit that works

Key Responsibilities
• Write robust SQL statements
• Optimize in-application SQL statements
• Ensure performance, security, and availability of databases
• Prepare documentations and specifications
• Handle common database procedures such as upgrade, backup, recovery, migration, etc.
• Profile server resource usage, and optimize and tweak as necessary
• Collaborate with other team members and stakeholders.
 
Skills we are looking for
We are looking for a Database Engineer who will be responsible for designing databases and ensuring their stability, reliability, and performance. You will also work other developers optimizing in-application SQL statements as necessary, and establishing best practices. You will help solve all database usage issues and come up with ideas and advice that can help avoid such problems in the future. Your skills and experience should align to the following:
• Strong proficiency with SQL and its variation among popular databases
• Experience with some of the modern relational databases
• Experience using databases running in AWS or other cloud service
• Skilled at optimizing large complicated SQL statements
• Knowledge of best practices when dealing with relational databases
• Capable of configuring popular database engines and orchestrating clusters as necessary
• Ability to plan resource requirements from high level specifications
• Capable of troubleshooting common database issues
• Familiar with tools that can aid with profiling server resource usage and optimizing it

Other beneficial skills
• Demonstrable experience of working in an Agile software environment.
• Strong experience of Continuous Integration, Continuous Delivery and Agile practices using GIT, Bamboo or Jenkins and SCRUM
• Quality first mind-set for writing tests.
• Brainstorming new and innovative ideas that improve efficiency and/or business results.
• Working in an agile environment, ensuring that appropriate balance is struck between delivering and providing a quality product.
• Data warehousing or big data experience are advantageous