Aventa
Database Engineer
Client Office
Saint Quentin en Yvelines (5 days / week)
Freelance or Permanent
As soon as possible
Based on experience
Published 2 years ago
Role summary
As a Database Engineer, you will be responsible for developing and maintaining database systems and applications to support internal maintenance engineering tools.
Responsibilities and Duties
MS Access:
Creation of tables, queries, and input forms according to specifications.
Development of complex update queries.
Writing VBA code.
Performing bulk updates of data in tables from user-provided Excel files or according to specific instructions.
SQL Server:
Creation of tables, fields, and views according to specifications.
Writing stored procedures in TransactSQL.
Managing the database size (current/in 1 year): 100/180 tables; 142/250 views; 82/140 stored procedures; 28/50 scalar functions.
C# Development:
Maintenance and development of small executables (file listing, text file processing, download robots, PDF analysis, etc.).
Qualifications
Language: Fluent in English.
Experience: 5 years of experience in database development (MS Access / SQL Server).
Software: MS Access / SQL / C#.