Database Analyst Senior

Caixa Mágica Software; Lisboa; On-site; EUR 55,000 - 90,000; Full time

Benefits offered by this job

Permanent contract

Tech equipment

Health and Life Insurance

Social events and team buildings

Training & certifications

Office snacks

Job summary

Caixa Mágica Software in Lisbon is seeking a Senior Database Analyst to design, administer, maintain and optimize 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

Qualifications

• 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
• Master Data Services
• Database Backup and Recovery Strategies

Responsibilities

• 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

Skills

SQL Server

PostgreSQL

Database Administration

Performance Tuning

Incident Resolution

DevOps & CI/CD

ITIL

Data Security

Power BI

Dynatrace

ELK

Zabbix

Git

Tools

Power BI

Dynatrace

ELK

Zabbix

Git

Job description

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.