Senior Database Performance Architect

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

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