Postgre SQL Administrator

Description of Work: • PostgreSQL, Database Administration (e.g. analysis, development, maintenance, reporting), Database Schema Design/Development/Maintenance, Cloud Infrastructure (i.e. AWS). • 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. Basic Qualifications: Minimum knowledge, skills, abilities needed. • 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. • 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.