Senior PostgreSQL Database Administrator

Artmac Soft LLC

Greer, SC, United States

13 days ago

Apply on www.careerjet.com

Prepare application

Role details

Contract type

Permanent contract

Employment type

Full-time (> 32 hours)

Experience level

Expert

Experience required

8 years minimum

Working hours

Regular working hours

Job source

www.careerjet.com

Tech stack

Bash Shell Cluster Analysis Data Integrity Extract Transform Load (ETL) Data Recovery Data Warehousing Relational Databases Database Security DevOps Perl (Programming Language) Monitoring of Systems Python (Programming Language)

+20 more

PostgreSQL MongoDB MySQL NoSQL Oracle (Applications) Performance Tuning Query Optimization Ansible Prometheus SQL Stored Procedures SQL Databases Data Streaming Management of Software Versions Datadog Scripting Grafana Database Optimization Amazon Relational Database Service Infrastructure Automation Frameworks Terraform

Requirements

8+ years of hands-on experience administering PostgreSQL in production environments
Strong expertise in PostgreSQL architecture, internals, and performance tuning
Proven experience with replication (streaming, logical), clustering, and high availability solutions (e.g., Patroni, repmgr, Pgpool-II)
Deep understanding of backup and recovery tools (pg_dump, pg_basebackup, pgBackRest, Barman, WAL archiving/PITR)
Expertise in query optimization, indexing strategies, and EXPLAIN/ANALYZE plan tuning
Solid experience with database security: roles, permissions, SSL/TLS, encryption at rest/in transit
Strong scripting skills (Bash, Python, or Perl) for automation
Experience with monitoring tools (pgAdmin, pg_stat_statements, Prometheus/Grafana, Datadog, or similar)
Solid understanding of SQL and PL/pgSQL for stored procedures, triggers, and functions
Experience with version upgrades and major migration projects
Experience with cloud-managed PostgreSQL services (AWS RDS/Aurora)
Experience with Infrastructure as Code tools (Terraform, Ansible)
Knowledge of other RDBMS/NoSQL systems (MySQL, MongoDB, Oracle) for cross-platform environments
Exposure to CI/CD pipelines and DevOps practices
Experience with data warehousing or ETL pipelines
PostgreSQL certification is preferred.
Strong troubleshooting skills for performance, connectivity, and data integrity issues

Qualification: Bachelor’s degree or equivalent combination of education and experience.

About the company

Artmac Soft is a technology consulting and service-oriented IT company dedicated to providing innovative technology solutions and services to customers.