Database Analyst Senior
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 Senior
This is your mission
Are you passionate about data management and optimization? Then this position is for you.
As Database Administrator, you will be responsible for designing, maintaining, and optimizing database systems and ensuring high levels of data integrity, performance, and availability in our ecosystem:
Build side:
- Designing and implementing database systems in the Information Systems.
 - Developing and optimizing SQL queries, stored procedures, and database triggers for data manipulation and reporting.
 - Working closely with Development teams to improve the value of business process outcomes.
 - Managing high-complexity databases such as Microsoft SQL Server and PostgreSQL.
 - Implementing backup systems to ensure the integrity of all database data.
 
Run side:
- Monitoring and supporting critical business processes to ensure optimal performance.
 - Provide support to developers and APS teams, troubleshooting and resolving database incidents.
 - Ensuring backups are made according to the defined strategy by each business line.
 - Actively participate in post-mortems for major and/or recurring database incidents.
 - Provide technical advisory on database performance, automation, and cost optimization.
 
This is your background
You have at least 5 years of experience in database management and optimization, specifically working with SQL databases (SQL Server, PostgreSQL). You enjoy improving database performance, automating processes, and optimizing business-critical applications. You are looking for a role where you can leverage your skills to support a diverse range of business teams and ensure high availability and data integrity.
This is your career path.
You have at least 5 years of experience in designing and optimizing databases and have worked on complex, large-scale database systems. You enjoy solving performance bottlenecks, innovating database solutions, and working on critical business applications. You are looking for an environment where your ideas matter and technology goes hand in hand with collaboration.
This is your expertise:
- Database Optimization & Performance Tuning: Expertise in developing, optimizing, and monitoring ETL processes, SQL procedures, and functions.
 - Root Cause Analysis: Strong skills in identifying issues and improving database performance through partitioning, indexing, and performance tuning.
 - Master Data Services: Experience managing and maintaining Master Data Services to ensure high-quality data across the organization.
 - DevOps & CI/CD: Practical experience with DevOps pipelines and Continuous Integration/Continuous Deployment (CI/CD) tools.
 - Monitoring Tools: Experience with tools like Dynatrace, Zabbix, or ELK for performance monitoring and troubleshooting.
 
This is how you work as part of a team:
- Communication Skills: Excellent oral and written communication, able to explain complex technical issues in a clear and concise manner.
 - Team Collaboration: Strong teamwork skills, capable of working effectively with cross-functional teams to resolve database issues and optimize processes.
 - Problem Solving & Analytical Thinking: Excellent ability to analyze problems systematically, find root causes, and develop innovative solutions.
 - Attention to Detail: High level of rigor and attention to detail, ensuring all database systems are working efficiently and securely.
 
Language Skills:
Portuguese: Mastery
English: Expert
Spanish: Notions
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
 
The recruitment process:
- An initial phone call with our recruitment team
 - An HR interview and a job interview with a business engineer
 - A test or technical interview with one of our experts
 - A final meeting with your future manager or project manager
 - And if we're a good fit, we'll get started together
 
Good to know
Location: Lisbon or Porto
Contract: Permanent contract
Remote work: Twice a week at client's premises
Job category: Database Administration / Data Management
What you will do here, you won't do anywhere else.
This moment is yours.
- Locations
 - Porto, Lisbon
 - Remote status
 - Hybrid
 - Employment type
 - Contract
 - Famille de Métiers
 - Data