Postgre SQL DBA

Infinite Computer Solutions; New Jersey; On-site; USD 65,000 - 90,000; Full time

Job summary

Infinite Computer Solutions is seeking a Junior PostgreSQL Database Administrator to support PostgreSQL database environments, assist senior DBAs, and help with backups, monitoring, and deployments across development, test, and production environments.

The role offers hands-on experience in SQL performance tuning, enterprise database support, and collaboration with application teams. This entry‑level position focuses on building skills in database operations and reliability.

Qualifications

• 1–3 years of PostgreSQL database administration experience.
• Solid understanding of PostgreSQL architecture and concepts.
• Strong SQL querying and troubleshooting skills.
• Familiarity with Linux/Unix environments.
• Knowledge of backup and recovery concepts.
• Experience with database monitoring and log analysis.
• Understanding of database security, roles and permissions.
• Ability to troubleshoot performance and connectivity issues.
• Excellent communication and documentation skills.

Responsibilities

• Install, configure, and maintain PostgreSQL databases.
• Monitor DB health, storage, and performance.
• Support backup, restore, and recovery activities.
• Perform routine maintenance and health checks.
• Assist with patching, upgrades, and migrations.
• Troubleshoot connectivity and performance issues.
• Write and support SQL queries, scripts, and procedures.
• Manage user access and database security controls.
• Review logs and assist root-cause analysis.
• Collaborate with development to resolve DB issues.
• Maintain runbooks and documentation.
• Support high availability and DR activities as needed.

Skills

PostgreSQL administration

SQL querying

Linux/Unix

Backups & recovery

Performance monitoring

Security & permissions

Troubleshooting

Documentation

Communication skills

Education

Bachelor's degree in Computer Science or related field

Tools

pgAdmin

psql

AWS RDS / Azure PostgreSQL

Job description

Junior PostgreSQL Database Administrator (Jr. PostgreSQL DBA)

Job Summary

We are seeking a Junior PostgreSQL Database Administrator (Jr. PostgreSQL DBA) to support the administration, maintenance, monitoring, and performance of PostgreSQL database environments. The ideal candidate will assist senior DBAs and application teams with database operations, backups, troubleshooting, performance monitoring, and database deployments in development, test, and production environments. This is an excellent opportunity for candidates looking to build hands‑on experience in database administration, SQL performance tuning, and enterprise database support.

Key Responsibilities

• Assist in the installation, configuration, and maintenance of PostgreSQL databases.
• Monitor database health, availability, storage usage, and system performance.
• Support database backup, recovery, and restoration activities.
• Execute routine database maintenance tasks and health checks.
• Assist with database patching, upgrades, and environment migrations.
• Troubleshoot database connectivity, performance, and operational issues.
• Write and support SQL queries, scripts, and stored procedures.
• Support user access management, permissions, and database security controls.
• Monitor database logs and assist in issue resolution and root cause analysis.
• Work with development and application support teams to resolve database‑related issues.
• Maintain database documentation, procedures, and operational runbooks.
• Support high‑availability and disaster recovery activities as needed.

Required Skills & Qualifications

• 1–3 years of experience supporting PostgreSQL databases or database administration.
• Basic understanding of PostgreSQL architecture and database concepts.
• Strong SQL querying and troubleshooting skills.
• Familiarity with Linux/Unix operating systems.
• Understanding database backup and recovery concepts.
• Experience with database monitoring and log analysis.
• Knowledge of database security, user roles, and permissions.
• Ability to troubleshoot performance and connectivity issues.
• Strong analytical and problem‑solving skills.
• Good communication and documentation skills.

Preferred Skills

• Experience with PostgreSQL replication and high‑availability concepts.
• Familiarity with pgAdmin, psql, or other PostgreSQL tools.
• Exposure to cloud database platforms such as AWS RDS or Azure PostgreSQL.
• Basic scripting knowledge (Shell, Python, or PowerShell).
• Knowledge of database migration and deployment processes.
• Experience working in Agile or DevOps environments.

Education

• Bachelor's degree in computer science, Information Technology, or related field preferred.