Postgres DBA

IBA InfoTech Inc.
Jacksonville, United States of America
2 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Intermediate

Job location

Jacksonville, United States of America

Tech stack

C
Java
PHP
Bash
C++
Ubuntu (Operating System)
CentOS
Databases
Computer Engineering
Data Migration
Database Design
Debian Linux
Linux
Perl
Python
Korn Shell
PostgreSQL
Microsoft SQL Server
MySQL
Online Transaction Processing
Oracle Applications
Performance Tuning
Red Hat Enterprise Linux - RHEL
Ruby
Standard Sql
SQL Databases
Data Streaming
Scripting (Bash/Python/Go/Ruby)
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

Apply for this position