Database Architect with AWS - MD (Onsite) - Full time only.

TEK Hire Solutions; Woodlawn (MD); On-site; USD 140,000 - 190,000; Full time

Job summary

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.

Qualifications

• 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).

Responsibilities

• 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.

Skills

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

Education

Master's degree

Bachelor's degree

Tools

Splunk

AWS RDS PostgreSQL

Job description

Role: Database Architect with AWS

Location: MD fully onsite

Duration: 1 year to start, multi- year contract

NOTE: Must attend Onsite interview.

Key Required Skills

Experience with PostgreSQL, SQL, Database management, Data Modelling, Data Analysis, Splunk and Server Patching

Position Description

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, manage caching, clustering, and leveraging auto-scaling to handle workloads.

Architect scalable, high-performance, and secure database solutions.

Integrate databases with other AWS services such as Lambda, S3, EC2, and Glue.

Utilize AWS security best practices (IAM, encryption, VPC, security groups) and compliance requirements for data storage.

Design backup, disaster recovery, high availability, and failover solutions (Multi-AZ, read replicas).

Ensure compliance with SSA security, privacy, and data management policies.

Provide guidance/support to other junior/mid-level developers.

All other duties as assigned or directed.

Skills Requirements

Foundation for Success (Basic Qualifications)

10+ years as a Database Admin/Architect

Required Skills

**Selected candidate must be willing to work on-site in MD 5 days a week**

**Master's and 5+ years of experience, Bachelor's and 7+ years of experience or 13+ years in lieu of a degree**

Skilled in PostgreSQL database management, data modeling, normalization, and schema design.

Advanced skills in writing complex SQL queries for data analysis, transformation, and reporting.

Skilled in designing backup, disaster recovery, high availability, and failover solutions (Multi-AZ, read replicas).

Strong experience with database architecture, configuration, installation, backup and recovery.

Experience with AWS RDS PostgreSQL or other cloud PostgreSQL platforms

Strong experience with Logical and Physical data modelling

Experience with Server patching

Experience with Splunk

AWS Experience

• Proven ability to architect scalable, high-performance, and secure database solutions, with proficiency in query optimization, indexing, caching, and performance tuning using AWS tools.
• Experienced in integrating databases with other AWS services such as Lambda, S3, EC2, and Glue.
• Adept at securing AWS clusters, managing IAM roles, implementing encryption, and monitoring jobs using AWS tools (CloudWatch, CloudTrail).

Desired Skills

Experience identifying requirements, researching options, designing, and implementing solutions at a leadership level on project work.

Experience scripting in a Linux environment to automate ETL solutions and data migration jobs.

Understand and apply quality techniques and practices (automated unit testing, Test Driven Design/Development, performance analysis, continuous integration)

Ability to assist with architectural tactical thinking, information solutions and road maps to drive architectural recommendations.

Detail oriented and committed to consistently completing repetitive production-like tasks on-time and error-free.

Prior experience working in a federal agency or public sector environment.

Effective communication skills for working with cross-functional teams, including data scientists, analysts, and business stakeholders.

Ability to translate technical concepts into non-technical terms for business stakeholders.

Ability to manage multiple projects, prioritize tasks, and deliver within deadlines.

Tekhire Solutions is a world-class technology focused on customer-driven solutions and has a deep dive knowledge of client requirements. Tekhire is best in connecting a bridge between highly skilled workers and the Fortune 500. Always thrives to be up with the technology trends, Innovation and transforms our trusted clients with certified and enterprise solutions that makes difference in the business.