Database Administrator (DBA)

Job Summary

The Database Administrator (DBA) is responsible for maintaining the database environment, ensuring it operates smoothly 24/7. The goal is to provide a seamless flow of information throughout the company, enhancing both backend data structure and frontend accessibility for end-users.

Responsibilities

• Build database systems of high availability and quality based on end-users' specialized roles.
• Design and implement databases according to end-users' information needs and views.
• Define user roles and enable data distribution in an appropriate format and timely manner.
• Utilize high-speed transaction recovery techniques and ensure robust data backups.
• Profile server resource usage, optimizing and tweaking performance as necessary.
• Troubleshoot and resolve production database issues promptly.
• Ensure the performance, security, and availability of databases.
• Manage parameters to provide fast query responses.
• Liaise with database programmers and IT project managers for collaborative projects.
• Protect databases from threats and unauthorized access, recommending improvements for better protection.
• Design and optimize complex SQL queries, indexes, and stored procedures to improve efficiency.
• Stay informed about trends and developments in database administration.
• Monitor system performance, identifying and addressing potential problems.
• Provide proactive and reactive data management support and training to users.
• Define, enforce, and document database policies, procedures, and standards.
• Conduct regular tests and evaluations to ensure data security, privacy, and integrity.
• Monitor database performance, implementing changes and applying patches and new versions as required.
• Understand MySQL’s underlying storage engines, such as InnoDB and MyISAM.
• Design, implement, and monitor disaster recovery plans for the production database environment.

Qualifications

• Strong proficiency in MySQL database management and cloud technologies.
• Knowledge of PostgreSQL database concepts is a plus.
• Minimum of 3+ years of experience in MySQL database implementation and operations.
• Hands-on experience with MySQL database standards and end-user applications.
• Excellent knowledge of data backup, recovery, security, integrity, and SQL.
• Familiarity with database design, documentation, and coding practices.
• Previous experience with DBA case tools (frontend/backend) and third-party tools.
• Strong problem-solving skills and the ability to think algorithmically.
• A degree in a related computer discipline or relevant certification.

Preferred Skills

• Knowledge of additional database management systems beyond MySQL and PostgreSQL.
• Experience with performance tuning and optimization techniques.

Experience

• At least 3+ years of relevant experience in MySQL database management and operations.