About Trace One
Trace One is a global leader in PLM and Compliance solutions within the process manufacturing and retail CPG space. With more than 30 years of industry expertise, we deliver innovative and scalable solutions that support the entire product manufacturing lifecycle and equip our customers to thrive in new markets. Serving more than 9,000 brand owners worldwide, Trace One is committed to delivering the best in every aspect of business, including solutions, data standardization and access, customer success and social and environmental responsibility.
Context
Working in the Management Information Systems (MIS) department, the mission is to, in an international and multicultural environment:
- Manage and administer the company's data management systems
- Ensure consistency, quality and security of databases and data
- Collaborate with the Professional Services and Engineering teams
Mission
- Design and specify the parameters and architecture of the database in conjunction with the IT architect (structure, parameters, modeling)
- Administer SQL servers (data quality monitoring, service level monitoring, user access and security management)
- Deal with performance issues
- Improve existing systems: rationalization, monitoring, industrialization, automation
- Contribute to projects: migration to the Cloud, dockerization of database services
- Manage evolutions, migrations and backups
- Update operating documents
- Provide technical support to users and development teams
- Provide DBA expertise and actively contribute to the resolution of incidents
- Guarantee the confidentiality, integrity and availability of data to internal and external users
- Ensure a technical watch
Skills:
- Fluent English
- In-depth knowledge of Microsoft SQL Server
- Knowledge of best practice for installing SQL Server instances in a VMWare virtualised environment (RDM, VMDK) with a SAN storage space
- Experience of installing, configuring and cloning a SQL instance on a physical or virtualised platform
- Mastery of the Transact-SQL language
- Knowledge of SSIS/ SSRS/ SAAS/ MDS
- Knowledge of the different backup and restore strategies and their implementations
- Knowledge of SQL Server high availability (Cluster, Alwayson) and replication
- Know how to optimize the functioning of an instance and its databases
- Easy communication with development teams
- Demonstrated ability to work in project mode
Technical Requirements:
- SQL Server
- RavenDB or another NoSQL database
- MySQL would be a plus
- SQL on Google Cloud Platform would be a plus but not required
- Experience with a SQL upgrade in production would be desirable
- Have knowledge of Cloud database services: docker, K8s.
Personal skills:
- Agile
- Curious
- Available for work
- Ability to analyze
- Relational quality
- Ability to grasp / increase competence on new technical or functional projects
- Listening, understanding of product issues and facilitator: "Problem Solver"
- Written and oral communication
- Priority and time management
Education / Experience:
- Engineering school or Master in Engineering
The group TraceOne is an equal opportunities employer.
If you recognize yourself in this offer, don't hesitate any longer and send us your application!
