Browse Jobs
For Employers
Post JobLog inGet Started

MySQL Database Administrator

EGID
New Cairo, Cairo
Posted 7 years ago
17Applicants for1 open position
  • 13Viewed
  • 1In Consideration
  • 11Not Selected
Search other opportunities

Job Details

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

Skills And Tools:

Job Description

About the Job

  • 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.
  • Configure DB’s at the instance level.
  • Deactivate unneeded features in configuration files
  • Set up any needed protective measure
  • Monitor overall performance, disk space, and log generation and manage DB processes and threads
  • Manage space for database devices (including Datafiles) and space allocation.
  • Perform DB backups according to standard policies and recovery actions as needed
  • Manage redo/transaction log files, including any request to restore
  • Strong experience working with logical and physical backup
  • Discover and analyze instance errors
  • Implement workarounds and solutions to solve incidents and problems, in close collaboration and according to OpCo’s needs.
  • Perform data refresh from production systems, wherever the infrastructure is available
  • Track and record basic tasks performed by users at system Administration level.
  • Participate in external security Audit
  • Perform database migration/upgrading
  • Work with application team for troubleshooting database issue during migration.

Job Requirements

  • Experience in installing, troubleshooting, and operating in virtualized environments.
  • Strong proficiency in MySQL database management
  • Recent experience with current 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 schedule
  • Ability to plan resource requirements from high-level specifications
  • Familiarity with other SQL/NoSQL databases such as PostgreSQL, 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)
  • Very good command of Microsoft Outlook, Word, Excel, PowerPoint, and Project
  • Experience in writing technical and non-technical documentations
  • Knowledge of the new trends in computing
  • Deep understanding of Information Security and Encryption
  • Self-motivated and continuous learner and ability to work under stress
  • Key Accountabilities
  • Performance tuning for specific application, applying patches, and securing the DB according to security policies

Featured Jobs

Similar Jobs

Search other opportunities
JobsAdministrationMySQL Database Administrator