Senior Database Administrator and Performance Engineer

Agiloft is a global leader in data-first contract lifecycle management (CLM) software, helping organizations manage their contract processes. The Senior Database Administrator and Performance Engineer will ensure the performance and availability of database servers, collaborate with various teams to troubleshoot performance issues, and contribute to product development for optimal database designs.

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

Requirements:

• 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
• 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