Adam Grams Email & Phone Number

Minneapolis, Mn, Us

Minneapolis, Mn, Us

Chanhassen, Mn, Us

* Implementing and designing of enterprise data lake storage strategies and identifying enterprise integration patterns congruent with Modern Data Architecture.* Supporting, designing and implementing end-to-end data ingestion patterns for distributed data sources to the business consumer.* Partnership with data scientists on data delivery goals and other data science initiatives.* Using a vast array of Azure cloud services to facilitate and automate distributed hot and cold path data delivery. ADLG1, ADLG2, BLOB, Event Hubs, Stream Analytics, Runbooks, Functions, Data Factory , DataBricks, Synapse, Service Bus.* Implemented and designed parameterized CI/CD Data Factory release pipelines to build scalable data ingestion pipelines for distributed data sets.* Acted as DBA consultant for high priority enterprise OLAP, OLTP DBMS performance tuning and troubleshooting for Oracle, SQL Server and Synapse.* Key member/developer on an Agile Data Warehousing team supporting DW engineering and sprints.* Key member in PCI compliance of databases and DW ETL pipelines.* ELT/ETL workflow manipulation and creation using Python, PowerShell.

Minneapolis, Minnesota, Us

* Managing, maintaining, administering and deploying enterprise SQL Server, Oracle, MongoDB databases in a public global organization.* Development of automation using PowerShell, PLSQL, TSQL to assist with daily DBA duties* Architect/engineer of HA and DR solutions for MongoDB & SQL Server implements.* Product champion for MongoDB troubleshooting, deployment, implementation and administration standards.* Developing DBMS development and production standards within the database team.* Administering, troubleshooting, and implementing standards and processes for DBA DW/BI.* Project management and coordination regarding DBMS upgrades and patching including DW/BI environment.* Implementing scalable database technologies best practices and administering databases for HR, CRM, and SOX systems.* Integral team member of ITIL change management control meetings and reviews.* Ensure database availability, integrity, security, and reliability for SAP, Sitecore and all Tier 1 enterprise and customer facing applications.* Countless successes regarding on-going DBMS performance and query tuning.* Highly respective and sought after for project collaborations/and DBA leadership.* Invaluable in a cross team collaboration with other teams such as Web Services, Server Team, Infrastructure, SAP Basis, and DevOps.* Successful mitigation and management of SQL Server and MongoDB licensing costs.* Enthusiastic adopter of company culture proven by involvement and leadership amongst many interoffice groups and organizations (Toastmasters, rec leagues, fund-raising and volunteer events).

Eden Prairie, Minnesota, Us

* Managed help desk requests while implementing new technologies, and monitoring system and network health.* Utilized, tested, and incorporated different strategies and technologies regarding disaster recovery on mission-critical systems.* Project lead on deployment on all system and network updates, including software and hardware life cycles.* Directed and executed customer service help desk strategies.* A key leader in implementing new system policies and updated existing technology policies.* Key strategist in the adoption and deployment of centralized virtual infrastructure.* Participated in committees pertaining to managing and deploying technology in an enterprise healthcare setting.* Accountable for support, optimization, and management of network infrastructure technologies.* Responsible for the standardization of hardware, and software in a corporate enterprise.* Assembled, installed, configured, and repaired servers, desktops, printers, routers, switches, and firewalls.* Administered Active Directory, Exchange and deployment after company acquisitions.* Project lead on instituting corporate IT standards during new acquisitions.* Responsible for the management, configuration, maintenance, and programming of employee time keeping systems (Kronos Workforce Central) as employee policies and regulations changed, and deployment after company acquisitions.* Administration of SQL databases.* Programmed ETL modules during transition from UNIX based accounting system to broader financial system, Dynamics Great Plains.* Designed and programmed ETL modules between SQL instances (Kronos to Great Plains, Kronos to UNIX).* Important team member during planning and deployment of new corporate financial accounting software system.

Supported client's IT needs.

Master'S Degree, Data Science

Bachelor Of Science, Telecommunications

Associates Of Arts