Database Administrator (DBA) with expertise in AWS, Aurora and PostgreSQL to manage and optimize a centralized database system. This role involves ensuring database availability, security, and performance while enabling seamless integration with other teams via direct database connections. The ideal candidate will have deep expertise in PostgreSQL, cloud-native database solutions, and database administration best practices.
Key Responsibilities
- Database Administration: Manage, monitor, and optimize AWS RDS Aurora PostgreSQL databases to ensure high availability, security, and performance.
- Performance Tuning: Analyze and optimize SQL queries, indexes, and overall database performance for improved response times and scalability.
- Security & Compliance: Implement database security best practices, access controls, encryption, and ensure compliance with industry standards and organizational policies.
- Backup & Recovery: Establish and maintain database backup and disaster recovery strategies to ensure data durability and business continuity.
- Automation & Monitoring: Utilize AWS-native tools and third-party solutions for proactive database monitoring, alerting, and automation.
- Documentation: Maintain up-to-date documentation for database structures, access policies, and best practices.
Required Qualifications
- Experience: 5+ years of experience in Database Engineering, with at least 3 years working with PostgreSQL (preferably AWS RDS Aurora PostgreSQL) Database Expertise: Strong proficiency in PostgreSQL, including query optimization, replication, partitioning, and high-availability configurations.
- Cloud & AWS: Hands-on experience with AWS RDS, Aurora, IAM, S3, Lambda, and CloudWatch for database management and automation.
- Scripting & Automation: Proficiency in SQL, Bash, or Terraform AWS CDK for database automation and infrastructure as code.
- Security & Compliance: Familiarity with database encryption, access control, auditing, and compliance frameworks (GDPR, HIPAA, SOC 2, etc.).
- Problem Solving: Excellent troubleshooting and problem-solving skills in high-availability database environments.
Preferred Qualifications
- Experience with data lake architectures, real-time streaming, or data warehousing solutions.
- AWS Certifications (e.g., AWS Certified Database – Specialty, AWS Solutions Architect – Associate).