Academy Accreditation - Databricks Fundamentals

Microsoft Certified Database Administrator MCDBA

edX Verified Certificate for Analyzing and Visualizing Data with Power BI

Bachelor's

Redesigned and migrated the company’s core product database supporting its e-commerce platform, transforming a de-normalized, constraint-free model into a properly indexed, normalized, and transactionally sound schema.

Implemented SQL Server 2005 Reporting Services (SSRS) and transactional replication to support scalable reporting and distributed data access.

Developed a T-SQL and C#.NET-based XML solution to generate and manage product feed files, automating integration with external shopping directories.

Administered and optimized a SQL Server 2005 environment supporting high-volume e-commerce operations, ensuring performance, reliability, and data integrity.

Improved application performance through stored procedure tuning, indexing strategy enhancements, and query optimization.

Database Architect

Designed and delivered an automated auditing solution for SQL Server database permissions across a large enterprise environment using SSIS, T-SQL, and PowerShell, improving visibility and streamlining compliance processes.

Operated within a large-scale SQL Server environment comprising 1,000+ instances and 15,000+ user databases, prioritizing high-impact security and auditing efforts across multiple business units.

Provided guidance on database security and data management best practices, including Transparent Data Encryption (TDE), Extensible Key Management (EKM), key rotation, and enforcement of least-privilege access controls.

Collaborated with cross-functional teams to support secure access to mission-critical databases while maintaining compliance and protecting sensitive data.

Senior SQL Server Database Developer

Engineered, owned, and operated a production-grade data ingestion pipeline in SQL Server (AWS) using SSIS and T-SQL to retrieve, decrypt, parse, transform, and process enterprise client data. Reduced processing time from two business days to under 90 minutes while eliminating manual intervention and stabilizing previously memory-intensive, failure-prone workflows. Ensured data integrity and consistency across ingestion and transformation processes through validation and controlled processing logic.

Utilized Python to support data transformation, validation, and pipeline processing tasks within SQL Server–based ingestion workflows.

Supported operational reliability of SQL Server environments, including monitoring, performance tuning, and proactive identification of system bottlenecks.

Diagnosed and resolved production data issues impacting performance and stability, including long-running queries and resource-intensive operations.

Designed, developed, and maintained complex T-SQL st

Senior SQL Server DBA and Database Developer

Designed and delivered multiple proof-of-concept solutions to validate data integration, reporting, and performance approaches across SQL Server and Azure environments.

Built an end-to-end POC integrating SQL Server views, supporting indexes, OData service endpoints, and SSIS to reassemble and process distributed data sources.

Diagnosed and resolved performance degradation in an Azure SQL Database Shard Map Manager implementation, improving query response times and overall system stability.

Developed a POC ASP.NET MVC application demonstrating dynamic SSRS integration, including parameterized report execution via ReportViewer.

Worked with DACPAC-based deployments to support database versioning, schema consistency, and controlled release processes.

Optimized query performance across both Azure SQL Database (PaaS) and SQL Server on Azure VMs (IaaS), addressing indexing, schema design issues, and inefficient data-access patterns.

SQL Server Developer

Database Developer and Administrator

Designed and implemented a SQL Server 2005 database to support core business operations.

Developed SSIS packages to perform ETL processes, including ingestion from external sources and export to third-party systems.

Built complex XML data structures using T-SQL (FOR XML, CTEs, and nested queries) to support integration with partner websites.

Designed and implemented maintenance plans for SQL Server 2000 and 2005 environments to ensure performance, reliability, and data availability.

Database Developer

Engaged to resolve a critical production performance issue causing system unresponsiveness in a SQL Server 2012 environment.

Identified the root cause within one hour and restored full system functionality within two hours using SQL Server Dynamic Management Views (DMVs) to analyze session activity and blocking behavior.

Conducted a broader performance assessment, delivering optimized T-SQL and implementing automated monitoring to capture blocking chains and generate alerts, preventing recurrence.

Designed and implemented an automated data growth tracking solution across key SQL Server instances, enabling capacity planning and long-term storage forecasting.

Developed reporting and analysis tools to support trend analysis and provide visibility into database growth patterns.

Expanded project scope after resolving the primary issue on the first day, delivering additional performance and monitoring solutions originally planned for a multi-week engagement.

SQL Server Consultant

Designed and implemented a modular, fault-tolerant ETL framework using SSIS to process large volumes of flat file data across multiple sources.

Built robust error handling, restartability, and data validation mechanisms, significantly reducing downtime and eliminating manual intervention during processing failures.

Optimized high-volume data ingestion by segmenting large files into smaller batches to enable controlled parallel processing, improving throughput and overall system resilience.

