Create, optimize and maintain queries, used in our software applications, as well as data extracts and ETL processes
Modify and maintain databases, routines, queries in order to ensure accuracy, maintainability, scalability, and high performance of all our data systems
Solve database usage issues and malfunctions
Liaise with developers to improve applications and establish best practices
Provide data management support for our users/clients
Research, analyze and recommend upgrades to our data systems
Prepare documentation and specifications for all deployed queries/routines/processes
Profile, optimize and tweak queries and routines for optimal performance
Support the Development and Quality Assurance teams with their needs for database development and access
Be a team player and strong problem-solver to work with a diverse team
Job Requirements
Bachelors Degree or equivalent work experience
Fluent in English, with excellent oral and written communication skills
5+ years of experience with Linux-based MySQL/MariaDB database development and maintenance
2+ years of experience with Database Design/Development/Scripting
Proficient in writing and optimizing SQL Statements
Strong proficiency in MySQL/MariaDB scripting, including functions, routines and complex data queries.
Understanding of MySQL/MariaDBs underlying storage engines, such as InnoDB and MyISAM
Knowledge of standards and best practices in MySQL/MariaDB
Knowledge of MySQL/MariaDB features, such as its event scheduler
(Desired) Familiarity with other SQL/NoSQL databases such as PostgreSQL, MongoDB, Redis
(Desired) Experience with Amazon Web Services RDS offering
(Desired) Experience with Data Lakes and Big Data
(Desired) Proficient Understanding of git/GitHub as a source control system
Familiarity with working on an Agile/Iterative development framework
Self-starter with positive attitude with the ability to collaborate with product managers and developers