Senior PostgreSQL Database Administrator

Who We AreArtmac Soft is a technology consulting and service-oriented IT company dedicated to providing innovative technology solutions and services to customers.Job DescriptionJob Title : Senior PostgreSQL Database AdministratorJob Type : W2/C2CExperience : 8 10 yearsLocation : Greer, South CarolinaResponsibilities8+ years of hands-on experience administering PostgreSQL in production environmentsStrong expertise in PostgreSQL architecture, internals, and performance tuningProven 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 tuningSolid experience with database security: roles, permissions, SSL/TLS, encryption at rest/in transitStrong scripting skills (Bash, Python, or Perl) for automationExperience with monitoring tools (pgAdmin, pg_stat_statements, Prometheus/Grafana, Datadog, or similar)Solid understanding of SQL and PL/pgSQL for stored procedures, triggers, and functionsExperience with version upgrades and major migration projectsExperience 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 environmentsExposure to CI/CD pipelines and DevOps practicesExperience with data warehousing or ETL pipelinesPostgreSQL certification is preferred.Strong troubleshooting skills for performance, connectivity, and data integrity issuesQualificationBachelor's degree or equivalent combination of education and experience.