Senior Database Administrator - Dublin, Ireland - QAD

    QAD
    QAD Dublin, Ireland

    1 week ago

    Default job background
    Full time
    Description

    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 (, Ansible, Terraform, CloudFormation) for Amazon RDS.
  • Strong scripting skills (, 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 (, 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