Job Information
Hapana DBA Specialist in Noida, India
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).