Start searching
Back to Jobs
Recently postedTechnology

Database Admin Architect

Omm IT SolutionsWoodlawn, MD🇺🇸United States

Quick overview

SeniorityMid Senior
Work modeOn Site
LocationWoodlawn, MD, United States
SQLAWSETLEncryptionSplunkPostgreSQLData AnalysisCI/CDLinuxIAM

Job description

PLEASE NOTE:
  • It is a 100% Onsite position.
  • Selected candidate must be willing to work on-site in Woodlawn, MD 5 days a week
  • Selected candidate must be able to obtain and maintain a public trust clearance
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.

Requirements

SKILL REQUIREMENTS:
BASIC QUALIFICATION:
  • Master's and 5+ years of experience, Bachelor's and 7+ years of experience or 13+ years in lieu of a degree\
  • 10+ years as a Database Admin/Architect
REQUIRED SKILLS:
  • 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.

Similar jobs

Apply