W2 Position: AWS RDS DBA (PostgreSQL) / Cloud Database Operations Engineer- Remote Dallas, TX

We have an immediate opening for an AWS RDS DBA (PostgreSQL) / Cloud Database Operations Engineer with strong hands-on experience to support a long-term engagement with our client. Must collaborate effectively with cross-functional teams to deliver high-quality solutions., We are seeking an experienced AWS RDS DBA (PostgreSQL) / Cloud Database Operations Engineer to manage the reliability, performance, security, and operational integrity of enterprise database platforms hosted on AWS., 1. AWS RDS Administration & Operations

• Manage and administer Amazon RDS PostgreSQL environments across development, testing, staging, DR, and production.
• Configure and maintain RDS instances, parameter groups, option groups, security groups, and database connectivity.
• Implement and manage multi-AZ deployments and read replicas.
• Collaborate with infrastructure teams on VPC, Direct Connect, PrivateLink, and cloud networking requirements.
• Monitor database availability, health, capacity, and performance.

1. PostgreSQL Performance Tuning & Optimization * Monitor and optimize database performance using AWS Performance Insights, CloudWatch, and PostgreSQL performance views. * Perform SQL query optimization, indexing, memory tuning, and connection management. * Troubleshoot slow-running queries, deadlocks, lock contention, replication lag, and resource bottlenecks. * Optimize database storage configurations and resource utilization.

2. Backup, Recovery & Disaster Recovery * Design, implement, and maintain database backup and recovery strategies. * Manage automated backups, snapshots, and point-in-time recovery. * Perform database restores, refresh activities, and recovery testing. * Conduct disaster recovery validation and support organizational RTO/RPO requirements. * Maintain recovery documentation, operational procedures, and runbooks.

3. Database Security & Compliance * Implement database security best practices and manage roles, permissions, and authentication. * Configure encryption at rest and in transit. * Manage database auditing and logging. * Support vulnerability remediation, security assessments, and regulatory compliance requirements. * Collaborate with Security teams to maintain database security standards.

4. Monitoring, Automation & Operational Excellence * Establish proactive database monitoring, alerting, and operational dashboards. * Automate database administration tasks using Python, AWS Lambda, Terraform, and AWS Systems Manager. * Develop automated operational processes and health reporting. * Identify opportunities to improve database reliability, scalability, and operational efficiency.

5. Production Support & Incident Management * Provide L2/L3 production database support. * Participate in production on-call rotations and respond to P1/P2 incidents within defined SLAs. * Troubleshoot database-related production issues and perform root cause analysis. * Implement preventive measures to minimize recurring incidents. * Collaborate with application and cloud platform teams during incident resolution.

6. Application & Cloud Platform Collaboration * Work closely with AWS Engineers, DevOps, Application Development, and Data Engineering teams. * Support application modernization and database migration initiatives. * Participate in architecture and operational readiness reviews. * Assist development teams with database design, schema optimization, and database deployment planning.

Core Technical Skills

• Database: PostgreSQL, Database Administration, SQL, Performance Tuning.
• AWS Services: Amazon RDS for PostgreSQL, CloudWatch, Performance Insights, AWS Lambda, AWS Systems Manager.
• High Availability & DR: Multi-AZ, Read Replicas, Backup & Recovery, Point-in-Time Recovery, Disaster Recovery.
• Database Performance: Query Optimization, Indexing, Connection Pooling, Deadlock Analysis, Replication Monitoring.
• Security: IAM, Database Roles & Permissions, Encryption, Audit Logging.
• Automation & IaC: Python, Terraform.
• Networking: VPC, Direct Connect, PrivateLink, Security Groups.
• Production Support: L2/L3 Support, Incident Management, Root Cause Analysis, On-Call Support.

The ideal candidate will have strong hands-on experience in PostgreSQL database administration, Amazon RDS, cloud database operations, performance tuning, backup and recovery, high availability, and disaster recovery.

This role will support mission-critical applications across production and non-production environments while collaborating with Cloud Engineering, DevOps, Data Engineering, Security, and Application Development teams.

I’m Rahul from Floga Technologies. We are a growing IT services organization delivering scalable technology solutions and are expanding our team with qualified talent.