AWSMS SQL ServerMySQLPostgresSQLAIRDSPostgreSQLSQL Server
About this role
Role Overview
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.