Database Administration: Perform core DBA tasks including database installation, configuration, patching, upgrades, performance tuning, backup and recovery, security management, and user management.
AWS Cloud Management: Manage and monitor AWS RDS instances or EC2, including provisioning, scaling, security groups, VPC configurations, and other related AWS services. Understand and implement AWS best practices for database deployments.
Performance Tuning and Optimization: Proactively monitor database performance, identify bottlenecks, and implement performance tuning strategies to optimize database efficiency and responsiveness. Utilize performance monitoring tools and techniques.
High Availability and Disaster Recovery: Design, implement, and test high availability and disaster recovery solutions for database platforms, including multi-AZ deployments, read replicas, and backup/restore procedures.
Security Management: Implement and enforce security best practices to protect sensitive data, including access control, encryption, auditing, and vulnerability management. Ensure compliance with relevant security standards.
Automation: Automate routine DBA tasks using scripting languages (e.g., Python, Bash) and AWS automation tools (e.g., CloudFormation, Terraform) to improve efficiency and reduce manual effort.
Monitoring and Alerting: Configure and maintain database monitoring and alerting systems to proactively identify and address potential issues. Respond to alerts and incidents in a timely manner.
Collaboration: Work closely with development teams, system administrators, and other stakeholders to support application deployments and database-related initiatives.
Documentation: Maintain accurate and up-to-date documentation for database configurations, procedures, and troubleshooting steps.
Problem Solving: Troubleshoot and resolve database-related issues, including performance problems, connectivity issues, and data corruption. Review and debug code written by others across all platforms used by the DBA team.
Capacity Planning: Participate in capacity planning activities to ensure that database resources are adequate to support future growth.
Continuous Learning: Stay up-to-date with the latest database platforms, AWS services, and best practices for cloud-based database management.
Job details are sourced from the employer's original posting.
