Hire the Best SQL Server Integration Services (SSIS) Specialists
in the United States

SQL Server slow, unstable, poorly documented, or becoming too risky to manage? That is exactly where I help. I'm a senior Microsoft SQL Server DBA and Developer with nearly 20 years of experience helping businesses troubleshoot, stabilize, optimize, migrate, and maintain SQL Server environments across versions 2000 through 2022. My work covers production DBA support, performance tuning, T-SQL development, high availability, disaster recovery, Azure SQL, AWS RDS, reporting, ETL, security, and database architecture. I help clients solve real SQL Server problems without unnecessary complexity. Whether your queries are timing out, backups are questionable, SQL Agent jobs are failing, reports are slow, an upgrade is overdue, or nobody is fully confident in the recovery plan — I can assess the environment and move it in the right direction. WHAT I DELIVER ◾ Performance tuning — slow queries, execution plans, indexing, waits, blocking, deadlocks, parameter sniffing, Query Store analysis ◾ Production DBA support — backups, restores, DBCC checks, SQL Agent jobs, maintenance plans, monitoring, alerts, server health reviews ◾ High availability and disaster recovery — Always On Availability Groups, clustering, log shipping, replication, backup strategy, restore testing, RTO/RPO planning ◾ SQL Server development — stored procedures, views, functions, triggers, T-SQL cleanup, reporting queries, data logic troubleshooting ◾ Migrations and upgrades — version upgrades, server moves, cloud migrations, Azure SQL Database, Azure SQL Managed Instance, AWS RDS ◾ Reporting and ETL — SSRS, SSIS, data imports/exports, scheduled jobs, broken or slow reporting processes ◾ Security and compliance — permissions, least privilege access, SQL logins/users, auditing, encryption, documentation, PCI, STIG compliance ◾ Documentation and knowledge transfer — runbooks, handoff guides, diagrams, and practical recommendations your team can use PERFORMANCE & TROUBLESHOOTING Many clients bring me in when SQL Server is already under pressure. Common problems I fix: ◾ Slow applications caused by inefficient SQL queries ◾ Reports that time out or block production users ◾ High CPU, memory pressure, tempdb issues, or storage bottlenecks ◾ Blocking, deadlocks, and long-running transactions ◾ Poor or over-indexed databases ◾ SQL Agent job failures ◾ Backup chain confusion or restore uncertainty ◾ Availability Group, replication, or failover problems ◾ Legacy databases with little or no documentation I focus on finding the actual cause, explaining it in plain terms, and recommending fixes that are safe for production. HOW I WORK 1. Discovery — Review the environment, the problem, business impact, risks, and current configuration 2. Assessment — Identify performance, reliability, security, backup, and architecture issues 3. Plan — Prioritize the safest and highest-value fixes first 4. Implement — Make careful changes with rollback awareness and documentation 5. Validate — Confirm the issue is resolved using data, not guesswork 6. Support — Provide clear next steps, ongoing monitoring, or handoff documentation WHAT CLIENTS SAY "Throughout our two-year contract, Michael demonstrated extraordinary proficiency as a Microsoft SQL Database Administrator, perfectly marrying technical expertise with excellent communication and a proactive mindset." -- Cloudacio “I have worked with Michael on several different projects ranging from web tool design and implementation to using his skills as a SQL DBA for contract work. When I need a skilled person for software development, web or DBA work - My first call always is to Michael.” -- Keith Swingle, VP Strategic Partnerships, NetVPro "Michael was a lifesaver in helping us figure out some complex Microsoft SQL Server issues. Watching him work inside a database is like watching a wizard." -- Bchex WHY CLIENTS WORK WITH ME Clients value that I'm practical, responsive, and able to explain technical database issues in plain English. I'm comfortable working with business owners, developers, IT teams, vendors, and executives. I don't throw scripts at the problem. I look at the full SQL Server environment: configuration, workload, queries, jobs, backups, HA/DR, application behavior, and operational risk. My goal: make your SQL Server environment faster, safer, more stable, and easier to support. COMMON ENGAGEMENTS ◾ SQL Server health check ◾ Emergency production troubleshooting ◾ Performance tuning review ◾ Query and index optimization ◾ Backup and restore validation ◾ SQL Server migration planning ◾ Azure SQL / Managed Instance support ◾ Always On Availability Group troubleshooting ◾ SSRS / SSIS / SQL Agent job support ◾ Long-term DBA support Whether you need a one-time SQL Server review, emergency troubleshooting, migration help, performance tuning, or ongoing DBA support — click **Invite to Job** and send me a quick summary of what you're trying to fix, improve, or migrate.

