Role: MSSQL DBA
Location: Minneapolis, MN
Duration: 12 Months
Role description:
Install, configure, and upgrade Microsoft SQL Server 2016/2019/2022 on Windows, Linux, and Azure (Azure SQL Database, Managed Instance, SQL VM). Set up and maintain development, test, and production environments, clustering, and Always On Availability Groups, as well as database mirroring and log shipping.
Monitor and tune performance using DMVs, Extended Events, Query Store, and index strategies (clustered, non-clustered, columnstore). Perform capacity planning, optimize tempdb, and manage workloads with Resource Governor.
Design and implement backup strategies (full, differential, transaction log) with compression, encryption, and automated verification. Execute restores and point-in-time recovery, maintain retention policies, and document RTO/RPO requirements.
Configure and support high-availability and disaster-recovery solutions such as Always On Availability Groups, failover cluster instances, mirroring, log shipping, and multi-datacenter DR; conduct regular failover testing and health monitoring.
Automate administrative tasks with T-SQL, SQL Server Agent, and PowerShell. Build deployment, refresh, monitoring, and alerting scripts and self-service tools for development teams.
Administer SSIS, SSRS, and SSAS: deploy packages, manage report servers, support tabular and multidimensional models, troubleshoot ETL processes, and optimize execution performance.
Provide secondary database support for Oracle 11g/12c/19c and PostgreSQL 12+: installation, patching, user management, backups, performance monitoring, security, replication, and assistance with migrations to SQL Server.
Develop and enforce database standards and best practices, create technical documentation, participate in 24/7 on-call rotation, collaborate with development and infrastructure teams on database design, plan and execute migrations and consolidations, perform root-cause analysis for incidents, mentor junior DBAs, and evaluate new database technologies and tools.
Never miss an opportunity! Create an alert based on the job you applied for.
