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.
