Job Type(s): Permanent, Full Time
Timing/Shift: 5 Day Week, Shifts
Industry: Building & Construction, Manufacturing
Job Type(s): Permanent, Full Time
Timing/Shift: 5 Day Week, Shifts
Industry: Building & Construction, Manufacturing
Singapore
Bachelor's Degree
Senior Executive
6 Years Experience
Travel to office
6 Years Experience
Travel to office
This is predominantly Senior Engineer role work under Production System & Development. You will be part of a team by implementing and supporting critical SQL Server RDBMS for MES and related systems. This role will also lead data platform to be relevant in current Technology (Industry 4.0). You will be providing database, data, and analytic related supports to production systems and throughout system development lifecycle. You will be responsible to build data pipelines and platforms to support business decisions making. In addition, you will be responsible to plan and create suitable environment for data science workloads and to train, deploy and operationalize machine learning solutions.
• 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 migration
• Perform 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 requirements
• Create 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
• This position is required to do occasional business travels and requires the ability to work and stay in Jamnagar of Gujarat, India for at least 1 year, due to expansion plans.
• Technical Degree E.g. 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
• Experience of SSRS report creation, MYSQL and PostgreSQL
• Sense of ownership and pride in your performance and its impact on company’s success
• Critical thinker and problem-solving skills
• Ability to communicate complex data in a simple, actionable way
• Good time-management skills
• Great interpersonal and communication skills
o Preferred:
• Minimum 6-10 years of working experience as database administrator in any IT Systems / Manufacturing Execution System (MES)
• Must involve at least in full SDLC.
• Experience of process automation solutions is a plus.