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).
Skills Required
- 5-8 years of experience as a SQL Server Database Engineer
- Experience with SQL Server 2016 or newer, including installation and configuration
- Knowledge of SQL Server performance tuning, query optimization, indexing strategies, execution plans, and SSMS tools
- Understanding of database security, encryption, user authentication, role-based access control, and auditing
- Expertise creating and managing backup strategies and testing restoration processes
- Experience with scripts and automation tools for database tasks
- Experience with SQL Server Profiler, Extended Events, DMVs, and database monitoring tools
- Familiarity with SSIS, SSRS, and SSAS
- Experience with version control systems such as Git for database changes and deployments
- Experience with cloud databases such as Azure SQL Database or AWS RDS for SQL Server
- Experience with cloud-based high availability solutions
- Experience with ETL processes, data warehousing, and SSIS
What We Do
WLEN WorldJobs LLP is a global recruitment network and job portal that connects job seekers with employment opportunities across various countries, including the USA, India, Japan, and Canada. They specialize in facilitating placements across diverse sectors such as IT/Software, Healthcare, Engineering, and Sales, helping professionals navigate international job markets and find global roles.
