Database Administrator - MSSQL

DATA INTENSITY LLC

🔍 Observed

Covington, Kentucky, US First seen 1 week, 4 days ago Last seen 2 hours, 29 minutes ago JSearch

This posting may no longer be available.

Our link checker detected that the external page returned an error. The position may have been filled or the listing removed. You can still try the link below, or browse other jobs.

Try Applying on JSearch Search Google for This Role

Job Description

AI Summary

• Own day-to-day MSSQL database operations across dev/staging/production environments, including installation, configuration, patching, security management, and user access control. • Design and maintain backup/recovery strategies, implement HA/DR solutions (Always On Availability Groups, Failover Clusters), and ensure defined RPO/RTO targets are met. • Monitor and optimize database performance using Query Store, Extended Events, DMVs, and third-party tools; conduct root cause analysis and implement permanent fixes. • Support application teams with T-SQL best practices, schema design, code reviews, deployments (SSDT/DACPAC), and CI/CD integration. • Automate routine tasks via PowerShell and SQL Agent; maintain monitoring/alerting; implement data governance, encryption, and compliance controls (SOX, HIPAA, PCI). • Requires 3–6 years MSSQL DBA production experience with SQL Server 2016+, Always On, PowerShell, and monitoring tools; Azure SQL and SSIS exposure preferred.

About the Role We’re looking for a mid-level MSSQL DBA to own day-to-day database operations, performance tuning, high availability, and security across our SQL Server environments. You’ll collaborate closely with application teams, DevOps, and InfoSec to ensure our data platforms are reliable, performant, and scalable. What You’ll Do (Key Responsibilities) • Administration & Operations • 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. • Performance & Optimization • 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. • Backup, Recovery & HA/DR • 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. • Development Support • 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). • Automation & Observability • 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. • Data Governance & Compliance • Implement encryption at rest/in transit, data masking, and retention policies.
Support audits and compliance (e.g., SOX, HIPAA, PCI) where applicable. • Cloud & Modernization (as 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.

Qualifications (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. Nice-to-Have (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). Education • Bachelor’s degree in Computer Science, Information Systems, Engineering, or equivalent experience. Work Eligibility • Must be authorized to work in the United States.

Skills

git terraform aws kubernetes sql go python

Quick Actions

Apply Externally Search Google Back to Jobs

Job Information

Company:
DATA INTENSITY LLC
Location:
Covington, Kentucky, US
Job Type:
Full-Time
Experience Level:
Mid
Source:
JSearch
Status:
Active

Activity Score

68 /100

Likely Active (68)

Higher scores indicate more likely active hiring based on listing freshness, company activity, and other signals. Learn more →