LMA Kuala Lumpur, Malaysia Posted 3 days ago Permanent RM15k - RM25k
Responsibilities
Designs, Develops, Maintains and Supports MS SQL database, procedures, packages, functions.
Conducts root cause investigations and provide recommendations for preventative measures and database performance optimization. Proactively address gaps with existing support processes, documentation, etc. and prioritize accordingly
Develops and documents processes, procedures, and best practices
Provides regular status, operational, incident, and change reports
Performs other duties as assigned
Requirements
Minimum 10+ years of experience as SQL developer in Microsoft SQL Server.
Strong skills in SQL programming tasks including creating view, procedures, function and packages.
Strong understanding and hands-on experience with optimizing database performance including analyzing SQL queries, reviewing execution plans, implementing appropriate indexing
Understanding of isolation levels in SQL Server and strategies to prevent deadlocks
Strong understanding of scripting fundamentals such as Shell, SQL, PL/SQL, PowerShell
Strong ability to automate and maintain automation for core job functions
Strong knowledge of application/data security best practices
Strong oral and written communication skills demonstrating ability to share and impart knowledge
Ability to quickly adapt to new methods, work under tight deadlines and stressful conditions.
Strong investigative, analytical and problem-solving skills
Strong ability to set goals and handle multiple tasks, clients, and projects simultaneously; Ability to appropriately balance priorities, deadlines, and deliverables
Ability to work well within a team environment and participate in department/team projects
Since 1999, LMA Recruitment has been providing leading businesses across the APAC, UK, Europe and ANZ with award winning recruitment services. Our con...
Boost your career
Find thousands of job opportunities by signing up to eFinancialCareers today.
Get a free, confidential review from a resume expert.