وصف الوظيفة
Key Responsibilities:
- Database Administration and Support:
- Manage and maintain MySQL, Postgres, MongoDB, Redis, and MS SQL databases.
- Monitor, troubleshoot, and resolve database-related issues to ensure high availability, performance, and security.
- Implement database backups, recovery, and disaster recovery strategies for MySQL, Postgres, MongoDB, Redis, and MS SQL.
- Database Performance Optimization:
- Perform performance tuning on MySQL, Postgres, MongoDB, Redis, and MS SQL databases by analyzing query performance, indexing, and executing optimization techniques.
- Develop and maintain scripts and tools for automating database performance monitoring.
- Database Security and Compliance:
- Implement security measures for all database platforms (including MySQL, Postgres, MongoDB, Redis, and MS SQL) to protect sensitive data and ensure compliance with organizational policies and regulations.
- Set up user access controls and permissions across all database platforms.
- Database Design and Architecture:
- Participate in the design, implementation, and management of MySQL, Postgres, MongoDB, Redis, and MS SQL database schemas to support application and business requirements.
- Work with application developers to design and implement scalable, high-performance database systems.
- Database Migration and Upgrades:
- Lead and support database migration initiatives involving MySQL, Postgres, MongoDB, Redis, and MS SQL, including upgrading databases to newer versions and ensuring minimal disruption.
- Plan and execute data migration, replication, and synchronization across different database environments.
- Troubleshooting and Incident Management:
- Provide expertise in diagnosing and resolving database issues, including slow queries, data inconsistencies, and downtime.
- Work closely with cross-functional teams to resolve incidents and minimize database-related disruptions.
- Documentation and Reporting:
- Maintain comprehensive documentation related to MySQL, Postgres, MongoDB, Redis, and MS SQL database configurations, procedures, and troubleshooting steps.
- Provide regular reports on database performance, backups, and other key metrics.
متطلبات الوظيفة
- Minimum 4 years of experience in database administration.
- Proficiency with MySQL, Postgres, MongoDB, Redis, and MS SQL.
- Strong understanding of database backup, recovery, and disaster recovery strategies.
- Solid experience in database performance tuning and optimization for large-scale environments.
- Knowledge of security protocols and best practices for MySQL, Postgres, MongoDB, Redis, and MS SQL databases.
- Ability to work under pressure, managing multiple priorities while ensuring high-quality database availability and security.
- Excellent troubleshooting skills and ability to resolve complex database issues.
- Familiarity with scripting languages such as Python, Bash, or PowerShell for automation.
Preferred Qualifications:
- Database certification (e.g., MySQL Certified DBA, Microsoft Certified: Azure Database Administrator, etc.).
- Experience with cloud-based database solutions and architecture (e.g., AWS RDS, Google Cloud SQL, Azure SQL).
- Familiarity with NoSQL data models and optimization techniques for MongoDB and Redis.