We provide IT Staff Augmentation Services!

Postgres Dba Resume

4.00/5 (Submit Your Rating)

Milwaukee, OR

SUMMARY:

Experienced Postgres DBA and developer on Linux/Unix platforms implementing a broad range of projects in the health care, financial, retail, manufacturing, and telecommunications industries. Design and maintain innovative solutions emphasizing performance, reliability, and maintainability. Similar Oracle experience.

SKILL:

Databases: Postgres, Oracle, SQLite

Operating Systems: Linux, UNIX

Languages: C, ksh, UNIX utilities, libpq, plpgsql, pro*c, ncurses

Security: PKI, STIG

Networking: sockets, redis

WORK HISTORY:

Confidential, Milwaukee, OR

Postgres DBA

Responsibilities:

  • collect operation system and database statistics and store in metrics database, monitor using grafana dashboards monitor replication - family tree graph database postGIS/pgrouting application redis reliable queue system postgres upgrades pgbackrest backups and restores

Confidential, Dedham, MA

Postgres BDR DBA

Responsibilities:

  • Assist in development of SIPRnet PKI application and STIG compliance
  • Assist in data center move - user maintenance, schema updates, data

Confidential, Denver, CO

Postgres DBA

Responsibilities:

  • upgrades, repmgr, barman backups and restores - optimization

Confidential, Buffalo, NY

Postgres/Oracle DBA/developer

Responsibilities:

  • health care claim related databases - query optimizations - ETL routines - benchmarks - Oracle to postgres data migrations using ora2pg - postGIS geocode provider locations install and upgrade Oracle 11.2 and 12c for Confidential & Confidential Vistakon project evaluate performance impact of Vormetric encryption

Confidential, Warren, NJ

Oracle/UNIX/C developer

Responsibilities:

  • designed, developed, and implemented Java/JNI/pro*c application to read and modify SYS 5 shared memory - port BEA MessageQ servers from VMS/RDB to HPUX/Oracle Pro*c environment

Confidential, Jacksonville, FL

Oracle/UNIX/C developer

Responsibilities:

  • designed, coded and implemented Ansi dynamic Pro*C query from Tuxedo service
  • Resolved issues with production queries returning inconsistent result sets performed maintenance of Oracle Pro*C routines install and patch Oracle on SUNOS platforms pro*c weekly and on demand ETL processes maintain SFTP site monitor OS and database metrics schema upgrades and optimization

Confidential, Madison, WI

Oracle/UNIX/C Developer

Responsibilities:

  • create database schema to store email logs and ETL routines to populate schema convert Encounter ETL from Pro*C to PL/SQL package, - modified schema to ensure data integrity and ease maintenance enhance HACMP software written in C, C++, and korn shell - updated various SMIT screens to reflect changes made to HACMP code.
  • Oracle/UNIX/C/Network developer designed and developed
  • The Confidential TCP/UDP SUNOS frontend check verification frontend - check21 multithreaded UNIX to mainframe ETL - multithreaded Oracle pro*c fraud check service.

Sprint Warrensburg, MO

Oracle/UNIX/C developer

Responsibilities:

  • port SQL Server asset management data to oracle SMS schema Project requirements where to create 2 Oracle schemas for ETL of asset management data from SQL Server RBMS

We'd love your feedback!