PostgreSQL Database Administrator

Skills:

10+ years of PostgreSQL DBA experience
Thorough knowledge of implementing and maintaining security controls in a highly regulated industry with PostgreSQL databases
PostgreSQL replication experience
SQL coding and tuning experience
Shell scripting and automation experience
PostgreSQL PGAdmin client connectivity tool experience
AWS/Cloud Services experience: EC2, RDS, and Aurora
Cloud deployments experience: Jenkins, Bitbucket, Terraform
Hands-on, technically adept DBA, capable of performing required DB tasks experience
Strong troubleshooting/performance tuning skills
Ability to assess and improve SQL performance
Understanding of PostgreSQL’s underlying storage engines
Ability to Handle common database procedures, such as upgrade, backup, recovery, migration, etc.
Profile server resource usage, optimize and tweak as necessary
Expert level PostgreSQL RDBMS installation/configuration, patching, troubleshooting, performance tracking/tuning, back-up/recovery, remote monitoring skills with hands-on experience in -large and very dynamic environments
Strong commitment to following SDLC/Change-Management principles
Self-starter and be able to perform work with minimal supervisory direction
Knowledge of data quality, data management, and data testing strategies and practices
Strong communication skills, both oral and written
Solid experience working with ticketing tools such as ServiceNow, Zenoss or any other monitoring tool, Cloud monitoring tools (CloudWatch, CloudTrail), AppDynamics (or similar APM tool)
Strong problem-solving and troubleshooting skills
Keen analytical and structured approach to problem solving
Ability to accommodate flexible work schedules