Senior PostgreSQL DBA

PLEASE NOTE:

It is a 100% Onsite position, Woodlawn, MD.

Selected candidate must be willing to work on-site in Woodlawn, MD 5 days a week.

• Design, architect, build, test, update, and document Postgre
  
  SQL databases.
• Administer Postgre
  
  SQL databases throughout the development and production life cycles 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.

• Strong knowledge of Postgre
  
  SQL, Database Administration (e.g. analysis, development, maintenance, reporting), Database Schema Design/Development/Maintenance, Cloud Infrastructure (i.e. AWS).

• Bachelor's Degree with 7+ years of experience
• Bachelor's Degree in Computer Science, Mathematics, Engineering, or a related field
• Master's or Doctorate degree may substitute for required experience
• 7+ years of experience with database infrastructure tasks on Linux/Unix operating systems.
• 7+ years of experience with relational database administration/management.
• Must be able to obtain and maintain a Public Trust. Contract requirement.

• Experience working in a cloud environment (e.g. AWS) and with deployment of AWS Cloud Infrastructure.
• Knowledge of Postgre
  
  SQL architecture with experience in optimizing large-scale Postgre
  
  SQL environments to reduce latency and improve query throughput.
• Experience setting up and managing Postgre
  
  SQL on AWS RDS/Aurora and AWS EC2 Virtual Server.
• Experience with data architecture, logical and physical design, reporting and analysis.
• Experience developing and testing automation scripts for startup, shutdown, backups, database scripts, and other tasks.
• Experience with programming languages like bash, Python, PL/pgSQL and Groovy.
• Experience with Replication and Change Data Capture (CDC) techniques and tools.
• Experience with data conversion and management strategies, database partitioning, and Agile database development.
• Experience with microservices database pattern and implementations.
• Experience with Disaster Recovery strategies and implementation.
• Experience with horizontal and vertical scaling techniques and tools in Postgre
  
  SQL.
• Experience with zero-downtime database management techniques (including blue-green deployments).
• Expertise in writing complex SQL queries in Postgre
  
  SQL.
• Strong communication and collaborative skills in providing technical direction and hands‑on database administration to include design, development, and testing.

• Comprehensive knowledge of Scrum and Kanban Agile development process and ceremonies including scrums, planning events, backlog grooming, retrospectives, and demos.
• Experience with collaborating within large, cross‑functional teams to manage upstream and downstream dependencies, while maintaining high productivity on independent assignments.
• Experience with various administration and development platforms for Postgre
  
  SQL (e.g., pg Admin, DBeaver)
• Experience with Liquibase 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.

• Bachelor's Degree with 7+ years of experience
• Must be able to obtain and maintain a Public Trust. Contract requirement.