Senior Database Analyst: SQL Server & PostgreSQL

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

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