Ben is an expert professional with over 20 years of experience in database administration, network engineering, and software development, working on a myriad of technology, programming languages, databases, and networks in his career. Extensive experience in designing, writing and implementing disaster recovery procedures, configuring databases for a point in time recovery, and configuring application systems for fall over. He has over 15 years as an advanced PostgresSql DBA and over 20 years as an advanced Linux/Unix administrator.
Provide support for database related issues, including performance, security, locks, bugs, connectivity, and auditing.
Establish the needs of users and monitor user access and security. Monitor performance and manage parameters in order to provide fast responses to front-end users.
Maximize service availability and oversee database security.
Designed the Tables for MEC’s accounting system for Court Clerks for Postgres. Assisted developers to resolve any and all issues with SQL and optimization of queries.
Closely collaborated with programmers and business analysts to implement the Clerk accounting system and provided much needed knowledge on data processing procedures.
Developed proof of concept system of python framework using flask, css, html 5, and orm’s.
Converted 148 SPL, 134 Triggers and 78 views from Informix to Postgres. Create the setup scripts to generate new Postgres instances, and design the method whereby multi Postgres server instances can be hosted on one server.
Developed the routines to migrate Postges database instances from version 9.5 to 9.6 in a seamless manner.
Set up replication servers and configure connection pooling and fall over servers for both Postgres and Informix. Migrated from zLinux on a mainframe Informix database to postgres, converting 148 SPL from Informix to Postgres, along with 134 Triggers and 78 views.
Acted as System Architect and Administrator responsible for Linux under VMware, Linux on the mainframe and web based application deployment for Linux.
Migrated Informix from SCO system to a Linux system and ISQL applications to a Linux system. Interfaced Informix database to and from WebSphere via Python for on-line renewals on the ITS' web facing portal.
Wrote a PCL library in Python to provide laser forms and reports for Board of Nursing. Upgraded Servers and SQL Server to next version. Implemented backup and restore services for SQL Server.
Wrote custom reports and Point of Sale system for clients. Setup and configured networking and VPN to stores and remote locations for Allied Feed and Seed.
Custom wrote in Appgen 4GL a funeral home management system and Home Office Insurance processing system.
Installed and configured AMANDA enterprise backup service on Hosted, co-located, equipment to centralized DLT based backup system. Configured and secured Routers and network infrastructure.
Designed and deployed the internet operations division for Fail Telecommunications. Created the first system east of the Mississippi river using ASCEND digital modems and Radius to allow dial-up users to access the internet.
Designed and programmed COBOL and CICS applications. Converted COBOL legacy programs to Mantis 4GL.
Designed and programmed COBOL and CICS applications for the insurance industry.
Performed the migration of Informix to PostgreSQL for the Space and Air Museum, eliminating most of the associated risks and considerably reducing internal efforts. Managed to achieve the maximum level of automation and quality of conversion from Informix to PostgreSQL. Converted 148 SPL, 134 Triggers, and 78 views from Informix to Postgres. Created the setup scripts to generate new Postgres instances, and design the method whereby multi Postgres server instances can be hosted on one server.
The project involved writing a Python database generator for an ERP system that scraped all the schemas from a 4GL and created a Postgres ERP database. Ensured a stable system that would suit a large number of applications, processing a huge amount of data.
Wrote a C program to use Ncurses and replicate the Dialog utility for Python. The library had tabbed screens and a debug console. A database instance describes a complete database environment, including the RDBMS software, table structure, stored procedures, and other functionality.
