Mô tả công việc
Key Responsibilities:
-
Database Administration & Management:
-
Install, configure, optimize, and manage our database management systems (e.g., SQL Server, PostgreSQL, MySQL, Oracle).
-
Design and implement robust backup and recovery procedures to ensure data availability and prevent data loss.
-
-
Performance & Security:
-
Monitor system performance, analyze query execution plans, and perform query optimization (indexing, refactoring) to ensure high-speed data access.
-
Manage user access control, implement security policies, and monitor database logs to protect sensitive information.
-
-
Support & Troubleshooting:
-
Collaborate with software development teams to design efficient database structures, write scripts, and create stored procedures.
-
Act as the first line of defense for database-related issues, troubleshooting system errors, slow queries, and service interruptions.
-
Ensure data integrity by managing constraints, implementing normalization, and controlling data redundancy.
-
Qualifications:
-
Experience: 1-3 years of hands-on experience in a DBA or similar data-focused role.
-
Education: Bachelor‘s degree in Computer Science, Information Systems, or a related technical field.
-
Technical Skills:
-
Strong proficiency in SQL is a must (complex queries using SELECT, JOIN, GROUP BY, Window Functions, CTEs).
-
Solid experience with database administration, including performance tuning (indexing, query plans), and transaction management.
-
Good understanding of relational database models (ERD, normal forms).
-
Certifications (MCSA SQL, Oracle DBA, etc.) are a strong plus.
-
-
Soft Skills:
-
Logical and analytical mindset with strong problem-solving abilities.
-
Excellent collaboration skills to work effectively with developers and analysts.
-
Ability to produce clear technical documentation.
-