syffer

AWS/Redshift Database Administrator

syffer  •  Porto, PT (Onsite)  •  13 hours ago
Apply
AI can make mistakes so check important info. Chat history is never stored.

Job Description

Syffer is an all-inclusive consulting company focused on talent, tech and innovation. We exist to elevate companies and humans all around the world, making change, from the inside to the outside.

We believe that technology + human kindness positively impacts every community around the world. Our approach is simple, we see a world without borders, and believe in equal opportunities. We are guided by our core principles of spreading positivity, good energy and promote equality and care for others.

Our hiring process is unique! People are selected by their value, education, talent and personality. We dont present ethnicity, religion, national origin, age, gender, sexual orientation or identity.

Its time to burst the bubble, and we will do it together!

What You'll do:

- Monitor Redshift cluster health, performance, and resource utilization on a daily basis;

- Manage and tune WLM queues to isolate and prioritize workloads effectively;

- Execute VACUUM and ANALYZE strategies for large-scale tables, including environments operating in the tens of terabytes, within constrained production windows;

- Diagnose and resolve performance issues using SVL/STV system views, CloudWatch metrics, and the Redshift console;

- Triage and respond to incidents raised via internal ticketing, including participation in war room calls with up to 40 to 50 stakeholders and senior management;

- Monitor all supported database platforms proactively, identify anomalies, and share findings with development teams in recurring alignment meetings;

- Plan and execute production and disaster recovery activities during Saturday maintenance windows;

- Cover on-call rotation across the full database stack, not only Redshift, requiring independent triage capability across multiple RDBMS technologies;

- Perform installation, configuration, patching, and upgrades across both on-premises and AWS database environments;

- Manage user access, space allocation, backup policies, and disaster recovery configurations;

- Provide architectural consultation and query performance guidance to application and DevOps teams on an advisory basis; 

- Modality: 3x in person per week.


Who You Are:

- 5+ years of experience as a Database Administrator with a strong focus on AWS database services in production environments;

- Expert-level, hands-on Amazon Redshift administration: cluster management, distribution and sort key strategy, WLM queue configuration, VACUUM and ANALYZE on large-scale tables, and performance diagnostics using SVL/STV system views;

- Solid operational DBA experience in at least one additional RDBMS for on-call coverage: Oracle, PostgreSQL, MySQL, or SQL Server, either on-premises or via AWS RDS and Aurora;

- All DBA experience must be evidenced as infrastructure-level hands-on work, not data engineering, analytics, or infrastructure provisioning;

- Availability for Saturday production windows and monthly on-call rotation after an onboarding period of approximately two to three months;

- Composure and clear communication under pressure during live critical incidents with executive stakeholders.



What you'll get:

- Wage according to candidate's professional experience;

- Remote Work whenever possible;

- Delivery of work equipment adjusted to the performance of functions;

- Benefits plan;

- And others.

Work together with expert teams on projects of large magnitude and intensity, long term together with our clients, all leaders in their industries.

Are you ready to step into a diverse and inclusive world with us?

Together we will promote uniquess!

syffer

About syffer

We are a consultancy focused on talent, tech and innovation, with global impact more and more everyday. We believe that innovation, technology + human kindness positively impacts every community around the world.

And we are here to make it happen!

Industry
IT & Software
Company Size
11-50 employees
Headquarters
Lisbon, PT
Year Founded
Unknown
Social Media