Onsite PostgreSQL DB Architect - AWS, Security & DR

Omm IT Solutions; Woodlawn (MD); On-site; USD 140,000 - 210,000; Full time

Job summary

Omm IT Solutions seeks a Database Admin Architect to design, implement, and optimize PostgreSQL databases for high availability in Woodlawn, MD. You will lead data modelling, complex SQL, and data analysis while enforcing security and compliance.

The role requires 10+ years in DBA/Architect roles, an advanced degree, and the ability to obtain and maintain a public trust clearance. This on-site position is full-time and onsite five days a week.

Qualifications

• Master's degree or higher with extensive database architecture background.
• 10+ years in PostgreSQL database administration and design.
• Strong SQL querying, data modeling, and performance tuning.
• Experience with AWS cloud services and security best practices.

Responsibilities

• Manage, secure, monitor, and optimize PostgreSQL databases for high availability.
• Design and implement backup, disaster recovery, and failover strategies.
• Write complex SQL for data analysis and reporting, and optimize performance.
• Integrate databases with AWS services (Lambda, S3, EC2, Glue) and IAM controls.
• Mentor junior staff and ensure compliance with SSA and security policies.

Skills

PostgreSQL

SQL

Database management

Data modelling

Data analysis

Splunk

Server patching

Education

Master's degree in a related field

7+ years as Database Admin/Architect

13+ years in lieu of a degree

Tools

AWS RDS PostgreSQL

AWS Lambda

AWS S3

AWS EC2

AWS Glue

IAM

CloudWatch

CloudTrail

Job description

Omm IT Solutions seeks a Database Admin Architect to design, implement, and optimize PostgreSQL databases for high availability in Woodlawn, MD. You will lead data modelling, complex SQL, and data analysis while enforcing security and compliance.

The role requires 10+ years in DBA/Architect roles, an advanced degree, and the ability to obtain and maintain a public trust clearance. This on-site position is full-time and onsite five days a week.