Azure Database Administrator

**Company Description**
Eurofins Scientific is an international life sciences company, providing a unique range of analytical testing services to clients across multiple industries, to make life and the environment safer, healthier and more sustainable. From the food you eat to the medicines you rely on, Eurofins works with the biggest companies in the world to ensure the products they supply are safe, their ingredients are authentic and labelling is accurate. Eurofins is a global leader in food, environmental, pharmaceutical and cosmetic product testing and in agroscience CRO services. It is also one of the global independent market leaders in certain testing and laboratory services for genomics, discovery pharmacology, forensics, CDMO, advanced material sciences and in the support of clinical studies.

In over just 35 years, Eurofins has grown from one laboratory in Nantes, France to 62,000 staff across a network of over 1,000 independent companies in 61 countries, operating 900 laboratories. Performing over 450 million tests every year, Eurofins offers a portfolio of over 200,000 analytical methods to evaluate the safety, identity, composition, authenticity, origin, traceability and purity of biological substances and products, as well as providing innovative clinical diagnostic testing services, as one of the leading global emerging players in specialised clinical diagnostics testing.

Eurofins is one of the fastest growing listed European companies with a listing on the French stock exchange since 1997.

Eurofins IT Solutions India Pvt Ltd (EITSI) is a fully owned subsidiary of Eurofins and functions as a Global Software Delivery Center exclusively catering to Eurofins Global IT business needs. The code shipped out of EITSI impacts the global network of Eurofins labs and services.

The primary focus at EITSI is to develop the next generation LIMS (Lab Information Management system), Customer portals, e-commerce solutions, ERP/CRM system, Mobile Apps & other B2B platforms for various Eurofins Laboratories and businesses. Young and dynamic, we have a rich culture and we offer fulfilling careers.

**Job Description** Key Responsibilities**:
**1. Database Design and Development**:
Design, develop, and maintain SQL Server databases, including tables, views, stored procedures, functions, triggers, and indexes. Create and optimize logical and physical data models.

**2 T-SQL Development and Optimization**:
Write, optimize, and troubleshoot complex T-SQL queries, stored procedures, and functions for high-volume data processing and efficient data retrieval.

**3. Performance Tuning and Optimization**:
Analyze and improve database performance through query optimization, indexing strategies, database configuration adjustments, and resource utilization monitoring.

**4. Database Administration and Maintenance**:
Perform routine database administration tasks such as backups, restores, disaster recovery planning, index maintenance, and database monitoring and SQL Application Jobs maintenance.

**5. Documentation and Best Practices**:
Create and maintain comprehensive documentation for database designs, processes, and procedures. Ensure adherence to coding standards and best practices.

**6. Cloud Platform Expertise**:
Leveraging Azure services for database management, including Azure SQL Database, Azure Cosmos DB, Azure Storage, and other related services. Understanding and implementing best practices for Azure SQL Database and other Azure data services.

**Desired Skills**:

- Writing complex queries, stored procedures, functions, and triggers, along with expertise in performance tuning, indexing, and query analysis.
- Understanding relational database principles, data modeling, normalization, and schema design for efficient and scalable databases.
- Experience with Extract, Transform, Load (ETL) processes and data integration techniques, potentially using tools like Azure Data Factory or SQL Server Integration Services (SSIS).
- Database Administration and Security
- Knowledge of database security best practices, user management, backup and recovery strategies, and monitoring database health and performance.
- Azure SQL Database - In-depth understanding of Azure SQL Database, including deployment options (single database, elastic pools, Hyperscale, serverless), performance tiers, and scaling.
- Azure Data Platform Services - Familiarity with other relevant Azure data services like Azure Synapse Analytics, Azure Cosmos DB, Azure Data Lake Storage, and Azure Data Factory.
- Azure Networking and Security - Understanding of Azure networking concepts for secure database connectivity and implementing security features like firewalls, virtual networks, and private endpoints.
- Azure Tools and Management - Proficiency in using Azure Portal, Azure CLI, Azure PowerShell, and Azure Data Studio for managing and interacting with Azure SQL databases.
- Ability to monitor Azure SQL Database performance using Azure Monitor and tr