MySQL and PostgreSQL Database Administrator

Save to Favorites

ROLE DESCRIPTION

Position

MySQL and PostgreSQL Database Administrator

Department

Product Development Organization

Reports to

Technical Product Manager

About School Group

School Group (SG) is a start-up international non-profit developing a cutting-edge global e-learning platform that will allow students around the world to connect for peer-to-peer collaborative learning and skills development - improving the accessibility and quality of education, while transforming lives and impacting future success. We need talented people to help us make our vision a reality. So, if you believe in the power of education, international development and community service - and have the time, skills and know-how to match - we want you as a School Group volunteer. 

RoleOverview

School Group is looking for an experienced MySQL and PostgreSQL database administrator who will be responsible for ensuring the performance, availability, and security of clusters of MySQL instances. You will also be responsible for orchestrating upgrades, backups, and provisioning of database instances. You will also work in tandem with the other teams, preparing documentations and specifications as required.

Essential Functions

• Monitor the system daily and respond immediately to security or usability concerns
• Create and verify backups of data
• Respond to and resolve help desk requests
• Upgrade systems and processes as required for enhanced functionality and security issue resolution
• Administrate infrastructure, including firewalls, databases, malware protection software and other processes
• Review application logs

Every effort has been made to identify the essential functions of this position. However, this position description in no way states or implies that these are the only duties you may be required to perform. The omission of specific descriptions of duties does not exclude them from the position if the work is similar, related or can be considered essential to this position. 

Qualifications

Basic

• Strong proficiency in PostgreSQL and MySQL database management
• Decent experience with recent versions of PostgreSQL and MySQL
• Understanding of PostgreSQL and MySQL’s underlying storage engines, such as InnoDB and MyISAM
• Experience with replication configuration in PostgreSQL and MySQL
• Knowledge of de-facto standards and best practices in MySQL
• Proficient in writing and optimizing SQL statements
• Knowledge of MySQL features, such as its event scheduler
• Ability to plan resource requirements from high level specifications
• Familiarity with other SQL/NoSQL databases such as MongoDB, etc.
• Knowledge of limitations in MySQL and their workarounds in contrast to other popular relational databases
• Proficient understanding of code versioning tools such as Git, Mercurial, SVN

Why volunteer with us?

We are a community of people from different parts of the world who share a common belief in improving education which will eventually reduce poverty and improve the quality of life and living conditions globally. Volunteering with us will enable you to build your resume and gain invaluable experience in a supportive environment. 

• In the USA, School Group is a Certifying Organization, offering the President’s Volunteer Service Award (PVSA) to eligible volunteers. 

• School Group will provide a letter of recommendation to all volunteers who are able to showcase outstanding performance for professional references. 

Other information

This is a volunteer position. There will be no financial compensation. Our organization is 100% volunteer-run. We welcome volunteers located anywhere in the world, as long as they can connect reliably to the internet. 

How to apply

Please email your resume to apply@schoolgroup.org. We would love to hear from you!