Enterprise Data Architect

Database and ETL Developer

Designed and led development of AIMS (Automated Index Management Solution), a centralized SQL Server utility built with T-SQL and SSIS to automate index maintenance across multiple SQL Server 2005 instances.

Implemented intelligent index maintenance using configurable thresholds and activity-aware scheduling, minimizing full index rebuilds and maintaining optimal OLTP performance with reduced resource impact.

Automated index fragmentation monitoring, maintenance execution, and alerting, eliminating manual overnight DBA tasks and reducing operational overhead.

Delivered SSRS reporting to provide visibility into index health, maintenance activity, and performance trends.

Administered SQL Server environments supporting choiceADVANTAGE®, a high-volume reservation and operations platform, ensuring performance, availability, and reliability.

Managed high-availability and data protection features including database mirroring, replication, backups, and log shipping (Red Gate SQL Backup).


Senior Database Administrator

Principal Software Architect | MMDA & Data Platforms

Administered and tuned multiple SQL Server 2012 instances supporting a high-volume OLTP environment for an education platform, ensuring reliability, performance, and operational readiness.

Eliminated database bottlenecks through performance tuning, including query optimization, indexing, and partitioning, significantly improving throughput and system responsiveness.

Implemented and managed high-availability configurations using Windows Server Failover Clustering (WSFC) and Always On Availability Groups to ensure fault tolerance and uptime.

Authored a streamlined runbook for WSFC and high-availability implementations, improving clarity, repeatability, and operational efficiency.

Designed and implemented real-time monitoring of query queue length and system performance metrics, enabling early detection of anomalies and proactive issue resolution.

Replaced batch ETL processes with real-time transactional replication, offloading reporting workloads from the primary OLTP system and red

Served as the primary SQL Server developer supporting multiple application development teams, owning database design, performance, and deployment across web-based systems.

Designed, developed, tested, implemented, and maintained SQL Server 2000 OLTP databases supporting a range of online applications.

Developed complex stored procedures, user-defined functions (UDFs), triggers, and views using Transact-SQL (T-SQL).

Performed schema redesigns, including data migration scripting and rollback planning to ensure data integrity during deployments.

Improved system performance through stored procedure tuning, indexing strategies, and architectural refinements to critical database components.

Diagnosed and corrected issues in legacy T-SQL logic and data workflows, reducing production defects and improving application stability.

Microsoft Access Database Developer and Systems Administrator

Delivered extensive T-SQL development to enhance the company’s Cornerstone Benchmarks platform, a flagship analytics product for the banking industry.

Designed and developed 40+ SSRS reports supporting multiple business units, enabling consistent and scalable business performance reporting.

Engineered high-volume data exchange processes using JSON and SQL Server, integrating data between internal systems and external client sources.

Implemented ETL workflows using stored procedures, staging tables, and custom processing logic to automate ingestion, transformation, and reporting pipelines.

Optimized data processing performance through efficient JSON parsing, bulk import/export techniques, and query tuning for large datasets.

Designed and built a financial data warehouse integrating data from QuickBooks, FDIC, and NCUA flat file sources.

Developed a web-based administration and analytics platform using ASP.NET Core MVC and D3.js to support interactive data visualization and reporti

SQL Database Developer

Resolved a critical production outage in under two hours by diagnosing active sessions with DMVs and addressing the root cause. Delivered optimized T-SQL and automated monitoring (blocking chain detection + alerts) to prevent recurrence. Designed and implemented an automated growth-tracking and forecasting tool, enabling proactive capacity and storage planning across SQL Server instances. Engagement originally scoped for two weeks; primary issue resolved on Day 1, with additional automation and forecasting solutions delivered thereafter.

Senior Database Consultant

Served as technical lead and Director of Information Infrastructure, leading a development team and overseeing all in-house software initiatives from architecture through delivery.

Conceived, designed, and built the full data infrastructure supporting OnePointRx, a multi-tenant healthcare application, including the relational database, data warehouse, security model, and ETL architecture on SQL Server.

Integrated HL7 clinical data from external sources into SQL Server, enabling timely and accurate access to patient information across pharmacy and care systems while maintaining HIPAA-compliant data handling.

Designed and implemented SSIS-based ETL pipelines to normalize HL7 message formats and integrate structured data into operational and reporting workflows.

Engineered a scalable SSRS reporting solution to support complex multi-tenant requirements, enabling secure, per-patient report generation across hospice clients.

Ensured data integrity, security, and availability across all 

Director, Information Infrastructure

Application Database Developer and Data Platform Engineer

Know about Michael Lockwood's work experience, education, bootcamps, certifications, and much more. Michael Lockwood