Job Description
Join our award-winning A-Team!
Ready to produce exceptional results with exceptional people? Get in touch, we would love to get to know you.
Affinitiv is the largest provider of end-to-end, data-driven marketing and software solutions exclusively focused on the automotive customer lifecycle. Backed by 20+ years of automotive and marketing expertise, we pride ourselves on being the go-to experts in the industry. Not only do we work with over 6,500 dealerships and every major manufacturer in the country, we’re well-versed in OEM standards and the intricacies of a dealership or group’s local business.
Position Overview
Affinitiv is seeking a skilled SQL Database Administrator (DBA) to support, maintain, and optimize our on-premises SQL Server environments running on Microsoft Windows within a secure datacenter. This role is critical in ensuring the reliability, performance, and availability of the databases supporting Affinitiv’s enterprise applications and client-facing platforms.
Key Responsibilities:
• 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.
Performance & Tuning
• 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.
Backup, Recovery & High Availability
• 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.
Security & Compliance
• 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.
Windows Server & Datacenter Operations
• Partner with Infrastructure, Network, and Application teams to support server builds and configurations.
Automation & Monitoring
• Develop and maintain scripts to automate routine tasks.
• Leverage monitoring for proactive oversight.
• Improve database management efficiency through automation and tooling enhancements.
Cross-Team Collaboration
• 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.
Required Qualifications:
• 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.
Preferred Qualifications:
• Experience with virtualization technologies (VMware or Hyper-V).
• Exposure to SAN/NAS storage systems and clustering.
• Cloud database experience (Azure SQL, Managed Instance) is a plus.
• Relevant certifications (Microsoft, Azure, etc.).
Soft Skills:
• Strong communication, collaboration, and documentation abilities.
• Detail-oriented with a strong focus on operational excellence and data integrity.
• Ability to work independently, prioritize effectively, and respond quickly in high-availability environments.
Work from Here
At Affinitiv, we have the best of both worlds. Our team members have embraced remote work and our Work from Here program allows for remote working and the utmost flexibility while keeping in person collaborating thriving in a safe work environment. Our Work from Here approach gives team members a choice to work on campus or remote, leaders can hold in person or virtual team meetings to collaborate and cultivate relationships.
Affinitiv knows you have interests outside of work, which is why we offer a comprehensive benefits package that includes medical, dental, vision and 401K effective day 1 just to name a few. We also offer generous PTO so you can enjoy off time with family and friends.
At Affinitiv, we celebrate diversity, equality, and an inclusive environment.
Affinitiv is committed to providing an environment of mutual respect where equal employment opportunities are extended to all employees and applicants for employment. We prohibit discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state, or local laws.
All aspects of employment are decided on the basis of qualifications, competence, merit, and business needs. Affinitiv is proud to be an equal opportunity employer.
