About the role

Senior Database Administrator and Performance Engineer on Cloud Operations team. Ensuring database availability, performance, and collaboration with development teams at Agiloft.

Responsibilities

Monitor, measure, and recommend optimizations for the performance of database transactions generated by web applications and batch workloads.
Optimize database indexes and analyze query performance to identify inefficiencies, recommending changes to enhance performance.
Troubleshoot database performance issues reported in production; recommend and implement solutions to resolve.
Collaborate with development teams to optimize logical schema designs of existing systems and new enhancements for maximum efficiency.
Contribute to the maintenance, optimization, automation and testing of robust backup/restore and disaster recovery processes, ensuring data durability, integrity and availability.
Contribute to IaC on AWS, to ensure scalability, security and reliability.
Troubleshoot and resolve complex issues related to infrastructure, DBs and applications.
Conduct performance tuning and capacity planning for database environments.
Stay current with industry trends and best practices, recommending tools and techniques to improve database performance and reliability.
Document database configurations, processes, and performance metrics for internal knowledge sharing.
Leverage AI-assisted tools to enhance productivity, improve processes and workflows, and overall support everyday work.
Other duties as assigned

Bachelor’s degree in Computer Science, Information Technology, or a related field, or equivalent experience.
5+ years of experience as a Database Administrator, with a strong focus on performance engineering.
Proficiency with AWS database services (e.g., Amazon RDS, Amazon Aurora) and their management.
Extensive experience in performance tuning, query optimization, and index management.
Solid understanding of backup/restore methodologies, real-time replication optimization, and disaster recovery processes.
Strong SQL skills and familiarity with multiple relational database management systems including MySQL, PostgreSQL, MS SQL Server.
Experience with adopting AI to supplement code development (Cursor, Copilot)
Excellent problem-solving abilities and a proactive approach to optimizing database systems.