Job Details
Experience Needed:
Career Level:
Education Level:
Salary:
Job Categories:
Skills And Tools:
Job Description
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.
Job Requirements
- Experience in installing, troubleshooting, and operating in virtualized environments like Microsoft Azure and AWS
- Strong proficiency in MySQL and MariaDB database management
- OCP MySQL Admin 5.6 Certification is an important value add.
- 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
- Set DBMS configuration parameters according to VT-IS policies and specific OpCos needs (upon evaluation and agreement).
- 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, according to VT-IS policies and OpCo’s application specifications.
- 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, e.g Sox compliance
- Install DBMS SW, with respect to appropriate version, release and patch level.
- Perform database migration/upgrading
- Work with application team for troubleshooting database issue during migration.
Featured Jobs
Similar Jobs
- Full Stack DeveloperPrometeon Tyres Group – Egypt (Ex-Pirelli Tyres Egypt) - Alexandria, Egypt8 days ago