SQL Database Administrator

About Us: Vergence is a dynamic IT consulting firm in Indianapolis, specializing in delivering cutting-edge solutions for our clients. As a trusted partner in the industry, we excel in leveraging cloud technologies, advanced database management, and load balancing strategies to ensure seamless operations for businesses. Our company is mission-driven and committed to creating a work environment that fosters employee fulfillment and work-life balance. We are seeking a highly skilled SQL Database Administrator (DBA) with expertise in SQL Server on Azure, particularly focused on load balancing and geography-based routing to multiple sites. Job Description: As a SQL Database Administrator (DBA) at Vergence, you will be responsible for managing and optimizing our clients' database systems hosted on Azure. A core aspect of this role will be ensuring high availability through load balancing and implementing geography-based routing across multiple sites. This position requires in-depth knowledge of SQL Server, experience with Azure's cloud environment, and a strong understanding of distributed database architecture. Key Responsibilities: Design, implement, and maintain SQL Server databases within an Azure environment. Develop and manage solutions for load balancing, ensuring database traffic is efficiently distributed across multiple geographic sites. Implement and optimize geography-based routing strategies to ensure minimal downtime and improved user experience. Ensure high availability and disaster recovery solutions are in place for databases. Monitor database performance and troubleshoot performance issues, including query optimization, indexing, and replication. Collaborate with development and operations teams to design and maintain scalable, high-performing databases. Manage database security, ensuring data integrity and compliance with company and client policies. Conduct regular maintenance, patching, and upgrading of database systems. Provide technical expertise and best practice guidance to internal teams and clients. Qualifications: 5 years of experience as a SQL Server DBA, with expertise in Azure cloud environments. Strong understanding of SQL Server architecture, performance tuning, and disaster recovery. Proven experience with load balancing and geo-distributed databases. Hands-on experience with Azure services such as Azure SQL Database, Azure Data Factory, and Azure Traffic Manager. Knowledge of routing policies, including weighted and geographic-based routing strategies. Experience in database security, including encryption, authentication, and authorization best practices. Familiarity with automation and DevOps processes for database management. Excellent problem-solving and troubleshooting skills. Strong communication and collaboration skills.