PostgreSQL DBA

PB Consulting

Las Vegas, NV

Posted On: Aug 28, 2024

Posted On: Aug 28, 2024

Job Overview

Job Type

Full-time

Experience

8 - 10 Years

Salary

$100,000 - $130,000 Per Year

Work Arrangement

Remote

Travel Requirement

0%

Required Skills

  • Postgres
  • AWS
  • Oracle
  • SQL Server
  • EC2
  • IAM
  • GitHub
  • CI/CD
Job Description
Role and Responsibilities
  • Install, configure, patch, Migrate, Maintain, and upgrade Open-source Database platforms like PostgreSQL, and AWS RDS
  • Implement and maintain effective database coding practices, focusing on performance improvement and indexing strategies.
  • Utilize advanced techniques for full-text indexing, message queuing, and other high-performance data concepts to enhance database efficiency.
  • Manage AWS environment tools and perform effective database administration in a cloud setting.
  • Develop and execute PostgreSQL migration strategies, including estimation, technical management, and execution.
  • Demonstrate advanced understanding of Linux OS, using SSH to connect to remote systems with passwords and public/private keys.
  • Utilize Jira, GitHub, Ansible, and Terraform for database management and automation tasks.
  • Understand and manage batch processes and job scheduling automation to ensure efficient data operations.
  • Apply knowledge of database design principles, query optimization, index management, integrity checks, and statistics to ensure high-quality database performance.
 
Required Qualifications
  • 10-12 years of experience in managing Postgres databases. 5 years of experience should be on the cloud version preferably AWS experience in managing databases as RDS services in AWS, security policy, user authentication, IAM, and database administration in AWS. 
  • Working Knowledge of EDB, Oracle, SQL Server and AWS day-to-day operation on S3 EC2 etc
  • 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
  • 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

Job ID: PC240349

Posted By

Naincy Chauhan

Sr. Manager

Related Jobs
  • Full-time
  • Company

  • COMPANY

    PB Consulting

  • Company

  • experience

    8 - 10 Years

  • Travel Requirements

  • Work Arrangement

    Remote

  • Wallet

  • SALARY

    $100,000 - $130,000 Per Year

  • Skills

  • SKILLS

    • Postgres
    • AWS
    • Oracle
    • SQL Server
    • +4 more

Posted On: Aug 28, 2024