Sql Server Database Administrator

In connection with the project manager, you will need to perform client data integration in a SQL Server or NoSQL MangoDb database. Solution setting is done through the interface but also by adding stored procedures or triggers to the database. In addition, editing reports from within the application is the purpose of client processes. Report template settings will need to be made from the Microsoft Visual Studio application.
After these steps, the integrator will be able to accompany the project manager during the delivery of the application for customer feedback and satisfaction.

Activities:
In collaboration with the project manager:
• Application deployment on AZURE servers
• Prepare and format customer input data
• Perform data integrations in the application databases
• Add, update, delete data in databases
• Solve problems with the database
• Add triggers or stored procedures using advanced scripts
• Embed images into the application via SQL sliders
• Make datasets using views or select
• Create reports through Visual Studio using the Cristal Report plugin
• Writing project files describing specific settings

Attributions:
• Responsible for managing UAT and PROD application servers
• Guarantee the integrity of UAT and PROD databases
• Creator and optimization of triggers and stored procedures
• Report template builder and optimization
• Responsible for improving database updating processes
• Ensures good technical monitoring of business applications
Technical and technological know-how:
• Strong knowledge of technologies (MSSQL, IIS, Visual Studio, and MangoDB)
• Be comfortable with all Microsoft tools
• Being familiar with Linux, OS, and Windows batch commands.
• Curious about new computer technologies.

Personal qualities:
• Computer skills.
• Social skills, attention to details.
• Organizational qualities to define the priorities of action and the allocation of resources.
• Ability to innovate and propose new and creative solutions.

Profile:
Bac + 2 / Bac +3 computer systems orientation maintenance
• More than 2 years experience