For one of our clients in the IT industry, we’re looking for a Senior Database Administrator with experience in MySQL who wants to be challenged on a daily basis. This position entails monitoring the integrity, optimizing the performance and ensuring the security of the Company’s databases.
In this role you will:
- Design and map the database architecture
- Assure the data remains consistent across the database
- Monitor performance and manage parameters to provide optional responses to users
- Develop, manage and test security, back-up and recovery plans
- Implement a failover solution
- Automate regular Database/OS Administrative work with other support teams and ensure they are functioning correctly
- Plan and execute tests of fault tolerance capabilities, including backup/recovery, replication, failover and disaster recovery
- Participate in the creation and refinement of staging & production database instances
- Write database documentation, including data standards, procedures and data dictionary definitions
- Collaborate with the Technical team in order in order to optimize queries, designs and SQL performance
- Provide support to the operations teams
- Serve as the primary point of contact for advanced level troubleshooting and perform hands-on Database/ System administration as required
- Collaborate with application developers to evolve the database architecture and design.
We would expect you to have:
- Bachelor degree in Computer Science
- 5 or more years of working experience in Relational DBMS Administration/Engineering (preferably MySQL) on production environment, supporting complex, highly available OLTP databases
- Experience in tuning database server configurations, queries and indexes
- Proficiency in any of the scripting languages (e.g. Python/ PHP/ Perl/ Ruby and SQL)
- Exposure to any NoSQL solutions ( Mongo is a big plus but any other NoSQL will also apply)
- Good understanding of the Operating System concepts, mainly Linux
- Experience in remotely managing Linux servers via command line tools
- Well-versed in HA strategies, including databases replication, failover clustering, database mirroring and log shipping
- Experienced in the creation and implementation of full proof DR plans – including Backup and Recovery
- Skilled in database server performance monitoring and storage performance optimization
- Working experience on Amazon Web Services is a plus.
Other skills:
- Dynamic, proactive and responsible
- Good organizational and time management skills
- Keen to keep up with the IT trends
- Full proficiency in English (mandatory)
