MS SQL Server Database Administrator

HR Ways - Hiring Tech Talent

Experienced SQL Server Database Administrator for US real estate tech company. Responsible for health, performance, and security of SQL Server environment.

Posted 7/2/2026full-timeRemote • 🇵🇰 PakistanMid-LevelSeniorWebsite

Tech Stack

Tools & technologies

MS SQL ServerSQL

About the role

Key responsibilities & impact

Monitor overall SQL Server health, performance, and availability on a daily basis
Proactively identify and resolve SQL Server issues before they cause system outages
Manage and monitor SQL Agent Jobs and Maintenance Plans, ensuring they execute successfully
Review and maintain SQL Server error logs, event logs, and system alerts
Perform regular database integrity checks, index maintenance, and statistics updates
Ensure adequate disk space, memory, and CPU resource allocation for SQL Server instances
Manage and monitor SQL Server replication (transactional, merge, or snapshot as applicable)
Troubleshoot and resolve replication errors and latency issues promptly
Document replication topology, subscriber/publisher configurations, and recovery procedures
Implement alerts for replication failures with escalation procedures to prevent business downtime
Serve as the SQL SME (Subject Matter Expert) for the CounterPoint point-of-sale platform
Coordinate with CounterPoint support teams on SQL-related issues and escalations
Investigate and resolve database issues that cause CounterPoint instability or non-functionality
Maintain documentation of CounterPoint database schema, stored procedures, and custom objects
Design, implement, and verify robust SQL Server backup strategies (full, differential, transaction log)
Test and document database restore procedures regularly
Maintain and enforce Recovery Time Objectives (RTO) and Recovery Point Objectives (RPO)
Ensure backup jobs are monitored and completed successfully; respond to backup failures immediately
Manage SQL Server logins, roles, and permissions following least-privilege principles
Conduct periodic security audits of database access and permissions
Apply SQL Server service packs, cumulative updates, and security patches on a regular schedule
Maintain compliance with internal data governance and security policies
Document all existing SQL Server configurations, Agent Jobs, Maintenance Plans, and replication setups
Establish and maintain a SQL Server runbook and standard operating procedures (SOPs)
Recommend and implement improvements to database architecture, performance, and reliability
Provide regular status reports on SQL Server health to IT management

Requirements

What you’ll need

5+ years of hands-on Microsoft SQL Server DBA experience (SQL Server 2016 or later)
Demonstrated expertise in SQL Server replication (transactional replication strongly preferred)
Strong proficiency in T-SQL, SQL Server Agent, and Maintenance Plan management
Experience with SQL Server performance tuning, query optimization, and index management
Solid understanding of SQL Server backup and recovery strategies
Experience troubleshooting and resolving production SQL Server issues under pressure
Ability to review and take ownership of an undocumented, inherited SQL environment
Strong written and verbal communication skills; ability to explain technical issues to non-technical stakeholders.

Benefits

Comp & perks

Gadgets like a laptop provided by the company
Tax free salary

ATS Keywords

✓ Tailor your resume

Applicant Tracking System Keywords

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

Hard Skills & Tools

SQL Server 2016T-SQLSQL Server AgentMaintenance Plan ManagementDatabase Integrity ChecksIndex ManagementReplication TroubleshootingBackup StrategiesSecurity AuditsPerformance Optimization

Soft Skills

Strong Written CommunicationStrong Verbal CommunicationProblem-Solving Under Pressure