Senior Database Administrator

at  QAD Inc

Company Description
QAD is building a world-class SaaS company, and we are growing. We are looking for talented individuals who want to join us on our mission to help solve relevant real-world problems in manufacturing and the supply chain.
We are a virtual first company and your primary work experience will be virtual / working from your home. Occasional travel to a physical office may be required to enhance working relationships, collaboration, design, strategy and alignment.
Job Description
We are seeking a highly skilled and experienced Senior Database Administrator (DBA) with expertise in managing and optimizing MariaDB databases in Amazon RDS environments, along with a strong background in database migration and conversion between different database technologies. The ideal candidate should possess deep expertise in database administration, performance tuning, troubleshooting, automation, and the ability to seamlessly migrate data between various database platforms.

QUALIFICATIONS

• Bachelor’s degree in Computer Science, Information Technology, or a related field; relevant certifications are a plus.
• Minimum of 10 years of experience as a Database Administrator, with a strong focus on MariaDB in production environments.
• Strong expertise in managing MariaDB databases on Amazon RDS, including deployment, configuration, and optimization.
• Proficiency in SQL query optimization, performance tuning, and troubleshooting on Amazon RDS.
• Solid understanding of database security principles and best practices on Amazon RDS.
• Experience with database backup, recovery, and replication strategies on Amazon RDS.
• Proven experience in successful database migration and conversion projects between different database technologies.
• Familiarity with automation and configuration management tools (e.g., Ansible, Terraform, CloudFormation) for Amazon RDS.
• Strong scripting skills (e.g., Bash, Python) for automating database tasks on Amazon RDS.
• Excellent problem-solving skills and the ability to diagnose and resolve complex database issues on Amazon RDS.
• Knowledge of cloud computing concepts and experience with AWS services.
• Strong communication skills and the ability to collaborate effectively with cross-functional teams.
• Demonstrated ability to work independently, prioritize tasks, and manage time efficiently.
• Experience with SkySQL is also a plus.
• Experience with other database systems (e.g., MySQL, PostgreSQL, Progress Db, MongoDb, Cassandra) is a plus.
• Knowledge of DevOps practices and CI/CD pipelines is advantageous.
• Strong written and verbal English language skills.

• Manage and administer MariaDB databases deployed on Amazon RDS, ensuring high availability, security, and performance.
• Monitor and proactively respond to database alerts, incidents, and performance issues on Amazon RDS to minimize downtime and optimize performance.
• Collaborate with cross-functional teams to design and implement database solutions that meet application requirements and scalability needs on Amazon RDS.
• Conduct regular database capacity planning on Amazon RDS and provide recommendations for resource optimization.
• Develop and implement backup, recovery, and disaster recovery strategies on Amazon RDS to ensure data integrity and availability.
• Perform data migration and conversion between different database technologies, ensuring data accuracy, consistency, and minimal disruption to services.
• Work on database schema design and optimization, including indexing, partitioning, and data modeling, on Amazon RDS.
• Collaborate with developers to optimize query performance, troubleshoot slow-running queries, and suggest query optimization techniques on Amazon RDS.
• Implement and maintain database security practices on Amazon RDS, including user access control, role management, and data encryption.
• Maintain documentation for database configurations, procedures, migration strategies, and troubleshooting guides on Amazon RDS.
• Automate routine database tasks using scripting and configuration management tools for Amazon RDS.
• Stay up-to-date with the latest developments in MariaDB, Amazon RDS, and other relevant database technologies, and apply new knowledge to enhance database operations and migrations.