Database Admin Architect

INSPYR Solutions; Milford Mill (MD); On-site; USD 80,000 - 113,000; Full time

Job summary

INSPYR Solutions is seeking a Database Architect for 100% onsite in Windsor Mill, MD. You will manage, secure, monitor, and optimize PostgreSQL databases to ensure high availability and performance, integrating with AWS services like Lambda, S3, EC2, and Glue.

The role requires over 10 years in database Admin/Architect roles, strong data modeling, backup/recovery design, and leadership to guide junior developers. This is an enterprise-grade position with a focus on scalable data platforms.

Qualifications

• Extensive experience (10+ years) as a Database Admin/Architect.

Responsibilities

• Manage, secure, monitor and optimize PostgreSQL databases for availability and performance.
• Monitor databases and perform health checks.
• Plan and implement backup, recovery, and DR strategies.
• Install, update and configure database software.
• Architect scalable database solutions integrating with AWS services.

Skills

PostgreSQL expertise

SQL proficiency

AWS experience

Data modeling

Security/compliance awareness

Leadership

Education

Master's degree in Computer Science or related field

Bachelor's degree in Computer Science or related field

Tools

AWS RDS PostgreSQL

PostgreSQL

Splunk

AWS services integration (Lambda, S3, EC2, Glue)

Job description

Database Architect

Location: 100% Onsite in Windsor Mill, MD

Duration: 12 months

Compensation: $70/ hour W2

Work Requirements: must be eligible to obtain a Public Trust Clearance

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.

Basic Qualifications / Required Skills

• 10+ years as a Database Admin/Architect
• 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.

#IND-Telecom

About INSPYR Solutions

Technology is our focus and quality is our commitment. As a leading expert in delivering flexible technology and talent solutions, we strategically align industry and technical expertise with our clients’ business objectives and cultural needs. Our tailored offerings include a wide variety of professional services, project solutions, managed services, and talent resources, all bolstered by our strategic partnerships with cutting-edge technology services. By always striving for excellence and focusing on the human aspect of our business, we work seamlessly with our talent and clients to match the right solutions to the right opportunities. Learn more about us at www.inspyrsolutions.com.

INSPYR Solutions provides Equal Employment Opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, sex, national origin, age, disability, or genetics. In addition to federal law requirements, INSPYR Solutions complies with applicable state and local laws governing nondiscrimination in employment in every location in which the company has facilities.

INSPYR Solutions provides Equal Employment Opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, sex, national origin, age, disability, genetics, or any other protected status. INSPYR Solutions complies with all applicable laws governing nondiscrimination in employment in every location in which the company has facilities. Applicants requiring reasonable accommodation during the application or interview process should contact [e-mail] for assistance.