Database Administrator - SnappBox

About Snappbox
Snappbox is a disruptive on-demand urban delivery platform in Iran, connecting any business with the largest fleet of delivery men in the country. Only a few companies have access to high-quality, low-cost last-mile delivery. At the same time, many bikers would like to work more but can’t find customers. We want to change this forever, through smart technologies and new standards of operations.
We are building the future, so join us.

Responsibilities:

• Database Design and Implementation:
  • Design, create, and implement database structures based on organizational requirements.
  • Optimize database schema for performance and scalability.
  • Install and configure database management systems (DBMS) software.
  • Demonstrates an understanding of the internal architecture of database management systems, as well as how they handle data storage, indexing, and querying.
  • Tests and applies patches to pre-production and production environments.
• Performance Tuning and Optimization:
  • Monitor and analyze database performance to identify and resolve bottlenecks.
  • Implement optimization techniques to enhance query efficiency and overall system performance.
  • Conduct regular system performance evaluations and recommend improvements.
• Backup and Recovery:
  • Develop and implement backup and recovery strategies to safeguard critical data.
  • Ensure data integrity through regular testing of backup and recovery procedures.
  • Respond promptly to data loss incidents, initiating recovery procedures as necessary.
• Security Management:
  • Implement and enforce security measures to protect sensitive data.
  • Manage user access and permissions, ensuring compliance with security policies.
  • Stay updated on security trends and implement best practices to mitigate potential risks.
• Database Maintenance:
  • Perform routine maintenance tasks, such as indexing, statistics gathering, archiving, and data purging.
  • Monitor system logs for errors and take proactive measures to address issues.
  • Keep database software and related tools up-to-date with the latest patches.
  • Manages database upgrades, and remains aware of change logs and new/deprecated features of database versions.
• High Availability Maintenance:
  • Mariadb Replication.
  • Database clusters design and maintenance.
  • Query routing and load balancing.
  • Automatic failover and post-failover maintenance.
• Collaboration:
  • Work closely with development teams to understand database requirements for new services.
  • Collaborate with DevOps engineers to ensure seamless integration between databases and server infrastructure.
  • Provide technical support and training to users as needed.
• Documentation:
  • Create and maintain comprehensive documentation of database configurations, procedures, and policies.
  • Document troubleshooting steps and resolutions for future reference.
• Communication:
  • Can openly handle requests from outside the team.
  • Has the patience to be available 24/7 when called.
  • Can provide technical support to end-users.

• Minimum of 1 year of relevant experience in database administration

• Proficiency in MariaDB and SQL programming

• Experience with High Availability (HA) technology and solutions. 

• Familiarity with Linux environments and scripting.

• Ability to be a team player

• Good interpersonal communication and presentation skills

• Database internals

• High Availability

• Knowledge of clouds

• Assist developers with query tuning and schema refinement

• Experience with SQL Monitoring tools

• Strong Knowledge of SQL performance tuning

• Well-experience in database

• Being able to plan technical solutions

• Strong troubleshooting skills

• knowledge of TCP/IP

• Familiarity with the car-hailing or transportation industry is highly desirable