Share of this job’s tasks that AI is already used for at work, from real usage. It is not a forecast of job loss, and a low number means no use seen yet. Source: Anthropic Economic Index.

Check how this applies to your own job

Skills this job asks for

Say which you have and which you want to build. We use it to match you to jobs like this one.

About the job

Database Administrator ( PostgreSQL ) Location: Hybrid/Center City Philadelphia, PA

Full-time / Regular W2 role - No C2C

No Visa transfers at this time

Our client is looking for an experienced Database Administrator with expertise in PostgreSQL to oversee the architecture, optimization, and upkeep of their database systems.

Responsibilities

Database Strategy and Design: Develop and implement scalable and reliable PostgreSQL database solutions tailored to business needs.

Optimization: Analyze and enhance database performance using techniques such as query optimization, indexing strategies, and resource allocation.

Data Protection: Establish robust backup and recovery mechanisms, including replication and disaster recovery solutions.

Security Oversight: Apply and maintain security measures to safeguard sensitive data, adhering to industry standards.

System Monitoring: Set up and use tools to continuously track database performance and ensure system reliability.

Automation: Streamline routine operations such as monitoring, backups, and deployment using automation tools and scripts.

Updates and Maintenance: Plan and execute database migrations, upgrades, and patches with minimal service disruption.

Documentation: Create comprehensive documentation of database processes, configurations, and guidelines.

Team Support: Collaborate with developers on query optimization, schema design, and application integration.

Incident Response: Diagnose and resolve database issues promptly to minimize downtime.

Requirements

Education: Bachelors degree in a relevant field or equivalent professional experience.

Experience: Minimum of 5 years in PostgreSQL database administration.

Technical Expertise: Deep understanding of PostgreSQL systems and architecture.

Strong skills in SQL tuning and performance enhancements.

Familiarity with high-availability setups, including replication and clustering.

Hands-on experience with backup and recovery strategies.

Proficiency in cloud-hosted databases (e.g., AWS RDS, Google Cloud SQL).

Automation experience using Bash, Python, or similar scripting languages.

Knowledge of monitoring tools and their configuration (e.g., pgAdmin, Nagios, Zabbix).

Awareness of database security practices and compliance standards.