Senior PostgreSQL Database Administrator
Artmac Soft LLC
Greer, SC, United States
2 months ago
- Discuss this with your agent
- Open in Claude
- Open in ChatGPT
Apply on www.careerjet.com
Prepare application
- Draft this with your agent
- Open in Claude
- Open in ChatGPT
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
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.
Apply for this position
This job is hosted externally. Click below to view the full posting and apply.
Apply on www.careerjet.com
Prepare application
- Draft this with your agent
- Open in Claude
- Open in ChatGPT
Good distractions
Loading talks and stories from around this role…