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

Hello,

Good morning,

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.

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.

Role: AWS RDS DBA (PostgreSQL) / Cloud Database Operations Engineer
Location: Remote (Based on the business needs candidates needs to be flexible to work from office, Dallas, TX)

Experience: 10+ years

Duration: Long Term

Job Summary:

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.

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.

Key Responsibilities:

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.

2. 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.

3. 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.

4. 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.

5. 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.

6. 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.

7. 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.