Artmac Soft is a technology consulting and service-oriented IT company dedicated to providing innovative technology solutions and services to customers.
Job Description:
Job Title : Senior PostgreSQL Database Administrator
Job Type : W2/C2C
Experience : 8 10 years
Location : Greer, South Carolina
Responsibilities:
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.
Numbers & Facts
Location
Greer, SC
Skills
Amazon Relational Database Service (RDS)unmatched
Analysis Skillsunmatched
Ansibleunmatched
Automationunmatched
Bash Scriptingunmatched
Cloud Computingunmatched
Clustering Softwareunmatched
Consultingunmatched
Continuous Deployment/Deliveryunmatched
Continuous Integrationunmatched
Cryptographyunmatched
Customer Support/Serviceunmatched
Data Qualityunmatched
Data Recoveryunmatched
Database Administrationunmatched
Database Extract Transform and Load (ETL)unmatched
Database Technologyunmatched
Database Triggersunmatched
DevOpsunmatched
High Availabilityunmatched
Identify Issuesunmatched
Information Technology & Information Systemsunmatched
Information/Data Security (InfoSec)unmatched
MongoDBunmatched
Multiplatform/Cross-Platformunmatched
MySQLunmatched
NoSQLunmatched
Oracleunmatched
Performance Tuning/Optimizationunmatched
Perl Programming Languageunmatched
PostgreSQLunmatched
Production Systemsunmatched
Python Programming/Scripting Languageunmatched
Query Optimizationunmatched
Relational Databases (RDBMS)unmatched
Replication and Remote Mirroringunmatched
SQL (Structured Query Language)unmatched
SSL-TLS (Secure Socket Layer - Transport Layer Security)unmatched
Stored Proceduresunmatched
🎯
Be found by employers
5,500+ employers search our resume database daily. Add yours to get found by recruiters looking for candidates like you.
Level up your application
Professional resume templates
Browse dozens of recruiter approved resume templates, layouts and formats. Choose your favorite and make it your own in minutes.