Description

You will manage and optimize large-scale PostgreSQL and AWS RDS environments.

Responsibilities

• Install, configure, patch, migrate, and upgrade PostgreSQL and AWS RDS instances.
• Implement effective database coding practices, indexing, and partitioning strategies to improve performance.
• Manage AWS cloud infrastructure including S3, EC2, IAM, security policies, and user authentication.
• Execute database migrations, including technical estimation and management of the migration approach.
• Automate batch processes and job scheduling while maintaining data quality, privacy, and security.

Required Skills

• 10-12 years of experience in managing PostgreSQL databases.
• 5 years of experience managing databases on AWS, specifically using RDS services.
• Deep knowledge of PostgreSQL performance improvement, indexing, and partitioning.
• Advanced understanding of Linux OS and remote system management via SSH.
• Experience with database design principles, query optimization, and isolation levels.
• Hands-on experience with Ansible, Terraform, GitHub, and Jira.
• Proficiency in CI/CD workflows using GitLab.
• Working knowledge of EDB, Oracle, and SQL Server.
• Experience with message queuing and full-text indexing.
• Strong troubleshooting and analytical skills for client-facing problem resolution.

Preferred Skills

• Experience managing AWS environment tools and day-to-day operations on EC2 and S3.

Key Skills

Education

Any Gradute