Senior SQL Server Database Administrator

Jobbify är en jobbplattform för vassa kandidater.
För kunds räkning har vi publicerat denna annons, vill du komma i kontakt med den slutgiltiga arbetsgivaren kan du klicka dig vidare till annonsen:

We are looking for a highly skilled and experienced Senior SQL Server Database Administrator (DBA) with expertise in Microsoft SQL Server to manage, optimize, and ensure the performance, availability, and security of our SQL Server database systems. The ideal candidate will have a strong background in database administration, SQL Server expertise, and the ability to proactively address database-related issues. This role will encompass in-depth SQL Server performance optimization, including indexing, wait stats analysis, query tuning, and integration with .NET-based applications. Additionally, experience with both on-premises and cloud-based installations is crucial to the organization's evolving infrastructure.

About Our Project

The customer landed an enterprise-level project within Procure-2-Pay in August 2022. The project is for the Danish government, and the scope is procurement, invoice workflow management, and contract management.

We have had this customer using our platform since 2014. Still, the new tender also includes many changes, including a minimum requirement to deliver a completely new invoice workflow solution handling the entire payment plan for the Danish government. The project has 350+ functional requirements, 150+ non-functional, and 50+ process requirements to be delivered within the project's scope.

Project Tech Stack

MS-SQL



TeamCity (CI/CD)



Git



ElasticSearch and Kibana



Redis cache



LaunchDarkly (Feature flags)



WCF



REST API



ASP.NET



Windows servers



HyperV



PowerShell



KafkaMQ


Requirements

Proven experience as a SQL Server Database Administrator with expertise in indexing, wait stats analysis, and query tuning



Proficiency in SQL, T-SQL, and query optimization



Knowledge of database security best practices and compliance requirements



Experience with high availability and disaster recovery solutions



Significant background with .NET for connecting databases with the application codebase and verifying findings



Ability to troubleshoot and resolve database-related issues



Teamwork skills


Nice-to-have

Relevant certifications (e.g., Microsoft Certified: Azure Database Administrator Associate)


English level:

Intermediate+

Responsibilities:

Administer, configure, and maintain Microsoft SQL Server databases to ensure high availability and performance



Create, modify, and optimize database objects, such as tables, views, stored procedures, and functions



Monitor database performance, troubleshoot, and resolve issues in a timely manner



Implement and maintain database security, including user access control and data encryption. Ensure compliance with data protection regulations and best practices for data security



Develop and maintain backup and recovery strategies to prevent data loss and ensure business continuity. Perform regular backups and test recovery procedures to guarantee data integrity



Identify and resolve database performance bottlenecks through indexing, wait stats analysis, and query tuning. Optimize SQL queries to enhance overall system performance



Configure and manage high-availability solutions, such as failover clustering and database mirroring. Develop and maintain disaster recovery plans to minimize data loss and downtime



Plan and execute SQL Server upgrades and apply patches to keep systems up-to-date and secure



Collaborate with developers to integrate SQL Server databases with .NET-based codebase. Verify findings through codebase interactions



Manage SQL Server installations in both on-premises and cloud environments



Implement and optimize database solutions on cloud platforms, such as Azure SQL Database or AWS RDS



Implement automation and scripting to streamline routine tasks and improve efficiency



Collaborate with application developers and IT teams to ensure seamless integration with database systems



Provide guidance and support to developers in database design and optimization


Location: Hungary, Lithuania, Poland, Romania