Postgre SQL DBA Job Description

We are seeking a highly skilled and experienced Postgre SQL Database Administrator (DBA) with solid expertise in AWS. The candidate will be responsible for the day-to-day management of Postgre SQL databases and will lead efforts to migrate and optimize our database infrastructure in the AWS cloud. This role requires deep knowledge of Postgre SQL database administration and AWS services, particularly related to database migration, performance tuning, and high availability.

Key Responsibilities
Lead and execute migration of on-prem (SQL/Oracle) databases to AWS Cloud Environment (Postgre SQL). Remediate code hands-on from SQL/Oracle to Postgre SQL including all schema components including stored procedures, triggers, functions. Experienced in finding and fixing naming conventions (Snake case vs Pascal case vs others). Code remediation not just to correct technically but able to engage with application teams to fix code functionally. Install, configure, and manage Postgre SQL databases across various versions.



Optimize database performance and ensure high availability and scalability. Design and implement backup and recovery strategies using native database tools and AWS services. Manage Postgre SQL replication (streaming replication, logical replication) and high availability setups. Implement and maintain Postgre SQL security policies, roles, and privileges. Monitor database health and performance using tools like pg Admin, AWS Cloud Watch, and other monitoring solutions. Perform regular database maintenance tasks including vacuuming, indexing, and query optimization. Configure and manage Postgre SQL on AWS Utilize AWS services such as S3, IAM, Cloud Watch, and DMS for database operations and migration. Design and implement disaster recovery strategies, including Multi-AZ deployments and failover configurations. Collaborate with development and infrastructure teams to support application requirements. Document database environments,

📌 Postgresql Dba (Madhya Pradesh)
🏢 Principle Pride
📍 Madhya Pradesh