Postgres SQL DBA

Title: Postgres DBA
Location: Las Vegas On-site
Duration: Long Term
Experience: 7

Only locals or nearby.

• Should be able to implement effective and maintainable database coding practices that form an architectural foundation.
  Experience in Postgres SQL performance improvement, indexing/other approaches
  Good experience on partitioning database
  Experience with message queuing, full-text indexing, and other high-performance data concepts.
  Experience in AWS environment management and knowledge of different tools for the same.
  Experience in Postgres SQL migration approach, estimating it, and technically managing it.
  Advanced understanding of Linux OS, use SSH to connect to remote systems with password & public/private keys.
  Ability to efficiently write database code without compromising data quality, privacy, or security.
  Hands-on Experience in Jira, GitHub, Ansible & Terraform.
  Good understanding of CI/CD using GitLab .
  Good understanding of the Batch process and Job scheduling automation .
  Knowledge of database design principles, query optimization, index management, integrity checks, statistics, and isolation levels .
  Good troubleshooting skills, Ability to evaluate alternative solutions and/or workarounds 1 Strong analytical, and interpersonal communication skills.