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

• Bachelors Degree with 7 years of experience
  
• Bachelors Degree in Computer Science Mathematics Engineering or a related field
  
• Masters 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.
  
• 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.
  

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