PostgreSQL Database AdministratorInterview: Video remote to start with; hybrid some time in 2024. Candidates must currently be located within a 2 hour radius of Woodlawn, MD.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 DescriptionKey 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. Administer 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. All other duties as assigned or directed.Skills RequirementsBasic 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.EducationBachelor'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.