Johann Sonnenberg

Johann Sonnenberg Email and Phone Number

Database Administrator @ TherapyAppointment
Oronoco, MN, US
Johann Sonnenberg's Location
Oronoco, Minnesota, United States, United States
Johann Sonnenberg's Contact Details
About Johann Sonnenberg

Seasoned Database Administrator working in the healthcare field. Currently working with Amazon Aurora MySQL in AWS.

Johann Sonnenberg's Current Company Details
TherapyAppointment

Therapyappointment

View
Database Administrator
Oronoco, MN, US
Employees:
1
Johann Sonnenberg Work Experience Details
  • Therapyappointment
    Database Administrator
    Therapyappointment
    Oronoco, Mn, Us
  • Therapyappointment
    Database Administrator
    Therapyappointment Jan 2019 - Present
    Oronoco, Minnesota, United States
    - Worked closely with a Spring Boot/Grails team to optimize performance and scale applications.- Streamlined backup and recovery processes including a global database cluster in two regions in AWS, enhancing overall system stability and availability.- Reduced data retrieval times for business users by creating covering indexes as appropriate and optimizing stored procedures.- Built databases and table structures for web applications.- Set up and controlled user access levels… Show more - Worked closely with a Spring Boot/Grails team to optimize performance and scale applications.- Streamlined backup and recovery processes including a global database cluster in two regions in AWS, enhancing overall system stability and availability.- Reduced data retrieval times for business users by creating covering indexes as appropriate 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 including implementation of a star-schema data warehouse.- Engineered and led a data migration of 3.5M patient records from a legacy system with zero data loss.- Planned, tested, and completed move from MySQL 5.x to MySQL 8.x.- Optimized database performance by monitoring health via CloudWatch logs and Performance Insights and implementing tuning recommendations. Show less
  • Booz Allen Hamilton
    Associate
    Booz Allen Hamilton Aug 2012 - Dec 2018
    Department of Veterans Affairs- Worked 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… Show more Department of Veterans Affairs- Worked 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.- 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).Department of the Interior- 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. Show less
  • Mayo Clinic
    It Lead
    Mayo Clinic May 2010 - Aug 2012
    Rochester, Minnesota, United States
    - Managed 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.- Conducted 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.
  • Mayo Clinic
    Analyst/Programmer - Senior Analyst Programmer
    Mayo Clinic Sep 2005 - May 2010
    Rochester, Minnesota, United States
    - Planned, designed, and developed 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… Show more - Planned, designed, and developed 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.- Managed tasks and issues to support existing products and define and develop new applications.- Coordinated and lead the upgrade to ColdFusion 9 workgroup, the Infrastructure and Environments workgroup, and the Common Development Language and Frameworks workgroup for the transition to .Net. Show less
  • Hormel Foods
    Computer Analyst
    Hormel Foods Oct 2001 - Sep 2005
    - Designed and developed the company Intranet, web-based business applications, content management application, and workflow applications, using ColdFusion, Oracle 8i/9i, and Oracle PL/SQL.- Developed Intranet security, built ColdFusion custom tags, user defined functions, web services and created graphics using Adobe PhotoShop and Image Ready.- Created WebFOCUS based web reporting applications retrieving data from DB2 on MVS, created user defined environments (dashboard), performed… Show more - Designed and developed the company Intranet, web-based business applications, content management application, and workflow applications, using ColdFusion, Oracle 8i/9i, and Oracle PL/SQL.- Developed Intranet security, built ColdFusion custom tags, user defined functions, web services and created graphics using Adobe PhotoShop and Image Ready.- Created WebFOCUS based web reporting applications retrieving data from DB2 on MVS, created user defined environments (dashboard), performed installations of WebFOCUS Client and Report Caster on Windows 2000 Servers, and scheduled reports in Report Caster.- Supported IIS and ColdFusion server on the Windows 2003 server platform. Show less
  • Und Athletic Department
    Web Development/Tech Support
    Und Athletic Department Oct 2000 - Jul 2001
    Duties included: Planning and updating the Athletic Department website, www.fightingsioux.com, building personal computers for the entire staff, creating an internal network for the central staff, providing troubleshooting and tech support for the coaching staff.
  • Commark, Inc
    Intern/Web Programmer
    Commark, Inc Apr 2000 - Apr 2001
    Duties included: Developing and maintaining dynamic websites using HTML, ColdFusion, and JavaScript, database design and implementation, Production and Development server administration and support, integrating a third-party CRM product with a web implementation product.
  • Und Housing Department
    Resident Assistant
    Und Housing Department Oct 1998 - Dec 2000
    Duties included: Acting as a campus resource for 30 residents; planning and hosting fun and educational events; assisting in new student orientation, managing room check-ins, transfers, check-outs and hall inventory, completing weekly reports as required by the Resident Hall Director; enforcing all rules and regulations of the University with consistency and fairness.

Johann Sonnenberg Skills

Asp.net Mvc Jquery Web Applications T Sql Microsoft Sql Server Crystal Reports Web Development Agile Methodologies Iis Ajax Html Xml Web Services Mvc Javascript Css Sql Database Design Software Development Coldfusion Soa C# Databases

Johann Sonnenberg Education Details

Frequently Asked Questions about Johann Sonnenberg

What company does Johann Sonnenberg work for?

Johann Sonnenberg works for Therapyappointment

What is Johann Sonnenberg's role at the current company?

Johann Sonnenberg's current role is Database Administrator.

What is Johann Sonnenberg's email address?

Johann Sonnenberg's email address is jo****@****ail.com

What is Johann Sonnenberg's direct phone number?

Johann Sonnenberg's direct phone number is +141048*****

What schools did Johann Sonnenberg attend?

Johann Sonnenberg attended University Of North Dakota.

What skills is Johann Sonnenberg known for?

Johann Sonnenberg has skills like Asp.net Mvc, Jquery, Web Applications, T Sql, Microsoft Sql Server, Crystal Reports, Web Development, Agile Methodologies, Iis, Ajax, Html, Xml.

Who are Johann Sonnenberg's colleagues?

Johann Sonnenberg's colleagues are Tammy Kirkland, Brian Kotek, Betsy Elick, Remy Gagnon, Matt Sonnenberg, Gina Colombo, Angela Forse.

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.