Summary: This role involves designing, maintaining, and optimizing database systems to ensure high availability, performance, and data quality across the organization. Highlights: 1. Design and implement database systems and optimize SQL queries 2. Administer and maintain databases in operational condition 3. Grow as a database and data platform expert with continuous training Every moment counts. Especially those you live to the fullest. Welcome to Consort Group. For over 30 years, Consort Group has been helping companies leverage their data and infrastructure. It is backed by two leaders, Consortis and Consortia, and places people and social responsibility at the heart of its values. **This is your future team** Established in 2021, Consort Portugal supports the strategic offshoring choices of our clients, particularly in Europe, and brings our expertise in infrastructure services to the Portuguese market. With a team of around 45 employees, our Service Center based in Porto is developing a dynamic nearshore business, offering the French and European markets an environment of excellence and high potential. #### **Database Analyst** **This is your mission** Are you passionate about data integrity, database performance, and business\-critical systems? Then this position is for you. As a Database Analyst, you will be responsible for designing, maintaining, and optimizing database systems and supporting business processes to ensure high levels of availability, performance, and data quality across the organization. **Build side:** * Design and implement database systems within enterprise information systems * Develop and optimize SQL queries, stored procedures, functions, and triggers for data manipulation and reporting * Work closely with development teams to improve business process efficiency and outcomes * Assess and deploy innovative database solutions to simplify, automate, and optimize costs * Ensure alignment between database architecture and business requirements * Contribute to continuous improvement of data platforms and processes **Run side:** * Monitor and support critical business processes relying on database systems * Administer and maintain databases in operational condition * Implement and manage backup strategies to ensure data integrity and availability * Ensure backups comply with strategies defined by business lines * Provide technical support to development and application production support teams * Intervene during database incidents impacting performance or access to information * Actively participate in post\-mortems for major or recurring incidents * Ensure performance and availability through monitoring and visualization tools **This is your background** You have strong experience as a Database Analyst or Database Administrator, supporting business\-critical applications in complex environments. You enjoy working at the intersection of data, systems, and business processes and thrive in collaborative, cross\-functional teams. **This is your career path** You will continue to grow as a database and data platform expert, strengthening your expertise in performance optimization, automation, monitoring, and modern BI and DevOps practices. **This is your expertise:** * Microsoft BI stack: SSIS, SSRS, SSAS (preferably Tabular models) * ETL development, optimization, and monitoring (SQL procedures, functions, etc.) * SQL performance tuning, partitioning, and indexing * Root cause analysis and incident resolution * Power BI * Master Data Services * C\#, PowerShell, .NET * Monitoring tools: Dynatrace, ELK, Zabbix * ITIL practices * DevOps / CI\-CD practices (working knowledge) **This is how you work as part of a team:** * Strong oral and written communication skills * Excellent collaboration and teamwork abilities * Analytical and problem\-solving mindset * High attention to detail and rigor * Creative and innovative approach to process improvement * Ability to design, adapt, and evolve processes effectively **Language skills** * Portuguese: mastery * English: professional proficiency * Spanish: basic knowledge **This is our commitment** At Consort Group, you are an expert who we support so that every assignment becomes a step that counts. * Attentive and human onboarding * A truly hands\-on management style * Continuous training opportunities * Concrete commitments: inclusion, equality, solidarity * The Move Up x United Heroes program to get moving and breathe * A comprehensive HR package: health insurance, TR card, CSE, pension plan * A culture of feedback and meaningful projects **Good to know** Location: **Lisbon or Porto** Contract: Permanent contract Remote work: **Hybrid** Job category: **Database Administration / Database Engineering** **What you will do here, you won't do anywhere else.** **This moment is yours.**