Database Administrator
About the Job
SimplePractice is the future of practice management. We’re at the forefront of making it simple for clinicians to run and grow their practices and growing quickly.We’ve built the highest-rated practice management software and we’re on track to become the market leader.
We are looking for database administrator with some devops background who has a strong motivation to deliver stable and secure database systems.
Under the lead of our Senior Database Administrator, you will be responsible for operating our services in a HA environment, as well as maintaining and scaling database components, and managing the database security of our production systems.
What you'll do day-to-day
- Set and maintain database standards across the organization
- Manage database access for various users
- Work with the rest of the engineering group to evaluate and tune the performance of application queries
- Install, upgrade and manage database servers
- Diagnose and troubleshoot database issues and errors
- Continuously evaluate and deploy database monitors
- Create and manage database reports, visualizations, and dashboards
- Automate repetitive tasks and database jobs
- Take part of on-call rotations
The ideal candidate
- Bachelor's degree in Computer Science (or equivalent) or higher degree
- Excellent knowledge of Linux operating systems
- 3+ years of production experience with MySQL
- Strong knowledge of scripting languages: Python, Ruby and Bash
- Knowledge of AWS systems and EC2 instances
- Ability to analyze and resolve complex database resource and application deployment issues
- Database security and encryption
- Problem solving skills and ability to work under pressure
- Passion, drive, energy, a sense of humor, great attitude and team player!
Bonus Points
- Strong AWS knowledge of EC2 instances and S3 buckets
- Knowledge of configuration management tools (Chef and Ansible)
- Knowledge with ProxySQL, Orchestrator, Percona Xtrabackup
- Ability to deploy monitors within DataDog
- Experience with global failover and load balancers
- Working knowledge of administering MySQL databases and MySQL replication
- Information security related work
Technology Stack and Tools you will be working with
- Ruby on Rails
- Nginx
- Phusion Passenger
- MySQL
- Terraform
- ElastiCache
- Redis
- Kibana
- Chef
- Ansible
- DataDog