Position: MS SQL Production/Development Database Administrator
Company: Art2Hire
Category: SQL
Experience required: 3y
English level: upper
Published: 2023-05-01T00:00:00+03:00

Our Client - is a Cyprus-based, established financial service provider, is now looking for an MS SQL Production & Development Database Administrator to join the team.

Location: Limassol, Cyprus
Type: Full-time 
Start date: ASAP
About Company:

The company has been in operation since 2001. It`s one of the first brokers to offer an actual online trading experience. This included an intuitive web trading platform and online funding instead of lengthy bank transfers. The company`s pioneering spirit has helped bring the clients innovations like Bitcoin Base Currency Accounts. This type of account allows Bitcoin traders to hold their crypto-funds but also use them for trading 200+ instruments (without transferring Bitcoin to FIAT currencies) and withdraw Bitcoin back to their wallet, all without needing a cryptocurrency exchange. Negative balance protection, free guaranteed stop loss, and take profit have been standard features on all accounts since its founding in 2001. 

About the Role:

The MS SQL Production & Development DBA will be responsible for the implementation, configuration, maintenance, and performance of the critical database systems, to ensure the availability and consistent performance of the corporate applications. This is a “hands-on” position requiring solid technical skills, as well as excellent interpersonal and communication skills.

This role requires some coverage of Production DBA responsibilities, in addition to responsibilities to develop and expand the company’s reporting and DB centric processing. The successful candidate will work closely with the in-house development team and operations and may need to perform investigative activities to understand and build upon legacy DB business logic.

This is a key role in helping our organization to achieve a state-of-the-art environment that meets current and future business objectives, while at the same time ensuring that the company’s production databases offer the highest reliability and performance possible.

Responsibilities include but are not limited to:

- Perform routine DBA activities & service requests
- Manage SQL Server databases through multiple product lifecycle environments;
- Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security;
- Write stored procedures, manage execution plans and indexes;
- Independently analyze, solve, and correct issues in real time;
- Refine and automate regular processes, track issues, and document changes;
- Assist developers with query tuning and schema refinement;
- Perform scheduled maintenance and support release deployment activities after hours;

Requirements:
- 3+ years of work experience on Microsoft SQL Server Databases (2012-2016);
- Expert in performing T-SQL DDL/DML/DCL commands using SQL Server Management Studio (SSMS);
- Strong experience in database installation, configuration, capacity planning, implementing backup and recovery strategy for applications and database;
- Experience with backups, restores, recovery models, and Security;
- Experience in implementing and monitoring different types of High Availability and Disaster Recovery scenarios like SQL Server clusters, Replication (Transactional and Peer-to-Peer), log shipping;
- Installed and maintained SQL Server failover clustering for SQL Server 2016;
- Experience in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks using DBCC Utilities;
- Experience in R&D projects (designing & creating DBs, tables, writing functions and procedures);
- Experience in reverse engineering and documenting legacy DB stored procedures and processes;
- An understanding of the SQL locks mechanism/ isolation levels, and their internals;
- Flexible, team player, “get-it-done” personality;
- English - Upper Intermediate +

It would be a plus if you have:
- Forex industry and/or Regulatory reporting knowledge
Maria DB and MySQL experience
- Creating and managing processes to transform data for use in BI, reporting, or data analysis;
- Knowledge of SSIS and SSRS;
- Tableau Server experience and optimization;
- Power BI and business intelligence methodologies;
- Experience in migrating DBs from on-prem/private cloud to public clouds;
- A practical understanding of Incident Management, and IT Risk Management;
- MCTS, MCITP, and/or MVP certifications
- MCSA (Microsoft Certified Solution Associate);
- MCSE (Microsoft Certified Solutions Expert);
- Microsoft Technology Associate (MTA): Database Fundamentals SQL Certification;

The company offer:

- Working hours start from 8-9am and end between 5-6pm Monday to Friday;
- The role is located in Limassol, Cyprus;
- Fun and creative work environment;
- Attractive remuneration package;
- Opportunities for professional development/learning and development opportunities;
- 20 days of annual leave days which increases every two years (capped at 23 days);
- Group medical insurance;
- Provident Fund;
- Discretionary bonuses at the end of the year;
- Quarterly team building activities;
- Weekly lunches;
- Monthly team outings;
- A strong culture promoting work-life balance, hybrid model, and flexibility.