Find Remote Jobs Worldwide & Work From Anywhere

Senior Database Administrator, UK

London office (Soho), but full time remote working applications considered (within UK)

Marin Software, headquartered in San Francisco, is looking for an outstanding individual in the UK, with extensive prior relational database experience, to join our Data Platform team. Marin is merging MySQL with Hadoop-based systems to refine and advance our innovative new a platform, and is seeking an expert in production delivery and support, primarily for ORM databases with MySQL as well as Hadoop to help us with this. 

This is a deeply technical hands-on position, requiring extensive knowledge of MySQL, including MySQL internals, supporting many different technologies. The successful candidate will play a critical role in advising software engineers on scalability and performance best practices throughout the development process and must have stellar communications skills. You will play an integral part in shaping the future of Marin, the databases it uses, be open to learning new technologies, as well as working outside of your comfort zone.

Working with data at Marin is an exciting opportunity where you will work with billions of rows, hundreds of thousands of transactions per second and petabytes of data. We manage billions of digital advertising spend, enjoying the challenges that come with big data and frequent changes from Facebook, Google, Amazon and more. This is a great opportunity to make a big impact on a business, which is highly ambitious and going through a highly exciting stage of our evolution!

Responsibilities

• Provide technical leadership to the Database Operations team and vision for the ongoing refinement of all database aspects of Marin’s next generation platform
• Represent the team on all architectural decisions regarding database issues, being an authoritarian on best practices
• Manage and maintain multiple production and pre-production MariaDB/MySQL, and MongoDB clusters, containing multi-petabytes of data
• Use prior experience to influence further developments with MySQL
• Perform administration, on-going management and monitoring of all database systems; always looking to streamline and improve processes
• Identify and troubleshoot performance/reliability issues, recommending and implementing solutions to overcome them to optimize our database cluster
• Triage, deep dive and troubleshoot complex issues in the Marin application and infrastructure across not only database systems but also Java, Python, MySQL, messaging, PHP, Angular and other open source technologies
• Support developers in building features that perform at scale, including writing, reviewing, and tuning SQL queries and recommending when something should be performed outside of the database
• Proactively develop scripts and tools required to support any or all of the above
• Automate where possible to ensure work is repeatable and consistent
• Protect the safety and integrity of the database platform through database design changes, backups and securing of database instances
• Participate in a 24x7 on-call 
• Responsible for database operations such as data retention, health report, backup management, etc

Marin Software is committed to promoting a diverse and inclusive workplace where we can all be ourselves and succeed on merit. We offer a range of family-friendly, inclusive employment policies, flexible working arrangements and benefits to support our employees from different backgrounds.

Skills & requirements

Essentials

• Proven, hands-on expertise with MySQL, with detailed understanding of internals, specifically with the InnoDB storage engine, isolation level, replication, partitioning, sharding, ACID, views, transactional SQL, and cache management
• Track record of writing and tuning SQL queries
• Experience in administration with MySQL and MongoDB recent major releases
• Experience working with OLTP and OLAP systems 
• Experience with with making large DB and tables performant
• Solid knowledge of database design principles
• Experience with automation in either Ansible, Puppet or Chef, and practitioner of Infrastructure as Code
• Extremely honed problem-solving and debugging ability
• Experience with high availability 24x7 customer facing environments
• Advanced proficiency in Bash scripting and fundamental knowledge in either Perl or Python
• Highly flexible individual who enjoys working in a fast paced environment with a high rate of change
• Have clear and responsive communication style, setting expectations as to when tasks will complete
• Bachelor degree in Engineering, Computer Science or equivalent 

Desirable

• Experience of working in a globally distributed team
• Strong Linux administration skills
• Familiar with ORM methodologies
• Understanding of Java and Hibernate concepts
• Understanding of the Hadoop ecosystem such as Presto, Phoenix, HBase and distributed system operation with big data, such as HDFS file management or a strong desire to learn
• Advanced degree in Engineering, Computer Science or equivalent