Folasade Akweh

Sql Server Database Administrator @Walmart

Expertise in SQL/Snowflake architecture, data warehouse model and ETL process design• Technical Director in Snowflake/SQL DB design, business process flows and daily operations• Expertise in Cloning Database, DB tables, Schemas from PROD to DEV, TEST, UAT instances• Executed businesses with High Availability solutions mitigating business risk and saving budget• Solid understanding of Snowflake features such as Cloning, Data Sharing, Secure Views, Cashes, Warehouse sizes, Scaling, Data Pipelines, Snowflake Time Travel, Multi –Cluster warehouse and Fall-safe. Executed and migrate users from SQLSERVER to Snowflake and create the roles and assign the users to the roles• Mentored in Sharing Data Securely Across Regions, Cloud Platforms for Snowflake accounts hosted AWS, AZURE and GOOGLE CLOUD• Execute Snow pipes to load streaming data from S3 buckets, created SQS and implementedIAM policies• Design and create DB, tables, views, stored procedures, and triggers on SQL Server databases.• Designed and implemented contained DB in SQL Server, including creating user accounts and configuring security.• Minimized downtime by optimizing and monitoring high availability for SQL Server, including Database Mirroring, Log Shipping, Traditional Failover Clustering, and Always on Availability Group• Proactively maintained performance tuning and monitoring by implementing automated jobs, optimizing scripts, and analyzing execution plans.• Migrated DB using backup and restore, detached, and attached, log shipping & database mirroring.• Managed indexes to improve performance, alongside database security and Identity.• Configured and supported Always On availability Groups for our core production servers.• Designed and implemented comprehensive Backup plan and disaster recovery strategies.• Implement Snowflake data security, Roles Based Access Control (RBAC) and User Administrations• Coordinate Importation of Data from SQL to Snowflake to build Data Warehouse