Job Description

Responsibilities * Responsible for implementation and performance of critical SQL Server RDBMS for MES * and related systems * Work closely with application development team to ensure appropr Responsibilities Responsible for implementation and performance of critical SQL Server RDBMS for MES and related systems Work closely with application development team to ensure appropriate and efficient SQL Perform tuning for queries, design indexes, monitor and optimize performance Investigate, analyze, and resolve database related issues Support periodic SQL patch, upgrade and migrationPerform database purging and collaborate with data owner to define the purging policy for each individual system, database re-indexing and database tuning Build, setup, and manage data pipeline in Azure Synapse Analytic and SQL data warehouse databases Ensure data pipelines and data stores are high-performing, efficient, organized, and reliable Collect, manage, and transform data into usable information for building business analytic and machine learning solutions Collaborate with various stakeholders to understand and provide data requirementsCreate reports and dashboards to support various stakeholders' analytic requirements Install, configure, and administer analytic application servers, such as SSRS reporting services and Tibco servers Plan and create suitable environment for data science workloads Run experiments, train, manage, optimize, and deploy machine learning models into production Prioritize, manage, and successfully complete multiple projects with minimal supervision from manager Requirement . Degree in Computer Science / Information Technology or equivalent with MS SQL Server DBA certification preferred . Expertise in Microsoft SQL Server and Reporting Services . Expertise in any cloud architecture (Azure) . Solid working experience as a MS SQL Database Administrator . Solid working experience with database partitioning design, data warehouse, database design and coding, performance tuning and optimization, database errors diagnostic and troubleshooting, and database access management . Solid working experience in SQL queries optimization, writing efficient functions, stored procedures and complex SQL queries is needed . Proven working experience in Azure Synapse Analytics and Azure Machine Learning platforms . Proven working experience in developing and operationalize Azure data pipelines and machine learning models . Hands-on experience with database standards and end user applications . Excellent knowledge in Database installation, configuration on Windows/Azure platforms . Excellent knowledge of data backup, recovery, security, integrity in MS SQL