SQL Server DBA

Job Description

We are seeking a skilled and experienced SQL DBA to play a crucial role in building, setting up, and migrating our critical SQL Server databases to a new server environment, with a significant focus on leveraging the Azure cloud platform for Disaster Recovery (DR). The primary objective of this role will be to ensure the new database infrastructure is optimally configured for DR and high availability within the Azure ecosystem. The successful candidate will be responsible for all aspects of database administration, including installation, configuration, performance tuning, security, backup and recovery strategies, and implementing robust DR solutions utilizing Azure services. This position requires a strong understanding of SQL Server architecture, Azure DR capabilities, and migration methodologies to the Azure environment.

Responsibilities :

• Database Build and Setup (On-Premise and Azure) : Plan and execute the installation and configuration of new SQL Server instances and databases on both on-premise and potentially Azure-based infrastructure.
• Define and implement optimal database configurations, including storage, memory, and other relevant parameters, ensuring performance and scalability across both environments.
• Collaborate with infrastructure and application teams to understand database requirements and design appropriate hybrid or cloud-native solutions.
• Database Migration to New Server Environment (with Azure DR Focus) : Plan and execute the migration of existing SQL Server databases from source servers to the new environment, strategically considering Azure for DR implementation.
• Utilize appropriate migration tools and techniques, including Azure Database Migration Service (DMS) or native SQL Server tools, ensuring data integrity and consistency.
• Troubleshoot and resolve any issues encountered during the migration process.
• Disaster Recovery (DR) Implementation and Configuration in Azure : Design, implement, and configure robust Disaster Recovery solutions for the SQL Server environment leveraging Azure services , including but not limited to :
• Azure SQL Database Geo-Replication and Auto-failover Groups.
• Azure Site Recovery (ASR) for SQL Server VMs.
• Hybrid DR strategies utilizing on-premise and Azure resources.