# Matthew James Ⓥ (@smokeyjmirror.bsky.social)

Profile: https://sifa.id/p/smokeyjmirror.bsky.social

## About

Support and Sustainment engineering with a bend toward backend and database management systems. Highly accomplished and results-oriented technical leader with over 20 years of expertise in software engineering, databases, and IT infrastructure. Holding Proficiency in cutting-edge AI, machine learning, cloud platforms (Azure, Google Cloud), and diverse database management systems (SQL Server, Oracle, NoSQL). Adept at leading data-driven initiatives, optimizing IT operations, and driving significant performance improvements. Possesses full-stack capabilities for development and operations, specializing in support engineering and analytical solutions.

## Experience

- **Development Database Administrator at TEKsystems/USDA NRCS** (2014 – 2014)
  Maintained Public Trust security clearance for sensitive government projects.Administered pre-production environments for complex database systems, ensuring readiness for deployment.Automated SQL Server processes and streamlined database schema management using Redgate tools, increasing efficiency and consistency. Developed robust Stored Procedures for the National Dams request for funds application, contributing to critical government initiatives.
  
- **Senior Analyst Programmer at Mayo Clinic** (2005 – 2013)
  Managed and developed vital .NET applications for internal use, successfully supporting high-volume EDI transactions.Administered MS SQL Server 2008 R2, optimizing performance through the effective use of SSIS packages.Led a significant Desktop to Citrix conversion project, improving user access and system scalability.Established secure PGP TCP/IP file transfers across multiple organizational areas, ensuring data integrity and compliance. Led SOX compliance initiative for secure data privacy related to 837 and 835 patient financial data storage and processing.
  
- **Consultant Programmer at Toltec Consulting, Inc./Software Architects, Inc./Talent, Inc.** (1998 – 2004)
  Specialized in backend systems development using Java, Visual Basic, COBOL, SQL Server, and Oracle.Implemented and customized CRM Systems for diverse clients.Gained extensive industry experience in eCommerce Retail, Government, and Insurance sectors. Clients: Midwest Security, Best Buy{dot com}, LifeTouch National School Studios, Inscape Publishing, Florida House of Representatives
  
- **CXP FastTrack Sustainment Engineer at TEKsystems/Microsoft** (2019 – 2020)
  Conducted in-depth performance analysis of SQL Server RDBMS and cube systems, identifying critical bottlenecks.Developed and implemented strategic indexing strategies, significantly optimizing system efficiency and reducing high-priority incident resolution times.Integrated advanced data tools, including SSAS, SSIS, and Azure Data Factory, to establish improved data flow and enhance system capabilities.
  
- **Database Specialist at TEKsystems/DaVita Kidney Care** (2015 – 2019)
  Led successful database migrations and upgrades from SQL Server environments, ensuring seamless transitions and minimal downtime.Enhanced database security measures, ensuring full compliance with stringent SOX regulations.Served as a key Subject Matter Expert (SME) for mission-critical systems, significantly improving system stability and overall performance.Provided comprehensive production database administration for all MS SQL Servers.
  

## Education

- **University of Wisconsin - La Crosse** — Bachelor of Science, Management Information Systems - Business Administration (1994 – 1998)

## Skills

- .NET Framework
- Team Collaboration
- Windows Administration
- Microsoft SQL Server
- JIRA
- Machine Learning
- Microsoft SQL Server
- Data Science
- ETL
- Hyperparameter Tuning
- Microsoft SQL Server
- System Administration
- Financial Systems
- PL/SQL
- Visual Basic
- COBOL
- Microsoft SQL Server
- Project Management
- SQL
- Python
- Go
- TypeScript
- XML
- Visual Studio
- C++
- C#
- HTML
- Google Cloud
- Artificial Intelligence
- Generative AI
- Kubernetes
- Docker
- Team Collaboration
- Leadership
- UX Design
- Microsoft SQL Server
- PowerShell
- Microsoft Azure
- Microsoft Excel
- Linux
- Agile Methodologies
- Windows Administration

## Languages

- English (native)
- Spanish (limited_working)
- Toki Pona (elementary)

## Other profiles

- github: https://github.com/smokeyjmirror
- youtube: https://youtube.com/@smokeyjmirror?si=VLxe90sY413WEBuG