Senior Database Administrator
Position Summary
The successful candidate will have a firm grasp of managing MySQL database servers in a 24×7 data center environment. You will need to be able to identify and solve problems such as poorly performing queries, indexing needs, good schema design, and general application performance issues as it pertains to the database. Also, the maintenance of MySQL replication for the purposes of disaster recovery, load distribution, and migration of data in real time to different servers is required. We currently maintain separate infrastructures in Chicago and London Rackspace data centers . We run our production MySQL 5.6 databases on our own leased hardware on top of CentOS to get optimal performance. We also utilize cloud servers when it makes sense.
We have the desire to begin using other NoSQL platforms for data that is better suited to that architecture. Experience in using Redis, MongoDB, or other NoSQL platforms is desirable.
We are looking for a Hands-On individual who is technically solid and also has a vision for how to generally manage large amounts of data. Self direction and creative thinking is required.
- Optimize and tune MySQL server configurations, queries and indexes for low latency and high TPS environments
- Work with Big Data and Engineering teams to deliver best architecture and schema design
- Work with Engineering and Operation teams to maintain high availability and scalability
- Continually improve monitoring
- Troubleshoot and diagnose database problems
- Perform database capacity and usage planning
- Manage backup and restore, assist with planning for disaster recovery
- Automate database administration and maintenance tasks
- Participate in prototyping and proof of concept system development and benchmarking
- Solid understanding of MySQL Server
- Expert knowledge of SQL
- Experience with MySQL replication, configuration, and deployment strategies
- Knowledge of MySQL clustering solutions is a big plus
- Demonstrated experience with relational database performance tuning and capacity planning (preferably with MySQL)
- Strong database systems administration, troubleshooting and automation skills
- Master of your favorite scripting and/or programming language
- Ability to interface and work cooperatively with software engineers and system administrators across different geo locations
- Big Data experience is a big plus
- Min. 5 years experience as a Mysql DBA
Resumes and employment applications may be sent to:
careers@omnna.com
or
Omnna
1256 Main St, Suite 277
Southlake, Texas 76092
