Database Analyst

• Sep 2022 - Present

SQL Server Database Lab Instructor/Administrator

• Sep 2019 - Sep 2022

Create an engaging learning environment that mirrors the real-world work experience and fosters student teamwork. I emphasize critical thinking and problem-solving skills through weekly exercises and projects, reinforcing the primary course content. To give students a taste of what they may encounter in the industry, I showcase different versions of SQL from 2012 to 2019. Additionally, I let them experience server installation and configuration to gain insight into how it operates. Introduce Microsoft Azure to the students, demonstrating the process of migrating from a local database to a cloud-based one, allowing them to practice and hone their skills. I aim to equip them with the necessary skills and knowledge to excel in their future careers. Show less

MSSQL Server Database Administrator

• Aug 2015 - Aug 2019

I have developed backup strategies and recovery solutions to ensure our data is always safe and secure. To improve performance, I use SQL Profiler and Database Engine Tuning Advisor to fine-tune our databases. I have installed and configured SQL servers in various environments, including 2008R2, 2012, and 2016. I also assist with capacity planning and storage space management. In addition, I have developed and written TSQL, Views, Stored Procedures, and Functions to streamline our database operations. Creating and implementing databases, tables, schemas, indexes, and constraints is another crucial part of my job. I provide database development support, query analysis, and optimization. I perform data import and export using SSIS and monitor and maintain database performance using System Monitor, Event Viewer, SQL Profiler, and Database Tuning Advisor. I have experience migrating on-premises databases to SQL Server Azure. Security management is essential to my job, and I have implemented policies for creating and managing roles, users, logins, and granting rights. Troubleshooting agent job failures and detecting and resolving blocking issues are other tasks I handle. Finally, I set up and monitored Always-On Availability Groups to ensure our databases were always available and accessible to our team. As a SQL Server Database Administrator, I am committed to providing that our databases are secure, efficient, and always available to our team. Show less

Inventory Control Specialist

• Jul 2014 - Jul 2015

I efficiently managed the warehouse inventory using the Warehouse Management System (WMS). My job involved diligently tracking inbound and outbound inventories and other resources, ensuring that products were replenished and stocked according to demand and priority. I also had to move products from the deep reserve to prime and vice versa as required, depending on changes in customer demands. In addition to these tasks, I was responsible for auto-marking out, re-billing customers, and controlling damage to all products in the inventory. I also assisted order fillers and pickers in fulfilling customer orders, ensuring products arrived to customers on time. To ensure the accuracy of the inventory, I verified product locations using barcode scanners and other computerized systems. Doing so ensured that all products were present and the warehouse ran smoothly and efficiently. Show less