Affinitiv

SQL Database Administrator, DBA

Affinitiv

full-time

Posted on:

Location Type: Remote

Location: United States

Visit company website

Explore more

✨ AI Apply
Apply

Tech Stack

MS SQL ServerSQL

About the role

  • Install, configure, and maintain Microsoft SQL Server instances on Windows Server.
  • Manage databases across development, staging, and production environments.
  • Perform patching, upgrades, health checks, and routine maintenance tasks.
  • Monitor database and server performance using SQL Server-native tools and third-party platforms.
  • Optimize queries, indexes, jobs, and overall database architecture.
  • Diagnose and resolve performance bottlenecks across storage, compute, and SQL layers.
  • Design, implement, and maintain robust backup and recovery strategies.
  • Support HA/DR solutions including Always On Availability Groups, Clustering, Log Shipping, and Replication.
  • Ensure Affinitiv’s systems meet defined RPO/RTO requirements.
  • Manage database-level security, accounts, roles, encryption, and auditing.
  • Work with Security and Compliance teams to meet internal and external standards.
  • Monitor activity for abnormal or high-risk events and act proactively.
  • Partner with Infrastructure, Network, and Application teams to support server builds and configurations.
  • Develop and maintain scripts to automate routine tasks.
  • Leverage monitoring for proactive oversight.
  • Improve database management efficiency through automation and tooling enhancements.
  • Work closely with software engineering, SRE, and product teams to support database needs in application lifecycles.
  • Provide database expertise for new application features, deployments, and architecture decisions.
  • Maintain clear, thorough documentation of database structures, configurations, and procedures.

Requirements

  • 4–7+ years of hands-on SQL Server DBA experience in enterprise or datacenter environments.
  • Deep understanding of SQL Server HA/DR technologies.
  • Experience with performance tuning, optimization, and advanced T-SQL.
  • Familiarity with PowerShell automation.
Benefits
  • medical
  • dental
  • vision
  • 401K effective day 1
  • generous PTO
Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools
Microsoft SQL ServerT-SQLPowerShelldatabase performance tuningbackup and recovery strategieshigh availabilitydisaster recoveryquery optimizationdatabase securityautomation scripting
Soft Skills
collaborationproblem-solvingcommunicationdocumentationproactive monitoring