We are hiring a Senior database analyst & administrator for one of our clients
- Senior database analyst & administrator familiar with building complex databases with knowledge on postgres and MSSQL.
We are looking for an experienced MySQL 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.
- Provision MySQL instances, both in clustered and non-clustered configurations
- Ensure performance, security, and availability of databases
- Prepare documentations and specifications
- Handle common database procedures, such as upgrade, backup, recovery, migration, etc.
- Profile server resource usage, optimize and tweak as necessary
- Collaborate with other team members and stakeholders
Administering MySQL encompasses the tasks required to ensure that MySQL can perform its data management duties in an efficient and secure manner. You might be responsible for some or all of the administrative tasks, depending on how you access MySQL.
If you’re using MySQL on a web hosting company’s computer, the hosting company performs most or all of the administrative tasks. However, if you’re using MySQL on your local computer, you’re the administrator, entirely responsible for the administration of MySQL.
The duties of the administrator include the following:
Install MySQL. If MySQL is running on a web hosting computer, you’re not responsible for installation.
Start and shut down the MySQL server. If MySQL is running on a web hosting computer, you don’t start or stop the server.
Create and maintain MySQL user accounts. No one can access the data in your database without an account. Accounts need to be installed and removed, passwords added or removed, and privileges assigned to or removed from accounts
Back up data. You need to keep backup copies of your data in case the data is lost or damaged. If you’re using MySQL at a web hosting company, you need to check with that company regarding its backup procedures. You might still want to keep your own backup, just in case the web hosting company’s backup procedures fail.
Update MySQL. Install new MySQL releases when needed. If MySQL is running on a web hosting computer, you’re not responsible for updates.