MySQL Database Administrator
EGID -
New Cairo, CairoPosted 7 years ago17Applicants for1 open position
- 13Viewed
- 1In Consideration
- 11Not Selected
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