Flag job

Report

PostgreSQL Database Administrator

Salary

$4k - $5k

Min Experience

3 years

Location

remote

JobType

full-time

About the job

Info This job is sourced from a job board

About the role

Requirements: Proven experience as a PostgreSQL DBA in a production environment. Deep understanding of PostgreSQL architecture, internals, and best practices. Strong SQL skills and experience with query optimization techniques. Experience with performance monitoring and tuning tools (e.g., pg_stat_statements, EXPLAIN ANALYZE, monitoring platforms like Prometheus/Grafana). Solid understanding of backup and recovery principles and experience with PostgreSQL backup and recovery tools. Experience with setting up and managing PostgreSQL replication (streaming, logical). Knowledge of database security principles and best practices. Experience with database upgrades and patching processes. Experience with cloud-based PostgreSQL services (e.g., AWS RDS for PostgreSQL, Azure Database for PostgreSQL, Google Cloud SQL for PostgreSQL). Nice-to-Have: Proficiency in scripting languages (e.g., Python, Bash). Experience with Linux operating systems. Experience with other database technologies. Knowledge of DevOps practices and tools (e.g., Terraform, Ansible, Chef, Puppet). Familiarity with containerization technologies (Docker) and orchestration platforms (Kubernetes). Key Responsibilities: Managed PostgreSQL Service Evaluation: Research and compare available managed PostgreSQL offerings (e.g., from GCP), conduct a Proof of Concept (POC), and deliver a report with recommendations and technical requirements for migrating our current PostgreSQL environments to a managed service. Migration Planning and Execution: Develop a detailed migration plan to the chosen managed PostgreSQL service, execute the initial migration steps based on POC results, and collaborate with the release team to understand deployment impacts. Database Performance Optimization: Monitor, analyze, and fine-tune PostgreSQL queries, indexes, and system resource utilization to ensure efficient and reliable operations. Backup and Disaster Recovery Planning: Develop and maintain robust backup strategies. Regularly test and validate recovery procedures to safeguard against data loss. Database Security Management: Manage roles, permissions, and access controls. Ensure database systems are secure and compliant with internal and regulatory standards. High Availability and Replication: Configure and maintain PostgreSQL replication (e.g., streaming replication, logical replication) to support failover, redundancy, and load balancing. Database Upgrades and Patching: Plan and execute PostgreSQL upgrades and patch deployments to maintain system stability, security, and feature parity.

About the company

KaaIoT Technologies, LLC is an Internet of Things Product company and one of the leading Internet of Things technology providers. Our clients are located in the US/EU/Middle East regions and they run projects in multiple industries - from Smart Home / Energy to Telecom, Smart Wearables, and Industry 4.0. We are developing one of the world's top IoT platforms. If you are result oriented and want to grow and develop in your career - just show us what you got. CyberVision were original creators of the Kaa IoT Platform, which later branched off as an independent company, KaaIoT. CyberVision is a software development company with a long history of global success stories. For over 25 years in the industry, we've built technologies now used by tens of millions of people and enabled our clients to grow their businesses manifold. We offer a broad range of software development, quality assurance, IT consulting, DevOps, and support services for global companies as well as rising start-ups. Our areas of expertise include Big Data, Cloud, Telecom, Internet of Things, Mobile, AI & ML, SaaS, and other modern technologies. Our delivery model is based on the time-proven agile methodologies that ensure full work transparency and fast time-to-market. CyberVision has R&D facilities in the US and Eastern Europe, with some of the most comprehensive talent & expertise profiles in the modern IT stack.

Skills

PostgreSQL
SQL
EXPLAIN ANALYZE
Prometheus/Grafana
AWS RDS for PostgreSQL
Azure Database for PostgreSQL