Caixa Mágica Software
Caixa Mágica Software
Caixa Mágica Software develops custom IT solutions with a focus on open-source technologies and human-centred software. Its work spans software engineering, UX/UI design, research and development, and artificial intelligence, supporting projects across mobile, desktop, web, and automotive environments. With more than two decades of experience, the company also provides nearshore staffing services, connecting businesses with European technology professionals. Its expertise serves organisations across consulting, logistics, and manufacturing.

Senior Database Analyst – Caixa Mágica Software, Portugal

Support a leading European bank by optimizing SQL Server and PostgreSQL platforms. Help maintain critical applications through database performance, availability, security, backup, recovery and automation.

Description

  • Design and deliver database solutions for Information Systems.
  • Monitor and support critical business processes and database operations.
  • Build and tune SQL queries, stored procedures, functions and triggers for data processing and reporting.
  • Work with Development teams to improve business processes and application performance.
  • Manage complex Microsoft SQL Server and PostgreSQL environments.
  • Operate and maintain databases to support stability and availability.
  • Implement and maintain backup and recovery solutions that meet business needs and policies.
  • Ensure backup and recovery procedures follow established strategies.
  • Provide technical support to Development and Application Production Support teams.
  • Diagnose and resolve incidents affecting database performance, availability or information access.
  • Contribute to post-incident reviews of major and recurring database issues.
  • Track technology developments and identify opportunities to improve and modernize databases.
  • Evaluate and deploy database platform solutions that simplify operations, increase automation and reduce costs.

Requirements

  • Substantial 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.
  • Experience working with Development, Operations and Security teams.
  • Strong focus on database performance, availability, integrity and reliability.
  • Ability to spot improvement opportunities and implement effective database solutions.
  • Microsoft SQL Server administration and management.
  • PostgreSQL administration and management.
  • SQL development, including 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 such as Dynatrace, ELK and Zabbix.
  • DevOps and CI/CD practices.
  • ITIL methodology.
  • Data reporting and visualization tools such as Power BI and Dynatrace.
  • Fluent English.

Benefits

  • Permanent employment contract for a long-term project.
  • Technology equipment, a SIM card and a personal smartphone.
  • Health and life insurance.
  • Social events and team-building activities.
  • Opportunities to grow and receive rewards in line with your development.
  • A supportive, energetic team.
  • Training in current technologies.
  • Coffee, fruit, snacks and a warm welcome at the office.

Related Jobs

No jobs found

Try adjusting or clearing your filters to find more opportunities.