Gregory Trunk

Senior Database Developer with 10+ years delivering logical database administration and database development for enterprise Java/J2EE applications, specializing in Oracle 11g/19c, PL/SQL, and PostGreSQL migrations. I have led an Oracle 19c upgrade and performance tuning that improved query performance by 65% and reduced deployment time by 70%, supporting platforms processing 5M+ daily transactions with 99.99% availability. Skilled in RAC, RMAN, Data Guard, GoldenGate, ASM, shell & SQL scripting, and Agile backlog grooming, with strong adaptability, problem solving, and relationship-building to mentor teams and enforce standards.

I apply rigorous standards, code review practices, and reliability engineering to maintain high-availability systems and to augment team delivery quality.

Senior Database Developer - Oracle - Austin, TX

(2023-08)

• Owned application-specific logical database design efforts for enterprise services, established database standards and code-review workflows, performed peer reviews and mentored developers to improve reliability and maintainability; bring 10+ years supporting enterprise databases.
• Architected and tuned Oracle 19c databases including ASM and RAC for high-availability, designed partitioning and indexing strategies that supported platforms processing 5M+ daily transactions and maintained 99.99% availability.
• Planned and executed an Oracle 19c upgrade across production and non-production environments; validated upgrades with RMAN backups and Data Guard failover tests, produced rollback and cutover runbooks to meet SLA windows.
• Implemented database CI/CD (Liquibase + Jenkins) and automated deployment checks, reducing production deployment failures by 60% and reducing deployment time by 70% through standardized change pipelines and pre-deploy validations.
• Built proactive monitoring and alerting using AWR/ASH/ADDM, OEM and shell-driven health checks; automated root-cause collection to shorten MTTR and improve incident triage during high-load windows.
• Developed and refactored complex PL/SQL stored procedures and triggers, optimized SQL and indexing to remove bottlenecks, and collaborated with app teams on parameterized query plans to ensure stability under peak concurrency.
• Provided on-call database operations triage and production support for Java/SOA services, performing live diagnosis, SQL tuning, hotfix scripts, and coordinating rollbacks with application owners to restore service quickly.

Senior Database Engineer - Bank of America - Charlotte, NC

(2020-03 - 2023-08)

• Refactored complex SQL queries, redesigned indexing strategies and tuned database access layers to improve database performance by 65%, eliminating peak-hour bottlenecks for transaction processing.
• Designed and implemented scalable logical data models and partitioning schemes that increased transaction throughput by 45% while maintaining ACID guarantees for critical banking workflows.
• Supported enterprise application stacks (Java / Spring Boot / WebSphere) by profiling SQL, tuning JDBC usage, and collaborating with developers to rewrite N+1 patterns and long-running queries.
• Authored and maintained stored procedures and database-side scripts for defect repair and performance fixes; created regression tests to validate fixes through CI pipelines.
• Automated database build and deployment operations using Jenkins and Azure DevOps, reducing full-schema deployment times from multiple hours to under 20 minutes and improving repeatability of releases.
• Planned schema migration activities and ran proof-of-concepts for migrating specific application schemas toward PostGreSQL, including schema conversion, compatibility testing, and performance baseline comparisons.
• Performed backup & recovery validation, capacity planning, and helped shape database change management policies to meet compliance and audit requirements across multiple development cycles.

Database Developer - IBM - Chicago, IL

(2015-05 - 2020-03)

• Developed enterprise web applications and database integrations using Java, Spring MVC, Hibernate and REST APIs; implemented server-side SQL and PL/SQL to support high-volume transactions.
• Built and optimized database solutions across PostgreSQL, Oracle Database, and MongoDB; tuned queries and designed indexes to improve query performance for high-volume transactional systems.
• Implemented and tested stored procedures, triggers, and ETL scripts to support application features; executed unit and integration tests to validate data correctness and performance.
• Participated in migration workstreams converting legacy schemas into service-friendly models and contributed hands-on to microservices migration efforts to improve maintainability and fault isolation.
• Containerized applications and supporting databases for development and test environments using Docker; supported CI pipelines and automated DB provisioning for dev/test consistency.
• Collaborated in Agile/Scrum teams on system design, code reviews, automated testing, and production support; supported troubleshooting and bug-fix deployments across staging and production environments.

Bachelor - Computer Science - Marquette University (2013 - 2013)

Master - Computer Science - University of Chicago (2019 - 2019)