Database Administrator Iii

.About KueskiAt Kueski, we’re dedicated to improving the financial lives of people in Mexico. Since 2012, we’ve been the leading buy now, pay later (BNPL) and online consumer credit platform in Latin America, known for our innovative financial services. Our flagship product, Kueski Pay, provides seamless payment solutions for both online and in-store transactions, establishing itself as the preferred option for a quarter of Mexico’s top e-commerce merchants. Notably, we were the first to introduce BNPL on Amazon Mexico.We’re a tech company with a culture geared toward innovation, collaboration, and impact, fostering a strong, diverse, and inclusive company culture. In 2023, Kueski was recognized as the top BNPL platform by Fintech Breakthrough and earned the title of one of Mexico’s most ethical companies from AMITAI. Additionally, we ranked as one of the Best Companies for Female Talent by EFY.PurposeAs a Database Administrator, you will be responsible for the integrity of the company’s databases, including but not limited to upgrades, updates, patches, migrations, troubleshooting, and performance monitoring. The DBA collaborates with cross-functional teams to ensure security compliance and performance optimizations.Key ResponsibilitiesManage, support, and maintain database technology and infrastructure.Design Kueski’s best practices, architectural guidelines, and policies regarding databases.Train eligible staff on how to access and apply the database.Model and design database schemas.Develop and design stored procedures, routines, tables, and triggers.Query tuning.Work with developers, product managers, and other team members to review business requirements and translate them into database objects.Create data and performance reports to support Kueski’s operational needs.Implement databases, storage structures, high-availability solutions, replication, and disaster recovery solutions.Identity and access management.Optimize database performance.Monitor deadlocks and concurrency issues.Assist with changes and implement a version control system for the database.Interact with the platform on maintenance and upgrades.Implement release management for the database.Provide reviewing capabilities for PRs related to database usage.Design and implement disaster recovery procedures.Position RequirementsBachelor’s Degree in Computer Science.3+ years of DBA experience implementing, managing, and administering enterprise databases.3+ years of DBA experience engineering, administering, and managing Postgres databases.3+ years of experience managing relational databases on cloud platforms (AWS).Required experience administering Amazon RDS service: PostgreSQL, MySQL, MariaDB.Experience supporting ETL processes.Experience with AWS cloud monitoring and alerting technologies such as CloudWatch and CloudTrail.Good understanding of storage architecture design techniques, theories, principles, and practices