JOBSEARCHER

Senior SQL Server DBA (Azure SQL and High Availability)

Required Education: Four-year college degree or equivalent qualification
Required Experience: Minimum 5 years of dedicated hands-on experience managing enterprise-level Microsoft SQL Server database environments, including on-premises and Azure-based platforms Minimum 5 years of experience in database performance monitoring, optimization, and tuning Minimum 5 years of experience implementing database security and compliance measures, including Role-Based Access Control (RBAC) Minimum 5 years of experience providing developer support and performing database code reviews Extensive experience installing, configuring, patching, upgrading, and maintaining Microsoft SQL Server instances across production, staging, and development environments Strong expertise in SQL Server Management Studio (SSMS), database architecture, and SQL Server internals Advanced proficiency in Transact-SQL (T-SQL), including query optimization, stored procedures, triggers, functions, and complex SQL queries Experience monitoring database performance, resource utilization, server health, and database availability Experience identifying and resolving performance bottlenecks, blocking, deadlocks, and inefficient queries Experience designing, implementing, testing, and maintaining database backup, recovery, and disaster recovery solutions Experience implementing High Availability and Disaster Recovery (HA/DR) solutions, including Always On Availability Groups, Log Shipping, Failover Cluster Instances, and database replication Experience administering Azure SQL Database, Azure SQL Managed Instance, and SQL Server hosted on Azure Virtual Machines Knowledge of Azure Monitor, Log Analytics, Microsoft Entra ID, Azure Key Vault, Azure Backup, and Azure RBAC Experience configuring Azure database monitoring, security, backup, migration, and disaster recovery solutions Experience migrating and integrating databases between on-premises SQL Server and Azure environments Strong understanding of Azure database security, networking, scalability, performance optimization, and cost management Experience implementing SQL Server Integration Services (SSIS) packages and Extract, Transform, Load (ETL) workflows Experience managing database storage, system databases, data file structures, and database configurations Experience implementing database encryption, user authentication, access controls, and security policies Ability to design and maintain database schemas, tables, indexes, and efficient data structures Experience developing T-SQL, PowerShell, or command-line scripts to automate routine database administration tasks Experience creating technical documentation covering database installation, monitoring, security, configuration, migration, and maintenance procedures Experience collaborating with application development teams, IT architects, and infrastructure teams on database design and implementation Ability to provide Tier III technical support and resolve complex database issues Strong analytical, troubleshooting, problem-solving, and communication skills Ability to explain complex database concepts and technical issues to non-technical stakeholders Strong attention to detail and the ability to manage multiple technical priorities Preferred Experience Hands-on experience with third-party SQL Server monitoring and backup tools such as Redgate Experience developing enterprise-level database architecture strategies across Azure and on-premises environments Experience supporting business intelligence solutions and establishing database development standards Experience contributing to technical solution designs, business cases, and database modernization initiatives Experience mentoring junior database administrators and technical support personnel Experience participating in Disaster Recovery, Business Resumption, or Incident Response teams
Overview: We are seeking an experienced SQL Server Database Administrator (DBA III) to manage, optimize, and secure enterprise Microsoft SQL Server environments across on-premises and Microsoft Azure platforms. The ideal candidate will possess advanced SQL Server administration expertise, strong database performance tuning capabilities, and hands-on experience implementing High Availability and Disaster Recovery solutions to ensure the reliability, security, and availability of mission-critical applications. The selected candidate will be responsible for installing, configuring, patching, upgrading, and maintaining SQL Server instances while managing Azure SQL Database, Azure SQL Managed Instance, and SQL Server on Azure Virtual Machines. Key responsibilities include database performance optimization, backup and recovery management, security administration, automation, database migrations, and Tier III technical troubleshooting. This role requires close collaboration with IT architects, developers, infrastructure teams, and security professionals to design scalable database solutions, implement security standards, and maintain efficient database operations. The successful candidate will demonstrate advanced T-SQL expertise, experience with Azure database technologies, strong analytical abilities, and the capability to develop reliable database architectures that support business continuity, regulatory compliance, and organizational objectives.
Job Responsibilities: Database Administration and Configuration Install, configure, patch, upgrade, and maintain Microsoft SQL Server instances across production, staging, and development environments Administer enterprise SQL Server databases hosted on-premises and within Microsoft Azure Configure and support Azure SQL Database, Azure SQL Managed Instance, and SQL Server on Azure Virtual Machines Manage SQL Server storage, system databases, database files, and related configurations Develop and implement database administration standards, maintenance procedures, and operational best practices Ensure database systems remain available, reliable, secure, and aligned with business requirements Support database migrations and integrations between on-premises and Azure environments Database Performance Monitoring and Optimization Monitor database health, performance, availability, resource utilization, and server metrics Identify and resolve performance bottlenecks, blocking issues, deadlocks, and inefficient queries Optimize SQL queries, indexes, database configurations, and resource allocation Perform ongoing database performance tuning across supported database management platforms Utilize SQL Server Management Studio, Azure Monitor, and Log Analytics to monitor and troubleshoot database environments Develop performance improvement strategies to enhance database scalability, reliability, and efficiency High Availability, Backup, and Disaster Recovery Design, implement, test, and maintain database backup and recovery procedures Develop High Availability and Disaster Recovery strategies for enterprise SQL Server environments Configure and support Always On Availability Groups, Log Shipping, Failover Cluster Instances, and database replication Plan and implement Azure database backup, recovery, and disaster recovery solutions Evaluate infrastructure and hardware requirements to support database availability and recovery objectives Conduct backup validation, recovery testing, and disaster recovery exercises Participate in Disaster Recovery, Business Resumption, and Incident Response activities as assigned Database Security and Compliance Implement and maintain Role-Based Access Control (RBAC), database permissions, user authentication, and access management Configure encryption at rest and in transit to protect sensitive data Maintain database security standards, access controls, and compliance requirements Utilize Microsoft Entra ID, Azure Key Vault, and Azure RBAC to support secure database administration Collaborate with information security leadership to implement and enforce established organizational security policies Monitor database security configurations and recommend improvements to strengthen data protection and system integrity Maintain documentation covering security policies, database access, and configuration changes Developer Support and Database Architecture Collaborate with development teams to design, implement, and optimize database schemas and data structures Assist with table design, data type selection, indexing strategies, and database architecture Review and optimize stored procedures, triggers, functions, and complex T-SQL queries Establish standards and best practices for database development, data exchange, and application integration Work with IT architecture and development teams to develop scalable Azure and on-premises database solutions Support database architecture planning throughout the application development lifecycle Contribute to technical solution designs and supporting business case documentation Database Automation and ETL Develop T-SQL, PowerShell, and command-line scripts to automate database administration tasks Automate index maintenance, integrity checks, statistics updates, backups, monitoring, and reporting activities Implement and support SQL Server Integration Services (SSIS) packages and ETL workflows Improve database maintenance efficiency through scripting and process automation Monitor and troubleshoot automated database processes to ensure reliability and performance Azure Database Administration Develop and maintain scalable database architectures across Microsoft Azure and on-premises environments Administer Azure SQL Database, Azure SQL Managed Instance, and SQL Server on Azure Virtual Machines Configure Azure monitoring, backup, security, migration, and disaster recovery capabilities Utilize Azure Monitor and Log Analytics to evaluate database performance and operational health Implement secure credential management using Azure Key Vault Support Azure database networking, scalability, cost optimization, and performance management Plan and execute database migrations between on-premises SQL Server and Azure environments Technical Support, Documentation, and Collaboration Provide Tier III technical support for critical and complex database issues Troubleshoot database availability, performance, configuration, and security incidents Collaborate with IT architects, infrastructure teams, development staff, and technical leadership to address database requirements Develop and maintain technical documentation covering installation, configuration, monitoring, security, migrations, and disaster recovery Provide technical guidance and mentorship to junior database administrators and support staff Participate in technical planning, solution design, and database strategy discussions Communicate complex technical issues and recommendations to technical and non-technical stakeholders Support additional database administration and technical responsibilities as assignedOnly those lawfully authorized to work in the designated country associated with the position will be considered.Please note that all Position start dates and duration are estimates and may be reduced or lengthened based upon a client’s business needs and requirements.About Rose Founded in 1993 Office Locations Across the U.S.150+ Clients: Corporations and Government Agencies Employee Oriented Company Challenging Assignments Across the U.S.Continuous Professional DevelopmentEMPLOYEE COMMENTSWe want you to work with us, but don't take our word for it. Take a look at this sampling of employee comments. They speak for themselves.