SQL Server Database Engineer

Key Responsibilities:

• Performance Tuning & Optimization: Perform analysis and performance tuning, optimize SQL queries, indexing, and schema designs to ensure efficient database performance.
• High Availability & Disaster Recovery (HA DR): Implement robust high availability and disaster recovery solutions such as SQL Server Always On, Log Shipping, Database Mirroring, and Replication.
• Backup & Recovery: Implement, maintain, and test backup and recovery strategies to ensure minimal downtime and data loss during disaster recovery scenarios.
• Database Security: Implement security measures, including user roles, permissions, encryption, and auditing to ensure databases are secure and compliant with organizational standards and regulations.
• Database Migration & Upgrades: Support efforts to migrate and upgrade SQL Server versions, ensuring minimal downtime and data integrity during these processes.
• Automation & Scripting: Automate routine database maintenance tasks using T-SQL scripts, PowerShell, or other automation tools to improve efficiency and reduce errors.
• Database Monitoring & Maintenance: Monitor the health and performance of production and development databases using tools like SQL Server Profiler, SQL Server Management Studio (SSMS), or third-party monitoring tools, and perform proactive maintenance to avoid performance issues.
• Collaboration & Troubleshooting: Work closely with developers, system administrators, and DevOps teams to troubleshoot and resolve database-related issues, including query performance, deadlocks, and locking problems.
• Required Skills & Qualifications:

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).