职位详情
国籍要求:马来西亚
职位描述
Key Responsibilities:
Install, configure, and upgrade Microsoft SQL Server database servers and related products.
Monitor database performance and implement changes to improve performance and reliability.
Perform regular database maintenance tasks such as backups, restores, integrity checks, and index optimization.
Manage database security by defining and enforcing access controls and permissions.
Troubleshoot and resolve database-related issues, including performance bottlenecks, deadlocks, and connectivity problems.
Develop and maintain database documentation, including data models, configurations, and procedures.
Collaborate with development teams to design and implement database schemas, stored procedures, triggers, and functions.
Plan and execute database migrations, upgrades, and patching activities with minimal downtime.
Implement disaster recovery plans and ensure data availability and business continuity.
Monitor and manage database storage, capacity planning, and growth forecasting.
Automate routine database tasks using scripts and tools.
Stay current with new SQL Server features, best practices, and industry trends.
Provide support for database-related audits and compliance requirements.
Familiarity with cloud platforms such as AWS, Azure is a plus.
Required Qualifications:
Bachelor’s degree in Computer Science, Information Technology, or a related field.
At least 1 year proven experience as a Microsoft SQL Server DBA or similar role.
Strong knowledge of SQL Server architecture, installation, configuration, and administration.
Proficiency in writing complex SQL queries, stored procedures, and T-SQL scripting.
Experience with database backup, recovery, and disaster recovery techniques.
Familiarity with performance tuning and optimization tools and techniques.
Understanding of database security principles and best practices.
Experience with monitoring tools such as SQL Server Management Studio (SSMS), SQL Profiler, and third-party monitoring solutions.
Knowledge of Windows Server operating systems and networking fundamentals.
Good communication & interpersonal skills.
Good problem-solving and communication skills.
Demonstrate continuous improvement mindset.
Ability to work independently and as part of a team.
Committed to learning new technologies such as PostgreSQL and MongoDB.