SQL Server Database Administrator

Wolfspeed Malaysia Sdn. Bhd.; Ipoh; On-site; MYR 100,000 - 167,000; Full time

Job summary

Wolfspeed Malaysia Sdn. Bhd. is seeking an experienced SQL Server DBA to install, configure, upgrade, and administer SQL Server databases including SSIS, SSAS, and SSRS in a 24x7 manufacturing environment.

You will troubleshoot performance issues, manage outages, implement monitoring, and document procedures, with on-call duties and shift flexibility required.

Qualifications

• Minimum 5 years experience with Microsoft SQL Server databases (2014–2019).
• Strong problem solving and data analysis skills.
• Able to work with limited supervision and in a team.
• Willingness to work shift schedules and on-call duties.
• Advanced T-SQL knowledge and query optimization.

Responsibilities

• Install, configure, upgrade, and administer SQL Server databases, SSIS, SSAS, and SSRS.
• Troubleshoot databases, schemas, and user accounts.
• Investigate and resolve performance issues.
• Respond to production interruptions/outages when able.
• Plan and coordinate testing of changes and new services.

Skills

Microsoft SQL Server

T-SQL

Performance tuning

Problem solving

Team collaboration

On-call duties

Tools

SSIS

SSAS

SSRS

Job description

Install, configure, upgrade, and administer SQL Server database engine, SQL Server Integration Services, SQL Server Analysis Services, and/or SQL Server Reporting Services.Troubleshoot databases, schemas, and user accountsInvestigate and resolve performance issuesRespond to production impacting interruptions/outages when able (at any time of day).Plan and coordinate testing changes, upgrades, and new services, ensuring systems will operate correctly in current and future environments.Create and maintain user facing and technical documentation for the usage and administration of the systems.Leads and participates in efforts to develop and implement processes for application and system monitoring.Responsible for problem management activities such as issue resolution and root cause analysisMaintains professional and technical knowledge by attending educational workshops; reviewing professional publications; update the team with the best in class technologies.Protects operations by keeping information confidential.This Job is Right for You if You Have (Minimum Requirements):5 Years experience working with Microsoft SQL Server databases (2014 – 2019)Passionate about problem solving and improvement, analyzing information.Self-motivated and able to work well with limited direction and supervisionAbility to work well within a team environmentDetail oriented, organized with sense of ownership of area of responsibilityFlexibility to work shift schedules and on-call duties as requiredPreferred Skills and ExperienceExperience with Microsoft SQL Server (2008 – 2019), particularly in a 24x7 manufacturing environment.Experience with SSIS, SSAS and/or SSRS.Experience working with a large-scale Virtualized Server Environment.Advanced T-SQL knowledge. Ability to understand and troubleshoot complex queries.Experience with performance tuning and query optimization.Experience working with large dataset strategies (partitioning, etc.)Experience with Availability Groups and SQL Server ReplicationThis role may require additional duties and/or assignments as designated by management.