Senior Database Analyst

Caixa Mágica Software

. Design and implement database solutions within Information Systems environments .

Posted 10/22/2026full-timeLisbon • PortugalSeniorWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in Database Administration and Optimization, with a strong focus on Microsoft SQL Server and PostgreSQL environments. Capable of implementing innovative database solutions, ensuring performance, availability, and compliance with backup and recovery strategies.

Highest-signal resume keywords

Database AdministrationMicrosoft SQL Server ManagementPostgreSQL ManagementSQL DevelopmentETL Development

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

Database OptimizationSQL Performance TuningStored ProceduresFunctionsBackup and Recovery StrategiesRoot Cause AnalysisIncident InvestigationMaster Data ServicesDatabase AutomationData Reporting

Soft Skills

CollaborationProblem-SolvingCommunication

Tools & Technologies

DynatraceELKZabbixPower BI

Industry Keywords

ITIL MethodologyDevOpsCI/CD PracticePerformance TuningBusiness Process Optimization

Tech Stack

Tools & technologies

ETLMS SQL ServerPostgresSQL

About the role

Key responsibilities & impact

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

Requirements

What you’ll need

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

Benefits

Comp & perks

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