Database Administrator

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.

**ESSENTIAL DUTIES AND RESPONSIBILITIES**:

- Responsible for implementation and performance of critical SQL Server RDBMS for MES and related systems
- 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
- 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 mínimal 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.
**ADDITIONAL RESPONSIBILITIES**:

- Provide cross-functional leadership and equipment's vendor interaction to troubleshoot, analyze and develop solution
- Work with service desk and third-party solutions vendor to resolve on the disrupted service and rectify the database issues promptly to minimize business impact
- Assist the Operations and Project Lead on the issues related to database in daily operations or new projects implementation
- Involve in write-up of RDBMS system specifications
- Demonstrated ability to manage technical teams
- Independent and self-motivated
- Strong communication and presentation skills with the ability to influence stakeholders

**REQUIRED QUALIFICATIONS AND SKILLS:
Technical/ Professional:

- 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
- 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
- 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.

Technological:
**Industry 4.0**
- Digitization and automation of operational activities
- Collecting and analyzing via Azure Synapse Analytics
- Building tools to automate data collection
- Developing prediction systems and machine learning algorithms

General:

- Ability to break down problems and gain understanding to make effective decisions.
- Innovative, motivated, team player and a quick learner
- Attention to detail, curiosity, and passion for technology
- Ability to establish clear, measurable goals and deliver o