Install, configure, patch, migrate, maintain, and upgrade PostgreSQL databases, including AWS RDS instances.
Perform day-to-day database administration tasks, including user management, security audits, and performance monitoring.
Implement and maintain robust database security measures, including user authentication, authorization, and data encryption.
Proactively identify and resolve database performance issues, including query optimization, indexing, and partitioning.
Implement and maintain disaster recovery and high availability solutions for PostgreSQL databases, leveraging AWS services like Aurora Read Replicas and Global Database.
Manage database capacity planning and performance assessments.
AWS Cloud Expertise:
Deep understanding of AWS services, including RDS, EC2, S3, IAM, and VPC.
Experience with AWS database administration best practices and security standards.
Hands-on experience with AWS RDS, including configuration, monitoring, and troubleshooting.
Ability to leverage AWS services to optimize database performance and cost-effectiveness.
Database Development & Engineering:
Experience with database design and development best practices.
Strong SQL skills, including advanced query writing, stored procedures, and functions.
Experience with database migration strategies and execution.
Knowledge of message queuing, full-text indexing, and other high-performance data concepts.
Collaboration & Communication:
Collaborate effectively with development teams, system administrators, and other stakeholders.
Excellent written and verbal communication skills.
Ability to clearly and concisely document technical procedures and processes.