Database Analyst Senior

Há 4 dias

Lisbon, Portugal Caixa Mágica Software Tempo integral

Overview: The leading bank in the European Union and a leading international player is seeking a Database Analyst Senior responsible for designing, administering, maintaining and optimizing database platforms supporting critical business applications. The role focuses on ensuring high levels of database performance, availability, integrity and security while collaborating closely with Development, Operations and Security teams. The consultant will contribute to process optimization, SQL performance tuning, incident resolution, database automation initiatives and continuous improvement of data management solutions.

What will you do?

Design and implement database solutions within Information Systems environments

Monitor and support critical business processes and database operations

Develop and optimize SQL queries, stored procedures, functions and database triggers for data processing and reporting

Collaborate closely with Development teams to improve business process outcomes and application performance

Manage complex Microsoft SQL Server and PostgreSQL environments

Administer and maintain databases in operational conditions ensuring stability and availability

Implement and maintain backup and recovery solutions according to business requirements and policies

Ensure database backups and recovery procedures comply with defined strategies

Provide technical support to Development and Application Production Support teams

Investigate and resolve incidents affecting database performance, availability and access to information

Participate actively in post-mortem analysis for major and recurring database incidents

Monitor technology trends and identify opportunities for database optimization and innovation

Assess and deploy solutions focused on simplification, automation and cost optimization of database platforms

What are we looking for?

Strong experience in Database Administration, Optimization and Support

Expertise in Microsoft SQL Server and PostgreSQL environments

Experience supporting critical business applications and production environments

Knowledge of ETL processes, performance tuning and database automation initiatives

Experience working closely with Development, Operations and Security teams

Strong focus on database performance, availability, integrity and reliability

Ability to identify improvement opportunities and implement innovative database solutions

Microsoft SQL Server Administration and Management

PostgreSQL Administration and Management

SQL Development, Stored Procedures and Functions

ETL Development, Monitoring and Optimization

SQL Performance Tuning, Partitioning and Indexing

Root Cause Analysis and Incident Investigation

Master Data Services

Database Backup and Recovery Strategies

Monitoring Tools (Dynatrace, ELK, Zabbix)

DevOps and CI/CD Practice

ITIL Methodology

Data Reporting and Visualization Tools (Power BI, Dynatrace)

Fluent in English

What can you expect from us?

A permanent job contract for a long term project;

Tech equipment + SIM Card + personal smartphone;

Health and Life Insurance;

Social events and team buildings;

The commitment of letting you grow with us, and be rewarded accordingly;

A dynamic and young team that will be always there to support you;

Training in the latest technologies;

Coffee, fruits, snacks and a warm welcoming when you pass by the office.