Database Administrator ( PostgreSQL )

10xTalents; Philadelphia (Philadelphia County); On-site; USD 90,000 - 120,000; Full time

Job summary

A leading tech firm is seeking an experienced Database Administrator specializing in PostgreSQL to develop scalable database solutions. The ideal candidate will have at least 5 years of experience in database administration, strong skills in performance optimization, and expertise in backup and recovery strategies. The role is hybrid, based in Center City Philadelphia, and requires collaboration with various teams to ensure database reliability and security.

Qualifications

• Minimum of 5 years in PostgreSQL database administration.
• Deep understanding of PostgreSQL systems and architecture.
• Familiarity with high-availability setups and real-time replication.

Responsibilities

• Develop and implement scalable PostgreSQL database solutions.
• Analyze and enhance database performance through optimization techniques.
• Establish robust backup and recovery mechanisms.
• Maintain security measures to protect sensitive data.

Skills

PostgreSQL expertise

SQL tuning and performance enhancements

Automation (Bash, Python)

Backup and recovery strategies

Monitoring tools (pgAdmin, Nagios, Zabbix)

Education

Bachelor's degree in a relevant field

Tools

AWS RDS

Google Cloud SQL

Job description

Philadelphia, Pennsylvania, United States

About the job Database Administrator ( PostgreSQL )

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.