From database design to Power BI dashboards — I deliver fast, reliable, and insight-driven data systems. I’ve helped 50+ companies optimize queries, automate ETL, and scale analytics with Microsoft SQL Server, SSIS, SSRS, SSAS, Power BI and Domo. Performance-focused | Cloud or on-prem . Contact me to get started WHAT I CAN DO FOR YOUR BUSINESS RELIABLE DATABASES (Microsoft SQL Server, PostgreSQL, MySQL, and more) Design and optimize SQL Server databases so your queries run faster, smoother, and at scale. Create business logic and build complex queries and stored procedures in T-SQL PERFORMANCE TUNING & OPTIMIZATION Identify bottlenecks and fine-tune SQL queries, indexes, and execution plans for maximum performance and reliability. FAST DATA PIPELINES (SQL Server Integration Services (SSIS)) Automate extraction, transformation, and loading of data (ETL)— clean and up-to-date data with zero manual effort. FLEXIBLE ANALYTICS MODELS (SQL Server Analysis Services) Build OLAP cubes and semantic models that allow decision-makers to analyze data from any angle. INSIGHTFUL DASHBOARDS & REPORTS (SQL Server Reporting Services (SSRS), Power BI, DOMO) Deliver clear, actionable visualizations that drive decisions based on facts, not guesswork. MY TOOLBOX Databases: MS SQL Server, PostgreSQL, Google Spanner, Google BigQuery, MySQL, Oracle Microsoft BI: SSIS, SSRS, SSAS, Power BI Other BI tools: DOMO (MajorDomo certified), Oracle Hyperion BI, SAP BI Languages: T-SQL, PL/pgSQL, other SQL dialects, MDX, Python, R Modeling: IDEF0/1/1X/3, UML, DFD (BpWin, ErWin, Rational Rose) LET’S TALK ABOUT YOUR PROJECT

My name is Kimberly Killian and I am the founder of SiteDataView, a small business dedicated to delivering high-quality Microsoft SQL Server database solutions. I am here to introduce myself, my company, and the services I provide to help organizations manage, optimize, and protect their data assets. At SiteDataView, I specialize in comprehensive Microsoft SQL Server services, including: • Administration & Maintenance – Managing backups, monitoring, job automation, and overall database health. • Database Design & Architecture – Creating scalable, secure, and efficient database environments. • Performance Tuning & Optimization – Improving speed, reliability, and overall system performance. • Troubleshooting & Repair – Diagnosing issues, resolving errors, and ensuring minimal downtime. • Migrations & Upgrades – Seamlessly moving data between platforms or SQL Server versions. • Consulting & Best Practices – Offering guidance to help teams follow modern, efficient, and secure database standards. • Always-On and Replication • Cloud on Azure and AWS as well as On-Prem • Data Warehouse and reporting - collecting, organizing, and storing large volumes of data from multiple sources into a centralized, structured repository for reporting. • Windows Server Administration, Active Directory, Patch Management, Server Clean ups • Cyber Security: Enterprise Networking, Security, and Automation, CCNA: Switching, Routing, and Wireless Essentials, CompTIA Security+, Qualys, Sentinel One With hands-on experience in SQL Server environments of all sizes, I focus on providing dependable, personalized service that meets each client’s unique technical and business needs. Whether you require ongoing support or assistance with a one-time project, SiteDataView is committed to delivering solutions that are both effective and future ready. I have also have a Window Systems Admin/Cyber Security Engineer in my employ to take on Windows Administration and Cyber Security Tasks! I split time between Metro Detroit and SW Florida both in the Eastern time Zone. I have over 30 years experience in the field of Information Technology with the last 24 dedicated to database technologies specifically MS SQL Server. Please feel free to check out my profile on LinkedIn as well as take a look at my website to see the services I provide thru my company SiteDataView. I've worked for very large companies on high profile projects and very small companies on small projects. I am a published author on SQLServerCentral and SQLShack. In addition to this, I am also rated as "Expert Vetted" on UpWork which is the highest rating one can hold! I welcome the opportunity to learn more about your organization and discuss how SiteDataView can support your database goals. Please feel free to contact me at your convenience. I would love the opportunity to talk to you about your project in more detail. I am available to begin today. Thank you, Kimberly Killian Sr. Database Administrator/SQL Developer/SQL Server Consultant SiteDataView

