Adastra Slovakia - Database Administrator (Microsoft SQL Server Data Warehouse)

We are hiring a Senior Database Administrator (DBA) to own the stability, performance, security, and operational excellence of our Microsoft SQL Server–based data warehouse environment. You will be responsible for day-to-day administration, proactive performance tuning and ensuring high availability and reliability. This role requires deep expertise in SQL Server and T-SQL, strong Windows Server fundamentals, and a disciplined approach to monitoring, incident response, and change management.

Status: Employee contract in Slovakia (2700 EUR brutto) or B2B. Salary expectation depends on the seniority level and we are open to speak about it.

Please note: This position is open only to applicants located in Slovakia.

Key Responsibilities

• Administer and operate Microsoft SQL Server instances supporting a data warehouse workload (OLAP/ETL/BI-heavy patterns).
• Administer and operate SSAS (Multidimensional) and SSIS production and non‑production environments, including deployments, upgrades, patching and capacity planning.
• Own performance optimization end-to-end: query tuning, indexing strategy, statistics maintenance, execution plan analysis, and workload management.
• Manage SQL Server security: logins/users/roles, least-privilege access, encryption where applicable, auditing, and compliance controls.
• Set up and maintain monitoring/alerting for performance, capacity, failures, and data/log growth; create actionable runbooks.
• Manage capacity planning: CPU/memory/storage sizing, tempdb configuration, file placement, and growth strategies.
• Support ETL/ELT and reporting workloads by collaborating with Data Engineers/Analysts to improve SQL patterns and data model access.
• Own operational discipline: incident triage, root-cause analysis, postmortems, and continuous improvement.
• Design disaster-recovery playbooks and inspect/test them quarterly.
• Conduct learn sessions to upskill developers on query optimization and best practices on SQL Server.
• Hold regular meetings with business analysts about SQL queries writing habits to avoid.

Required Qualifications

• Deep, hands-on experience administering Microsoft SQL Server in production (data warehouse or similarly critical workloads).
• Deep knowledge of T-SQL, including performance considerations (set-based logic, window functions, temp tables vs table variables, transaction scope, isolation levels).
• Proven experience with performance troubleshooting and tuning:
  • execution plan analysis
  • indexing strategy (clustered/non clustered, filtered indexes, column store where appropriate)
  • statistics maintenance
  • blocking/deadlock resolution
  • IO and tempdb bottleneck diagnosis
• Strong Windows Server knowledge relevant to SQL Server operations (services, permissions, storage, networking basics, event logs, patching).

Nice-to-Have Qualifications

• Experience operating SQL Server workloads in Azure (e.g., Azure SQL Managed Instance, SQL Server on Azure VMs, storage considerations, monitoring, identity integration).

Additional Skills We Consider Important for This Role

• Security mindset: understanding of least privilege, separation of duties, and practical auditing/monitoring.
• Operational reliability: monitoring-first approach, clear runbooks, predictable change management, and ownership during incidents.
• Communication skills: can explain root causes and trade-offs clearly to technical and non-technical stakeholders.

Documentation discipline: maintains configuration baselines, maintenance schedules, and operational procedures.

Employee perks, benefits

• Our daily jobs are AI-enabled, including access to an enterprise Claude license to help you work smarter and faster.
• You will have an immense opportunity and our support to grow professionally, working on leading data analytics projects and technologies in the region
• You will work in an environment which will stand behind you, support you in your growth, and which will value your work through competitive salary and a bonus structure