Database Analyst Lisboa

Database Analyst
Lisboa
Lisboa, Lisboa, Portugal

Database Developer – Hybrid (Lisbon or Porto)

Are you passionate about data, performance, and optimisation?

Join our dynamic team and help shape the future of our database systems! We're looking for a skilled SQL Developer to support critical business processes and drive innovation across our platforms.

Main Responsibilities

Database Design & Implementation

• Design and implement robust database systems within our Information Systems landscape
• Monitor and support critical business processes to ensure data reliability
• Develop and optimise SQL queries, stored procedures, and triggers for efficient data manipulation and reporting
• Collaborate closely with Development teams to enhance business process outcomes

Database Administration

• Maintain databases in optimal operational condition
• Implement backup systems to safeguard data integrity
• Ensure backups align with business line strategies

Technical Support

• Provide support to developers and APS teams
• Respond to incidents affecting database performance or data access
• Actively participate in
  - mortems for major or recurring database issues

Technical Advisory

• Monitor technologies to maintain performance and availability using tools like Dynatrace and Power BI
• Evaluate and deploy innovative solutions to simplify, automate, and optimise database costs

Technical Skills

• Strong experience with Microsoft BI stack: SSIS, SSRS, SSAS (preferably Tabular Models)
• Expertise in ETL development, optimisation, and monitoring (SQL procedures, functions, etc. )
• Solid root cause analysis capabilities
• Skilled in SQL performance tuning, partitioning, and indexing
• Experience with C#, Power
  Shell, . NET
• Proficiency in Power BI and Master Data Services
• Familiarity with ITIL and Dev
  Ops (CI/CD) practices
• Experience with monitoring tools (e. g. Dynatrace, ELK, Zabbix)

Language Requirements

• Portuguese
• English

Work Mode

Hybrid – based in Lisbon or Porto