- Write and troubleshoot complex SQL scripts for advanced query handling.
- Manage, monitor, and optimize SQL Server databases for performance and reliability.
- Design and implement robust backup, recovery, and disaster recovery strategies.
- Enhance performance through indexing, query optimization, and resource allocation.
- Ensure security compliance with encryption and access controls.
- Plan and execute seamless database migrations, upgrades, and patches.
- Implement and manage replication, clustering, and high-availability solutions.
- Collaborate with developers to design and implement efficient ETL processes.
- Proactively monitor databases and resolve performance or connectivity issues.
Requirements:
- Expertise in Microsoft SQL Server, with SSIS, SSRS, and SSAS knowledge as a plus.
- Experience with partitioning, advanced indexing strategies, and data compression.
- Proven ability in complex query scripting, execution plan analysis, and performance tuning.
- Knowledge of high availability solutions (Always On, replication, clustering).
- Familiarity with backup tools and database security best practices.
Bonus: Experience with ClickHouse!
Apply now to be part of a team dedicated to secure, scalable, and high-performance data solutions!