
Caixa Mágica Software razvija prilagojene IT-rešitve s poudarkom na odprtokodnih tehnologijah in programski opremi, osredotočeni na človeka. Njeno delo zajema programsko inženirstvo, oblikovanje UX/UI, raziskave in razvoj ter umetno inteligenco, pri čemer podpira projekte na področjih mobilnih naprav, namiznih okolij, spleta in avtomobilske industrije. Podjetje z več kot dvema desetletjema izkušenj zagotavlja tudi nearshore kadrovske storitve, ki povezujejo podjetja z evropskimi tehnološkimi strokovnjaki. Njegovo strokovno znanje uporabljajo organizacije s področij svetovanja, logistike in proizvodnje.
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.
Opis
- 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.
Zahteve
- 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.
Ugodnosti
- 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.
Sorodna delovna mesta
Ni najdenih delovnih mest
Poskusite prilagoditi ali počistiti filtre, da najdete več priložnosti.