Senior Cloud DBA - AWS PostgreSQL & Data Warehouse Expert

northsouthconsultinggroup; United States; Remote; USD 130,000 - 190,000; Full time

Job summary

NorthSouth Consulting Group is seeking a Senior Cloud Database Analyst to design, implement, and maintain cloud-based database solutions on AWS for mission-critical HR data. The role is 100% remote within the United States and requires US citizenship, with the ability to obtain an active clearance.

Focus areas include security, reliability, and scalable data architectures. You will optimize PostgreSQL and Amazon Aurora on RDS, oversee ETL pipelines (AWS Glue), data warehousing, and produce

Qualifications

• Proven experience as a Database Administrator or Analyst in an AWS environment.
• Hands-on expertise with PostgreSQL and Amazon Aurora.
• Experience with AWS database services, including Amazon RDS, and migration strategies (AWS DMS).
• Solid ETL knowledge; IBM DataStage is a plus.
• Active Secret clearance or ability to obtain one; US citizenship required.
• Strong written and verbal communication skills.

Responsibilities

• Lead the development, maintenance, and optimization of databases within the AWS cloud environment.
• Design, implement, and manage highly available PostgreSQL and Amazon Aurora databases using AWS RDS.
• Provide expertise in database security, including IAM policies and encryption, within AWS context.
• Review and provide technical solutions for database-related projects from design to deployment and ongoing support.
• Develop and manage data warehousing solutions, ETL processes (e.g., AWS Glue), and reporting from diverse data sources.
• Oversee job scheduling, monitoring, and performance tuning of database systems to ensure reliability.
• Create and maintain comprehensive technical documentation for database architecture, processes, and procedures.

Skills

PostgreSQL

Amazon Aurora

AWS RDS

AWS DMS

ETL processes

IBM DataStage

Security (IAM, encryption)

Data warehousing

SQL & performance tuning

Strong communication

Education

Master's degree in Computer Science / IT / Data Science

BA/BS + 15 years experience

Tools

AWS Glue

AWS DMS

PostgreSQL

Amazon Aurora

AWS RDS

Job description

NorthSouth Consulting Group is seeking a Senior Cloud Database Analyst to design, implement, and maintain cloud-based database solutions on AWS for mission-critical HR data. The role is 100% remote within the United States and requires US citizenship, with the ability to obtain an active clearance.

Focus areas include security, reliability, and scalable data architectures. You will optimize PostgreSQL and Amazon Aurora on RDS, oversee ETL pipelines (AWS Glue), data warehousing, and produce