Accelerate infrastructure deployment and optimize data architecture:
Manage and enhance our AWS cloud infrastructure, with a focus on RDS MySQL databases, to ensure optimal performance, availability, and security
Implement strategies to significantly reduce infrastructure deployment times, emphasizing efficiency and scalability
Improve developer support and infrastructure issue resolution:
Work closely with developers to optimize database performance, addressing bottlenecks and ensuring data integrity
Streamline the process for resolving infrastructure tickets, focusing on database-related issues to improve overall response and resolution times
Enhance DX culture and documentation:
Participate in creating and maintaining comprehensive documentation that outlines Platform philosophy and methodologies, with a focus on database management practices
Develop and support efficient onboarding and asynchronous work:
Contribute to a comprehensive onboarding program for Engineering and Data teams, aimed at enhancing productivity and efficiency
Develop guidelines for effective asynchronous work, with an emphasis on database engineering and collaboration tools
Enhance monitoring and operational efficiency: Implement and train on advanced monitoring tools to improve incident response and system health tracking
Develop strategies to streamline and automate the top time-consuming database tasks
Develop self-healing capabilities for critical database services
Create comprehensive documentation and automated responses:
Develop and document play/runbooks for critical database services
Create and deploy alerts for databases that trigger automated corrective actions for common service incident
Day to day
Monitor and resolve performance and availability issues of cloud-based databases through routine maintenance and optimization tasks.
Collaborate with stakeholders to design and implement efficient data models and schemas that meet business requirements.
Fine-tune database queries and indexes, and implement caching mechanisms to optimize database performance.
Develop and implement backup and disaster recovery strategies, ensuring data integrity and availability in case of failures.
Automate database administration tasks using scripting languages, and employ Infrastructure as Code practices for streamlined deployments.
Collaborate with cross-functional teams, provide guidance, and document database configurations and troubleshooting guides.
Work closely with the data team, providing expertise on database aspects, data modeling, migration projects, and code reviews.
Implement security best practices, access controls, and ensure compliance with data privacy regulations.
Stay updated with the latest database technologies, research new tools and methodologies, and provide recommendations for improvement.
Requirements
+3 years of experience working as a DBA, Cloud Database Administrator or similar.
Proficient in utilizing AWS monitoring tools and techniques to resolve performance and availability issues in cloud-based databases.
Skilled in leveraging AWS services and features to optimize database performance and conduct routine maintenance tasks.
Strong ability to design efficient data models and schemas in AWS that align with business requirements.
Thorough understanding of AWS database services like RDS (Relational Database Service), Aurora MySQL, DynamoDB, and Redshift.
Experienced in fine-tuning database queries, optimizing indexes, and implementing caching mechanisms using AWS database technologies.
Demonstrated capability in developing and implementing comprehensive backup and disaster recovery strategies in AWS.
Advanced scripting proficiency in AWS-supported languages like Python or similar for automating database administration tasks.
Familiarity with Infrastructure as Code (IaC) practices using AWS CloudFormation or similar tools for streamlined deployments and consistent configuration.
Excellent collaboration and communication skills to work effectively with cross-functional teams and stakeholders in AWS environments.
Provides guidance, support, and comprehensive documentation for AWS database configurations and troubleshooting.
Strong ability to collaborate closely with data teams in AWS, offering expertise on AWS database services, data modeling, migration projects, and code reviews.
In-depth knowledge of AWS security best practices for databases, including access controls, encryption, and compliance with AWS data privacy regulations.
Proactively stays updated with the latest AWS database technologies, tools, and methodologies.
Conducts research, evaluates new AWS technologies, and provides recommendations for enhancing the AWS database infrastructure.
Nice to have:
Knowledge of database security best practices, including data encryption, access control, and compliance requirements such as GDPR or HIPAA.
Experience working with data warehouses, technical data architectures, infrastructure components, ETL/ELT (Extract, Transform, Load/Extract, Load, Transform) processes, and reporting/analytic tools.
Willingness to participate in an on-call rotation to provide timely support and resolution for critical database issues outside regular business hours.