Job Description

We are seeking a highly motivated and detail-oriented Database Administrator (DBA) with 1+ year of hands-on experience in database management to join our growing team. The ideal candidate will possess a strong understanding of MySQL, Cassandra, and MongoDB, with practical experience in AWS. You will play a key role in ensuring our databases run efficiently, securely, and remain highly available.

About the Role - As a DBA, you will be responsible for designing and maintaining robust database architectures, optimizing performance, managing backups and recovery processes, and ensuring overall database health. The successful candidate will be proactive in solving performance issues, ensuring data integrity, and recommending solutions to enhance database efficiency.

Responsibilities:

• Design and create database objects, including tables, stored procedures, views, triggers, and reports.
• Oversee database administration, configuration, maintenance, and support for MySQL, Cassandra, and MongoDB.
• Perform data migration, backup, restore, and recovery tasks; troubleshoot and resolve blocking and deadlock.
• Optimize database performance by monitoring queries, identifying bottlenecks, and implementing query optimization strategies.
• Manage database partitioning, replication, and migration processes to ensure data consistency and high availability.
• Research and make recommendations on new database products, services, protocols, and standards to support business needs.
• Collaborate with technical teams to design and develop relational and secondary databases while identifying inefficiencies and proposing improvements.
• Diagnose and resolve database access and security issues to ensure data integrity and compliance.
• Set up alerts and notifications for database issues, such as system errors, insufficient resources, and fatal errors.
• Manage databases with large-scale data (1+ TB) and ensure scalability and performance.

Qualifications:

• Bachelor’s degree in Computer Science or related field, or proper DBA certification.
• Minimum of 1+ year of experience working as a Database Administrator.
• Proficiency in MySQL, Cassandra, and MongoDB.
• Working knowledge of AWS (Amazon Web Services) for database management and support.
• Strong understanding of database architecture, administration, and optimization techniques.
• Experience with data migration, backups, restores, and troubleshooting performance issues.
• Ability to work with large-scale databases (over 1 TB) and manage database partitioning and replication.
• Excellent problem-solving skills with a focus on database performance tuning and query optimization.
• Knowledge of database security practices and experience in resolving access and security issues.
• Ability to work collaboratively with technical teams and provide database recommendations for improvements.

Preferred Skills:

• Familiarity with database monitoring tools and alert configurations.
• Experience in troubleshooting and resolving database access issues in a multi-cloud environment.
• Exposure to additional database technologies and automation tools.