Data Services Consulting

I help visualize Production, Staging, QA, Dev, Sandbox and Users Topology like Server types, Server names, OS, IP, Firewall etc. in clean diagrams, simple to grasp quickly.

I provide details about Data Retrieval, Process, Report - Pipelines, ETL\ELT etc. Data Governance, Acquisition, Curation, Syndication, Archival.

I provide simple and clear ERD diagrams for data modelling.

I provide and maintain or follow Team PM's Project Plan.

I participate in the various teams Scrum\Agile process.

I work with IT team and hardware team and specify drives, cpu, memory and network requirements.

I configure and optimize Host Servers for VM guest Servers.

I install Windows and harden Windows.

I install SQL Server.

I patch SQL Server.

I configure SQL Server.

I harden SQL Server for SOX, STIG, HIPPA.

I catalog Servers.

I work with IT and hardware team and specify drives, cpu, memory, network, permissions, software requirements.

I configure user Laptops and Desktops to host VMs for local isolated environments. I put processes in place to refresh these VMs on demand or on schedule.

I upgrade SQL Server 2000, 2005, 2008, 2012, 2019, 2022 to higher versions.

I migrate SQL Server to various versions to Microsoft Fabric.

I migrate SQL Server to various versions to AWS.

I migrate SQL Server to various versions to Azure.

I migrate MS Access to desired SQL Server version or Microsoft Fabric.

I migrate Oracle to desired SQL Server version or Microsoft Fabric.

I migrate DB2 to desired SQL Server version or Microsoft Fabric.

I migrate FoxPro data to desired SQL Server version or Fabric.

I consolidate and separate data systems\databases in legacy servers.

Data systems are brought together in one set of server based on application.

Data systems are separated into various environments based on life cycle and purpose.

I provide progress information to management via BAU reports

I install, Patch and Upgrade.

I create Users, Groups, AD Users, AD Groups, Service Accounts.

I grant and Revoke permissions to various objects for these Accounts.

I document every Account's Permissions in every object.

I audit permissions regularly, notify change.

I Automate Admin password changes on regular basis.

I provide clean approved permission templates for new Employees.

I remove Permissions for Terminated Employees adjusting ownership.

I create Simple Maintenance Plans - Backups, Integrity Check, Update Statistics, Rebuild and Reindex. I implement Ola Hallengren framework. I also setup Centralized Management Servers MSX. 

I set up jobs to send Daily Consolidated Report.

My experience as a Developer turned DBA with Data Modeling, redefined my optimization skills. Working with final level of Microsoft SQL Server support team, I use their tools to optimize code, processes and the configuration and build of SQL and Windows Servers.

I use Brent Ozar's, Paul Randal's, Kalen Delaney's and Brad McGehee's insights.

This is my core strength. I have been writing code since I was in school.

I write clean optimized self-documenting TSQL Code as scripts, stored procedures, functions, views, CTE.

I rewrite and optimize existing code.

I work in Microsoft Fabric, and I convert legacy systems to  Fabric medallion Architecture.

I convert various types of databases like Oracle, DB2, MySQL etc. to Lakehouse.

I convert Windows Tasks, SQL Agent Jobs to pipelines.

I used to write DTS packages and then I wrote complex SSIS packages.

I upgrade DTS to SSIS Packages.

I now convert SSIS and loading scripts to Fabric pipelines.

I leverage my migration skills to transform the data to Parquet from Oracle, DB2 etc.

I write complex Excel Reports.

I write complex SSRS Reports.

I maintain and convert legacy reporting systems like Crystal Reports  to SSRS.

I use PowerBI for new projects and convert legacy reports to PowerBI.