About this role
<p style="text-align:center;margin:0.0in;font-size:12.0pt;font-family:Aptos, sans-serif"><strong><span style="font-size:14.0pt">Job Description</span> <br><br></strong><strong><span style="font-size:14.0pt">Postgres Database Administrator</span></strong></p> <p style="margin:0.0in;font-size:12.0pt;font-family:Aptos, sans-serif"><strong><br></strong><strong><span style="font-size:11.0pt">Job Summary:<br><br></span></strong></p> <p style="text-align:justify;margin:0.0in;font-size:12.0pt;font-family:Aptos, sans-serif"><span style="font-size:11.0pt">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.</span></p> <p style="margin:0.0in;font-size:12.0pt;font-family:Aptos, sans-serif"> </p> <p style="margin:0.0in;font-size:12.0pt;font-family:Aptos, sans-serif"><strong><span style="font-size:11.0pt">Key Responsibilities<br><br></span></strong></p> <p style="margin:0.0in;font-size:12.0pt;font-family:Aptos, sans-serif"><strong><span style="font-size:11.0pt">PostgreSQL Administration</span></strong></p> <ul style="margin-bottom:0.0in;margin-top:0.0px"> <li style="margin:0.0in 0.0in 0.0in 0.0px;font-size:12.0pt;font-family:Aptos, sans-serif"><span style="font-size:11.0pt">Install, configure, administer, and maintain PostgreSQL databases. </span></li> <li style="margin:0.0in 0.0in 0.0in 0.0px;font-size:12.0pt;font-family:Aptos, sans-serif"><span style="font-size:11.0pt">Monitor database health, performance, and availability. </span></li> <li style="margin:0.0in 0.0in 0.0in 0.0px;font-size:12.0pt;font-family:Aptos, sans-serif"><span style="font-size:11.0pt">Perform database performance tuning and query optimization. </span></li> <li style="margin:0.0in 0.0in 0.0in 0.0px;font-size:12.0pt;font-family:Aptos, sans-serif"><span style="font-size:11.0pt">Manage backup, recovery, replication, and disaster recovery processes. </span></li> <li style="margin:0.0in 0.0in 0.0in 0.0px;font-size:12.0pt;font-family:Aptos, sans-serif"><span style="font-size:11.0pt">Troubleshoot database issues and provide timely resolutions. </span></li> <li style="margin:0.0in 0.0in 0.0in 0.0px;font-size:12.0pt;font-family:Aptos, sans-serif"><span style="font-size:11.0pt">Implement database security, user management, and access controls. </span></li> <li style="margin:0.0in 0.0in 0.0in 0.0px;font-size:12.0pt;font-family:Aptos, sans-serif"><span style="font-size:11.0pt">Support database upgrades, patching, and migrations. </span></li> <li style="margin:0.0in 0.0in 0.0in 0.0px;font-size:12.0pt;font-family:Aptos, sans-serif"><span style="font-size:11.0pt">AWS Database & Infrastructure Management</span></li> <li style="margin:0.0in 0.0in 0.0in 0.0px;font-size:12.0pt;font-family:Aptos, sans-serif"><span style="font-size:11.0pt">Manage AWS database services including Amazon RDS and Aurora PostgreSQL. </span></li> <li style="margin:0.0in 0.0in 0.0in 0.0px;font-size:12.0pt;font-family:Aptos, sans-serif"><span style="font-size:11.0pt">Monitor AWS resources using CloudWatch and Performance Insights. </span></li> <li style="margin:0.0in 0.0in 0.0in 0.0px;font-size:12.0pt;font-family:Aptos, sans-serif"><span style="font-size:11.0pt">Configure and maintain backup, failover, and high-availability solutions. </span></li> <li style="margin:0.0in 0.0in 0.0in 0.0px;font-size:12.0pt;font-family:Aptos, sans-serif"><span style="font-size:11.0pt">Work with AWS services such as EC2, S3, IAM, Lambda, SNS, and AWS Backup. </span></li> <li style="margin:0.0in 0.0in 0.0in 0.0px;font-size:12.0pt;font-family:Aptos, sans-serif"><span style="font-size:11.0pt">Optimize database infrastructure for cost, performance, and scalability. </span></li> <li style="margin:0.0in 0.0in 0.0in 0.0px;font-size:12.0pt;font-family:Aptos, sans-serif"><span style="font-size:11.0pt">Implement security best practices including encryption and IAM policies. <br><br></span></li> </ul> <p style="margin:0.0in;font-size:12.0pt;font-family:Aptos, sans-serif"><strong><span style="font-size:11.0pt">Snowflake Administration</span></strong></p> <ul style="margin-bottom:0.0in;margin-top:0.0px"> <li style="margin:0.0in 0.0in 0.0in 0.0px;font-size:12.0pt;font-family:Aptos, sans-serif"><span style="font-size:11.0pt">Administer and maintain Snowflake environments. </span></li> <li style="margin:0.0in 0.0in 0.0in 0.0px;font-size:12.0pt;font-family:Aptos, sans-serif"><span style="font-size:11.0pt">Manage virtual warehouses, databases, schemas, roles, and permissions. </span></li> <li style="margin:0.0in 0.0in 0.0in 0.0px;font-size:12.0pt;font-family:Aptos, sans-serif"><span style="font-size:11.0pt">Monitor Snowflake performance and optimize warehouse utilization. </span></li> <li style="margin:0.0in 0.0in 0.0in 0.0px;font-size:12.0pt;font-family:Aptos, sans-serif"><span style="font-size:11.0pt">Support data loading, data sharing, and integration processes. </span></li> <li style="margin:0.0in 0.0in 0.0in 0.0px;font-size:12.0pt;font-family:Aptos, sans-serif"><span style="font-size:11.0pt">Troubleshoot Snowflake operational and performance issues. </span></li> <li style="margin:0.0in 0.0in 0.0in 0.0px;font-size:12.0pt;font-family:Aptos, sans-serif"><span style="font-size:11.0pt">Basic Oracle Database Administration</span></li> <li style="margin:0.0in 0.0in 0.0in 0.0px;font-size:12.0pt;font-family:Aptos, sans-serif"><span style="font-size:11.0pt">Basic understanding of Oracle Database architecture and administration. </span></li> <li style="margin:0.0in 0.0in 0.0in 0.0px;font-size:12.0pt;font-family:Aptos, sans-serif"><span style="font-size:11.0pt">Assist with user management, tablespace monitoring, and database health checks. </span></li> <li style="margin:0.0in 0.0in 0.0in 0.0px;font-size:12.0pt;font-family:Aptos, sans-serif"><span style="font-size:11.0pt">Support backup and recovery activities using RMAN. </span></li> <li style="margin:0.0in 0.0in 0.0in 0.0px;font-size:12.0pt;font-family:Aptos, sans-serif"><span style="font-size:11.0pt">Execute data export/import activities using Data Pump (expdp/impdp). </span></li> <li style="margin:0.0in 0.0in 0.0in 0.0px;font-size:12.0pt;font-family:Aptos, sans-serif"><span style="font-size:11.0pt">Monitor database performance and review alert logs. <br><br></span></li> </ul> <p style="margin:0.0in;font-size:12.0pt;font-family:Aptos, sans-serif"><strong><span style="font-size:11.0pt">Required Skills</span></strong></p> <ul style="margin-bottom:0.0in;margin-top:0.0px"> <li style="margin:0.0in 0.0in 0.0in 0.0px;font-size:12.0pt;font-family:Aptos, sans-serif"><span style="font-size:11.0pt">3–5 years of hands-on experience in PostgreSQL database administration. </span></li> <li style="margin:0.0in 0.0in 0.0in 0.0px;font-size:12.0pt;font-family:Aptos, sans-serif"><span style="font-size:11.0pt">Experience with AWS RDS PostgreSQL and Aurora PostgreSQL. </span></li> <li style="margin:0.0in 0.0in 0.0in 0.0px;font-size:12.0pt;font-family:Aptos, sans-serif"><span style="font-size:11.0pt">Strong understanding of PostgreSQL replication, backup, recovery, and performance tuning. </span></li> <li style="margin:0.0in 0.0in 0.0in 0.0px;font-size:12.0pt;font-family:Aptos, sans-serif"><span style="font-size:11.0pt">Experience administering Snowflake Data Cloud. </span></li> <li style="margin:0.0in 0.0in 0.0in 0.0px;font-size:12.0pt;font-family:Aptos, sans-serif"><span style="font-size:11.0pt">Basic knowledge of Oracle Database administration. </span></li> <li style="margin:0.0in 0.0in 0.0in 0.0px;font-size:12.0pt;font-family:Aptos, sans-serif"><span style="font-size:11.0pt">Strong SQL and query optimization skills. </span></li> <li style="margin:0.0in 0.0in 0.0in 0.0px;font-size:12.0pt;font-family:Aptos, sans-serif"><span style="font-size:11.0pt">Experience with Linux/Unix administration. </span></li> <li style="margin:0.0in 0.0in 0.0in 0.0px;font-size:12.0pt;font-family:Aptos, sans-serif"><span style="font-size:11.0pt">Familiarity with CloudWatch, Performance Insights, Datadog. </span></li> <li style="margin:0.0in 0.0in 0.0in 0.0px;font-size:12.0pt;font-family:Aptos, sans-serif"><span style="font-size:11.0pt">Experience with database migration, upgrades, and troubleshooting. </span></li> <li style="margin:0.0in 0.0in 0.0in 0.0px;font-size:12.0pt;font-family:Aptos, sans-serif"><span style="font-size:11.0pt">Understanding database security, auditing, and compliance best practices. </span></li> </ul>