Position: Database Analyst/Developer
Company: SKE inc.
Experience required: 2y
English level: pre

The role is to design, install, and maintain production databases while ensuring high levels of data availability, system resiliency and optimal performance.
Responsibilities

Database 

Ensuring the stability, availability and data integrity of the database environments;
Providing database troubleshooting, maintenance and support;
Performance tuning of database systems and identify opportunities to continuously improve service levels and database standards.
Install, upgrade, and manage database applications in our secure cloud environment.
Diagnose and troubleshoot database and application errors.
Write basic scripts to extract data from database and files.
Write complex SQL queries, functions, stored procedures and triggers.
Read data models and understand object-relational databases.
Set and maintain database standards to ensure data quality and integrity.
Create automation for repeating database tasks and processes.
Development

Write structured, scalable code using .NET programming languages, designed to work with multiple web browsers.
Follow internal company coding standards.
Develop technical documentation throughout the software development life cycle.
Test code to detect and remedy errors and omissions.
Improve existing software and code to ensure adherence to stipulated guidelines and standards.
General

Communicate with other team members to provide technical input on various tasks and projects.
Provide technical support for our Client User Support Team in resolving technical issues.
Evaluate and implement new technologies and strategies to support business objectives and priorities.
Remain abreast of technological changes that will impact your work.
 
Requirements

Database

Experience with development using database technologies.
DBA expertise and best practices to scale and optimize database services.
Advanced knowledge of troubleshooting databases, database monitoring, administration and maintenance and database applications.
Capable of creating, reviewing and delivering complex database scripting and analysis 
Capacity to use SQL (Structured Query Language) to query object-relational databases.
Experience with SQL Query Tuning.
Database Architecture and Data Modelling experience.
Development

Familiarity with the Windows Server 2019+, ASP.NET framework, SQL Server 2017+.
Understanding of structured software development methodologies.
Formal knowledge/training and experience as a .NET Developer, preferably with Visual Basic, Java Script, and HTML5/CSS3.
Knowledge of client and server-side application development based on REST and RPC HTTP API architectures.
General

Troubleshooting skills -Ability to proactively identify, troubleshoot and resolve live database systems issues.
Willingness to communicate and collaborate with other technical staff working as part of project teams on various projects.
Attention to detail.
Qualifications

· College or university degree in the field of computer science, information systems, or related field of study or 3-5 years equivalent work experience
Language

· English speaking and writing capabilities at intermediate level (B1/B2), with willingness to become fully proficient (SKE will provider English training classes). 

 
About SKE Inc.

SKE is an information solutions company with over twenty-six years of project management, systems design, development and implementation experience. We support Canadian Federal and Provincial government clients in their implementation of geo-information management solutions. Our key product and service is ‘GeoPortal’ - an award-winning geo-intelligent platform consisting of hosting infrastructure, software, services, and data used by our clients. See www.skeinc.com and www.ontariogeoportal.com and www.canadageoportal.com for more details. 

 

Work Location and Compensation

You will be expected to work remotely in Ukraine. You will be expected to work during normal hours, Monday to Friday, from app. 12 p.m. to 8 p.m. to coincide with our Canadian office work hours. There are occasions where some of the implementation work must be done off hours and you will be expected to work during these times, with appropriate compensation. 

Compensation is based on a very competitive hourly wage that will be negotiated, and is dependent on your skills and work experience. Hourly wages are reviewed on an annual basis and increased based on performance and cost of living expenses. Annual performance bonuses may also be provided that are dependent on overall company performance.