Database Developer

At Optel, database developers don't just write queries ! They participate in all phases of development, from design to implementation, offering innovative solutions to software challenges in a collaborative Agile environment. To ensure the delivery of high performance code, OPTEL is looking to add to its team a database developer  that will be responsible for developing, testing, improving and maintaining new and existing databases. More specifically, the main responsibilities are to:

• Build effective, usable database environments to support business applications
• Work with the application development team to ensure that appropriate and efficient SQL is being coded and tested
• Ensure all database programs meet company and performance requirements
• Translate the logical data model into a physical database implementation
• Ensuring the integration and automation of DBA tasks as part of the DevOps pipeline.
• Act as a database reference for the development team to improve applications and establish best practices (coverage, automation, integration, security, etc)
• Research and suggest new database products, services and protocols
• Assist the development team with the investigation of automated test failures with respect of SOC2 policies 
• Identifies database performance opportunities and optimizes stability issues (monitoring, maintenance, reporting, etc)
• Propose new tools and working methods to continuously improve
• Participate in team activities and make your contribution!

Requirements

• University degree or relevant studies with significant experience as a database developer and/or DBA
• Knowledge of software development and software development life cycle
• In-depth understanding of data management (e.g. permissions, recovery, security and monitoring) 
• Strong knowledge of Microsoft SQL Server and other relational database
• 5+ years of experience with Transact SQL and other database programming languages 
• Good knowledge of NoSQL databases and search and analytics engines (ex. MongoDB, Elasticsearch)
• Knowledge of common programming languages, in particular C# and javascript. Python is a plus

Nice to have: 

• Knowledge of Business Intelligence, Analytics and ETL is a plus;
• Knowledge of application hosting and deployment in the cloud (Azure, GCP or AWS);
• Knowledge of Behavior Driven Development is a plus