Senior Database Architect, HA/DR Specialist

Michael Honig

* ********* ** *******@*****.*** 914-***-****

Tarrytown, NY 10591

Senior Database Administrator/Architect (CISSP, CIPP/US) Highly energetic and skilled DBA with experience in optimizing MySQL, MariaDB, MongoDB, PostgreSQL and Oracle databases across multiple data centers, designing high-availability architectures and disaster recovery solutions. I hold the high-value CISSP and CIPP/US certifications, reflecting my strong commitment to data security, privacy protection, and compliance.

Education

■ B.A. (Biochemistry/History; GPA 3.4), Columbia University

■ Certification (Database Applications & Development Design; GPA 4.0), Computer Technology & Applications Program (Post Baccalaureate - 10 courses), Columbia University.

Professional Experience

Mediacom Communications Corporation - Chester, NY

Senior Director of Database Operations March 2022 - Present

● Manage MySQL, MariaDB, MongoDB, PostgreSQL and Oracle databases across three data centers.

● Design, develop, upgrade and maintain Test, Development, Staging and Production systems

● Serve as primary resource for schema design and query tuning for MySQL, MariaDB & MongoDB

● Design Disaster Recovery architectures across data centers for MySQL, MariaDB, and MongoDB

● Adoption of High Availability Cluster technologies such as MariaDB Galera Cluster and MySQL Group Replication

● Design and run PII discovery scans across multiple database platforms using K2View Data Product platform.

● Upgrade Oracle APEX / ORDS installations

● Configure monitoring alerts with MySQL Enterprise Monitor, Nagios, AppDynamics, PagerDuty

● Partition large tables to improve query performance and to simplify removal of old records

● Automate routine tasks through shell scripting and ActiveBatch jobs

● Maintain documentation for all workflows and construct database cluster diagrams for HA

● 24/7 support, on-call duty to heavy usage, high-traffic databases Mediacom Communications Corporation - Chester, NY

Director of Database Operations March 2018 - 2022

● Manage MySQL, MariaDB, MongoDB, PostgreSQL and Oracle databases across three data centers

● Design, develop, upgrade and maintain Test, Development, Staging and Production systems

● Serve as primary resource for schema design and query tuning for MySQL & MongoDB

● Design Disaster Recovery architectures across data centers for MySQL, MariaDB, and MongoDB

● Adoption of High Availability Cluster technology such as Galera Cluster and MySQL Group Replication

● Supervise two full-time DBAs and five consultants

● Schedule meetings, assign new tasks and review existing ones, take the minutes

● Configure monitoring alerts with MySQL Enterprise Monitor, Nagios, AppDynamics, PagerDuty

● Partition large tables to improve query performance and to simplify removal of old records

● Automate routine tasks through bash scripting and ActiveBatch jobs

● Maintain documentation for all workflows and construct database cluster diagrams for HA

● 24/7 support, on-call duty to heavy usage, high-traffic databases Remedy Partners - New York, NY

Senior/Lead Database Administrator April 2016 - December 2017

● Designed, developed, and maintained testing, development, QA, staging and production systems

● Performed database administration tasks including maintenance, upgrades, user management, monitoring, audit and performance tuning

● Enforced database version control through git and central source repository

● Created, secured, maintained, expired user accounts following best practices for compliance with HIPAA and SOX guidelines

● Analyzed query performance and tuned when circumstances warranted

● Configured MONyog to add new MySQL servers for monitoring and modified alerts

● Developed Bash scripts to automate routine tasks and pushed changes to source repository

● Worked with DevOps to create Chef recipes to enforce consistent database configurations across MySQL masters/slaves and MongoDB primary/secondary nodes

● Knowledge of established data management and data governance principles

● Thorough knowledge of conceptual, logical data modeling and familiarity with physical database design and optimization concepts.

● Possess excellent communication skills required to interface with various teams New York Times Digital, New York NY

MySQL Database Administrator May 2015 - March 2016 I worked with MySQL and MongoDB database clusters residing within NYT and AWS Cloud

== MySQL support ==

● 24/7 support, on-call duty to heavy usage, high-traffic databases

● Installation/Setup/Backup/Restore databases

● Configured Nagios and monitor MySQL databases for critical issues

● Analyzed query performance and provided solutions

● Upgraded MySQL Clusters - version 5.5 -> 5.6

● Data migrations (from development to staging to production)

● Created, secured, maintained and expired user accounts

● Set up, maintained, & troubleshooted replication over multiple data centers

● Wrote bash scripts to automate routine tasks

● Developed query-based reports in response to a variety of user needs

● Maintained documentation and constructed diagrams detailing database architectures

== MongoDB support ==

● 24/7 support, on-call duty

● Configured Nagios and monitored MongoDB nodes for critical issues

● Created new replica sets spanning multiple data centers to ensure HA

● Conducted rolling fashion index builds over all replica set nodes

● Conduct switchovers of primary nodes to different data centers to test disaster recovery procedures Columbia University Medical Center

Database Administrator/Analyst, Jan. 2006 - May 2015 I managed over 100 databases (roughly 5.0T), including MySQL, Oracle, SQL Server, PostgreSQL, and genomics flat file databases.

● Bioinformatics Software Platform - Quality Assurance Support:

Developed in-house MySQL database to collect all system testing information and bug reports pertaining to each software release for our main Bioinformatics software platform

Developed PHP web application on top of the database to permit the software development team to insert, modify, or delete data

● Migration of clinical information database

Migrated, upgraded, and patched patient database (Oracle 10g to Oracle 11g) used by clinicians throughout the medical center

Documented entire procedure, with all errors and their resolutions for posterity

● Hospital clinical cancer database (NYCP):

Extended logical design to capture new user requirements and documented entire process

Converted logical design to physical implementation in Oracle, creating new triggers, functions, stored procedures, constraints, etc.

Software Skills

Operating systems:

RHEL7/8/9/CentOS, MacOS, Solaris, Windows

Database Software:

MySQL 3.x/4.x/5.x/8.x, MySQL InnoDB Cluster, MongoDB Server 4.x-7.x, MongoDB Ops Manager, MariaDB 10.x, MariaDB Galera Cluster, Oracle 11g/19c, Oracle APEX 23.x, MS Access, Percona XtraBackup, MySQL Enterprise Backup, SQLyog

Monitoring Software:

Nagios, Grafana, MySQL Enterprise Monitor (MEM), MONyog, Database Performance Analyzer (DPA), AppDynamics, Oracle Enterprise Manager (OEM), PagerDuty, QRadar, Rapid7 Web Development:

JBoss/Tomcat, HTML, PHP

Logical design and case tools

Entity Relationship Diagrams (ERDs), ERwin, Oracle Toad, Oracle SQL Developer, MySQL Workbench Languages

SQL, Oracle PL/SQL, Python, sed, awk, bash, Java/JDBC, Perl DBI/CGI, VBA Configuration Management & Version Control Tools:

git, svn, Bitbucket, Puppet

Documentation and Workflow Tools:

Jira, Confluence, Visio

Professional Certifications.

● Certified Information Privacy Professional/United States (CIPP/US), IAPP. February 2026. Expires February 2028.

● Certified Information Systems Security Professional (CISSP), (ISC) . January 2025. Expires January 2028.

● Security+, CompTIA. July 2023. Expires July 2029.

Contact this candidate