Senior Database Developer / DBA - Limassol

Vitae Recruitment is currently seeking an experienced Senior Database Developer / DBA to join our client's dynamic team on a permanent basis. We are looking for a well-rounded Senior Database Professional with genuine depth across database development and database administration. 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: 

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.

Joining this company offers a range of benefits, including competitive salary, private healthcare, and opportunities for professional development. The company prides itself on fostering a collaborative and innovative working environment, supporting their staff to thrive and excel in their roles. This is an excellent opportunity for a seasoned database professional seeking stability, career progression, and the chance to make a significant impact within a well-established company.