SQL Database Administrator

HTP Consulting Services; Remote; USD 80,000 - 100,000; Full time

Job summary

A fully remote IT consulting company is looking for a SQL Server Database Administrator to manage and optimize SQL Server environments across multiple clients. The ideal candidate has 3-7+ years of DBA experience and strong skills in T-SQL, backup strategies, and HA/DR solutions. This role includes performing health checks, ensuring database security, and providing client support. The position offers a competitive salary ranging from $80,000 to $100,000 and a flexible work environment.

Benefits

Competitive salary

Professional development opportunities

Flexible working hours

Remote work options

Qualifications

• 3–7+ years of experience as a SQL Server DBA.
• Strong proficiency with SQL Server versions 2016–2025.
• Deep knowledge of T-SQL and query optimization.

Responsibilities

• Design, implement, and optimize SQL Server environments for various clients.
• Perform routine health checks and manage backups.
• Collaborate with clients to optimize SQL queries.

Skills

SQL Server DBA experience

T-SQL proficiency

Strong analytical skills

Customer service skills

Troubleshooting abilities

Tools

Azure SQL

Windows Server

Monitoring tools

Job description

Salary Range: $80,000 - $100,000 (depending on level of relevant experience)

Company Description

HTP is a fully remote IT consulting company and Managed Service Provider largely focused on data and integrations. We’re a team of adaptable, curious professionals who enjoy solving complex problems and helping our clients grow through smart, scalable technology solutions.

We work collaboratively, move quickly, and support one another. Our company culture emphasizes learning, flexibility, and doing great work without ego. If you’re someone who loves tackling new challenges and wants to work in a supportive, people‑first environment — we’d love to meet you.

Role Description

The SQL Server Database Administrator (DBA) is responsible for the design, implementation, maintenance, and optimization of Microsoft SQL Server environments across multiple clients. This role ensures high availability, performance, security, and recoverability of all database systems while supporting development teams, business stakeholders, and mission‑critical applications.

Key Responsibilities

Database Administration & Maintenance

• Install, configure, and maintain SQL Server instances (on‑premises and/or cloud).
• Perform routine health checks, performance tuning, and index/statistics maintenance.
• Manage database backups, restores, and disaster recovery strategies.
• Monitor system performance and proactively identify bottlenecks or risks.

High Availability & Disaster Recovery

• Implement and support HA/DR solutions such as:
  • Always On Availability Groups
• Conduct regular failover testing and ensure RPO/RTO objectives are met.

Security & Compliance

• Manage database security, including logins, roles, permissions, and encryption.
• Ensure compliance with internal policies and external regulations.
• Audit database activity and maintain proper documentation.

Development & Support

• Collaborate with clients and developers to optimize SQL queries, stored procedures, and schema design.
• Troubleshoot database‑related issues and provide on‑call support as needed.

Automation & Optimization

• Automate routine tasks using T‑SQL or SQL Agent Jobs.
• Implement monitoring and alerting solutions for proactive issue detection.
• Continuously evaluate and improve database performance and reliability.

Soft Skills

• Strong customer service skills and ability to work directly with clients.
• Strong analytical and troubleshooting abilities.
• Excellent communication and documentation skills.
• Ability to work independently and collaboratively in a fast‑paced environment.
• Detail‑oriented mindset with a focus on reliability and uptime.

Must‑Have Qualifications

• 3–7+ years of experience as a SQL Server DBA.
• Strong proficiency with SQL Server versions 2016–2025.
• Deep knowledge of T‑SQL, query optimization, and execution plans.
• Experience with HA/DR technologies and backup/restore strategies.
• Familiarity with Windows Server administration.
• Understanding of networking fundamentals, storage, and virtualization.
• Strong customer service and communication skills.

Nice‑to‑Have Qualifications

• Experience with Azure SQL, Managed Instance, or hybrid cloud environments.
• Knowledge of SSRS, SSIS, or SSAS.
• Experience with monitoring tools (e.g. Idera, Redgate, SolarWinds).
• PowerShell scripting for automation.
• Other database systems knowledge (e.g. Oracle, PostgreSQL, MariaDB/MySQL, SAP).
• Certifications such as Microsoft Azure Database Administrator Associate (DP‑300).

Benefits

• Competitive salary and comprehensive benefits package.
• Opportunities for professional development and career advancement.
• Flexible working hours and remote work options.
• Dynamic and innovative work environment.

Disclosure

HTP Consulting Services is an Equal Opportunity Employer. We are committed to providing a workplace free from discrimination and harassment. All employment decisions, including hiring, promotion, compensation, and termination, are based on qualifications, merit, and business needs without regard to race, color, religion, sex (including pregnancy, gender identity, and sexual orientation), national origin, age, disability, genetic information, veteran status, or any other characteristic protected by federal, state, or local laws. We comply with all applicable laws, including the Equal Employment Opportunity Commission (EEOC) guidelines, to ensure fair treatment for all employees and applicants.