Agiloft

Senior Database Administrator and Performance Engineer

Job Description

Position Overview

As a Senior Database Administrator and Performance Engineer on our Cloud Operations team, you will ensure the availability, restorability, and performance of our fleet of database servers serving production customer SaaS, hosted in AWS. You will collaborate with DevOps Engineers, Application Software Engineers, QA, and product specialists to troubleshoot and resolve performance challenges in production services. You will also participate in the product development process to help ensure optimal performance and database designs for new enhancements.


Job 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

  • Required Qualifications
  • 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.

  • Preferred Qualifications
  • Experience with NoSQL databases (e.g., DynamoDB, MongoDB) and data warehousing solutions.
  • Experience with managing and optimizing vector databases for AI/ML (e.g., PostgreSQL vectordb)
  • Familiarity with automation and monitoring tools (e.g., CloudWatch, Prometheus/Grafana).
  • Previous experience in a SaaS environment is a plus.
  • Relevant AWS certifications.