Key skills
AWS RDS for PostgreSQLSQL proficiencyAWS monitoring toolsBackuprestore proceduresLinux/Unix environmentsScripting automationOpenSearch access controlsDynamoDBS3TerraformCloudFormationAWS certificationPythonSQLBashAWSRDSIAMCloudWatchPostgreSQL
About this role
Blu Omega is a Woman Owned Small Business Federal Technology services firm looking for a Cloud Database Engineer (PostgreSQL) to join their dynamic team. This role involves ensuring the integrity, performance, and security of data platforms hosted on AWS, supporting vital national security initiatives.
Responsibilities:
- Deploy, configure, and manage PostgreSQL databases on AWS RDS, ensuring high availability and performance
- Monitor, analyze, and optimize database performance through indexing, query tuning, and parameter adjustments
- Implement and validate backup, recovery, and disaster recovery strategies to ensure data resiliency
- Manage database security, including roles, privileges, encryption, and compliance with organizational policies
- Plan and execute database upgrades, patches, and version migrations with minimal downtime
- Automate routine DBA tasks using AWS CLI, Infrastructure as Code (Terraform, CloudFormation), and scripting languages like Bash and Python
- Respond to database incidents, perform root cause analysis, and participate in on-call rotations
- Maintain detailed documentation, runbooks, and generate periodic health and performance reports
Requirements:
- Active, fully adjudicated Secret clearance
- Proven experience managing AWS RDS for PostgreSQL, including performance tuning, backups, and upgrades
- Strong SQL proficiency with the capability to diagnose and resolve performance issues
- Experience with backup and restore procedures and testing recovery plans
- Working understanding of AWS monitoring tools such as CloudWatch and security services including IAM and encryption best practices
- Familiarity with Linux/Unix environments and scripting automation (Bash, Python)
- Experience provisioning and managing OpenSearch access controls, troubleshooting permission issues
- Experience with DynamoDB and S3 for data storage and management
- Knowledge of additional database platforms or open-source tools
- Familiarity with Terraform or CloudFormation for infrastructure automation
- Certification in AWS or database administration