Database Administrator (DBA)

وصف الوظيفة

Key Responsibilities:

  1. 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.
  2. 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.
  3. 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.
  4. 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.
  5. 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.
  6. 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.
  7. 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.

وظائف مشابهة