Postgres DBA

Jacksonville, FL

Company Name :IBA Infotech LLC

Type : Contract

Primary Skills : PostgreSQL, PostgreSQL Plus Advanced Server, C, C++, PHP, python.

Location : Jacksonville

CTC : DOE

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

Qualifications:

  • 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