Position: Database analyst
Company: SKE inc.
Experience required: 2y
English level: intermediate

Summary

Spatial Knowledge Engineering Inc., is a Canadian IT company searching for an intermediate software web developer/Database analyst with 3+ years of work experience supporting SqlServer/Oracle Databases. The role is to design, install, and maintain production databases while ensuring high levels of data availability, system resiliency and optimal performance.

Responsibilities
- Ensuring the stability, availability and data integrity of the database environments;
- Providing database troubleshooting, maintenance and support;
- Performance tuning of database systems.
- Install, upgrade, and manage database applications.
- 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.
- Evaluate and implement new technologies and strategies to support business objectives and priorities.
- Identify opportunities to continuously improve service levels and database standards.
- 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.
- Remain abreast of technological changes that will impact your work.
- 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.
- Implement visually appealing, user-friendly, and engaging user interfaces.
- Deploy applications and systems in our secure cloud environment.
- Improve existing software and code to ensure adherence to stipulated guidelines and standards.

Requirements
- English speaking and writing capabilities at intermediate level, with willingness to become fully proficient (SKE will provider English training classes).
- 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.
- Familiarity with the Windows Server 2019+, ASP.NET framework, SQL Server 2017+.
- Understanding of structured software development methodologies.
- Capable of creating, reviewing and delivering complex database scripting and analysis.
- Capacity to use SQL (Structured Query Language) to query object-relational databases.
- Database Architecture experience.
- Data Modelling experience.
- SQL Query Tuning 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.
- Familiarity with the Windows Server 2019+, ASP.NET framework, SQL Server 2017+.
- 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.

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

One of our technical offices is located in Kyiv, Ukraine. You will be expected to work in the office 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.

Contact

If you are interested please submit a detailed resume to [відгукнутися]. The job posting will be open from September 20, 2021 until a suitable candidate is found.