Senior DBA (Multi-Engine / AWS)

Description

Job Summary: A professional responsible for the administration, maintenance, and evolution of critical data environments, ensuring high availability, performance, and security. Key Highlights: 1. Operation in critical environments with high data volume and low tolerance for failures 2. Supporting engineering and BI teams in building and optimizing queries 3. Administration of databases in hybrid environments (on-premises and AWS RDS) ### **Responsibilities:** * Responsible for administering, maintaining, and evolving critical data environments, working with multiple database engines across on\-premises and cloud (AWS) environments. * The professional will ensure high availability, performance, security, and continuous data replication across different platforms. * Administration of databases in hybrid environments (on\-premises and AWS RDS) * Management of multiple database engines: Microsoft SQL Server, PostgreSQL, MariaDB, Redis, MongoDB, Amazon DocumentDB * Implementation and maintenance of continuous data replication (CDC) * Operation and troubleshooting of pipelines using AWS Database Migration Service * Monitoring and performance optimization (queries, indexes, statistics) * Execution and validation of backup and restore routines * Ensuring high availability and data integrity * Operation in critical environments with high data volume and low tolerance for failures * Supporting engineering and BI teams in building and optimizing queries ### **Mandatory Requirements:** * Hybrid work model (4x1\) at Consolação, São Paulo/SP; * Solid experience as a DBA in production-critical environments; * Advanced proficiency in T\-SQL and performance troubleshooting; * Practical experience with AWS (especially RDS and data services); * Knowledge of data replication across different database engines (CDC); * Experience with: backup, restore, and recovery; indexing and query tuning; execution plan analysis; distributed environments and high-volume data handling ### **Desirable Requirements:** * Experience with automation and orchestration via Rundeck; * Close collaboration with data engineering and software development teams; * Experience with data pipelines and system integration; * Knowledge of data architecture (Data Lake / Lakehouse); * Experience with monitoring and observability (CloudWatch, Datadog); **We aim to provide our team with a welcoming, dynamic, and collaborative environment. To achieve this, we offer several initiatives, including:** * Fully remote opportunities ‍ * Remote work allowance * Periodic feedback sessions * Employee referral program Psychological support ‍* ️ * Workplace gymnastics ️ * Knowledge academy * English school partnership * Monthly transparency meetings * Online happy hours * Welcome kit