Database Administrator

Snapp Market Tehran

Posted Over a month ago

Job Description

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:

  • 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 backup and recovery plans.
  • Ensure that storage and archiving procedures are functioning correctly.
  • Carry out capacity planning.
  • Work closely with IT project managers, and 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 of experience covering MySQL/PostgreSQL database administration experience.
  • Familiar with MySQL Database 8, and performance tuning
  • Familiarity with waits and events
  • Familiar with PostgreSQL administration.
  • Familiar with ProxySQL.
  • 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.

Employment Type

  • Full Time

Details

To see more jobs that fit your career