• Install MSSQL servers and configure SSIS and Reporting Services.• Manage availability groups.• Create and update Azure Data Factory pipelines for data warehouse.• Maintain and recommend privilege assignments in MSSQL and PostgreSQL.• Inventory high volume data and create automated cleanup routines.• Assist with migration from on-premise to cloud.

• Installed and upgraded MSSQL servers and databases.• Created, maintained, and monitored server tasks and SQL Agent jobs.• Managed and audited database security.• Wrote ETL/ELT processes for data, file, and warehouse handling.• Installed and configured Power BI gateway and deployment pipeline.• Continued programming support and development for internal applications.

• Created, unit tested, documented, and supported web applications and Windows form applications with ASP.NET using VB.NET and C#. • Created and modified SQL tables, functions and stored procedures to maintain the underlying data for the applications. • Worked closely with database administrators with regard to database design, utilization, and optimization. • Assisted with project requirements and specifications development. • Collaborated in the selection of application development tools as well as the definition of standards and methods.

• Designed, updated, and maintained internal and external web sites, and tracked web statistics. • Collaborated with external vendors and internal IT department on design and development. • Designed interactive emails for announcements and invitations. • Continued Mac administration role, and managed budget and purchasing of hardware and software.

• Designed and produced collateral such as flyers, folders, brochures, and direct mail to support marketing strategies, and coordinated external production and delivery of collateral. • Scanned, manipulated, and color-corrected photos, converted and modified architectural drawings, and maintained electronic archives. • Maintained and troubleshot Macs and color laser printers in creative department.

Scanned and manipulated photos and illustrations. Provided rough layouts for ads and collateral. Checked all outgoing electronic files to ensure they met publication/printer specs. Responsible for burning CD archives for all clients in the agency. Maintained, troubleshot and installed software on Macs.

Designed phone cards and related point-of-purchase displays for paper and plastic media. Checked customer-supplied art and prepared files for film output. Also responsible for trapping and ripping files to film.