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
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.
Database Administrator and Analyst managing donor database systems for a digital hospital. Responsible for data integrity, system configuration, and supporting fundraising processes.
Senior Oracle DBA overseeing Oracle environments and leading cloud migrations for clients in Managed Services. Focused on performance, security, and high availability of database resources.
Senior Database Administrator managing production, non - production, and DR databases for Canadian Tire Corporation. Ensuring high availability and performance while driving automation and modernization initiatives.
Database Manager leading operational excellence for Oracle and Mongo platforms at Intact. Mentoring teams and driving transformation with cloud and AI strategies.
Oracle Database Administrator responsible for the configuration and administration of databases at Desjardins. Ensuring the integrity, security, and performance of the Oracle database services.
Database Administrator providing technical support and administration of IDMS databases for a consulting firm specializing in digital transformation. Collaborating to support operational processes and software upgrades.