Postgres Database Administrator

Job Description

Postgres Database Administrator

Job Summary:

We are seeking a skilled Database Administrator (DBA) with 3–5 years of experience in PostgreSQL, AWS cloud services, and Snowflake Data Cloud. The ideal candidate will be responsible for database administration, performance tuning, monitoring, backup and recovery, security management, and supporting data platform operations across cloud environments.

Key Responsibilities

PostgreSQL Administration

• Install, configure, administer, and maintain PostgreSQL databases.


• Monitor database health, performance, and availability.


• Perform database performance tuning and query optimization.


• Manage backup, recovery, replication, and disaster recovery processes.


• Troubleshoot database issues and provide timely resolutions.


• Implement database security, user management, and access controls.


• Support database upgrades, patching, and migrations.


• AWS Database & Infrastructure Management


• Manage AWS database services including Amazon RDS and Aurora PostgreSQL.


• Monitor AWS resources using CloudWatch and Performance Insights.


• Configure and maintain backup, failover, and high-availability solutions.


• Work with AWS services such as EC2, S3, IAM, Lambda, SNS, and AWS Backup.


• Optimize database infrastructure for cost, performance, and scalability.


• Implement security best practices including encryption and IAM policies.
  
  

Snowflake Administration

• Administer and maintain Snowflake environments.


• Manage virtual warehouses, databases, schemas, roles, and permissions.


• Monitor Snowflake performance and optimize warehouse utilization.


• Support data loading, data sharing, and integration processes.


• Troubleshoot Snowflake operational and performance issues.


• Basic Oracle Database Administration


• Basic understanding of Oracle Database architecture and administration.


• Assist with user management, tablespace monitoring, and database health checks.


• Support backup and recovery activities using RMAN.


• Execute data export/import activities using Data Pump (expdp/impdp).


• Monitor database performance and review alert logs.
  
  

Required Skills

• 3–5 years of hands-on experience in PostgreSQL database administration.


• Experience with AWS RDS PostgreSQL and Aurora PostgreSQL.


• Strong understanding of PostgreSQL replication, backup, recovery, and performance tuning.


• Experience administering Snowflake Data Cloud.


• Basic knowledge of Oracle Database administration.


• Strong SQL and query optimization skills.


• Experience with Linux/Unix administration.


• Familiarity with CloudWatch, Performance Insights, Datadog.


• Experience with database migration, upgrades, and troubleshooting.


• Understanding database security, auditing, and compliance best practices.