Experience: 5-8 years of experience as a SQL Server Database Engineer.
SQL Server: Experience with SQL Server 2016 and newer versions, including installation, configuration.
Performance Tuning & Query Optimization: knowledge of SQL Server performance tuning, query optimization, indexing strategies, execution plans, and the tools available in SQL Server Management Studio (SSMS).
Security Management: Understanding of database security, including encryption, user authentication, role-based access control, and auditing.
Backup & Recovery: Expertise in creating and managing backup strategies, and testing restoration processes to ensure data integrity.
scripts, and other automation tools to streamline database tasks.
Monitoring & Diagnostics: Experience with SQL Server Profiler, Extended Events, Dynamic Management Views (DMVs), and third-party monitoring tools for diagnosing and troubleshooting database issues.
Tools & Technologies: Familiarity with SSIS (SQL Server Integration Services), SSRS (SQL Server Reporting Services), and SSAS (SQL Server Analysis Services) is a plus.
Version Control: Experience working with version control systems (e.g., Git) to track database changes and deployments.
Preferred Qualifications:
Cloud Experience: Experience with cloud databases (e.g., Azure SQL Database, AWS RDS for SQL Server) and cloud-based high availability solutions.
ETL & Data Warehousing: Experience with ETL processes, data warehousing, and SQL Server Integration Services (SSIS).


