Browse Jobs
For Employers
Post JobLog inGet Started
Logo

Database Administrator

Aman Holding
Nasr City, Cairo
Posted 3 years ago
14Applicants for1 open position
  • 7Viewed
  • 0In Consideration
  • 0Not Selected
Search other opportunities

Job Details

Experience Needed:
Career Level:
Education Level:
Salary:
Job Categories:

Skills And Tools:

Job Description

Job Purpose: 

  • Database Administrator Lead 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.

Responsibilities

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

Job Requirements

  • Strong proficiency in MySQL database management
  • Decent experience with recent versions of MySQL
  • Understanding of MySQL’s underlying storage engines, such as InnoDB and MyISAM
  • Experience with replication configuration in 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 PostgreSQL, MongoDB, etc. {{if required}}
  • 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}

Featured Jobs

Similar Jobs

Search other opportunities
JobsInstallation/Maintenance/RepairDatabase Administrator