Your responsibility as a database administrator will be the performance, integrity and security of databases and ensure that the databases run efficiently and securely. You'll be involved in the planning and development of the database, as well as in troubleshooting any issues on behalf of the users.
Key Duties and Responsibility:
monitor performance and manage parameters to provide fast responses
map out the conceptual design for a planned database
refine the logical design so that it can be translated into a specific data model
further refining the physical design to meet system storage requirements
install and test new versions of the database management system (DBMS)
write database documentation, including data standards, procedures and definitions for the data dictionary (metadata)
control access permissions and privileges
develop, manage and test back-up and recovery plans
ensure that storage and archiving procedures are functioning correctly
carry out capacity planning
work closely with IT project managers, developers
communicate regularly with technical, applications and operational staff to ensure database integrity and security
manage the security and disaster recovery aspects of databases
Requirements:
2 years experience covering MySQL/PostgreSQL database administration experience.
Expert/Familiar with Mysql Database 8.x - Performance Tuning - Familiarity with waits and Events
Expert/Familiar with Postgresql administration.
Expert/Familiar with Proxysql.
Expert/Familiar with PMM.
Hands on bash scripting/python or any other programming languages.
Good knowledge of data retention policy and data archiving.
Good knowledge of backup and recovery and related tools.
معرفی شرکت
Snapp Grocery, the largest online supermarket holding company in Iran, encompasses a range of diverse services in the supermarket industry. These services include Snapp Market!, our online supermarket service offering scheduled delivery, Snapp Express!, our fast delivery online supermarket service, Smart!, our online chain supermarket service (Dark Store), and Snapp Market Pro!, our wholesale supply service. These services have been designed and implemented with the aim of integrating operations, creating synergies, and providing a better shopping experience for our users.
The organization's core values lie in intelligence, dynamism, and reliability in delivering online supermarket services, driven by a team of over a thousand dedicated professionals.