Job description:
Design, implement, and maintain databases, ensuring data integrity, security, and high availability.
Perform routine database maintenance tasks, such as backups, recovery, and optimization.
Monitor database performance, identify bottlenecks, and recommend improvements.
Troubleshoot and resolve database issues, working closely with development and operations teams.
Collaborate with development and operations teams to establish and enhance DevOps processes for database management.
Implement automated deployment and configuration management for databases using tools like Ansible, Chef, or Puppet.
Contribute to the development of CI/CD pipelines, ensuring smooth integration of database changes.
Work with version control systems and release management tools to track and manage database changes.
Analyze database performance metrics and proactively identify opportunities for optimization.
Optimize database configurations, queries, and indexing strategies to improve overall system performance.
Collaborate with development teams to design efficient database schemas and query patterns.
Stay up to date with emerging technologies and best practices in database performance optimization.
Implement and enforce database security measures, including access controls and data encryption.
Ensure compliance with relevant data protection regulations and industry standards.
Perform regular security assessments and vulnerability testing on databases.
Contribute to disaster recovery planning and execute recovery procedures when necessary.