DBA Specialist
Hapana empowers premier fitness facilities to build efficient and powerful business operations through superior technology and remarkable experiences.
The Hanana Solution is a turnkey solution for fitness facilities powering boutique and big-box (gym) operations globally. Our technology services the day-to-day operations of a fitness business: Membership Management, Access Control, Class Scheduling, Member Mobile and Web Experiences, Point of Sale, Corporate Reporting and more.
Globally, Hapana is the clear software choice for managing multi-location fitness business operations.
About this role
We are seeking a seasoned DBA to join our team. You will have extensive experience in a mission-critical environment as a database administrator over a successful career. You will primarily work on the Supporting our Databases, AWS RDS (MySQL), and MongoDB/ DynamoDb.
Responsibilities
- Provide leadership in database scaling & monitoring. Maintain runbooks for our 24x7 SRE team.
- Assist in troubleshooting and resolution of database issues. Perform database upgrades and patches.
- Define and develop data pipelines between platforms in a mission-critical environment using DMS, Fivetran, Kafka, etc.
- Work with our developers to optimize and tune their SQL queries.
- Assist in application development, debugging, and optimization with respect to data concerns.
- Provide input in the design and implementation of backup, recovery, and DR strategy
- Review application and database design for compliance.
Requirements
- Ability to script in a high-level language like Python, Ruby, etc for Automation.
- 8+ years of experience in AWS database services like RDS (Mysql), MongoDB/ DynamoDb.
- Must demonstrate a clear understanding of logical and physical database design and standards.
- Experience in columnar data warehouse solutions like Redshift or Snowflake.
- Must have extensive hands-on experience with MySQL in a large-scale 24x7 production environment with millions of records.
- Bachelor of Science in Computer Science, Mathematics, or Engineering; or equivalent work experience
Bonus Points If You Have
- Experience with NoSQL solutions such as DynamoDb /MongoDB etc.
- Experience with software development life cycle (SDLC) in an agile environment
- Hands-on production experience with Big Data applications such as HIVE/PIG .
- Knowledge of development best practices (source control with Git, continuous integration, automated testing).