Oracle DBA Specialist | Automation Mindset

Hello, I'm

Seán Hogan

|

Managing and optimizing enterprise Oracle databases with 5 years of hands-on experience. I focus on dependable administration, evidence-led performance tuning, and high availability setups that keep businesses moving.

5+ Years In OpsEvidence-led Oracle administration with an automation-first mindset and steady on-call reliability.

Behind The Databases

About Me

DBA by trade, collaborator by nature. I keep Oracle workloads healthy while building the relationships that make shipping software feel effortless.

I'm Sean, an Oracle Database Administrator who has spent the last 5+ years shepherding mission-critical data platforms. My comfort zone sits where solid processes meet human-first collaboration, pairing clear runbooks with open communication so teams always know what is happening and why.

Day to day you'll find me orchestrating backup and recovery strategies, tuning SQL with AWR and ASH insights, and hardening environments using Linux, Bash, and Python automation. I love closing feedback loops quickly: observe, tune, document, and share.

Outside the pager, I invest in continuous learning, experimenting with AI copilots, refining playbooks, and mentoring newer DBAs. The goal stays the same: stable systems, confident teams, and data that delivers measurable business value.

Strengths

  • - Performance tuning & execution plans
  • - Backup, recovery & standby design
  • - Proactive observability practices

Working Style

  • - Calm during incidents
  • - Transparent status updates
  • - Automation before repetition

Collaboration

  • - Partnering with dev teams early
  • - Sharing postmortems & learnings
  • - Mentoring junior DBAs
Experience5+ yearsEnterprise Oracle environments
Focus AreasPerformance & ResilienceTuning, HA, and recovery strategy
ToolingOracle, ASM, Linux, Bash, PythonAutomation-first approach
AvailabilityOpen to collaborationsRemote-friendly & US/EU overlap
99%
Change success aligned to SLA
24/7
On-call support with calm comms

Day-To-Day Toolkit

Technical Skills

The capabilities I lean on most to keep Oracle workloads stable, observable, and ready to grow. Clear, repeatable patterns over sprawling bullet lists.

Oracle Operations

Daily stewardship of 19c/23ai estates with automation-first checklists.

  • Provisioning, patching, and ASM storage management
  • Runbooks for incident handling and post-incident reviews
  • Security baselines aligned with CIS controls

Performance & Reliability

Evidence-led tuning backed by observability and HA design.

  • AWR/ASH deep dives and execution plan coaching
  • Data Guard and backup strategies tested with drills
  • OEM Performance Hub insights and tuned alert rules

Automation & Collaboration

Glue work that keeps environments reproducible and teams aligned.

  • Linux/Bash/Python tooling for drift detection and audits
  • Documentation and status updates baked into delivery
  • Mentoring and pairing to uplevel DBA best practices

Core Stack

Oracle 19c/23aiASMOEMRMANData Guard

Performance Toolkit

AWR & ASHSQL TraceOEM Performance HubBaseline alerts

Automation

LinuxBashPythonAnsiblen8n

99%

Change success

Deployments aligned with SLOs through pre-flight checks

24/7

On-call

Calm, transparent communication when incidents strike

80%

Automation coverage

Repeatable tasks scripted and version-controlled

Personal Builds

Featured Projects

A selection of systems and products where Oracle discipline meets thoughtful engineering.

PersonalView

BabySteps - iOS Baby Tracking App

A fully native SwiftUI experience for tracking growth, milestones, and daily activities. Features CloudKit family sharing, Apple Sign In, and a zero-dependency architecture built for maintainability.

Highlights

  • 15,000+ lines of handcrafted Swift
  • Family sharing with real-time sync
  • Lock screen sleep timer widgets
  • Offline-first persistence with Core Data
SwiftSwiftUICloudKitCore DataiOS
Personal

AI-Powered Server Monitoring via Telegram

Self-hosted Ubuntu infrastructure managed through natural language conversations. An N8N orchestrated workflow uses OpenAI tooling to interpret intents, execute shell commands, and stream results back through Telegram.

Highlights

  • Conversational server queries and actions
  • Real-time telemetry surfaced in chat
  • Secure command execution with audit trail
  • Composable automation using N8N workflows
Ubuntu ServerN8NOpenAITelegram BotBash
Personal

EduManage - Intelligent School Platform

Next.js 15 platform for school operations with Skye, an AI assistant that supports exam creation, attendance, analytics, and role-based workflows. Built with PostgreSQL, Prisma, and hardened authentication.

Highlights

  • AI-powered operational assistant (Skye)
  • Exam lifecycle automation end to end
  • Granular role-based access control
  • Security posture with encryption and audit logging
Next.jsTypeScriptPostgreSQLPrismaNextAuth

Want to dive deeper into code, architecture decisions, or operations stories?

Let's Collaborate

Get In Touch

Ready to talk Oracle databases, automation, or resilient systems? Reach out through the channel that works best and I'll typically reply within a day.

Contact Information

Prefer async communication? Email works best, with follow-up calls arranged once we align on scope.

24h

Typical response time

Partnership

Happy to pair or lead projects

How I Can Help

Whether you need someone to steady an existing Oracle estate, design a resilience plan, or collaborate on automation initiatives, I bring a calm, evidence-led approach.

  • Reliability reviews, runbooks, and on-call handoffs you can trust.
  • Performance tuning observability briefs that bring teams along for the ride.
  • Lightweight automation and documentation to keep operations predictable.

Send an email with a brief outline and we can schedule a call to dive deeper.

© 2025 Sean Hogan - Crafted with Next.js, TypeScript, Tailwind CSS