PostgreSQL Database Engineer
ShiftCode Analytics - Riverdale, MD
Apply NowJob Description
Interview : Video Remote to start with; hybrid some time in 2024. Candidates must currently be located within a 2 hour radius of Woodlawn, MD. Description : Notes: Candidate must currently be within a 2-hour radius of Woodlawn, MD No relocation candidates will be considered, only currently local Strong development and administration experience within PostgreSQL database Strong PL/pgSQL and pgAdmin experience Strong experience with AWS cloud (RDS, EC2, etc...) The PostgreSQL Database will be hosted on top of AWS I believe. Job Description: Key Required Skills: PostgreSQL, Database Administration (e.g. analysis, development, maintenance, reporting), Database Schema Design/Development/Maintenance, Cloud Infrastructure (i.e. AWS). Position Description: • Design, architect, build, test, update, and document PostgreSQL databases. • dminister PostgreSQL databases throughout the development and production lifecycles in an AWS environment. • Design and develop logical and physical database designs. • Brief management, customer, team, or vendors using written or oral skills at appropriate technical level for audience. • ll other duties as assigned or directed. Skills Requirements: Basic Qualifications: • Bachelor's Degree in Computer Science, Mathematics, Engineering, or a related field • Master's or Doctorate degree may substitute for required experience • 5+ years of experience with database infrastructure tasks on Linux/Unix operating systems. • 5+ years of experience with relational database administration/management. Required Skills: • Experience working in a cloud environment (e.g. AWS) and with deployment of AWS Cloud Infrastructure. • Knowledge of PostgreSQL architecture. • Experience setting up and managing PostgreSQL on AWS RDS and AWS EC2 Virtual Server. • Experience with data architecture, logical and physical design, reporting and analysis. • Experience developing and testing Linux or Bash scripts for startup, shutdown, backups, database scripts, and other scripting. • Experience with programming languages like PL/pgSQL and Groovy. • Experience with Replication and Change Data Capture (CDC) techniques and tools. • Experience with data conversion and management strategies. • Experience with database partitioning and microservices. • Expertise in writing complex SQL queries in PostgreSQL and optimize queries. • Strong communication and collaborative skills in providing technical direction and hands-on database administration to include design, development, and testing. Desired Skills: • Comprehensive knowledge of Scrum and Kanban Agile development process and ceremonies including scrums, planning events, backlog grooming, retrospectives, and demos. • Experience working as part of a large team and working with upstream and downstream dependencies. • Experience with various administration and development platforms for PostgreSQL (e.g., pgAdmin) • Experience with Liquibase and LiquiGen plug-in. • Experience with Jenkins CI/CD tools and scripting. • Experience with source code versioning and Pull Requests with Git and Stash. • Experience with performance tuning and increasing efficiency of a large enterprise system. Education: Bachelor's Degree in Computer Science, Mathematics, Engineering, or a related field Master's or Doctorate degree may substitute for required experience Must obtain Public Trust
Created: 2026-03-10