Senior PostgreSQL DBA

Omm IT Solutions

19h • Onsite

About The Position

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.

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.

Nice To Haves

• 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.

Responsibilities

• 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.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level