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.
Sign in
To continue your applicationor continue with email
By continuing you agree to our Terms & Privacy Policy.
Similar jobs
Show more