Senior Database Developer

Core Responsibilities:

• Performance Tuning and Optimization: Analyze and improve database performance through query optimization, indexing strategies, database configuration adjustments, and resource utilization monitoring.
• 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.
• Database Maintenance: Maintain SQL Server databases, including tables, views, stored procedures, functions, triggers, and indexes. Create and optimize logical and physical data models.
• 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.
• Documentation and Best Practices: Create and maintain comprehensive documentation for database designs, processes, and procedures. Ensure adherence to coding standards and best practices.
• Cloud Platform Expertise: Leveraging Azure services for database management, including Azure SQL Database, Azure Storage, and other related services. Understanding and implementing best practices for Azure SQL Database and other Azure data services.

This role contributes to maintaining and optimizing critical database systems that support Eurofins' operations, ensuring data integrity, performance, and security for their scientific testing and laboratory services.

Required Skills and Experience:

• 5-8 years of experience in database development and administration
• Expertise in performance tuning, indexing, query analysis, and maintaining complex queries, stored procedures, functions, and triggers
• Understanding of relational database principles, data modeling, normalization, and schema design for efficient and scalable databases
• Ability to monitor Azure SQL Database performance using Azure Monitor and troubleshoot database-related issues within the Azure environment
• Knowledge of database security best practices, user management, backup and recovery strategies, and monitoring database health and performance
• In-depth understanding of Azure SQL Database, including deployment options (single database, elastic pools, Hyperscale, serverless), performance tiers, and scaling
• Proficiency in using Azure Portal, Azure CLI, Azure PowerShell, and Azure Data Studio for managing and interacting with Azure SQL databases

Good to have:

• Experience with Extract, Transform, Load (ETL) processes and data integration techniques, potentially using tools like Azure Data Factory or SQL Server Integration Services (SSIS)
• Familiarity with other relevant Azure data services like Azure Synapse Analytics, Azure Data Lake Storage, and Azure Data Factory
• Understanding of Azure networking concepts for secure database connectivity and implementing security features like firewalls, virtual networks, and private endpoints

Eurofins is a global leader in bioanalytical testing, providing a comprehensive range of testing and support services to the pharmaceutical, food, environmental, and consumer products industries.