Senior SQL Server Engineer Porto

Senior SQL Server Engineer
Porto
Porto, Porto District, Portugal

As an experienced SQL Server Specialist, you will administer, support, and optimise Microsoft SQL Server databases
- premises and in the cloud. You will ensure our database systems' health, performance, security, and reliability while collaborating with
- functional teams to design and implement innovative database solutions.

Database Administration & Maintenance

• Administer, maintain, and troubleshoot Microsoft SQL Server databases to ensure optimal performance and reliability.
• Monitor database performance, identify bottlenecks, and implement tuning measures to enhance efficiency.
• Plan and execute database upgrades, patches, and migrations while minimizing downtime.

Always On High Availability & Disaster Recovery

• Design, implement, and maintain SQL Server Always On Availability Groups for high availability and disaster recovery.
• Monitor and manage Always On configurations to ensure seamless failover and data replication.
• Conduct periodic failover testing to validate the reliability of
  - availability solutions.

Database Design & Deployment

• Design, deploy, and manage SQL Server databases
  - premises and in cloud environments.
• Collaborate with development, network, and infrastructure teams to architect scalable database solutions.
• Ensure database designs align with best practices for security, performance, and scalability.

Backup, Recovery, & High Availability

• Develop and manage backup and recovery strategies to safeguard data integrity.
• Implement and maintain disaster recovery plans, integrating Always On solutions for maximum resilience.
• Ensure databases adhere to organizational Service Level Agreements (SLAs) for uptime and availability.

Security & Compliance

• Manage database security, including user permissions, encryption, and auditing.
• Enforce compliance with organizational and regulatory standards for data privacy and protection.
• Conduct regular security assessments and proactively address vulnerabilities.

Collaboration & Support

• Work closely with software developers to optimize database queries and enforce best practices in database usage.
• Provide technical support for
  - related issues and guide teams in troubleshooting complex problems.
• Collaborate with
  - functional teams to integrate database solutions into broader IT systems.

Qualifications:

• Experience as a SQL Server Database Administrator.
• Strong knowledge of database architecture, performance tuning, and optimization techniques.
• Hands-on experience with backup, recovery, and high availability strategies.
• Familiarity with SQL Server security best practices, including encryption and
  - based access control.
• Proficiency in scripting and automation for database administration (e. g. , Power
  Shell, Shell Script, T-SQL, Python or Golang).
• Knowledge of observability stacks like Prometheus, Loki and Jira Alerts.
• Knowledge of Windows operating systems.
• Experience working in Agile and SRE environments is a plus.

Skills & Competencies:

• Excellent
  - solving and analytical skills.
• Strong communication skills to collaborate effectively with technical and
  - technical stakeholders.
• Ability to manage multiple priorities and deliver results in a
  - paced environment.
• Detail-oriented with a focus on database integrity and reliability.

The Perks

• We trust you, so we offer flexible working hours, as long it suits both you and your team;
• Health Insurance;
• Meal Allowance;
• 25 days of Annual leave (+ Bank holidays);
• Public Transportation Card;
• Frequent team events & activities in the office and outside;
• Office snacks every day;
• Friendly, comfortable and informal office environment.