SQL Server Developer DBA
- Kuala Lumpur
- Permanent
- Full-time
- Administer and maintain SQL Server databases in both development and production environments
- Develop, optimize, and troubleshoot T-SQL queries, stored procedures, and functions. Help write and optimize in-application SQL statements
- Collaborating with cross-functional teams to gather requirements and implement solutions. Creating and maintaining database documentation
- Strong experience in Database Migration, Import/Export and ETL. Implement database security and ensure compliance with company policies.
- Perform database backup and recovery tasks. Administrative and configuration on SSRS (SQL Server Reporting Services), and SSIS (SQL Server Integration Services).
- Assist with database design, indexing, and optimization for better performance. Monitor database health, jobs, and performance using SQL Server tools.
- Collaborate with developers to ensure smooth integration of database solutions. Troubleshoot and resolve database connectivity and performance issues.
- Knowledge of replication, mirroring, and clustering for high availability. Follow Change Management processes to implement database configuration changes
- Follow Problem Management processes to troubleshoot and resolve recurring issues .Proactively monitor and respond to MSSQL database Alerts. Knowledge of Powershell will be advantageous
- 4-6 years of experience in SQL Server database administration and development.
- Strong knowledge of T-SQL, stored procedures, triggers, and functions. Proficiency in writing complex queries.
- Experience with SQL Server 2016 and above.
- Hands-on experience with SSIS.
- Familiarity with backup strategies, recovery models, and performance tuning.
- Basic understanding of indexing, query optimization, and execution plans.
- Strong analytical and problem-solving skills.
- Ability to work independently and in a team-oriented environment.
- Excellent communication skills.