Andrew Rose

About Andrew Rose

At ITS Logistics, our team leverages Azure technologies to modernize data infrastructure and optimize performance. As a Sr. Database Administrator with extensive experience, I have contributed to designing and implementing a robust Data Warehousing solution using Azure Databricks, while overseeing the migration of on-prem servers to the Azure Cloud. By collaborating with developers, we have enhanced database designs and query efficiency, ensuring seamless operations and scalability. With over two decades of expertise in relational databases and cloud infrastructure, I focus on aligning data strategies with business objectives. Previous roles include leading Azure Synapse migrations and mentoring junior developers, fostering team growth and technical excellence. Passionate about enabling innovation through data-driven solutions, I aim to empower organizations to achieve operational efficiency and long-term success.

Experience

1. Sr Database Administrator

   ITS Logistics

   Nov 2023 — Present · Reno, NV, US

   Managed offshore Team in Chennai for ITS Logistics, designing and coding Data Warehousing solution using Azure Databricks.• Oversaw migration of On-Prem servers to Azure Cloud, collaborating with Developers to optimize queries and Database design.• Implemented PowerShell scripts for database maintenance automation, increasing efficiency by 40% and reducing manual errors.

Education

• New York University

  BS, Computer Science, Computer and Information Sciences, General

Skills

• Extract, Transform, Load (Etl)
• Microsoft Sql Server
• Transact-Sql (T-Sql)
• Unix
• Databases
• Software Design
• Disaster Recovery
• T-Sql
• Xml
• Database Design
• Visual Basic
• Sharepoint
• Apache
• Sql Server Reporting Services (Ssrs)
• Oracle
• Ssis
• Data Warehousing
• Database Administration
• Sql Server Integration Services (Ssis)
• Java
• Etl
• Enterprise Software
• Enterprise Architecture
• Rdbms
• Solaris
• Architecture
• Sql
• Business Analysis
• High Availability