Adam F. Helm

• Database Management: Expert in Oracle, SQL Server, and MongoDB, specializing in performance tuning, high availability, disaster recovery, and complex migrations.
• Full Stack Development: Skilled in using modern technologies to develop scalable applications, focusing on optimizing user engagement and backend efficiencies.
• Technical Leadership: Experienced in leading technical teams and projects, ensuring seamless integration and deployment of large-scale systems.

Senior Software Engineer & DBA | Independent Consultant

Location: East Stoneham, Maine | Sep 2019 - Present

• Lead development and optimization of next-generation applications enhancing discoverability and functionality for content creators, utilizing Nuxt, Node.js, and MongoDB Atlas.
• Oracle DBA at WorkOtter assisting the development team with migrating on-prem software to the cloud.
• Back End Consultant @ Georgia State University: Developed Ansible cookbooks to deploy Oracle infrastructure including database installation, CRS, ASM, RAC, Patches, etc.
• Executed complex data migration from AWS to Linode for full stack applications, improving performance and cost efficiency.
• Developed generative AI capabilities for prompt engineering using Google Big Query and MongoDB Atlas Vector Search.
• Recognized as "Top Rated Plus" by Upwork for exceptional performance on complex and high-budget projects.

Senior Database Consultant | Casne Engineering

Nov 2006 – Present

• Manage database architecture and operations for high-profile clients, including a major upgrade and migration project for Olympic Pipeline from Oracle 12.2 on RHEL 7 to Oracle 19.3 on RHEL 8.
• Designed and implemented high availability solutions for SQL Server and Oracle databases, significantly enhancing system resilience and uptime for clients like eBay.

Integration Consultant | Carlson Management Consulting / Datablend

Oct 2017 - Jan 2019

• Spearheaded the design and implementation of cloud-based financial system integrations by building robust data pipelines that facilitate efficient data exchange and aggregation.
• Developed API-driven integrations, leveraging platforms like NetSuite, Salesforce, QuickBooks, Microsoft Dynamics 365, and Adaptive Insights, to optimize enterprise data flows and enhance financial reporting capabilities.
• Engineered custom solutions that automated data collection and transformation processes, significantly reducing manual data entry errors and improving data quality.
• Collaborated with cross-functional teams to identify integration requirements, define API specifications, and customize solutions that support business objectives and operational efficiency.
• Utilized best practices in continuous integration and deployment (CI/CD) to ensure seamless updates and scalability of financial systems without disrupting existing workflows.

Applications DBA / Architect | Computer Sciences Corporation

Nov 1999 - July 2017

• Led database technology initiatives at Bath Iron Works, progressing from Oracle 7 on HPUX to Oracle RAC on RHEL7, focusing on performance optimization and system scalability.
• Engaged with development teams to refine and tune database designs and SQL performance, significantly enhancing system responsiveness and efficiency.

B.S.B.A. in Management Information Systems
Duquesne University | 1993 – 1997

Self-Directed Computer Science Education
Stanford University (Online Resources) | 2015 – 2017

Completed hundreds of hours of self-study in introductory computer science. Focused on mastering fundamental concepts and the "Art and Science of Programming" using CS106A and CS106B materials (YouTube lectures, textbooks, and syllabus).