Job Responsibilities
- Provision and maintain MySQL/MariaDB instances, both in clustered and non-clustered configurations
- Manage Database Servers/Clusters in Cloud environments
- Ensure performance, security and availability of databases
- Prepare documentation and specifications for all deployed databases
- Plan, document, prepare and handle database procedures, such as backup/restore/migration and more.
- Good to have Shell script knowledge.
- Experience in developing ETL processes.
- Profile, optimize and tweak server resource usage for optimal performance
- Create/Maintain/Review database-level coding, such as stored procedures, functions, and more.
- Execute security audits within our database eco-system
- Document processes executed in our database servers in full details (diagrams, documentation and more).
- Support the Development and Quality Assurance teams with their needs for database development and access
- Ability to analyze and compare database vendors (and their offerings) on a regular basis to understand the market trends and best solutions for our data-driven efforts
- Use knowledge and research to constantly modernize our data storage and server stacks
- Be a team player and strong problem-solver to work with a diverse team
Job Requirements
- Bachelor’s Degree or equivalent work experience
- Fluent in English, with excellent oral and written communication skills
- 5+ years of experience with Linux-based MySQL/MariaDB server management and maintenance
- 5+ years of experience with Database Design/Development/Scripting
- Strong proficiency in MySQL/MariaDB database management
- Understanding of MySQL /MariaDB’s underlying storage engines, such as InnoDB and MyISAM
- Experience with replication configuration in MySQL/MariaDB
- Knowledge of standards and best practices in MySQL/MariaDB
- Proficient in writing and optimizing SQL Statements
- 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
