DBA with DevOps Expertise

Skills

Description

● Minimum of 10+ years of professional experience in software development

● Experience as a Database Administrator, with expertise in managing and optimizing databases.

● Strong knowledge of database management systems, such as Oracle, MySQL, PostgreSQL, or MongoDB.

● Proficiency in scripting languages like SQL, Python, or PowerShell.

● Familiarity with DevOps principles, tools, and methodologies.

● Experience with configuration management tools like Ansible, Chef, or Puppet.

● Understanding of CI/CD pipelines and version control systems (e.g., Git).

● Knowledge of performance monitoring and optimization techniques for databases.

● Excellent problem-solving and analytical skills.

● Strong communication and collaboration abilities to work effectively in cross-functional teams.

Responsibilities

• ● 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.