/ TECHNOLOGIES / SQL SERVER / TEAM RESUME /

Microsoft Data Platform/SQL Server Team Resume

To realize the full benefits of your Microsoft Data Platform systems and ensure their stability, you need support from a team with a deep understanding of its capabilities. Pythian’s DBAs have years of technical expertise and experience in all aspects of Microsoft SQL Server, the offerings of Azure SQL Database and the rest of the Microsoft data ecosystem. 

Along with core database administration, Pythian experts have extensive knowledge in all SQL Server related products, such as: SSIS, SSRS and SSAS, as well as high availability and disaster recovery solutions for SQL Server, security, virtualization and many more. This expertise extends as well to the Azure SQL Database family of products and the rest of the Azure data services. Our teams include certified specialists, authors, speakers, college instructors, and community leaders.

Skills and experience

  • Microsoft SQL Server (2000, 2005, 2008 R2, 2012, 2014, 2016, 2017, 2019)
  • Windows Server (2003, 2008, 2008 R2, 2012, 2012 R2, 2016, 2019)
  • SQL Server on Linux, Docker and Kubernetes
  • High availability and disaster recovery: clustering, log shipping, mirroring, AlwaysOn Availability Groups
  • Data integration: Microsoft SQL Server Integration Services (SSIS/DTS), Azure Data Factory
  • In-Memory OLTP and Columnstore technologies
  • Replication: Microsoft SQL Server to Oracle replication, Microsoft SQL Server replication
  • Business intelligence: Microsoft SQL Server Analysis Services (SSAS), Microsoft SQL Server Reporting Services (SSRS), and Power BI
  • Cloud: Microsoft Azure, Amazon Web Services (AWS), Google Cloud Platform (GCP)
  • Azure Data Lake and U-SQL
  • Azure SQL Database (single – pools – Managed Instance)
  • Azure Synapse
  • Azure Synapse Analytics
  • Cosmos Db
  • Virtualization: VMware and Microsoft Hyper-V
  • Table partitioning
  • Resource Governor
  • Extended Events
  • And more

Areas of expertise

  • Architecture design 
  • Automation 
  • Backup and recovery 
  • Best practices review 
  • Business intelligence
  • Cloud architecture, design, and migrations 
  • Complex technical issue resolution
  • Consolidation 
  • Data analysis 
  • Database design and development 
  • Data warehousing 
  • ETL development 
  • High availability and disaster recovery solution design and implementation 
  • New feature review 
  • Operating system, instance, and database monitoring 
  • Performance tuning, T-SQL coding and optimization 
  • Security and auditing 
  • Upgrades and migrations
  • Platform migrations (Oracle to SQL)
  • And more

Programming languages

  • C, C++, C#
  • Microsoft Visual Basic
  • ASP .NET
  • Java
  • JavaScript
  • Scheme
  • Matlab
  • Prolog
  • Python
  • x86-ASM
  • Perl
  • VBScript
  • PowerShell
MSFT Competencies

Certifications

  • Microsoft Most Valuable Professionals (MVPs)
  • Microsoft Partner – Gold Data Platform
  • Microsoft Partner – Silver Cloud Platform
  • Microsoft Certified Trainer
  • Microsoft Certified Master
  • Microsoft Certified Systems Administrator
  • Microsoft Certified Solutions Expert
  • Microsoft Specialist: Cloud Data Platform

Learn more about our SQL Server expertise and services