postgresql DBA - AWS

Job Description: AWS PostgreSQL Database Administrator (DBA)

Position Overview:

As an AWS PostgreSQL Database Administrator (DBA), you will play a critical role in managing and maintaining the performance, integrity, and security of PostgreSQL databases hosted on the Amazon Web Services (AWS) platform. Your responsibilities will include database design, implementation, monitoring, optimization, and troubleshooting to ensure the availability and reliability of database systems.

Key Responsibilities:

1. Database Design and Implementation:

· Collaborate with application developers and system administrators to design and implement PostgreSQL database solutions that meet business requirements.

· Ensure optimal database schema design, indexing, and partitioning for performance and scalability.

2. Database Administration:

· Install, configure, and upgrade PostgreSQL database software.

· Create and manage database instances on AWS RDS/Aurora or EC2 instances.

· Perform regular database maintenance tasks, including backups, restores, and disaster recovery procedures.

3. Performance Monitoring and Optimization:

· Monitor database performance and proactively address issues to ensure optimal performance.

· Identify and implement performance tuning strategies, including query optimization and indexing.

4. Security and Compliance:

· Implement and enforce security best practices to safeguard sensitive data.

· Ensure compliance with data protection regulations and industry standards.

5. High Availability and Disaster Recovery:

· Configure and manage high availability solutions such as streaming replication and logical replication.

· Develop and maintain disaster recovery plans to minimize downtime in the event of a failure.

6. Automation and Scripting:

· Implement automation scripts for routine database tasks using tools like AWS CLI, Python, or other relevant technologies.

· Work on infrastructure as code (IaC) to automate the deployment and maintenance of database environments.

7. Collaboration and Documentation:

· Collaborate with cross-functional teams to troubleshoot and resolve database-related issues.

· Maintain comprehensive documentation for database configurations, procedures, and troubleshooting guides.

8. Capacity Planning:

· Monitor database growth trends and plan for scaling resources as needed.

· Recommend and implement capacity planning strategies to ensure sufficient resources for future demands.

Qualifications:

· Bachelor's degree in Computer Science, Information Technology, or a related field.

· Proven experience as a PostgreSQL Database Administrator, preferably in an AWS environment.

· Strong understanding of database design principles, performance optimization, and security best practices.

· Hands-on experience with AWS services, particularly Aurora/RDS, EC2, and related tools.

· Proficiency in scripting languages such as Python, Bash, or PowerShell.

· Knowledge of database migration strategies and tools.

· Excellent problem-solving and communication skills.

Certifications (Preferred):

· AWS Certified Database - Specialty

· PostgreSQL Certification

Join our dynamic team and contribute to the success of our organization by ensuring the reliability and performance of our PostgreSQL databases on the AWS platform.