Senior PostgreSQL DBA & Programmer - Build & Optimize DBs

Ask IT consulting; Portland (OR); On-site; USD 90,000 - 120,000; Full time

Job summary

ASK IT consulting is seeking a PostgreSQL Database Administrator and Programmer for a client project in Portland, Oregon. The position is a contract engagement lasting 8 months.

The role involves supporting a software development team to design and maintain PostgreSQL databases, write SQL, manage backups, perform performance tuning, and implement schema changes and security controls. Strong written and verbal communication skills are required, and the candidate must meet deadlines.

Qualifications

• 5+ years of PostgreSQL experience.
• Proficient in SQL and advanced SQL.
• Experience with performance tuning PostgreSQL.
• Backup and restore procedures experience.
• Designing and managing PostgreSQL database schemas.
• Proficient in pgPL/SQL and triggers.
• SQL Development experience with ETL and Oracle data.
• Experience assisting front end application developers with SQL.
• Experience in security access control.
• Full project lifecycle experience.
• Strong written and verbal communication skills.

Responsibilities

• Support a software development team by building databases, tables, triggers, and functions.
• Maintain schemas, create users/roles, and manage backup/restore processes.

Skills

PostgreSQL

SQL

Performance tuning

Backup and restore

Database schema design

pgPL/SQL

ETL

Security access control

Full lifecycle

Communication

Teamwork

Job description

ASK IT consulting is seeking a PostgreSQL Database Administrator and Programmer for a client project in Portland, Oregon. The position is a contract engagement lasting 8 months.

The role involves supporting a software development team to design and maintain PostgreSQL databases, write SQL, manage backups, perform performance tuning, and implement schema changes and security controls. Strong written and verbal communication skills are required, and the candidate must meet deadlines.