Position at WorldFirst
Your main responsibilities will be looking after the day to day operation, improvement, refactoring and upgrading of the MySQL database powering this application.
You will work closely with the Software Engineers on your team and other Software Development teams, Product Managers and Architects to identify the risks and help choose solutions to evolve from a monolithic application and shared database to a more modern service based infrastructure and architecture, always keeping business value in mind and sight.
You will :
Probably be from a Techops / Devops background.
Take ownership of our MySQL database infrastructure
Support multiple databases of high complexity with multiple concurrent users, ensuring control, integrity and accessibility of the data
Recommend and implement database solutions to support data integrity efforts alongside developing data access tools and techniques.
Monitor transactions between application systems and the database identifying and improving inefficiencies in SQL queries
Look to the future . Make recommendations for the enhancement of the DB estate.
Want to expand your horizons.
What you need to know :
Experience with MySQL Replication, with both Master-Slave and Master-Master
Understanding of AWS RDS
Ability to work cooperatively within a software development team
Exceptional problem-solving expertise and attention to detail
Experience in Linux environment with understanding of the operating system.
Linux shell scripting, python, knowledge of Git
Advanced knowledge and experience in physical / logical database design.
Strong Install, configure, patching, and upgrading MySQL databases using configuration management and provisioning tools
Support operations for both development and production databases.
Experience and success in automating administrative tasks
Strong understanding of hardware performance, memory and I / O
Advanced knowledge and experience in database security management