Note: Pls scroll down to the end to see my employment history ⦿ Work: I assist small to mid-sized enterprises with data engineering, business intelligence, and visualization/Reporting. I don’t believe in a one-size-fits-all solution for Data Management. I help my clients make the right choice. After completion of a project, I provide detailed documentation to enable you to continue maintaining your data product(s). ⦿ My Skills: Data Visualization/Reporting Tools: Tableau, SSRS, Cognos 10.2, Cognos 11.1 Analytics,Google Data Studio, Grafana Databases: SQL Server, mySQL, postgreSQL, Azure, AWS Redshift Cloud Technologies: AWS AppFlow, AWS S3, AWS Lambda ETL Development Tools: SSIS, T-SQL, Cognos Framework Manager, Cognos Transformers Coding languages: Python, R Agile Project Management Platform: Atlassian (JIRA) Source Control: Git Survey Tools: Qualtrics No Code/Low Code Workflows: Zapier, Notion Data Sources: IBM MAPICS, Google Analytics, Epicor, Anaplan, Google Sheets, CSV/Excel files, Microsoft SQL Server, PostgreSQL, S3, Redshift, RDS API Integrations: Mixpanel, Twilio Segment, CustomerIO, Posthog, Salesforce, Qualtrics, Stripe, Saleor, MedusaJS ------------------------------------------------------ ⦿ Work Highlights: • Designed and set up the entire Redshift database architecture, and built cloud data pipelines to integrate tools like Mixpanel, Segment, Customer.io for seamless analytics ingestion. Also set up data pipelines from order management systems such as MedusaJS and Saleor. • Developed an image-processing algorithm using OpenCV and Python. • Developed a workflow using Notion and ChatGPT to generate detailed scripts for social media advertising. • Used Zapier to integrate multiple APIs to trigger jobs and to post data onto platforms. • Created dashboards with Grafana and Tableau, enabling stakeholders to monitor KPIs and take data-driven actions. • Automated reporting workflows using Microsoft GraphQL and custom Python scripts. • Architected an end-to-end Azure reporting solution, automating SFTP ingestion and email-based report distribution. • Custom built call center analytics performance tool to reduce call volume using Python & Tableau. o Built a tool in Tableau comprising multiple dashboard views where users could decide the type of comparisons they wanted to see. o Built Python scripts to pull raw data from multiple Google Analytics properties periodically, combine data and feed the data to Tableau on a schedule. o Used AWS AppFlow and AWS S3 to export data from Salesforce on a schedule. Built Python scripts to clean this data and run multiple machine learning algorithms (Ensembles) to perform Sentiment Analysis. The Python scripts were setup to allow for constant training based on verified data. This data was then fed to Tableau on a schedule. • Developed Dashboards in Tableau to gauge Chatbot effectiveness • Used AWS AppFlow to gather chatbot data and store it in S3 for historical tracking. This data was then visualized for various metrics like Retention Rate, Chatbot Conversation Length, etc. • Performed Hypothesis testing to determine the chatbot's launch effectiveness (i.e., to determine if the introduction of the chatbot had a significant effect on call volume reduction) • Developed a Chatbot in Python for ticketing (NLP, chatterbot libraries) • Used Python NLP algorithms and libraries to build a chatbot that could answer queries related to ticket booking and could retrieve booking details. • Developed Dashboards in Tableau for Non-profit research based storytelling • Mined survey data from Google Sheets and developed dashboards in Tableau to relay the stats related to a certain social cause. • Developed stored procedures and SQL views using SQL Server, SSIS and T-SQL for a large beauty company. The 'Revenue Recognition' logic was incorporated in the report development so that revenues could be realized only after being invoiced. Developed the necessary processes to deploy the reports to top executives to their emails. Developed reports using Cognos Analytics and SSRS. • Developed Predictive Analytics algorithms in R and Python across domains. • I have also worked on Predictive Analytics use cases (supervised & unsupervised) in R and Python. ----------------------------------------------------------------------------------- ⦿ Availability: I am in Stamford, CT and work in any US timezone. If you have a requirement for a different timezone, we can always discuss it.

✅ TOP RATED Consultant on UpWork | *100% Client Recommendation Score* My name is Ryan, and I am one of Upwork's highest rated SQL Server DBA (Database Administrator) and Developers. I've worked with numerous companies on projects including database administration, optimization, performance tuning, automation, and SQL programming. If you are having a database issue, you have come to the right place for help. Unlike other database professionals, I am able to effectively communicate to understand your business needs and technical architecture in order to meet your deliverables. I keep my high Job Success Score and Five-Star Feedback rating by accepting only the jobs I know myself to be the best person for. If I'm not completely confident in delivering you the perfect job, I'll let you know and steer you in the right direction. Thank you for reading this far, and I look forward to discussing your project together. Technical Skills: Twelve (12) years of experience in SQL Server versions from 2005-2022, and over 7 years working with Azure and AWS. Certifications: • MCA: Microsoft SQL Server Systems AI-Enabled Database Solutions • MCSE: Microsoft SQL Server Systems Expert Data Platform • MCSA: Microsoft SQL Server Certified Solutions Associate • MCITP: Microsoft SQL Server Database Administrator • MCITP: Microsoft SQL Server Business Intelligence Developer • MCSA: Microsoft SQL Server Certified Solutions Associate

20+ years of professional development experience. Industry experience includes: Finance, Broadcast TV, Distribution & Transportation, Manufacturing, Oil Services, Non-Profit, Retail. ▬ Microsoft Full Stack Development ▬ Data Analysis, Data Modeling, Data Warehouse, Data Mart ▬ Data Integration, ETL, Data Quality ▬ Database Administration/Development ▬ SQL Server. SSIS, SSAS, SSRS, T-SQL ▬ PostgreSQL, MySQL ▬ Business Intelligence Solutions ▬ Software Development (.NET, .NET Core, MVC, C#, VB.NET) ▬ SAP Crystal Reports, Power BI ▬ Power Apps, SharePoint, Power Automate (Flow), Logic Apps