Description
Summary:
Ivy Partners is seeking an AWS/Redshift Database Administrator to manage, monitor, and optimize database environments, ensuring performance and reliability.
Highlights:
1. Opportunity for personal and professional development
2. Supportive environment with training and growth prospects
3. Work with cutting-edge technology and innovative approaches
**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 them genuine opportunities for progression.
**As an AWS/Redshift Database Administrator at Ivy Partners, you will:**
* 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: 4x times per week in the Office in Porto.
**About You**
You are our ideal candidate if you:
* Possess over 5 years of experience as a Database Administrator with a deep focus on AWS database services in a production setting.
* Have expert\-level, hands\-on Amazon Redshift administration skills including cluster management, distribution and sort key strategies, WLM queue configuration, and performance diagnostics.
* Maintain 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.
* Are available for Saturday production windows and monthly on\-call rotations after a thorough initial onboarding period (approximately two to three months).
* Demonstrate composure and clear communication skills in high\-pressure situations involving executive stakeholders.
* Fluent English both spoken and written.
**Why join Ivy Partners?**
* **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.