AWS PostgreSQL Architect—Onsite MD

Tek Hire Solutions; Woodlawn (MD); Vor Ort; USD 140.000 - 190.000; Vollzeit

Zusammenfassung

Tekhire Solutions in Maryland is seeking a Database Architect with AWS for a 1-year contract onsite five days a week. You will manage PostgreSQL databases, design scalable data models, write complex SQL, and optimize performance and security across AWS services (RDS, Lambda, S3, EC2, Glue).

Requirements include 10+ years as a Database Admin/Architect with Master’s or equivalent, strong PostgreSQL, data modeling, backups and DR, and experience patching servers and using Splunk.

Qualifikationen

• 10+ years as a Database Admin/Architect.
• Master's or 13+ years in lieu of a degree.
• PostgreSQL database management, data modeling, normalization, and schema design.
• Advanced SQL for data analysis, transformation, and reporting.
• Experience with AWS RDS PostgreSQL or other cloud PostgreSQL platforms.
• Experience with server patching and Splunk.
• Strong data modeling (logical/physical).

Aufgaben

• Managing, maintaining, securing, monitoring and optimizing PostgreSQL databases to ensure high availability and performance.
• Database monitoring and health check.
• Backup and recovery management.
• Database installation, updates and configuration.
• Write complex SQL queries for data analysis, transformation, and reporting.
• Optimize queries, caching, clustering, and auto-scaling.
• Architect scalable, high-performance, and secure database solutions.
• Integrate databases with AWS services (Lambda, S3, EC2, Glue).
• Apply AWS security best practices and compliance for data storage.
• Design backup, disaster recovery, high availability, and failover (Multi-AZ, read replicas).
• Ensure compliance with SSA security, privacy, and data management policies.
• Provide guidance/support to junior/mid-level developers.
• All other duties as assigned or directed.

Kenntnisse

PostgreSQL

SQL

Data Modeling

Normalization

Schema Design

Data Analysis

Query Optimization

AWS

RDS PostgreSQL

Disaster Recovery

High Availability

Read Replicas

Backup and Recovery

Server Patching

Splunk

Ausbildung

Master's degree

Bachelor's degree

Tools

Splunk

AWS RDS PostgreSQL

Jobbeschreibung

Tekhire Solutions in Maryland is seeking a Database Architect with AWS for a 1-year contract onsite five days a week. You will manage PostgreSQL databases, design scalable data models, write complex SQL, and optimize performance and security across AWS services (RDS, Lambda, S3, EC2, Glue).

Requirements include 10+ years as a Database Admin/Architect with Master’s or equivalent, strong PostgreSQL, data modeling, backups and DR, and experience patching servers and using Splunk.