SQL Server Database Administrator (Mid-Level)

Company Overview

ActiveProspect is on a mission to make consent-based marketing the best channel for online customer acquisition. We provide marketers the products they need to acquire qualified customers at scale. Our platform is trusted by thousands of companies engaged in direct-to-consumer marketing, helping them save wasted spend, comply with ever-changing regulations, and manage a constantly evolving partner landscape. Our flagship product, TrustedForm is used to certify over 1 billion opt-in digital customer leads every year and is the gold standard for documenting prior express written consent for TCPA compliance.

Job Summary

We are seeking a Database Administrator to own the day-to-day administration, support, and scheduled release of our Microsoft SQL Server environment. The role combines responsive request handling — ad-hoc queries, restores, and environment support for internal teams — with the disciplined execution of recurring production data releases on a defined schedule. The ideal candidate is equally comfortable troubleshooting a time-sensitive issue and managing a multi-component release from planning through completion, while keeping the databases performant, secure, and reliable.

Responsibilities:

• Database Operations & Administration

• Install, configure, upgrade, and patch SQL Server instances across production, testing, and development environments, including cloud-hosted databases.

• Monitor database health, capacity, and performance; proactively tune queries, indexes, and configurations to meet stability and performance targets.

• Implement and maintain backup, recovery, and high-availability strategies, and validate restores on a regular basis.

• Administer database security, access controls, and user management in line with company policy.

• Maintain clear documentation of the database environment, standards, and procedures.

• Request & Support Handling

• Serve as the point of contact for incoming database requests from internal teams (e.g., product, data, support, and operations), tracked through a ticketing system.

• Triage and prioritize requests by severity and business impact, managing competing demands against agreed response expectations.

• Execute ad-hoc queries against production and non-production databases to retrieve and validate data on behalf of requesting teams.

• Restore, refresh, and test databases on demand, and stand up databases in development and test environments.

• Generate schema and DDL scripts — tables, indexes, views, functions, stored procedures, and related objects — to support development and environment setup.

• Reload or correct data sets when source files are missing or require reprocessing.

• Scheduled Database Releases

• Plan and execute recurring (e.g., monthly) production data releases across multiple product lines and database servers.

• Coordinate releases composed of many database components, ensuring each is updated accurately and on schedule.

• Track release progress through a defined workflow (planned, in progress, completed) and communicate status to stakeholders.

• Manage release timelines and dependencies, and perform the scheduled maintenance and deployment activities each release requires.

• Collaboration & Improvement

• Partner with development, infrastructure, and operations teams to resolve database issues and support a smooth end-user experience.

• Assist developers with query tuning, schema refinement, and best practices.

• Identify and implement improvements to database processes and standards, automating routine tasks to reduce manual effort and risk.

Qualifications and Skills

• Bachelor's degree in Computer Science, Information Systems, or a related field, or equivalent practical experience.

• 3+ years of hands-on Microsoft SQL Server database administration experience.

• Strong proficiency in T-SQL, including writing and tuning complex queries, stored procedures, functions, and views.

• Solid understanding of backup and recovery, high availability, and disaster recovery concepts.

• Familiarity with automation and scripting (e.g., PowerShell, SQL Agent jobs, or similar) to streamline routine tasks.

• Experience managing scheduled or recurring production release cycles across multiple environments or product lines.

• Experience with performance monitoring, tuning, and capacity management on production databases.

• Working knowledge of database security and access management.

• Ability to manage and prioritize multiple concurrent requests in a ticket-driven environment.

• Strong attention to detail, organizational skills, and clear written documentation.

• Experience with Microsoft Transparent Data Encryption, Mirroring and Replication preferred.

• Experience administering cloud-hosted databases (e.g. managed SQL Server on a major cloud provider) preferred.

Reports to:

• VP - IT, Security & Business Systems

Direct Reports:

• None

Organizational Impact

This role ensures the SQL Server environment behind our products and operations stays reliable, secure, and performant. Through responsive request handling and on-schedule production releases, the DBA directly enables product delivery, data accuracy, and reduced operational risk across the teams that depend on trustworthy data.

Powered by JazzHR