SQL Database Administrator

ResponsibilitiesInstall, configure, patch, upgrade, and administer SQL Server instances across production, staging, and development environments.Manage SQL Server storage, system databases, data files, filegroups, TempDB, and transaction logs.Monitor database/server health, capacity, resource utilization, and performance; troubleshoot blocking, deadlocks, and complex performance issues.Perform advanced SQL Server performance tuning, including query optimization, execution-plan analysis, indexing, statistics, and configuration tuning.Design, implement, test, and maintain backup and recovery strategies.Design, configure, and support HA/DR solutions, including Always On Availability Groups, Failover Cluster Instances, Log Shipping, and Replication.Administer Azure SQL Database, Azure SQL Managed Instance, and SQL Server on Azure Virtual Machines.Support Azure database backup, monitoring, security, migration, scalability, cost optimization, and disaster recovery.Utilize Azure Monitor, Log Analytics, Microsoft Entra ID, Azure Key Vault, Azure Backup, and Azure RBAC.Implement database security, RBAC, logins, roles, permissions, and encryption at rest/in transit in accordance with organizational security standards.Support development teams with schema design, table structures, data types, stored procedures, triggers, functions, and complex T-SQL queries.Perform SQL/database code reviews and provide recommendations for performance, scalability, security, and maintainability.Develop T-SQL, PowerShell, and command-line scripts to automate backups, integrity checks, index maintenance, statistics updates, monitoring, and reporting.Support database migrations and integrations between on-premises SQL Server and Azure environments.Create and maintain documentation for installation, configuration, monitoring, security, migration, backup/recovery, HA/DR, and development standards.Provide Tier III technical support, root-cause analysis, and resolution for critical database issues.Collaborate with IT Architecture, development, infrastructure, security, and management teams to design scalable and reliable database solutions.Provide technical mentorship to junior DBAs and participate in disaster recovery, incident response, and business continuity activities as required.Required QualificationsBachelor's degree in Computer Science, Information Technology, or an equivalent technical field, or equivalent professional experience.5+ years of dedicated hands-on experience managing enterprise-level Microsoft SQL Server database environments.Strong experience supporting both on-premises and Azure SQL environments.Advanced knowledge of SQL Server Management Studio (SSMS), T-SQL, and SQL Server internals.Strong experience in performance monitoring and tuning, including indexing, query optimization, blocking, and deadlock resolution.Experience designing and supporting backup, recovery, High Availability, and Disaster Recovery solutions.Experience with Always On Availability Groups, Failover Cluster Instances, Log Shipping, and Replication.Experience with Azure SQL Database, Azure SQL Managed Instance, and SQL Server on Azure VMs.Knowledge of Azure Monitor, Log Analytics, Microsoft Entra ID, Azure Key Vault, Azure Backup, and Azure RBAC.Strong understanding of database security, RBAC, permissions, encryption, and compliance.Experience supporting developers with database design and performing SQL/database code reviews.Experience with SSIS and ETL workflows.Proficiency in PowerShell and/or command-line scripting for DBA automation.Familiarity with third-party monitoring and backup tools such as Redgate.