Senior PostgreSQL DBA

• 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 PostgreSQL databases.
  
• Administer PostgreSQL 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 PostgreSQL, Database Administration (e.g. analysis, development, maintenance, reporting), Database Schema Design/Development/Maintenance, Cloud Infrastructure (i.e. AWS).
  

Requirements

• 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 PostgreSQL architecture with experience in optimizing large-scale PostgreSQL environments to reduce latency and improve query throughput.
  
• Experience setting up and managing PostgreSQL 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 PostgreSQL.
  
• Experience with zero-downtime database management techniques (including blue-green deployments).
  
• Expertise in writing complex SQL queries in PostgreSQL.
  
• 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 PostgreSQL (e.g., pgAdmin, 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.