Database Administrator (MySQL, Postgres)

Ixl Learning - Raleigh, NC

Full-time

Raleigh, NC

Professional, Scientific, and Technical Services

About the position

IXL Learning, a leader in personalized learning products, is seeking a self-motivated MySQL and/or Postgres Database Administrator to enhance our database infrastructure. This full-time position is based in our Raleigh, NC area office and involves collaboration with our Systems and Database team to ensure the reliability and performance of our databases. The ideal candidate will thrive in a team environment, enjoy experimenting with new technologies, and be comfortable managing multiple projects simultaneously. In this role, you will be responsible for the administration of PostgreSQL, MySQL, and MongoDB databases throughout their development and production lifecycles. You will develop and maintain processes aimed at optimizing database security and standards, manage backup, replication, and disaster recovery functions, and monitor performance issues across all production and non-production databases. Your expertise will assist development teams in optimizing SQL statements and designing databases for maximum performance, security, reliability, and availability. Additionally, you will participate in capacity planning related to production databases and engage in cross-training for NoSQL database administration, specifically with Cassandra and MongoDB. Automation of repeated database tasks will also be a key part of your responsibilities.

Responsibilities

• Administration of PostgreSQL, MySQL, and MongoDB databases throughout the development and production lifecycles.
• Develop and maintain processes for optimizing database security and standards.
• Manage backup, replication, and disaster recovery functions for the database environments.
• Monitor performance issues on all production and non-production databases, implementing performance monitoring and trending.
• Assist development groups in optimizing SQL statements in applications, batch jobs, and reports.
• Design and use databases and database applications for maximum performance, security, reliability, and availability.
• Participate in capacity planning as it relates to production databases.
• Cross-train in NoSQL database administration (Cassandra and MongoDB).
• Automate repeated database tasks.

Requirements

• BS in Computer Science or IT related field.
• 4+ years of IT experience.
• 3+ years PostgreSQL Database Administrator experience (working with PostgreSQL v11.0 and above).
• In-depth knowledge of PostgreSQL Architecture.
• Working knowledge of Patroni HA Cluster.
• Working knowledge of Amazon RDS (Postgres, MySQL, and Aurora).
• Strong knowledge of Linux and shell scripting.
• 3+ years of experience in any other database administration is a plus.
• Strong communication and interaction skills.
• Eagerness to continue learning.