Lori Dobson Email & Phone Number

Greater St. Louis Area

• Snowflake Database Administrator (2020 – current)
• Standup and configure Snowflake Account from ground up.
• Org Admin integration of new account and build new accounts.
• Define standards for environments (dev,qa,uat and prod).
• Standards on user accounts, roles and configured provisioning between Azure IDP and Snowflake.
• Standards on service accounts using ssh keys.

Greater St. Louis Area

• Implemented a new EMR (Electronic Medical Record) application. Develop data migration scripts and conversions from Oracle to SQL Server.
• Developed a Data Warehouse in SQL Server implementing Multi-Dimensional cubes using SAS (SQL Server Analysis Services) to support dashboard development in Reporting Services and in Sharepoint.
• Utilizing Idera tools for SQL backups and monitoring of the databases. (SQLSafe, SQLDM, SQLDoctor and SQLDefrag)
• Provide Oracle Database Administration on a Unix Aix Platform for Medical OLTP systems and Windows OS Financial packages.
• Provide Support on SQL Server Databases, writing database procedures, DTS data transformation services packages.
• Design and Implement Database Warehouse Strategy including data feeds from hospitals and insurance companies, to provide risk analysis and financial reporting needs.

Greater St. Louis Area

• Provide Oracle Database Administration on a Unix/Sun Platform for Multi-Terabyte Databases. Support OPS Database environments.
• Provide primary and secondary production support in a 24x7 environment. Manage TARs and Internal Database issues and problem solving.
• Support new and modified database designs, partitioning, tune queries, write PL*SQL packages for database maintenance, utilize OEM, Precise, Fastunload, DBunload, PowerDesigner and Oracle Designer.
• Supported large projects for EMR Enhanced Merchant Reporting, Authorization, Debit, Clearing and Marketscope. Provide test/development support on database technical expertise. RMAN backup routines. Assisted on a.