IT Database Administrator Mid senior

extra holidays - extra parental leave
Work set-up: 
Full Remote
Contract: 
Experience: 
Mid-level (2-5 years)
Work from: 

Offer summary

Qualifications:

Over 6 years of experience managing SQL Server databases., Proficiency in T-SQL development, performance tuning, and troubleshooting., Experience with Azure SQL Database, Azure Managed Instance, and cloud migrations., Strong scripting skills with PowerShell for automation and routine tasks..

Key responsibilities:

  • Manage and maintain SQL Server databases across multiple environments.
  • Perform routine database maintenance, backups, restores, and performance monitoring.
  • Implement high availability, disaster recovery, and security measures for databases.
  • Automate routine DBA tasks and support database migrations to Azure cloud.

Eurofins BioPharma Product Testing Ireland Ltd logo
Eurofins BioPharma Product Testing Ireland Ltd SME http://www.eurofins.ie
201 - 500 Employees
See all jobs

Job description

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 our environment safer, healthier and more sustainable. From the food you eat, to the water you drink, to the medicines you rely on, Eurofins laboratories work with the biggest companies in the world to ensure the products they supply are safe, their ingredients are authentic and labelling is accurate.

The Eurofins network of companies believes that it is a global leader in food, environment, pharmaceutical and cosmetic product testing and in discovery pharmacology, forensics, advanced material sciences and agroscience contract research services. It is also one of the market leaders in certain testing and laboratory services for genomics, and in the support of clinical studies, as well as in biopharma contract development and manufacturing. It also has a rapidly developing presence in highly specialised and molecular clinical diagnostic testing and invitro diagnostic products.

The groups key figures are approximately: Turnover of 6.5 billion euros, more than 940 laboratories in 62 countries and around 62,000 employees.

Job Description

SUMMARY OF POSITION AND OBJECTIVES:
The Database Administrator is responsible for the design, installation, configuration, upgrading, and maintenance of databases. They ensure the smooth running of database systems by optimizing performance, performing regular backups, and managing database security. The role requires an indepth understanding of database management systems (DBMS), SQL, performance tuning, and high availability solutions.

Job description:

We are seeking an experienced SQL Database Administrator (DBA) with over 6 years of experience in managing, maintaining, and optimizing SQL Server databases. The ideal candidate will possess a deep understanding of SQL Server, Azure Cloud environments, TSQL development, and will be skilled in automating DBA tasks. Knowledge of backup and restore processes across onpremises and cloud environments, Change Data Capture (CDC), Job monitoring, and monitoring tools like Grafana and SolarWinds is highly desirable.

Key Responsibilities:

  • Database Administration:
    • Manage and maintain SQL Server databases across multiple environments (development, staging, production) ensuring high availability, scalability, and security.
    • Perform routine database maintenance tasks such as backups, restores, reindexing, and monitoring database performance.
    • Implement and manage database replication, clustering, Always On availability groups, and other HADR strategies.
    • Ensure database security by managing access permissions, roles, and implementing security best practices.
      • Azure Cloud Management:
        • Administer SQL Server instances hosted on Azure SQL Database, Azure SQL Managed Instance, and Azure Virtual Machines.
        • Implement and manage database migrations from onpremises to Azure cloud, ensuring minimal downtime and data consistency.
        • Optimize database performance in the cloud environment, using Azure monitoring tools and recommendations.
          • TSQL Development:
            • Develop and optimize complex TSQL queries, stored procedures, and functions to meet business requirements.
            • Troubleshoot and resolve performance issues in complex queries and database workloads.
            • Design and implement database schema changes, indexes, and other structures to support efficient data storage and retrieval.
              • Automation of Repetitive DBA Tasks:
                • Automate routine DBA tasks, including backuprestore, health checks, and database maintenance using PowerShell and SQL Server Agent Jobs.
                • Create and maintain TSQL scripts for automating tasks related to data migration, database optimization, and health monitoring.
                  • Backup and Restore Operations:
                    • Perform and automate backup and restore processes between onpremises and cloud (Azure) databases, ensuring reliable disaster recovery mechanisms and testing recovery procedures.
                      • Change Data Capture (CDC):
                        • Implement and manage CDC (Change Data Capture) to track changes in the database for auditing, data synchronization, and realtime reporting.
                          • Job Monitoring and Alerts:
                            • Set up monitoring and alerting for SQL Server jobs and system health, ensuring proactive identification and resolution of potential issues.
                            • Monitor job execution and performance using SQL Server Agent, Grafana, SolarWinds, and other thirdparty monitoring tools.
                              • SSL Implementations:
                                • Configure and manage SSLTLS encryption for SQL Server instances to secure data in transit between servers and clients.
                                  • Performance Tuning & Optimization:
                                    • Continuously monitor database performance, identifying bottlenecks, and applying optimizations to ensure highperformance queries and data access.
                                    • Use execution plans, indexing, and other techniques to tune SQL Server for efficiency.
                                      • Collaboration & Support:
                                        • Collaborate with development teams to ensure database designs support application requirements.
                                        • Provide oncall support for critical production issues, troubleshooting complex SQLrelated problems.
                                        • Work with stakeholders to gather requirements and ensure database architecture aligns with business goals.

                                            • Qualifications

                                              QUALIFICATIONS AND EXPERIENCE REQUIRED:

                                              • Experience:
                                                • Experience with TSQL development, including writing complex queries, stored procedures, and functions.
                                                • Proven experience in SQL Server performance tuning, optimization, and troubleshooting.
                                                • Expertise in Azure SQL Database and Azure SQL Managed Instance deployments, migrations, and management.
                                                  • Technical Skills:
                                                    • English Language is mandatory to collaborate in a global environment, including writing, speaking and presenting.
                                                    • Deep understanding of SQL Server architecture, including high availability and disaster recovery solutions.
                                                    • Experience with PowerShell scripting for automating DBA tasks such as backups, database health checks, and job monitoring.
                                                    • Experience with Change Data Capture (CDC) for tracking changes in the database.
                                                    • Proficiency in setting up and configuring SSIS and SSRS for SQL Server data communications.
                                                    • Familiarity with monitoring tools like Grafana, SolarWinds, and Azure Monitor for realtime database health tracking and issue resolution.
                                                    • Knowledge of SQL Server Agent for job management and automation.
                                                      • Soft Skills:
                                                        • Strong problemsolving and analytical skills, with the ability to handle complex issues independently.
                                                        • Excellent communication skills, capable of collaborating with crossfunctional teams and presenting complex technical concepts to nontechnical stakeholders.
                                                        • Ability to manage time efficiently and prioritize multiple tasks in a fastpaced environment.
                                                            • Desired Qualifications:

                                                              • Microsoft Certified: Azure Database Administrator Associate or Microsoft Certified: Azure Solutions Architect Expert.
                                                              • Experience with SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS).
                                                              • Familiarity with database version control and deployment tools (e.g., Devops, Visual Studio,SSMS).
                                                              • If you are an experienced SQL DBA with strong expertise in Azure Cloud, TSQL, automation, and monitoring tools, we encourage you to apply and join our dynamic team. This is a great opportunity to work in a fastpaced, innovative environment with cuttingedge technologies.
                                                                • Additional Information

                                                                  Working hours:

                                                                  Monday to Friday 08:00 to 17:00 Hybrid Work

Required profile

Experience

Level of experience: Mid-level (2-5 years)
Spoken language(s):
English
Check out the description to know which languages are mandatory.

Other Skills

  • Time Management
  • Communication
  • Problem Solving

Database Administrator Related jobs