Senior Database Administrator

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.

What you’ll do:

• 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.

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.

Additional Information

• Your health and well being are important to us at QAD. We provide programs that help you strike a healthy work-life balance.
• Opportunity to join a growing business, launching into its next phase of expansion and transformation.
• Collaborative culture of smart and hard-working people who support one another to get the job done.
• An atmosphere of growth and opportunity, where idea-sharing is always prioritized over level or hierarchy.
• Compensation packages based on experience and desired skill set

About QAD:

QAD Inc. is a leading provider of adaptive, cloud-based enterprise software and services for global manufacturing companies. Global manufacturers face ever-increasing disruption caused by technology-driven innovation and changing consumer preferences. In order to survive and thrive, manufacturers must be able to innovate and change business models at unprecedented rates of speed. QAD calls these companies Adaptive Manufacturing Enterprises. QAD solutions help customers in the automotive, life sciences, packaging, consumer products, food and beverage, high tech and industrial manufacturing industries rapidly adapt to change and innovate for competitive advantage.

QAD is committed to ensuring that every employee feels they work in an environment that values their contributions, respects their unique perspectives and provides opportunities for growth regardless of background. QAD’s DEI program is driving higher levels of diversity, equity and inclusion so that employees can bring their whole self to work.

We are an Equal Opportunity Employer and do not discriminate against any employee or applicant for employment because of race, color, sex, age, national origin, religion, sexual orientation, gender identity, status as a veteran, and basis of disability or any other federal, state or local protected class.