Buffer Offfer Ng Kf Dba

Company 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 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 POSITION TITLE ENGLISH Database Administrator REPORTING TO Gurumurti Esumane REPORTING LOCATION Bangalore WORKING LOCATION Bangalore NUMBER OF FTEs UNDER RESPONSIBILITY None 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 in-depth understanding of database management systems DBMS SQL performance tuning and high availability solutions POSITION OBJECTIVES 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 T-SQL development and will be skilled in automating DBA tasks Knowledge of backup and restore processes across on-premises 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 HA DR 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 on-premises to Azure cloud ensuring minimal downtime and data consistency Optimize database performance in the cloud environment using Azure monitoring tools and recommendations T-SQL Development Develop and optimize complex T-SQL 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 backup restore health checks and database maintenance using PowerShell and SQL Server Agent Jobs Create and maintain T-SQL 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 on-premises 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 real-time 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 third-party monitoring tools SSL Implementations Configure and manage SSL TLS 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 high-performance 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 on-call support for critical production issues troubleshooting complex SQL-related problems Work with stakeholders to gather requirements and ensure database architecture aligns with business goals EVOLUTION What we offer A launch pad into various senior management opportunities - within the many business lines of Eurofins globally - or into the management hierarchy in our different corporate functions The opportunity to grow your project management skills in a demanding fast growing organization A chance to become part of a highly motivated international team of professionals In a fast growing group successful leaders are frequently being offered increased areas of responsibility subject to geographic mobility QUALIFICATIONS AND EXPERIENCE REQUIRED Profile description Experience Minimum 5 to 6 years of experience as a SQL Database Administrator DBA with at least 1 to 2 years of experience in Azure Cloud environments Experience with T-SQL 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 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 real-time database health tracking and issue resolution Knowledge of SQL Server Agent for job management and automation Soft Skills Strong problem-solving and analytical skills with the ability to handle complex issues independently Excellent communication skills capable of collaborating with cross-functional teams and presenting complex technical concepts to non-technical stakeholders Ability to manage time efficiently and prioritize multiple tasks in a fast-paced 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 T-SQL automation and monitoring tools we encourage you to apply and join our dynamic team This is a great opportunity to work in a fast-paced innovative environment with cutting-edge technologies