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
- PostgreSQL DBA
Las Vegas, NV
- Full-time
COMPANY
PB Consulting
experience
8 - 16 Years
Work Arrangement
Hybrid
SALARY
$110,000 - $130,000 Per Year
SKILLS
- PostgreSQL
- DBA
- Database
Posted On: Nov 14, 2024
- PostgreSQL DBA
Las Vegas, NV
- Full-time
COMPANY
Long Finch Technologies
experience
8 - 20 Years
Work Arrangement
Hybrid
SALARY
$100,000 - $130,000 Per Year
SKILLS
- PostgreSQL
- SQL
- DBA
- Admin
- +1 more
Posted On: Sep 19, 2024
- PostgreSQL DBA
Las Vegas, NV
- Full-time
COMPANY
PB Consulting
experience
8 - 10 Years
Work Arrangement
Remote
SALARY
$100,000 - $130,000 Per Year
SKILLS
- Postgres
- AWS
- Oracle
- SQL Server
- +4 more
Posted On: Aug 28, 2024