Postgres Dba Resume
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