Data Intensity · 2 days ago
Database Administrator - MSSQL
US
Full-time
Onsite
Mid Level
3+ years expData Intensity is seeking a mid-level MSSQL DBA to manage day-to-day database operations and ensure high availability and security across SQL Server environments. The role involves collaboration with application teams and DevOps to maintain reliable and scalable data platforms.
Cloud Data ServicesDatabaseInformation TechnologyProfessional ServicesSoftware
Responsibilities
Install, configure, and maintain Microsoft SQL Server (2016+ preferred) across development, staging, and production
Manage user access, roles, and security (AD integration, least privilege, auditing)
Plan and apply patches and cumulative updates, managing change windows and rollbacks
Monitor and tune performance (indexes, stats, query plans, I/O, memory, CPU)
Use tools such as Query Store, Extended Events, DMVs, and third-party monitoring (e.g., Redgate, SolarWinds/DPA)
Conduct root cause analyses and implement permanent fixes
Design and maintain backup/restore strategies (native backups, compression, encryption)
Implement and support HA/DR (Always On Availability Groups, Log Shipping, Failover Cluster Instances)
Test and document disaster recovery procedures with defined RPO/RTO
Partner with developers on T‑SQL best practices, schema design, and code reviews
Manage deployments (SSDT/DACPAC, migrations) and support CI/CD integration
Optimize stored procedures, views, functions, and ETL jobs (SSIS or equivalent)
Automate routine tasks with PowerShell, SQL Agent jobs, and scripts
Maintain monitoring and alerting for capacity, performance, and availability
Produce runbooks, documentation, and knowledge base articles
Implement encryption at rest/in transit, data masking, and retention policies
Support audits and compliance (e.g., SOX, HIPAA, PCI) where applicable
Support SQL Server in Azure/AWS VMs; familiarity with Azure SQL Managed Instance/Azure SQL Database a plus
Participate in migration or modernization initiatives
Qualification
Required
3–6 years of hands-on experience as an MSSQL DBA in production environments
Strong knowledge of SQL Server 2016/2019/2022 administration, T‑SQL, indexing, statistics, and query optimization
Experience with Always On Availability Groups, backups/restores, and SQL Server Security (encryption, auditing)
Proficiency with Windows Server, Active Directory, and networking basics (DNS, TCP/IP)
Experience with PowerShell scripting and SQL Server Agent job management
Familiarity with monitoring/observability tools (native + third-party)
Excellent documentation, communication, and stakeholder collaboration skills
Preferred
Exposure to Azure SQL (PaaS/MI), AWS RDS for SQL Server, or Kubernetes (SQL on containers)
Experience with SSIS, SSRS, SSAS (or modern equivalents)
Knowledge of ETL/ELT patterns, data warehousing, or BI tooling
Experience with DevOps/CI-CD for databases (Git, pipelines, Redgate, SSDT)
Scripting in Python or Bash, and infrastructure-as-code (Terraform/ARM)
Certifications: Microsoft Certified: Azure Database Administrator Associate, DP-300, or MCSA/MCSE (legacy)
Company
Data Intensity
Solution Expertise. Boutique Service. Trusted Advisor.
501-1000 employees
H1B Sponsorship
Data Intensity has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (3)
2024 (3)
2023 (6)
2022 (7)
2021 (10)
2020 (7)
Funding
Current Stage
Late StageTotal Funding
unknownKey Investors
Audax Group
2017-08-09Private Equity
2017-08-09Acquired
2012-12-13Private Equity
Leadership Team
David Piwowar
Chief People Officer - Data Intensity
James White
Chief Solutions Officer at Data Intensity
Recent News
GlobeNewswire News Room
2025-02-26
2025-02-17
2024-04-10
Company data provided by crunchbase