Job Title: PostgreSQL Database Administrator (DBA) Location: Charlotte, NC(On-site/Hybrid – Only Locals) Job Type: LongTerm Contract Only on W2, We can accept H1B Transfer candidates too. Job Summary: We are seeking a skilled
PostgreSQL Database Administrator to manage, optimize, and ensure the security and performance of our PostgreSQL databases. The ideal candidate will have hands-on experience with database administration, performance tuning, backup and recovery strategies, and high-availability solutions.
Key Responsibilities: - Install, configure, and maintain PostgreSQL database systems.
- Monitor database performance and tune queries for efficiency.
- Design and implement backup and disaster recovery strategies.
- Perform data migration and upgrades across PostgreSQL versions.
- Ensure data integrity and implement security best practices.
- Collaborate with developers to optimize SQL queries and schema design.
- Set up replication, clustering, and high-availability solutions.
- Monitor and resolve database-related incidents and issues.
- Write and maintain documentation for database systems and procedures.
Required Qualifications: - 5+ years of hands-on experience with PostgreSQL.
- Strong understanding of RDBMS concepts and PostgreSQL architecture.
- Proficiency in SQL and experience with query optimization.
- Experience with backup tools like pg_dump, pg_basebackup, or Barman.
- Familiarity with high availability (e.g., Patroni, repmgr, streaming replication).
- Experience in Linux/Unix environments and shell scripting.
- Knowledge of monitoring tools (e.g., pgAdmin, Nagios, Prometheus + Grafana).
- Familiarity with CI/CD pipelines and DevOps practices is a plus.
Preferred Qualifications: - Experience with cloud-based PostgreSQL services (AWS RDS, GCP Cloud SQL, Azure Database for PostgreSQL).
- Knowledge of JSONB, Full-Text Search, and PostgreSQL extensions (PostGIS, TimescaleDB).
- Experience with Python, Java, or another backend language.
- Familiarity with containerization tools (Docker, Kubernetes).