Hiring Freelance Database Administrator

Budget

Posted: 4 year ago

Opened

Description: Here is a glimpse of what you will do:
• Responsible for creating & managing Daily, Weekly & Monthly report as well as data validation and new reports & data structure as per management requirement.
• Excellent knowledge on one or more SQL Server, MySQL with standard SQL, Create database objects such as tables, views, stored procedure, Triggers etc. and
Management and maintenance of back-ups & recovery procedures also ensure the reliability and security of databases.
• Ensure that database is properly tested and bugs are fixed appropriately with optimizing database for operational and performance efficiency
• Creating DB Schema and table audit schemas.
• Know how to avoid dirty, orphan data while running import and export jobs and queries.
• Analyze on premise transactional database environment (especially MySQL ), evaluate and plan migrations to AWS RDS.
• Understanding of MySQL replication models including statement based, row based replication.
• Perform tests and evaluations regularly to ensure data security, privacy and integrity
• Monitor database performance, implement changes and apply new patches and versions when required.
Skills:
MySQL,Reports,Databse Modelling

Source: guru.com