Database Analyst Senior

Caixa Mágica Software; Portugal; On-site; EUR 45,000 - 65,000; Full time

Benefits offered by this job

Health and Life Insurance

SIM Card and personal smartphone

Training in the latest technologies

Coffee, fruits, snacks

Job summary

Caixa Mágica Software in Portugal seeks a Senior Database Analyst to design, administer, maintain and optimize database platforms that support critical business applications. You will ensure performance, availability, integrity and security while collaborating with Development, Operations and Security teams.

You will work with Microsoft SQL Server and PostgreSQL, performing SQL tuning, backups, automation and incident resolution while supporting production environments and data management

Qualifications

• Experience in database administration, optimization and support.
• Expertise with Microsoft SQL Server and PostgreSQL environments.
• Experience supporting critical business applications and production environments.
• Knowledge of ETL processes, performance tuning and database automation initiatives.
• Strong collaboration with Development, Operations and Security teams.

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 triggers.
• Collaborate with Development teams to improve application performance.
• Manage MS SQL Server and PostgreSQL environments.
• Administer and maintain databases ensuring stability and availability.
• Implement and maintain backup and recovery solutions.
• Ensure backups and recovery procedures comply with strategies.
• Provide technical support to Development and Production Support teams.
• Investigate incidents affecting performance, availability and data access.
• Participate in post-mortem analysis for major incidents.
• Monitor tech trends and identify opportunities for optimization and innovation.
• Deploy solutions focused on simplification, automation and cost optimization.

Skills

Database Administration

SQL Performance Tuning

Incident Investigation

Automation

Collaboration with Dev/Ops/Sec

Backup and Recovery

MS SQL Server

PostgreSQL

Tools

Dynatrace

ELK

Zabbix

Power BI

Job description

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)

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.