Duties and Responsibilities

Develop clean, maintainable, documented, high-performance database functions, stored procedures, and triggers to support application development

Translate business requirements into database code for new and existing systems

Ability to perform Data Modelling

Assist with schema design and SQL query tuning

Develop client reports using a reporting tool

Migrate data from one location to another, one format to another or one application to another

Involve in the entire project life cycle including design, development, testing and maintenance

Working in an agile development environment

Stay up-to-date in Database latest updates and enhance the development practices

Troubleshoot and monitor bugs in existing systems and take the initiative in solving problems and fixing critical errors

Communicate and present complex issues with assurance and confidence

Utilize company configuration management practices for code check-in/check-out, version control, and overall management

Utilization of task management system to ensure all work is tracked properly

Curious about new technologies and excited to find ways to implement them in your work and enhance the developments practices

Qualifications and Requirements

BS degree in Computer Science, Engineering, or a related subject

2-4 years' experience with SQL programming languages (PL/SQL, T-SQL, ...)

Strong in developing and debugging Packages, Procedures, Functions and other database objects

Strong experience with performance tuning for Oracle and PLSQL coding

In-depth understanding of data management (e.g. permissions, security and monitoring)

Understand the difference between OLAP and OLTP and when/where to use OLAP structures

Knowledge of data reporting and visualization software (ex: PowerBI, Crystal Reports, JasperReports...)

Basic knowledge of NoSQL database systems

Familiarity with Caching Solutions (Redis, Memcached, ...)

Excellent communication skills with the ability to explain technical processes in a clear and concise manner

Ability to work well independently and with a team while displaying a positive attitude

Ability to carry responsibility

Ability to perform qualified problem-solving and task completion in an acceptable time

Nice to have

Familiarity with ERP systems