Postgres DBA

IBA InfoTech Inc.

Jacksonville, FL, United States

about 2 months ago

Role details

Contract type

Permanent contract

Employment type

Full-time (> 32 hours)

Experience level

Experienced

Experience required

3 years minimum

Working hours

Regular working hours

Job source

ibainfotech.com

Tech stack

C (Programming Language) Java (Programming Language) PHP (Programming Language) Bash Shell C++ (Programming Language) Ubuntu (Operating System) CentOS Databases Computer Engineering Data Migration Database Design Debian Linux

+23 more

Linux Perl (Programming Language) Python (Programming Language) Korn Shell PostgreSQL Microsoft SQL Server MySQL Online Transaction Processing Oracle (Applications) Performance Tuning Red Hat Enterprise Linux Ruby Standard Sql SQL Databases Data Streaming Scripting System Availability Database Optimization Software Application Programming Database Migration Information Technology Free and Open-Source Software Programming Languages

Job description

Evaluate customer deployments of PostgreSQL, Postgres Plus and Postgres Plus Advanced Server and make recommendations on how to improve them.
Work to develop Services proposals to achieve customer needs/targets.
Familiarity with programming languages like C, C++, PHP, python, Java or Ruby to guide customers in the development of custom Postgres-based applications
Deliver PostgreSQL Postgres Plus and Postgres Plus Advanced Server courses over the web and on site.
Perform database Migrations from Oracle, SQL Server, MySQL to PostgreSQL
Performance tune and make performance tuning recommendations to existing database deployments
Set up High Availability configurations using PostgreSQL
Implement backup strategies and performs upgrades and patching
Develop architectures to migrate data and entire databases; implement and deliver on the architecture migrating databases

Requirements

Bachelor or Masters of Science in Computer Science/Computer Engineering or equivalent experience
At least three years of DBA level experience for PostgreSQL or Oracle
Be well versed in SQL
Be familiar with database design and building applications for PostgreSQL, Oracle, or other databases
General system administration and performance skills for Linux, (Ubuntu, Centos, Redhat, or Debian), including facility with scripting.
Must be able to travel up to 60%+

Preferred Skills:

Proficient with PostgreSQL community version and PostgreSQL Plus Advanced Server (PPAS) commercial version installation and configuration
Proficient with PostgreSQL /PPAS tools EDB’s PostgreSQL Enterprise Manager (PEM), EDB’s Backup and Recovery Tool (BART)
Proficient with database tuning and use of PostgreSQL tools such as PgBadger, EDB’s PgStatsPack, EDB’s DRITA
Proficient with PostgreSQL replication technologies Binary Streaming Replication, EDB’s xDB Replication, Logical Replication via Slony, Londiste
Proficient with PostgreSQL architecture
Proficient with PostgreSQL networking, HBA and connection pooling (PgBouncer, PgPool) Working knowledge of OLTP/DSS/DW system design
Working knowledge of scripting languages, BASH, KSH, Python, Perl etc.
Have experience deploying open source software
provided by Dice Postgres, SQL, Oracle, DBA, database administration