Remote Senior Cloud DBA: AWS PostgreSQL & Data Warehousing

North South Consulting Group, LLC; Elizabethtown (KY); On-site; USD 120,000 - 160,000; Full time

Job summary

North South Consulting Group, LLC seeks a Senior Cloud Database Analyst to design, implement, and maintain cloud-based databases on AWS, emphasizing PostgreSQL and Aurora. You will optimize HR processes and enable data-driven decisions across the organization.

The role requires strong ETL, data warehousing, and security expertise, plus active Secret clearance eligibility and US citizenship. This is a 100% remote position with cross-functional collaboration across lines of business.

Qualifications

• Proven AWS cloud database experience including design, implementation, and maintenance of cloud databases.
• Strong PostgreSQL and Amazon Aurora expertise in AWS RDS environments.
• Experience with ETL processes and data warehousing; IBM DataStage is a plus.
• Must hold Technical Level III certification per DODI 8570.
• Excellent written and verbal communication skills.
• Active Secret clearance required (or ability to obtain).
• U.S. citizen required.

Responsibilities

• Lead development, maintenance, and optimization of databases within AWS.
• Design and manage highly available PostgreSQL/Aurora databases in AWS RDS.
• Provide database security expertise including IAM, encryption, and security groups.
• Review and propose technical solutions for database projects from design to deployment and support.
• Develop data warehousing solutions, ETL processes, and report generation from multiple sources.
• Oversee job scheduling, monitoring, and performance tuning for reliability and performance.
• Create and maintain comprehensive documentation for database architectures and processes.

Skills

AWS

PostgreSQL

Amazon Aurora

ETL processes

Data warehousing

Security (IAM, encryption)

Written & verbal communication

Clearance eligibility

Education

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

BA/BS with 15 years experience

Tools

AWS RDS

AWS DMS

IBM DataStage

Job description

We are seeking a highly skilled and experienced Senior Cloud Database Analyst to join our team. The successful candidate will play a pivotal role in designing, implementing, and maintaining our cloud-based database solutions on Amazon Web Services (AWS). This candidate will optimize HR processes and improve decision-making for the Army's Human Resources Command (HRC) by leveraging modern database technologies. The ideal person will work closely across various lines of business to understand the objectives of the organization and prioritize any requirements.

This position is 100% remote.

Responsibilities:

• Under general direction, lead the development, maintenance, and optimization of application databases and structures within the AWS cloud environment
• Design, implement, and manage highly available and scalable PostgreSQL and Amazon Aurora databases using AWS RDS
• Provide expertise in database security, including Cyber and IA systems maintenance, within an AWS context, implementing security groups, IAM policies, and encryption
• Review and provide technical solutions for database-related projects, from initial design to deployment and ongoing support
• Develop and manage data warehousing solutions, ETL processes (e.g., using AWS Glue), and report generation from various data sources
• Oversee job scheduling, monitoring, and performance tuning of database systems to ensure optimal performance and reliability
• Create and maintain comprehensive technical documentation for database architecture, processes, and procedures
  
  

Requirements:

• Proven experience as a Database Administrator or Analyst in an AWS environment
• Strong, hands-on expertise with PostgreSQL and Amazon Aurora
• Experience with AWS database services, including Amazon RDS, and familiarity with database migration strategies (e.g., AWS DMS)
• Solid understanding of ETL processes and tools; experience with IBM DataStage is a plus
• Professionally certified as Technical Level III as defined by DODI 8570
• Advanced previous experience working in roles with strong written and verbal communications skills
• Active Secret clearance required (or the ability to obtain one)
• Must be a US citizen
  
  

Preferred Education/Experience:

• Minimum of 10+ years’ experience with a Master’s degree in Computer Science, Information Technology, Data Science or a related field
  
  

Or in lieu: BA/BS with 15 years experience

• AWS Certified Database - Specialty certification is highly desirable