This list contains only the countries for which job offers have been published in the selected language (e.g., in the French version, only job offers written in French are displayed, and in the English version, only those in English).
The SQL Database Administrator will be responsible for ensuring the optimal performance, availability, and security of our database systems. This role involves a keen understanding of SQL Server architecture, with a focus on performance profiling, permissions management, and data integrity practices. The ideal candidate will possess strong technical skills in SQL and related database technologies, along with an analytical mindset. The candidate will also have Azure experience.
Job Responsibility:
Monitor, analyze, and optimize the performance of databases to ensure they meet the needs of the business
Use tools such as SQL Server Management Studio (SSMS) to identify and resolve performance bottlenecks
Regularly conduct performance reviews and make necessary adjustments to database configurations for optimal operation
Ensure that database users and applications have the appropriate permissions to access and modify tables, stored procedures, and other database objects
Maintain column level encryption for data across clustered server environments
Develop and implement policies for access controls, and audit logging
Update databases to leverage foreign keys, indexes, and other features that enhance performance and integrity
Perform database normalization to eliminate redundancy and improve data consistency
Optimize stored procedures and application queries for efficiency and speed
Load balancing , clustering, database tuning, and denormalization experience to maintain best performance
Leverage Data-tier application tools to maintain schema versioning and consistency in multiple databases
Work closely with developers and other stakeholders to support database needs and address technical challenges
Provide training and guidance on SQL Server technologies and best practices to team members as needed
Support team when creating new columns/tables to optimize storage and data retrieval efficiency based on various factors such as data types
Stay updated with the latest trends in database technology to continually improve our systems
Develop, implement, and maintain a comprehensive backup and disaster recovery strategy
Monitor backup logs and storage systems to ensure that all backups are successful, complete, and performed on schedule
Conduct regular tests of the restore processes to validate effectiveness and to refresh lower environments with production like data
Manage replication of databases across multiple servers in the cluster and review updates to before release to mitigate their impact on replication
Ensure that sensitive data is properly sanitized in lower environments and reduce unnecessary exposure of personal or sensitive information
Requirements:
5+ years of experience as a SQL Server Database Administrator or similar role
Strong hands-on experience with Microsoft SQL Server (installation, configuration, administration, and tuning)
Solid understanding of SQL Server architecture, including Always On Availability Groups (AoAG), clustering, and load balancing
Proven experience with performance profiling and tuning (indexes, queries, stored procedures, execution plans) using tools such as SSMS