The Role
Architect, administer, secure, monitor, and optimize PostgreSQL databases for high availability and performance. Design schemas, complex SQL queries, backup and disaster recovery solutions, clustering, failover, and scalable AWS database architectures. Integrate PostgreSQL with AWS services, implement security and compliance controls, perform patching and monitoring, and support data analysis and migration initiatives. Provide technical guidance to junior and mid-level developers while collaborating with cross-functional stakeholders.
Summary Generated by Built In
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.
Skills Required
- Master’s degree and 5+ years of experience, bachelor’s degree and 7+ years of experience, or 13+ years of experience in lieu of a degree
- 10+ years of experience as a database administrator or database architect
- PostgreSQL database management, data modeling, normalization, and schema design
- Advanced SQL query writing for data analysis, transformation, and reporting
- Design of backup, disaster recovery, high availability, and failover solutions
- Database architecture, configuration, installation, backup, and recovery
- AWS RDS PostgreSQL or another cloud PostgreSQL platform
- Logical and physical data modeling
- Server patching
- Splunk experience
- AWS database architecture, query optimization, indexing, caching, and performance tuning
- Integration with AWS Lambda, S3, EC2, and Glue
- AWS security practices including IAM, encryption, VPC, security groups, CloudWatch, and CloudTrail
- Ability to obtain and maintain a Public Trust clearance
- Linux scripting for ETL automation and data migration
- Automated testing, test-driven development, performance analysis, and continuous integration
- Federal agency or public-sector experience
- Experience providing architectural recommendations and road maps
- Effective communication with technical and business stakeholders
- Ability to manage multiple projects and deliver within deadlines
Am I A Good Fit?
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.
Success! Refresh the page to see how your skills align with this role.
The Company
What We Do
Omm IT Solutions is a leading provider of IT consulting, analysis, and advisory services, specializing in delivering technical solutions for federal and state government agencies. Their offerings include application development, cybersecurity services, cloud advisory, network modernization, and data analytics.
