Position: Database Developer (MS SQL)
Company: Ecentria Solutions Odessa
Experience required: 2y
English level: intermediate

Required skills

— 2+ years of professional work experience;
— Strong experience in T-SQL, procedures, functions, triggers, views and queries;
— Experience with Microsoft SQL Server 2012/2014/2016 and newer;
— Knowledge of PowerBI is considered a plus;
— Experience with SSRS, SSAS, SSIS, & SSDT;
— Working knowledge of MySQL databases;
— Knowledge and experience of Data Warehouse concepts;
— Problem solving skills;
— Strong written and verbal English communications skills.

As a plus

— A degree in Computer Science, IT or related field is considered a plus.

We offer

— Direct employment, an e-commerce company. Not out staff/outsource;
— Agile culture, the continuous improvement process;
— Friendly and highly-qualified colleagues;
— Challenging international projects; 
— Competitive salary, yearly reviewed; 
— Real possibilities of growth;
— Direct employment with paid vacations & sick leaves;
— Flexible work schedule; 
— Excellent working conditions; 
— Powerful hardware, best software/tools;
— Learning and innovations — internal demos & trainings, individual mentorship; 
— Potential business trips /relocation to the USA;
— Ability to attend local & international conferences.

Responsibilities

— Develop complex stored procedures, functions, triggers, views and queries in support of application development;
— Participate in application development projects and be responsible for the database architecture and design;
— Review and optimize existing stored procedures, functions, triggers and queries;
— Convert existing embedded SQL code into stored procedures;
— Develop custom scripts to automate various database management processes;
— Develop PowerBI reports;
— Define and review best practice standards for data integrity;
— Develop various ETL jobs for our Data Warehouse.

Project description

OpticsPlanet is seeking a supremely talented Software Engineer to work at our e-commerce company using cutting edge technologies, tools, and processes.

We use the latest in OOP: Domain-Driven Design, Design patterns, Object Relational Mapping (ORM) via Doctrine, Symfony and Zend Frameworks for MVC in a LAMP stack environment. We use ELK stack for search, logging, analysis and reporting and test with PHPUnit, Behat. We work with the latest tools: PHPStorm, git, JIRA/Confluence/Bamboo/Bitbucket, slack, etc. We work with could services (AWS, Azure) as well as on-prem resources.

We work in teams using agile processes, peer code reviews, and continuous integration. The work includes the whole spectrum of web development tasks, such as writing web apps (both front-end and back-end work), web service consumers and providers, automated publishing tools for our stores and retail channels, and critical business analytics applications.

This person will be working on the most complex projects being introduced in the company’s e-commerce web platform, leading technical discussions, mentoring other developers and enforcing best practices and coding standards on both a team and department level. This is a great opportunity for problem solvers who are comfortable tackling challenging problems in an Agile team environment.