Senior Database Architect – SQL Server & PostgreSQL

Decskill; Porto; On-site; EUR 55,000 - 75,000; Full time

Job summary

Decskill is seeking a Senior Database Analyst to design, optimise and maintain our database environments (Microsoft SQL Server and PostgreSQL) across our international operations. You will fine-tune performance, develop ETL processes and collaborate with development teams to ensure data integrity and availability.

Successful candidates will have strong troubleshooting skills, experience with monitoring tools (Dynatrace, ELK, Zabbix) and a solid DevOps mindset.

Qualifications

• Strong experience administering complex Microsoft SQL Server and PostgreSQL environments.
• Experience developing, optimising and monitoring ETL processes with SQL procedures and functions.
• Proven expertise in SQL performance tuning, partitioning and indexing.
• Experience with Master Data Services.
• Root cause analysis and database troubleshooting skills.
• Knowledge of monitoring tools (Dynatrace, ELK, Zabbix).
• DevOps practices including CI/CD; ITIL basics.
• Experience supporting production environments and business-critical applications.
• Excellent communication and collaboration with cross-functional teams.
• Fluency in Portuguese and strong English; some Spanish valued.

Responsibilities

• Design, implement and maintain database systems with a focus on data integrity and availability.
• Administer and optimise Microsoft SQL Server and PostgreSQL environments.
• Monitor critical processes and ensure database systems meet business requirements.
• Develop, optimise and maintain SQL queries, stored procedures, functions and triggers.
• Develop and monitor ETL processes for data integration and ops efficiency.
• Collaborate with development teams to boost performance and outcomes.
• Implement and maintain backup and recovery strategies; ensure data integrity.
• Provide support to developers and APS teams; investigate database incidents.
• Conduct root cause analyses and participate in post-mortems for major incidents.
• Monitor performance using tools (Dynatrace, Power BI, etc.) and optimize costs.

Skills

Microsoft SQL Server

PostgreSQL

ETL development

SQL performance tuning

Partitioning

Indexing

Master Data Services

Dynatrace

ELK

Zabbix

DevOps CI/CD

ITIL basics

Production support

English proficiency

Portuguese fluency

Spanish knowledge (nice-to-have)

Education

Bachelor’s or Master’s in Computer Science / related field

Tools

Dynatrace

Power BI

Job description

Decskill is seeking a Senior Database Analyst to design, optimise and maintain our database environments (Microsoft SQL Server and PostgreSQL) across our international operations. You will fine-tune performance, develop ETL processes and collaborate with development teams to ensure data integrity and availability.

Successful candidates will have strong troubleshooting skills, experience with monitoring tools (Dynatrace, ELK, Zabbix) and a solid DevOps mindset.