استخدام Database Administrator
شرح موقعیت شغلی
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 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.
مهارتهای مورد نیاز
- Databases
- Sql Server
- پایگاه داده
- SQL
حداقل سابقه کار
- کمتر از سه سال
جنسیت
- مهم نیست
وضعیت نظام وظیفه
- مهم نیست