Senior PostgreSQL Database Administrator

Who We Are 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.