Sr. Cloud DBA

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

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.