MS SQL Server Database Administrator

Job not on LinkedIn

🔥 0 minutes ago

Apply Now

Find Similar Remote Jobs

Receive Emails For Remote Jobs

📊 Check your resume score for this job

Improve your chances of getting an interview by checking your resume score before you apply.

Upload Resume

HR Ways - Hiring Tech Talent

WebsiteLinkedInAll Job Openings

11 - 50 employees

Founded 2017

👥 HR Tech

🎯 Recruiter

☁️ SaaS

HR Tech • Recruitment • SaaS

HR Ways is a trusted technical recruitment agency specializing in hiring tech talent across various regions, including Dubai, Saudi Arabia, and India. The company focuses on providing a comprehensive range of HR outsourcing services, including recruitment, payroll, background checks, and staff augmentation. With a deep understanding of the tech industry, HR Ways partners with over 300 tech companies globally to help them build top-tier technology teams, ensuring the right fit for each organization. Their expertise and commitment to quality have made them a preferred choice for employers looking to streamline their hiring processes and boost productivity.

📋 Description

• 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

• 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

• Gadgets like a laptop provided by the company • Tax free salary