• Database Developer

Industry Accounting/Finance
Location Iasi
Experience Range 3 - 7 Years
Qualification BE Computer Science and Engineering (Computer Science)
Not posted

Functional Finance
Job Description
About Us
We know that people are our "greatest asset". Our staff’s professionalism, innovation, teamwork and dedication to excellence have helped us become one of the world’s leading technology companies. It is these qualities that are vital to our continued success. As a Ness employee you will be working on products and platforms for some of the most innovative software companies in the world. The opportunity to evolve your expertise by using new cutting edge technologies will expand your horizons and create an exciting work environment. You’ll also gain enormous knowledge working alongside other highly skilled professionals that will help accelerate your career progression. At Ness we treat our values of rigor, innovation and partnership with the highest priority and they are placed at the very core of our business — to guide us through our daily operations and interactions with our customers. We offer our employees exciting and challenging projects across a diverse range of industries, as well as the opportunity to collaborate with a group of forward thinking, capable partners around the globe.
About Company
With over 22 years of experience in the financial services industry, ClioTech enjoys worldwide reputation and recognition. The Group operates various brands in multiple regions and over 20 languages, specializing in CFD trading on web and mobile. ClioTech is a multi-jurisdictional company, regulated in specific regions by CySEC and BVI FSC.
Roles and Responsibility

We build and maintain an ecosystem of applications and tools that serves a multi-million customer online financial trading platform. We deal with fast and diverse data requiring millisecond response and the SQL Server databases are at the core of the data management capabilities.

*             Collaborate with backend developers and product managers to analyze business specifications and implement new functionalities.

*             Design and implement database modules through T-SQL code: determine the data model (tables, types) and APIs for querying and processing data (stored procedures, views, functions, Service Broker services).

*             Write unit tests with tSqlt framework for both new logic and retroactively for old critical modules.

*             Create upgrade scripts for manipulating large tables that require low or no downtime.

*             Improve mission critical systems by analyzing queries, execution plans, execution statistics and refactoring code, designing indexes, altering storage properties of objects.

*             Offer guidance and code review for T-SQL code written by peer developers.

*             Offer occasional support for data synchronization between various application environments

*             Develop and maintain automated processes for ongoing database maintenance (like partitions management and archival processes for historical data).

*             Perform proof of concepts for leveraging new SQL Server capabilities (like column-store indexes, in-memory capabilities, stretch DB functionalities).

*             Monitor production systems and conduct investigations of performance bottlenecks and incidents (Redgate DB Monitor, Perfmon)

*             Devise security strategies for access to code and protecting sensitive personal data

*             Create/maintain frameworks and dashboards for managing alerts and monitoring data consistency (Redgate DB Monitor, Splunk, SQL Server Reporting Services)

*             Create/maintain Powershell scripts for embedding the database code within the continuous integration and delivery flow (Jenkins, Powershell, Redgate Compare, Redgate DataCompare).

Desired Skills
  • At least 4 years of experience in MS SQL Database
  • Experience in developing T-SQL – Design, Code, Troubleshooting
  • Performance – indexes, profiler, normalization form
  • Experience in Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools
  • Understanding Transactions, Triggers, Isolation Levels
  • Knowledge of SQL Permissions – Users, Roles, Logins, Schemas
  • Features – Service Broker, XML Fields, SQL Audit, CTE, Linked Servers, Jobs
  • Experience in Reporting Services, Integration Services
  • Experience in implementing operational automation using scripts
  • Good communication and documentation skills

Personal skills and qualities

  • Good communication skills, team player, responsibly
  • Interest in technologies and science
  • High motivation
  • Work in dynamic environment
  • Will and ability to acquire deep understanding of underlying business domain
  • Lifelong learner who understands that continual improvement in the path of quality
  • Wants to solve difficult design decisions
A+| A| A-