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.• Define and implemented RLS Row Level Security.• Define implemented Masking Policies by roles for Patient PHI.• Configure Qlik Replicate and Compose tools for replicating and ETL processes. • Configure security integrations with 3rd party tools to Snowflake (DBT, Tableau,Google Looker …).• Configure storage integrations for AWS .• Configure notification integrations support alerts.• Configure data shares, replication, reader accounts and provider listings.• Develop DR Disaster Recovery plan / documentation. • Support Business Units.SQLSERVER Database Administration (2013-Current)• Support of Source Systems Applications, Database Design, Performance tuning, Monitoring and Maintaining, DR, Alwayson HA and Development support.• Support ETL processes to SQL Server Data Warehouse, Data Feeds to pharmaceutical customers. • Develop Scripts for Client Datafeeds to S3, SFTP using Limagito application including alert notifications and retry logic.• Redgate Tools: Configured / Implemented SQL Source Control linked to SVN and shared databases. This is to support Deployment Process between environments, Maintain RI, Rollback Capability, Version Control and audit of changes. • SQL Server Maintenance plans for scheduling index maintenance, statistic updates and database backup/recovery.• Support HIPAA and Client Audits.Teradata Database Administrator on Linux SLES11 Platform. (2017-2020)• Stood up Teradata Database, wrote Linux Bash scripts to support database maintenance and monitoring.• Manage and Train 4 Teradata Managed Services consultants for tier 1,2 support for Informational

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.• Provide expertise knowledge in designing DR Disaster Recovery site with implementing new features of Oracle parallel server processing RAC benefits. • Provided support and technical expertise in a physical move of our server room to a new building location. Move of all servers and provide strategies of database moves with fail over and the least down time.• Implement Oracle 10G R2 and migrate the 9i databases.• Create a Disaster Recovery standby database with archive shipping. Written scripts to manage our standby since our DR servers were not licensed to use Data Guard.

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 project to re-platform the databases from Sun to IBM/AIX along with upgrading Oracle 8i to 9i.