Job Description:
The Database Operations (DBOps) Engineer will be responsible for the maintenance, optimization, and high-availability implementation of our database systems, including MSSQL, MySQL, and PostgreSQL. The candidate will ensure the performance, security, and scalability of our database infrastructure across both on-premises and cloud environments (Azure and AWS).
Responsibilities:
- Administer, monitor, and support MSSQL clusters, as well as MySQL and PostgreSQL databases, ensuring their performance, availability, and security.
- Implement and manage high-availability and disaster recovery solutions for database systems.
- Conduct regular database maintenance tasks, including backups, indexing, and cleanup to ensure optimal performance.
- Optimize database systems for maximum efficiency and minimal downtime, using advanced performance tuning strategies.
- Collaborate with development teams to advise on database design, query optimization, and best practices for database usage.
- Manage database migrations and upgrades, ensuring smooth transitions with minimal impact on operations.
- Monitor database systems to identify and resolve issues proactively, implementing monitoring tools and alerts as necessary.
- Work with cloud services (Azure and AWS) to deploy and manage database solutions in the cloud, leveraging PaaS and IaaS offerings.
- Document database configurations, procedures, and changes to maintain a clear understanding of the environment.
Qualifications:
- Minimum of 5 years of experience in database administration, specifically managing MSSQL clusters, with a strong background in MySQL and PostgreSQL.
- Proven experience in database optimization, performance tuning, and high-availability implementations.
- Familiarity with both on-premises and cloud-based database deployments, including Azure and AWS.
- Proficient in database backup and recovery methodologies.
- Strong understanding of database security best practices and experience in implementing security measures.
- Excellent problem-solving skills and the ability to work independently or as part of a team.
- Effective communication skills, with the ability to document and explain technical details clearly.
Desired Skills:
- Certifications in Azure and/or AWS, with specific focus on database services, are a significant advantage.
- Familiarity with DevOps practices and tools, and their application to database operations.