Johann Sonnenberg
Summary
High-performing professional with extensive experience managing large-scale, complex databases. Skilled in SQL and database management systems. Strong understanding of database design and data modeling with excellent troubleshooting skills. Smart and committed to staying up-to-date with new technologies and advancements.
Overview
23
23
years of professional experience
1
1
Certification
Work History
Database Administrator
TherapyAppointment.com
Mills River, NC
01.2019 - Current
- Streamlined backup and recovery processes, enhancing overall system stability and availability.
- Ensured database security with implementation of role-based access control and regular vulnerability assessments.
- Reduced data retrieval times for business users by creating indexed views and optimizing stored procedures.
- Built databases and table structures for web applications.
- Set up and controlled user access levels across databases to protect important data.
- Created and updated database designs and data models.
- Increased efficiency in software development processes through effective collaboration with developers to design databases that support application requirements.
- Optimized database performance by monitoring health and implementing tuning recommendations.
Associate
Booz Allen Hamilton
McLean, VA
08.2012 - 12.2019
- Duties include: Working as a Sr. Software Engineer on the Veteran's Applications and Preferences application.
- Responsible for developing the application using Java Servlets, Spring, and Hibernate in a WebLogic and Oracle Database environment.
- Completely redesigned the application using Bootstrap and jQuery including adhering to UX design patterns and standards and 508 compliance.
- Running Fortify scans on the application codebase and remediating found security vulnerabilities.
- Creating and maintaining project documentation in the team wiki.
Associate
Booz Allen Hamilton
McLean, VA
08.2012 - 12.2019
- Duties included: Worked as a Sr. Software engineer on the First Responder's Communities of Practice application
- Was responsible for developing the application using Java, JSF, Java Servlets, and Portlets
- Much of the programming effort was extending and overriding the out-of-the-box functionality in the Liferay CMS product to tailor many portlets and sub-applications to the needs of DHS
- Worked with the Amazon Console for server set up (EC2), content (S3), and deployment and server startup/shutdown (Data Pipeline).
Associate
Booz Allen Hamilton
McLean, VA
08.2012 - 12.2019
- Duties included: Worked as the Application DBA on the Presidential Awards for Excellence in Mathematics and Science Teaching (PAEMST).
- Redesigned the existing SQL Server database from a partially relational database to a third-normal form database implementing existing and new requirements.
- Worked with the development team to write stored procedures, UDFs, views, and triggers to support the rewrite of the application.
- Also, tuned the database using appropriate indexing and scheduled jobs to monitor and keep the stats up-to-date for continued performance.
Associate
Booz Allen Hamilton
McLean, VA
08.2012 - 12.2019
- Duties included: Worked as the Application DBA on the Implant Tracking Registry application.
- Was responsible for creating and maintaining the entire schema for this application, developing ETL scripts to bring over patient, address, surgery, implant, and other data as needed.
- Worked part-time as a C# .Net developer to help the team with coding and debugging the application.
- Also, was the build manager to AWS (Cloud) environment and to the AITC environment at the VA.
Associate
Booz Allen Hamilton
McLean, VA
08.2012 - 12.2019
- Duties included: Worked as a Sr. Software Engineer on the Continuity Database application.
- Was responsible for developing the application using ColdFusion 9 and 11 (using Model-Glue MVC framework, ColdSpring IOC framework, and MXUnit unit testing framework) and SQL Server 2008R2/2012.
- Worked as the team Application DBA that included debugging and optimization of queries, implementing partial and full database backups including transaction log backups, and indexing and keeping statistics up-to-date on the database to improve performance.
Associate
Booz Allen Hamilton
McLean, VA
08.2012 - 12.2019
- Duties included: Worked as a Sr. Software Engineer on the National Fire Plan Operations and Reporting System.
- Was responsible for developing the application using ColdFusion 11 and SQL Server 2008R2 (using Model-Glue MVC framework, ColdSpring IOC framework, MXUnit unit testing framework, and Selenium for U/I tests).
- Brought in to work as the Application DBA to debug and optimize slow-running queries, implement backups, and keep indexes and statistics up-to-date.
Associate
Booz Allen Hamilton
McLean, VA
08.2012 - 12.2019
- Duties included: Worked as a Sr. Software Engineer on the Department of Navy Chief Information Officer Dashboard.
- Was responsible for front-end module development and refactoring using jQuery, back end model using Groovy/Grails as well as service creation for tasks such as data ingestion via CSV file.
IT Lead Analyst/Programmer
Mayo Clinic
Rochester, MN
05.2010 - 08.2012
- Duties included: Managing a 15-member shared services unit spanning five IT disciplines including database administrators, system engineers, Microsoft tools support, .Net identity management development, and IT security.
- Conducting annual personnel reviews, setting direction for projects including server and vended software upgrades and migrations, database standards and procedures, remote monitoring of hardware and software.
Analyst/Programmer - Senior Analyst Programmer
Mayo Clinic
Rochester, MN
09.2005 - 05.2010
- Duties included: Planning, designing, and developing the Extranet, a ColdFusion-based web application using Model-Glue, ColdSpring, AJAX and SQL Server that internal teams as well as clients use to build customized Health and Wellness portals.
- Extranet application examples are client setup, a rules manager, client content and health assessment configuration setup.
- Learned, implemented and taught the Model-Glue and ColdSpring frameworks used for developing ColdFusion applications to existing and new staff.
- Managing tasks and issues to support existing products and define and develop new applications.
- Most recently, coordinating/leading the upgrade to ColdFusion 9 workgroup, the Infrastructure and Environments workgroup, and the Common Development Language and Frameworks workgroup for the transition to .Net.
Computer Analyst
Hormel Foods
Austin, MN
10.2001 - 09.2005
- Duties included: Designing and developing the company Intranet, web-based business applications, content management application, and workflow applications, using ColdFusion, Oracle 8i/9i, and Oracle PL/SQL.
- Developing Intranet security, building ColdFusion custom tags, user defined functions, web services and creating graphics using Adobe PhotoShop and Image Ready.
- Creating WebFOCUS based web reporting applications retrieving data from DB2 on MVS, creating user defined environments (dashboard), performing installations of WebFOCUS Client and Report Caster on Windows 2000 Servers, and scheduling reports in Report Caster.
- Supporting IIS, and ColdFusion server on the Windows 2003 server platform.
Education
BBA in Information Systems -
University of North Dakota
Grand Forks, ND08.2001
Skills
- Windows
- Mac OS X
- Microsoft Office Suite
- Atlassian Suite - Jira, Confluence, BitBucket
- Adobe Photoshop
- SQL, T-SQL in SQL Server 7, 2000, 2005, 2008R2, and 2012
- SQL and PL/SQL in Oracle 8i, 9i, 11g
- MySQL 5x, 8x
- JavaScript/AJAX - jQuery
- Bootstrap
- Less}
- HTML
- Subversion (SVN), Git
- Groovy and Grails
- ColdFusion
- ColdFusion Frameworks: Model-Glue, ColdSpring, Framework One, MXUnit
- Cascading Style Sheets
- C# Net including Entity Framework, Net MVC, Net Core
- Java including Spring and Hibernate
- Development Methodologies: Waterfall, Iterative Waterfall, Agile
- Database Administration: including management and administration, backup and recovery, monitoring, troubleshooting, data migration, database design, query optimization, and performance tuning
Certification
Certified Scrum Master (certificate received 2015)
Awards Organizations
- Volunteer Firefighter, Secretary/Treasurer and Communications Officer on the Hayfield Fire Department - 05/2007 - 05/2013
- 2008 Firefighter of the Year - Hayfield Fire Department
- 2012 Firefighter of the Year - Hayfield Fire Department
- Race Director of the Annual Hayfield Fire Department Fun Run/Walk - 2008 - 2012
- Senior Youth Sunday School Teacher at Trinity Lutheran Church in Hayfield - 2007 - 2010
- Founder and Co-Manager of the Southeast Minnesota ColdFusion User Group - 03/2005 - 03/2010
- National Dean's List - 2000, 2001
- University of North Dakota Dean's List - Fall 2000, Summer 2001
- Sigma Iota Epsilon Management Fraternity, Treasurer - Spring 2000 - Summer 2001
- Information Management Association, Fall 2000 - Summer 2001
- Member of the National Honor Society - 1997
- Full Athletic Scholarship - University of North Dakota, 2000/2001
- Network Applications Planning Committee, Student Representative - Spring 2001 - Summer 2001
Awards/Organizations
Volunteer Firefighter, Secretary/Treasurer and Communications Officer on the Hayfield Fire Department – May 2007 – May 2013
2008 Firefighter of the Year – Hayfield Fire Department
2012 Firefighter of the Year – Hayfield Fire Department
Volunteer Firefighter, Training Officer on the Oronoco Fire Department - April 2021 - Present
Volunteer Fire Responder, Training Officer and EMR on the Oronoco First Responders - April 2021 - Present
Full Athletic Scholarship - University of North Dakota, 2000/2001
Timeline
Database Administrator
TherapyAppointment.com
01.2019 - Current
Associate
Booz Allen Hamilton
08.2012 - 12.2019
Associate
Booz Allen Hamilton
08.2012 - 12.2019
Associate
Booz Allen Hamilton
08.2012 - 12.2019
Associate
Booz Allen Hamilton
08.2012 - 12.2019
Associate
Booz Allen Hamilton
08.2012 - 12.2019
Associate
Booz Allen Hamilton
08.2012 - 12.2019
Associate
Booz Allen Hamilton
08.2012 - 12.2019
IT Lead Analyst/Programmer
Mayo Clinic
05.2010 - 08.2012
Analyst/Programmer - Senior Analyst Programmer
Mayo Clinic
09.2005 - 05.2010
Computer Analyst
Hormel Foods
10.2001 - 09.2005
BBA in Information Systems -
University of North Dakota