Endress+Hauser is a family run business and a global leader in measurement instrumentation, services and solutions for industrial process engineering. We employ over 15,000 people globally and place a strong emphasis on the employee experience. Our brand belongs to EveryONE and our values of Commitment, Excellence, Sustainability & Friendliness, underpin everything we do and how we interact with our customers, employees and colleagues. We want all our employees to understand the contribution of their role to the Endress+Hauser Group and feel part of ONE team.
The Database Administrator will support the Global Logistics Operations Center (G-LOC) and Corporate Logistics for the Transportation Management System (TMS) software and all interconnecting systems. This role will maintain and manage the Data Warehouse in order to support the analytics team as they create critical reports for the business.
Roles + Responsibilities
Operational tasks related to the data warehouse: performance tuning, database security, back-up, and so on
Close collaboration with the business teams to understand business challenges and find solutions through well considered building and maintenance of the Data Warehouse
Ability to work with data analytics team to understand and develop reports to measure success of business processes and identify areas to improve
Planning for and allocating the database system’s physical requirements, such as memory, disk space, network requirements, etc.
Modifying the database structure using information provided by application developers
Creating users’ profiles and ensuring system security by careful allocation of user permissions
Ensuring compliance with database vendor license agreement, including number of installations, and taking care of licensing renewals
Creating a backup and recovery strategy for the database, and regularly testing the backups to ensure usability
Monitoring technical support for both database systems and related applications
Creating reports by querying from database (as per need). These reports can be in the form of pre-formatted reports using the application frontend, or custom-made ad hoc reports by the database administrator
Monitoring and optimizing the database’s performance using either manual or automated tools
Migrating database instances to new hardware and new versions of software from on premise to cloud based databases and vice versa
Have an ability to analyze, propose and develop new processes and procedures to improve how it works to support the TMS’s ongoing evolution
Any other duties commensurate with your skills and experience and as requested by your manager
Qualification + Profile
Bachelor in IT systems, Computer Science. Mathematics, Physics (or other exact sciences) supported with several years of experience as a Database Warehouse and/or in relevant professional experience
Excellent working knowledge of relational database systems like SQL Server, PostgreSQL, MySQL
Proven analytical and problem-solving experience to develop robust and feasible data models with ability to abstract and think analytically
Experience monitoring data and implementing improvements to the design of the system
Solution focused with proven ability to problem solve and operate at pace and with a sense of urgency
Availability to travel internationally
Benefits + Perks
We offer you a start-up character and at the same time the security of an internationally active, successful family business
High culture diverse team, enhancing your multi-cultural expertise
We attach great importance to the personal and professional development of our employees, such as trainings and continuing education in Logistics, Digitalization and Continuous Improvement