Job Summary: We are seeking a Senior DBA to administer, optimize, and ensure the security of SQL and NoSQL databases on AWS, operating in a collaborative environment with tangible real-world impact. Key Highlights: 1. Work with cutting-edge technologies focused on real-world impact 2. Collaborative, respectful, and transparent environment 3. Opportunity for growth within a team that plays together At **ed**, we develop *intelligent software and technological solutions* that empower people, businesses, and society. We are driven by *innovation, tangible results*, and an environment grounded in *collaboration, respect, and transparency*. We value who you are. More than experience, we seek **attitude**, **a willingness to learn**, and **a readiness to make a difference**, regardless of age, gender, or background. We work with *cutting-edge technologies*, maintaining high-quality standards and focusing on **real-world impact**. We operate as **one team**: challenges are shared, and achievements celebrated collectively. If you enjoy collaborative environments, real-world challenges, and want to grow alongside a team that plays together, this could be your place. Learn more about **ed** by visiting our *Careers Page*: We are hiring a **Senior DBA \[AWS]** to join the ed team! **Remote** **Responsibilities and Duties** * Administer, maintain, and optimize SQL and NoSQL database environments on AWS. * Participate in the design, evolution, and optimization of schemas, indexes, partitioning, and sharding strategies. * Perform advanced performance tuning in high-volume, high-transaction environments. * Analyze execution plans and optimize complex queries and database structures. * Implement and maintain advanced monitoring for performance and availability. * Conduct capacity planning, ensuring balance among performance, scalability, and cost. * Manage serverless database solutions on AWS. * Plan, test, and maintain Disaster Recovery (DR) strategies, ensuring RTO and RPO compliance. * Ensure security, compliance, and sound data governance practices. * Serve as technical authority and escalation point for critical incidents. **Requirements and Qualifications** What strengthens your candidacy: * Prior experience with large-scale, high-transaction-volume environments; * Experience with FinOps or cost optimization for AWS data environments; * AWS certifications (Database Specialty, Solutions Architect, or similar); * Experience automating operational routines and pipelines; * Close collaboration with development teams (DevOps/DataOps). **Must-Have:** * *Proficiency in administering and optimizing NoSQL databases, specifically AWS DocumentDB, MongoDB, AWS DynamoDB, and AWS OpenSearch (with emphasis on schema design, sharding, compound indexes, and query optimizations);* * Proficiency in administering and optimizing cloud-based SQL databases, specifically AWS RDS MySQL and AWS RDS PostgreSQL (with emphasis on query optimization, indexing, and parameter tuning); * Optimization of complex queries, stored procedures, and database structures (indexes, design, partitioning), analyzing execution plans to guarantee performance and low latency; * *Management of AWS serverless database solutions (e.g., Aurora Serverless, DynamoDB on-demand) (using CDK and/or CloudFormation preferred, or another IaC approach);* * Performance tuning (fine-tuning of DBMS parameters) for high-volume, high-transaction environments (desirable knowledge of buffer pool, work\_mem, connections, cache, indexes); * Implementation and management of advanced monitoring to proactively identify bottlenecks (CPU, I/O, latency) and prevent incidents, *with emphasis on metrics from CloudWatch;* * *Execution of capacity planning, optimizing both performance and cost of data services,* (with emphasis on DocumentDB, Aurora MySQL, and Aurora PostgreSQL); * Management and testing of Disaster Recovery (DR) strategies, ensuring adherence to RTO/RPO objectives; * Ensuring security and compliance (e.g., LGPD), implementing audit trails, logs, and strict access controls (principle of least privilege); * Defining and documenting database design, deployment standards, and best practices for the development team; * Serving as technical authority and senior escalation point for critical performance and availability incidents. *Soft Skills:* * Strong analytical ability and capability to solve complex problems; * Clear and concise communication with both technical and non-technical stakeholders; * Proactivity and strong sense of responsibility for critical environments; * Organization and discipline in documenting standards and processes; * Ability to perform under pressure and during critical incidents. **Employment Type: CLT** **Work Modality: Remote** **Our Standard Benefits** * Meal/Voucher Card; * Remote Work Allowance; * Life Insurance; * Funeral Assistance; **Our Flexible Benefits** * Health Insurance; * Dental Insurance; * Education Assistance; * Additional credit on benefits card – Meal/Voucher Card; * Credit on benefits card – Mobility; * Pet Plan – PetLove; * Total Pass Plan – TP1\+; **Differentiator** * Profit and Results Sharing **(Semesterly PLR)**, reinforcing our commitment to recognizing performance. **Ready to take on this challenge with us?** Apply now and help build the future with ed