System Status: 99.999% Uptime
npm run dev --host
Hi, I'm Mark Rodgers
A dedicated Database Administrator by day. I craft resilient schemas, optimize query plans, tune buffer pools, and safeguard data integrity.
A creative Full Stack Engineer by night. I build responsive frontends, implement robust REST/GraphQL APIs, and design distributed web architectures.
“
"Information is the asset; design determines its velocity. I ensure your data foundation is bulletproof."
"Code is the medium; experience is the target. I bring full-stack architecture to life under the cover of night."
postgresql_monitor.sql
EXPLAIN ANALYZE
SELECT u.id, u.username, count(p.id)
FROM users u
LEFT JOIN posts p ON u.id = p.author_id
WHERE p.created_at > '2026-01-01'
GROUP BY u.id;
-> Index Scan using idx_posts_author_created
Planning Time: 0.142 ms
Execution Time: 4.812 ms (Optimized - 92% speedup)
0.8ms
Avg Query Latency
5.4TB
Data Managed
Server.ts
import { Fastify } from "fastify";
const app = Fastify({ logger: true });
app.get("/api/v1/metrics", async (req, res) => {
const metrics = await db.fetchStats();
return { status: "online", data: metrics };
});
await app.listen({ port: 3000 });
UI COMPONENT
Bridging the Gap
Data Architect meets Web Engineer
The Best of Both Worlds
In software, databases are often treated as black boxes. Web developers write ORM queries that look clean on screen but compile to inefficient, locking queries underneath. Conversely, DBAs can sometimes be isolated from the product vision and frontend demands.
I live at the intersection of these two domains. My day job as a DBA embeds me deep within transaction logs, query execution engines, index strategies, and failover topologies. When night falls, I leverage this depth to build high-performance web applications that respect the constraints of database engines, scale gracefully under load, and feature gorgeous, responsive user interfaces.
Performance-First Engineering
I design endpoints that execute query plans in milliseconds, avoiding N+1 problems and transaction blocks.
Resilient Infrastructure
I build web layers that fail gracefully and handle database failovers, connection pooling, and auto-scaling events seamlessly.
“
"A full-stack developer who doesn't understand databases is only building half an application. A DBA who doesn't understand client experience is only optimizing half the system."
Core Capabilities
My Tech Stack
PostgreSQL & Oracle
High-availability replication, partitioning, custom index strategies, vacuum tuning, and schema design.
Performance & SQL Tuning
Plan analysis (EXPLAIN ANALYZE), join-order optimization, deadlock resolution, index-only scans, and stored procedures.
High Availability & Clustering
Active-passive failover, multi-master replication, pgpool setups, connection pooling, and point-in-time recovery (PITR).
React & Modern Javascript
TypeScript integration, state machines, virtual lists, performance-centric renders, and modern build tooling.
Node.js & Backend API
Fastify/Express backend servers, microservices, REST/GraphQL design, connection pooling drivers, and caching logic.
Docker, Redis & Linux Systems
Containerized workloads, Redis caching structures, bash scripting, network troubleshooting, and security hardening.
Showcase
Featured Projects
Postgres Failover & Replication Controller
An automated failover script orchestrating PostgreSQL streaming replication. Includes health checks, automated split-brain prevention, and DNS routing updates.
Distributed Query Caching Gateway
An intelligent proxy gateway sitting between API layers and relational databases. Uses Redis cache invalidation pipelines and query hashing to cache heavy relational joins.
Chronology
My Journey
2024 - Present
Lead Database Administrator & Engineer
Enterprise Financial SystemsManage over 80 production database instances. Orchestrated a zero-downtime major PostgreSQL engine upgrade across multi-terabyte shards. Automate daily cluster performance reporting using customized shell scripts and Node.js dashboards.
2021 - 2024
Database Administrator & Backend Developer
DataCore TechnologiesMaintained high-transaction SQL databases while designing REST microservices. Cut cloud database infrastructure expenditures by 30% through index consolidation, query optimization, and connection pool restructuring.
2019 - 2021
Junior Software Engineer
WebLaunch AgencyDeveloped responsive web applications for enterprise clients using React, Express, and PostgreSQL. Interacted directly with clients to map business logic to relational database schemas.
2018
Computer Science Graduate
University of ScienceGraduated with honors, focusing on Relational Database Management Systems (RDBMS), Algorithms, and Web Architectures. Built a custom embedded database engine for senior project.
Reach Out
Get In Touch
Let's talk optimization and code
Have an application that's scaling poorly, slow-running queries, or want to discuss full-stack web architectures? I'm always excited to connect and collaborate.