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