AWS/Redshift Database Administrator

IVY Partners; Porto; Presencial; EUR 55 000 - 85 000; Tempo integral

Vantagens oferecidas por esta oferta de emprego

Care

Trust

Innovation

Responsibility

Resumo da oferta

Ivy Partners in Porto is seeking a senior Database Administrator with deep AWS Redshift experience to join our growth-focused team. You will monitor, tune, and scale Redshift clusters in production, implement vacuum and analyze strategies, and work across on-premises and AWS environments.

The role requires 5+ years in production DBAs, fluent English, and the ability to handle on-call rotations and weekend windows, with collaboration across executives and development teams.

Qualificações

• Over 5 years of experience as a Database Administrator with AWS database services in production.
• Expert-level Amazon Redshift administration including cluster management, distribution and sort key strategies, WLM queue configuration, and performance diagnostics.
• Solid operational DBA experience with Oracle, PostgreSQL, MySQL, or SQL Server, on-premises or via AWS RDS/Aurora.
• Available for Saturday production windows and monthly on-call rotations after onboarding (~2–3 months).
• Demonstrate composure and clear communication in high-pressure situations involving executives.
• Fluent English both spoken and written.

Responsabilidades

• Monitor Redshift cluster health, performance, and resource utilization daily.
• Manage and tune WLM queues to isolate and prioritize workloads.
• Implement VACUUM and ANALYZE strategies for large-scale tables in production.
• Diagnose performance issues via SVL/STV views, CloudWatch metrics, and the Redshift console.
• Participate in incident response and war room calls with senior management.
• Proactively monitor all supported DB platforms and collaborate with development teams.
• Conduct maintenance and disaster recovery during scheduled windows.
• Handle on-call responsibilities across DB stack with robust triage capability.
• Oversee installation, configuration, patching, and upgrades across on-premises and AWS environments.
• Administer user access, space allocation, backup policies, and DR configurations.

Conhecimentos

AWS Redshift

WLM configuration

Cluster management

Performance diagnostics

SQL & DB general skills

Incident response

English fluency

Formação académica

Bachelor's degree in Computer Science

Ferramentas

Amazon RDS/Aurora

Oracle

PostgreSQL/MySQL

CloudWatch

Descrição da oferta de emprego

Our Mission

Ivy Partners is a Swiss consulting firm that assists companies in addressing their strategic, technological, and organizational challenges. We are committed to providing our employees with a career that enhances both their personal and professional development. We support their skill advancement and offer genuine opportunities for progression.

Responsibilities

• Monitor Redshift cluster health, performance, and resource utilization daily.


• Manage and tune WLM queues to effectively isolate and prioritize workloads.


• Implement VACUUM and ANALYZE strategies for large-scale tables in a high-demand production environment.


• Diagnose and resolve performance issues through SVL/STV system views, CloudWatch metrics, and the Redshift console.


• Participate in incident response, including war room calls with senior management.


• Proactively monitor all supported database platforms, identify anomalies, and collaborate with development teams.


• Conduct maintenance and disaster recovery operations during scheduled windows.


• Handle on‑call responsibilities across a broad database stack, ensuring robust triage capability.


• Oversee installation, configuration, patching, and upgrades across on‑premises and AWS database environments.


• Administer user access, space allocation, backup policies, and disaster recovery configurations.

Work Arrangement

Work: 4 times per week in the office in Porto.

Qualifications

• Over 5 years of experience as a Database Administrator with a deep focus on AWS database services in a production setting.


• Expert‑level, hands‑on Amazon Redshift administration skills including cluster management, distribution and sort key strategies, WLM queue configuration, and performance diagnostics.


• Solid operational DBA experience with at least one additional RDBMS such as Oracle, PostgreSQL, MySQL, or SQL Server, either on‑premises or via AWS RDS and Aurora.


• Available for Saturday production windows and monthly on‑call rotations after an initial onboarding period (approximately 2–3 months).


• Demonstrate composure and clear communication skills in high‑pressure situations involving executive stakeholders.


• Fluent English both spoken and written.

Benefits

• Care – We care about our employees by creating a supportive environment where everyone is valued and empowered with training and growth prospects.


• Trust – Trust forms the bedrock of our client relationships, fostering a partnership characterized by professionalism, ongoing trust, and transparency.


• Innovation – We drive effective digital transformation with our cutting‑edge technology and innovative approach.


• Responsibility – Our commitment to the community is deep‑rooted and we diligently work towards making a sustainable impact.