MS SQL Server Database Administrator

Jobtailor; Deutschland; Vor Ort; EUR 70.000 - 110.000; Vollzeit

Zusammenfassung

Jobtailor is seeking an experienced SQL Server DBA in Germany to monitor, maintain, and optimize our SQL Server environment, including replication, backups, high availability, and performance tuning, to prevent outages. You will manage SQL Agent Jobs, Maintenance Plans, error logs, and runbooks, coordinating with CounterPoint teams to keep the POS system stable and secure.

The ideal candidate has 5+ years of hands-on SQL Server experience, strong T-SQL skills, and clear communication for

Qualifikationen

• 5+ years of hands-on Microsoft SQL Server DBA experience (SQL Server 2016 or later)
• 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.

Aufgaben

• Monitor overall SQL Server health, performance, and availability daily
• Proactively identify and resolve SQL Server issues before outages
• Manage and monitor SQL Agent Jobs and Maintenance Plans
• Review and maintain SQL Server error logs, event logs, and system alerts
• Perform regular database integrity checks, index maintenance, and statistics updates
• Coordinate with CounterPoint support teams on SQL-related issues and escalations
• Design, implement, and verify robust SQL Server backup strategies (full, differential, transaction log)
• Test and document database restore procedures regularly
• Maintain Recovery Time Objectives (RTO) and Recovery Point Objectives (RPO)
• Ensure backup jobs are monitored and completed successfully; respond to backup failures immediately
• Maintain and enforce least-privilege SQL Server logins, roles, and permissions
• Document all SQL Server configurations, Agent Jobs, Maintenance Plans, and replication setups
• Establish and maintain a SQL Server runbook and SOPs
• Recommend improvements to database architecture, performance, and reliability
• Provide regular status reports on SQL Server health to IT management

Kenntnisse

T-SQL

SQL Server Agent

Maintenance Plans

Performance tuning

Index management

Replication expertise

Tools

CounterPoint Platform

Jobbeschreibung

Responsibilities

• 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.

Tools & Technologies

• CounterPoint Point-of-Sale Platform