You have opted out of job matches in .
To undo this, go to the 'Skills and Interests' section of your preferences.
Shared by 
about 20 hours ago
warning
Heads-up
Requirements and responsibilities
Hiring from PakistanClient Company Introduction: A US based real estate tech platform/company having 100+ employees working over there.Opening: MS SQL Server Database AdministrationWe are seeking an experienced Microsoft SQL Server Database Administrator (DBA) to join our team in-house. This is a critical role responsible for the health, performance, security, and reliability of our SQL Server environment, which serves as the backbone of our Counterpoint point-of-sale and business operations platform. The successful candidate will take ownership of all SQL Server infrastructure, proactively monitor system health, and resolve issues before they impact business operations.This role was identified as a critical gap following ongoing SQL replication and performance issues that have directly impacted system availability. The DBA will be the primary technical owner of all SQL-related systems.Job Responsibilities:SQL Server Administration & Health MonitoringMonitor overall SQL Server health, performance, and availability on a daily basisProactively identify and resolve SQL Server issues before they cause system outagesManage and monitor SQL Agent Jobs and Maintenance Plans, ensuring they execute successfullyReview and maintain SQL Server error logs, event logs, and system alertsPerform regular database integrity checks, index maintenance, and statistics updatesEnsure adequate disk space, memory, and CPU resource allocation for SQL Server instancesReplication ManagementManage and monitor SQL Server replication (transactional, merge, or snapshot as applicable)Troubleshoot and resolve replication errors and latency issues promptlyDocument replication topology, subscriber/publisher configurations, and recovery proceduresImplement alerts for replication failures with escalation procedures to prevent business downtimeCounterPoint & Business Application SupportServe as the SQL SME (Subject Matter Expert) for the CounterPoint point-of-sale platformCoordinate with CounterPoint support teams on SQL-related issues and escalationsInvestigate and resolve database issues that cause CounterPoint instability or non-functionalityMaintain documentation of CounterPoint database schema, stored procedures, and custom objectsBackup, Recovery & Business ContinuityDesign, implement, and verify robust SQL Server backup strategies (full, differential, transaction log)Test and document database restore procedures regularlyMaintain and enforce Recovery Time Objectives (RTO) and Recovery Point Objectives (RPO)Ensure backup jobs are monitored and completed successfully; respond to backup failures immediatelySecurity & ComplianceManage SQL Server logins, roles, and permissions following least-privilege principlesConduct periodic security audits of database access and permissionsApply SQL Server service packs, cumulative updates, and security patches on a regular scheduleMaintain compliance with internal data governance and security policiesDocumentation & Continuous ImprovementDocument all existing SQL Server configurations, Agent Jobs, Maintenance Plans, and replication setupsEstablish and maintain a SQL Server runbook and standard operating procedures (SOPs)Recommend and implement improvements to database architecture, performance, and reliabilityProvide regular status reports on SQL Server health to IT managementRequired Qualifications: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 managementExperience with SQL Server performance tuning, query optimization, and index managementSolid understanding of SQL Server backup and recovery strategiesExperience troubleshooting and resolving production SQL Server issues under pressureAbility to review and take ownership of an undocumented, inherited SQL environmentStrong written and verbal communication skills; ability to explain technical issues to non-technical stakeholdersPreferred Qualifications:Experience with NCR CounterPoint or similar retail/POS platformsMicrosoft certifications: MCSA/MCSE Data Management, or DP-300 (Administering Relational Databases on Microsoft Azure)Experience with SQL Server high availability (Always On Availability Groups, Failover Clustering)Familiarity with SQL Server Reporting Services (SSRS) or Integration Services (SSIS)Experience implementing SQL monitoring tools (SolarWinds DPA, Redgate SQL Monitor, SentryOne, etc.)Prior experience inheriting and documenting legacy SQL environmentsOther Details:Experience: 5+ yearsWork Timings: 7:30 pm - 4 am PKT (Monday - Friday) & Saturday (4 hours - Half Day)Work Mode: Remote from PakistanSalary: Market CompetitiveBenefits:Gadgets like a laptop provided by the companyTax free salaryAbout HR Ways: HR Ways is an Award winning Technical Recruitment Firm helping software houses and IT Product companies internationally and locally to find IT Talent. HR Ways is engaged by 300+ Employers worldwide ranging from worlds biggest SaaS Companies to most competitive Startups. We have entities in Dubai, Canada, US, UK, Pakistan, India, Saudi Arabia, Portugal, Brazil and other parts of the world. Join our WhatsApp Channel https://shorturl.at/983az to stay updated or visit www.hrways.co to know more.
Optionally, you can add more information later (benefits, pre-screening questions, etc.)