Vitae Recruitment is seeking a highly skilled Senior Database Developer / DBA with genuine depth across database development and database administration, to join our client's dynamic team in Limassol, Cyprus. You will own the full data lifecycle - from schema design and query optimisation through to production DBA responsibilities and analytical reporting - across MSSQL, MySQL,Tableau and MariaDB environments.
DATABASE ADMINISTRATION
Infrastructure & Reliability
- Manage and administer production MSSQL, MySQL, and MariaDB environments including configuration, patching, and upgrades.
- Implement and maintain high-availability solutions: Always On Availability Groups (MSSQL), MySQL Group Replication, and Galera Cluster (MariaDB).
- Design and own backup and disaster recovery strategies; define RTO/RPO targets and test restore procedures regularly.
- Monitor server health, disk usage, and resource utilisation; respond to incidents and maintain uptime SLAs, using SQL Profilers e.g Redgate
Performance & Security
- Perform query optimisation using execution plans, Query Store, Performance Schema, and wait statistics analysis.
- Design indexing strategies including covering indexes, filtered indexes, and columnstore indexes.
- Tune server-level parameters across all three platforms (buffer pools, MAXDOP, TempDB, thread settings).
- Manage user permissions, implement least-privilege access controls, and enforce encryption at rest (TDE) and in transit (SSL/TLS).
- Configure audit logging for compliance requirements (DORA, ISO 27001, PCI-DSS as applicable).
Automation & DevOps (Optional)
- Automate routine DBA tasks via SQL Agent, PowerShell, or shell scripts (index maintenance, integrity checks, statistics updates).
- Implement database CI/CD pipelines using Flyway or Liquibase integrated with Git and Azure DevOps / GitHub Actions.
- Set up and maintain monitoring and alerting using Grafana and Prometheus.
DATA ANALYTICS
Advanced SQL Analytics
- Write analytical queries using window functions,recursive CTEs, and pivot/unpivot logic.
- Design and optimise analytical views, indexed views, and materialised views for high-frequency reporting workloads.
- Implement in-database statistical processing: moving averages, percentile analysis, Z-score outlier detection, and cohort analysis in a high demand financial sector.
Data Warehousing & Modelling
- Design and maintain star schema and snowflake schema data warehouses; manage fact/dimension tables and Slowly Changing Dimensions (SCD Types 1–3).
- Build and optimise ETL/ELT pipelines using SSIS, dbt, manage staging and load layers.
- Produce conceptual, logical, and physical data models; document naming conventions and schema standards.
Reporting & Business Intelligence
- Build Power BI semantic models with complex DAX measures including time intelligence (YTD, MTD, rolling periods), RLS, and certified datasets.
- Develop SSRS parameterised, drill-through, and matrix reports for operational stakeholders.
- Define KPI frameworks and data dictionaries; translate business requirements into precise analytical deliverables.
- Use Python (pandas, SQLAlchemy) or R for data extraction, transformation, and exploratory data analysis (EDA) tasks.
DATABASE DEVELOPMENT
- Design and develop complex stored procedures, functions, triggers, and views across MSSQL, MySQL, and MariaDB.
- Write optimised T-SQL with comprehensive error handling, transaction management, and concurrency control.
- Implement table partitioning, archiving strategies, and data lifecycle management for high-volume tables.
- Lead database code reviews; enforce development standards and schema versioning.
- Build dynamic SQL frameworks using parameterised execution for flexibility and security.
TECHNICAL SKILLS
Category Technologies & Tools
Database Platforms MSSQL 2016–2022, MySQL 5.7 / 8.0
High Availability Always On AG, MySQL Group Replication, Galera Cluster, Log Shipping,
Query & Development T-SQL (advanced), Window Functions, CTEs, Dynamic SQL, Stored Procedures, Job Events.
ETL / Pipelines SSIS, dbt, Debezium, Zapier, Python
BI & Reporting Power BI, Tableau
Performance Tuning Execution Plans, Query Store, Performance Schema, Index Strategies
Security & Compliance TDE, RLS, SSL/TLS, SQL Audit, GDPR / PCI-DSS
CI/CD & Automation Git, Flyway, Liquibase, Azure DevOps, PowerShell, SQL Agent
Monitoring Grafana, Prometheus, Zabbix, Azure Monitor, DMVs
Cloud Azure SQL, AWS RDS, Azure Blob / S3 backup targets
QUALIFICATIONS
Required
- 6+ years of hands-on experience in a senior database role spanning development, DBA, and analytics.
- Expert-level MSSQL knowledge including Always On, TDE, and advanced T-SQL.
- Strong production DBA experience with MySQL and/or MariaDB including replication topologies.
- Proven experience building data warehouses, BI models, high traffic data, event driven ecosystems and ETL pipelines.
- Proficiency in query optimisation and server-level performance tuning across all three platforms.
Preferred
- Microsoft Certified: Azure Database Administrator Associate (DP-300) or Data Engineer Associate (DP-203).
- Experience with dbt or modern ELT orchestration tools.
- Familiarity with containerised database environments (Docker, Kubernetes).
- Degree in Computer Science, Information Systems, Mathematics, or Statistics.
BENEFITS:
- Competitive senior-level salary with annual performance review.
- Certification and professional development budget.
- Hybrid working arrangements and collaborative team culture.
- Direct influence on data architecture and strategy.
Our client offers a competitive remuneration package based on qualifications and experience, along with the opportunity to work in a vibrant location. Employees will benefit from a supportive work environment, potential career development opportunities, and the chance to be part of a growing organisation. This role is ideal for a motivated IT professional looking to expand their expertise in a challenging yet rewarding position in Cyprus.