Terry Dougal
- Role
- Data Architect at Audacy, Inc.
- Location
- Salt Lake City, UT, US
- LinkedIn followers
- 500 followers
About Terry Dougal
I have hired and led some rockstar data teams in the past and we have accomplished a lot…
Experience
Data Architect
Mar 2022 — Present
o Managed Snowflake Oversaw and optimized Snowflake parameters, access controls, and operational costs to enhance data warehouse efficiency. o AWS Infrastructure Management: Created and managed AWS S3 buckets, user accounts, policies, and roles to facilitate data storage and access. o AWS Secrets Management: Implemented AWS Secrets Manager to securely store and manage sensitive information. o Database Design: Designed and maintained data tables, ensuring efficient data storage and retrieval for organizational needs. o ETL Tool Integration: Spearheaded the evaluation, testing, and integration of a new ETL tool to streamline data processing workflows. o Security Enhancement (Sox 1 Compliance): Redesigned Snowflake Role-Based Access Control (RBAC) and AWS RDBS configurations to enhance data security and ensure compliance with Sox 1 standards. o GitLab Migration and Code Security: Successfully transitioned the team to GitLab version control, enhancing code security by removing sensitive information such as usernames and passwords from ETL code. o Cost Optimization (DataDog): Significantly reduced DataDog costs by implementing selective log forwarding, ensuring only essential logs were sent for analysis. o Development Environment Setup: Established a development instance of Snowflake to facilitate testing and development processes. o Technological Expertise: Utilized a diverse technology stack, including Elasticsearch, OpenSearch, and Kafka for data management and processing. Proficient in JavaScript, TypeScript, and Kotlin for application development. o Code Development and Support: Actively participated in code development and provided support for Audacy.com\'s Podcast application. o Kafka Environment Support: Utilized Elasticsearch and Conduktor in supporting and optimizing the Kafka environment to ensure efficient data streaming and processing.
Skills
- Oracle
- Disaster Recovery
- Databases
- Sdlc
- Ssrs
- Ssis
- Integration
- Software Documentation
- Business Intelligence
- Database Design
- Etl
- Erp
- Sql Server Reporting Services (Ssrs)
- Data Analysis
- T-Sql
- Business Analysis
- Sql Server
- Unix
- Visio
- Agile Methodologies
- Database
- Kimball Methodology
- Software Development
- Data Warehousing
- Microsoft Sql Server
- Sql
- Crystal Reports
Find verified contacts for anyone on LinkedIn
Unifers gives sales teams verified emails and direct dials, enriched profiles, and outreach that lands in the inbox.
Free plan included · No credit card required
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.