Senior Database Administrator (DBA) Offline

We are looking for a database administrator with a DevOps mindset for automation and problem solving who can drive the technical direction for database ecosystem. You will be responsible for mission critical databases running in our own data centers, on our own hardware (no public cloud!) handling millions of transactions per second with millisecond latency, doesn’t that sound exciting?

What You Will Do

• Troubleshoot and resolve issues of any complexity related to their MySQL environments.
• Perform technical work that requires planning and scheduling to ensure the best possible solution is delivered on time.
• React on incidents and provide solutions aiming at maintained environment improvements.
• Work in a fast-paced environment where we are responsible for Acuity’s most critical systems.
• Mentor and guide other engineering colleagues, helping to breakdown knowledge silos and lead all teams to succeed.
• Serve as a point of technical escalation for difficult problems.

Your Technical Experience

• 2-5 years of experience working with MySQL Databases, including the community edition.
• Knowledge/expertise administering both OLTP and OLAP systems.
• In-depth knowledge of MySql configuration best practices.
• Advanced understanding of Linux OS: RedHat, CentOS, Ubuntu and/or Debian.
• Deep understanding of database systems performance.
• Understand automation concept preferably with experience in tooling such as Ansible and Terraform. 
• Advanced knowledge on InnoDB internals.
• Expert knowledge of Performance Schema.
• Hands-on experience with schema management and related tooling.
• Knows how to optimize queries/schemas to enhance the overall experience for our customers and developers.
• Deep understanding of replication and clustering.
• Comfortable designing and implementing HA and backup solutions and strategies.
• Knows proxy usage as it relates to MySQL.

Your Abilities and Attributes

• You are comfortable working in an on-premise environment with both virtual and physical hardware.
• Ability to individually assess developer/environment impact for changes being requested.
• Ability to review, approve and offer feedback on plans/designed created by others.
• Define runbooks that improve efficiency of all teams.
• Ability to identify skill/knowledge gaps and will proactively ask for help when required.
• Skilled at mining information from in-house documentation and the internet
• Ability to create in depth technical documents that may need to speak to a cross sectional audience.
• Ability to work well with people and communicate effectively with your own team as well as colleagues at all levels of the business.
• Ability to communicate information to colleagues in a clear and concise manner.
• Positive, helpful and supportive
• Able to make unilateral decisions in emergencies and under pressure.

What Will Make You Stand Out

• Experience with NoSql technologies such as Cassandra, HBASE and AeroSpike and how to apply best configuration practise to these systems in cross data center implementation.
• Knowledge /experience with Percona tools and PMM
• Previous experience working hands-on in an on-premise or hybrid cloud environment.
• Kubernetes expertise
• Experience working in Agile environments and/or familiar with DevOps methodologies.
• Expert level systems and network administration knowledge.
• Proven mentorship or leadership skills.