Senior SQL Server Database Administrator
For job seekers, BONAPOLIA offers a gateway to exciting career prospects and the chance to thrive in a fulfilling work environment. We believe that the right job can transform lives, and we are committed to making that happen for you.
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
- related issues. This role will encompass
- depth SQL Server performance optimization, including indexing, wait stats analysis, query tuning, and integration with. NET-based applications. Additionally, experience with both
- premises and
- based installations is crucial to the organization's evolving infrastructure.
About Our Project
The customer landed an
- 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+
- functional, and 50+ process requirements to be delivered within the project's scope.
Project Tech Stack
- MS-SQL
- Team
City (CI/CD)
- Git
- Elastic
Search and Kibana
- Redis cache
- Launch
Darkly (Feature flags)
- WCF
- REST API
- ASP. NET
- Windows servers
- Hyper
V
- Power
Shell
- Kafka
MQ
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
- 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
- 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
-
- 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
- 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
Fii primul, care se va înregistra la oferta de muncă respectivă!
-
De ce să cauți de muncă pe Lucrezi.ro?
În fiecare zi oferte noi de muncă Puteți alege dintr-o gamă largă de locuri de muncă: Scopul nostru este de a oferi o gamă cât mai largă de opțiuni Lasă să-ți fie trimise noile oferte prin e-mail Fii primul care răspunde la noile oferte de muncă Toate ofertele de muncă într-un singur loc (de la angajatori, agenții și alte portaluri) Toate serviciile pentru persoanele aflate în căutarea unui loc de muncă sunt gratuite Vă vom ajuta să găsiți un nou loc de muncă