BackSenior Specialist, DBA
Kuala Lumpur, Malaysia
Permanent
Duties & Responsibilities
- 1. Database Design and Implementation:
- Design, develop, and implement databases that meet the organization's requirements.
- Collaborate with software developers and system architects to ensure database designs are efficient, scalable, and optimized.
- Create and manage database schemas, tables, indexes, and views.
- 2. Database Administration and Maintenance:
- Monitor database performance, identify and resolve performance issues, and optimize database configurations for maximum efficiency.
- Perform regular backups and ensure data integrity and availability.
- Develop and implement database security policies and procedures to protect sensitive data.
- Install and configure database management systems and software updates.
- 3. Data Management and Migration:
- Manage data extraction, transformation, and loading (ETL) processes.
- Monitor and optimize data storage and access.
- Plan and execute data migration, database upgrades, and consolidation projects.
- 4. Troubleshooting and Support:
- Identify and resolve database-related problems and incidents in a timely manner.
- Collaborate with application developers and system administrators to troubleshoot issues related to database connectivity, performance, and data integrity.
- Provide technical support to end-users and assist with database-related inquiries.
- 5. Documentation and Reporting:
- Maintain accurate and up-to-date documentation of database configurations, procedures, and processes.
- Generate and analyze database performance reports and provide recommendations for improvement.
Requirements
- Bachelor's degree in computer science, information technology, or a related field. Relevant certifications on MySQL are a plus.
- Proven work experience as a Database Administrator or a similar role.
- In-depth knowledge of MySQL database management systems and their associated tools.
- Knowledge on AliCloud RDS, Polar DB and OceanBase
- Strong understanding of database design principles, data normalization, and indexing techniques.
- Proficiency in writing and optimizing SQL queries and stored procedures.
- Familiarity with database security best practices and principles.
- Experience with database performance tuning and optimization.
- Knowledge of data backup and recovery strategies.
- Excellent analytical and problem-solving skills.
- Strong communication and interpersonal skills to collaborate effectively with cross-functional teams.
- Ability to work independently and manage multiple tasks simultaneously.
- Flexibility to adapt to changing business requirements and priorities.
