Sanford, Florida, United States
I offer experience in database administration, automation, troubleshooting, performance analysis, and design with emphasis on both application functionality and system scale-ability. I believe that it is important to stay current on new technologies so that we can offer the best possible solutions to business problems. This includes technologies such as Kafka message streaming and document style databases. I am known for debugging issues, taking ownership of problems, and follow through. People who work with me would say that I am easy to work with, that I share knowledge, I am thoughtful, and always willing to help when needed to solve a problem. This includes both database and OS performance and operational issues. I am knowledgeable in Oracle, Mongo, Confluent Kafka products, Ansible, Linux, and scripting using a variety of languages including Java, groovy, Python, and shell.
Kafka and StreamSets administrator implementing automation and support for Confluent Apache Kafka, Kafka Connect, KSQL, and StreamSets data collector integration platform. Implemented zero downtime Kafka upgrades that removed downtime costs associated with Kafka upgrades across 4 data centers. Designed and Implemented StreamSets deployment including automated installation and validation so that new environments and products could be easily created. Provided support to production staff including platform performance optimization and problem resolution. This included Kafka, Kafka Connect, KSQL, and StreamSets across 4 data centers and more than 40 hosts. Automated process monitoring configuration using Prometheus, JMX, and Loki to allow for fast deployment of new processes.
Oracle and Mongo database administrator and architect implementing new product across multiple data centers. Designed and implemented Mongo database multiple data ceneter cluster for high availability along with Mongo production operational procedures. Implemented Oracle Multi-master Goldengate replication to allow for increased availability and ease of application failover between data centers. Performed Mongo database document design and shard design during implementation phase of new product. Executed performance and scale-ability testing against Mongo Database based on specific application requirements to prove viability of Mongo. JMeter and custom java classes were utilized to drive application functionality along with rest interface calls. Implemented Oracle Standby failover procedures for production environments to increase availability of application systems. Designed and implemented automated zero downtime Mongo upgrades utilizing Ansible automation. Evaluated Oracle database replacement solutions including PostgreSQL, MySQL, DB2, and others. Recommend the use of Postgres whenever possible over Oracle for new project development to reduce database maintenance costs. Architected Postgres deployment using Patroni and Barman for availability and recoverability and created example deployment.
Development Database Architecture and administration for Oracle Database, Oracle RAC, and Goldengate replication. Performed Oracle logical and physical database design for platform project that was responsible for tracking of voice and data network events. Debugged application database issues across development, staging, and production environments. Implemented RAC Universal Connect Pool to allow for transparent failover between RAC instances to allow for increased availability and simplified management. Implemented data replication scheme using Oracle Goldengate to facilitate data availability between application components. Implemented PLSQL procedures, triggers, and other schema components to provide for scale and functionality of application processes. Optimized database SQL access paths to increase performance and scalability of application processes. Designed and implemented schema components (tables, indexes, partitions).
Billing System Design, Support, Implementation, and Benchmarking. Designed and implemented MySQL Cluster database to allow for billing of real time network call events so that rating can occur in the call path. Implemented federated database for online real time event rating. Supported sales through critical large-scale application benchmarks utilizing Oracle RAC and various load generators to acquire business from major telecommunications providers. Performed variety of functions including Oracle schema design, production support, application design, SQL performance optimization, and Database performance optimization. Defined integration requirements and architecture for integration of customer service system into a billing operational system with team members in the US and China.