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 and newer, including installation and configuration
- Performance tuning and query optimization, indexing strategies, execution plans
- Database security management: encryption, authentication, role-based access control, auditing
- Backup and recovery strategy design and restoration testing
- Scripting and automation to streamline database tasks
- Monitoring and diagnostics using SQL Server Profiler, Extended Events, DMVs, and third-party tools
- Experience with version control systems for database changes (e.g., Git)
- Familiarity with SSIS, SSRS, SSAS
- Cloud database experience (Azure SQL Database, AWS RDS for SQL Server)
- ETL and data warehousing experience
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.
