Maxim T. Email & Phone Number

New York, Ny, Us

London, Gb

Boston, Ma, Us

Responsibilities: 1. Management of more than 300 high load SQL Servers (AlwaysOn groups, Failover Clusters, Standalones) built on Google Cloud virtual machines.2. Level 3 support role for troubleshooting of complex issues with database systems (performance or infrastructure related).3. Optimization and troubleshooting of complex replication topologies (thousands of subscriptions, high load).4. Troubleshooting of a custom data transfer solution based on SQL Server change tracking technology.5. Interviewing and mentoring Level 2 and Level 3 database administrators.6. Implementation of custom monitoring and automation solutions based on Windows Power Shell.7. Automation of code review for database changes via GitHub webhooks triggering code sniffs in Buildkite.8. Automation of DDL/DML deployments via GitHub webhooks and Jenkins jobs.9. Cost optimization project: server consolidation, review of hardware configurations and SQL Server licenses.10. Planning and management of SQL Server version upgrades.11. Taking a leading part in migrating on-premises SQL Servers to Google Cloud.12. Tech Lead of Data Movement area: everything related to replication, change tracking, CDC. Project planning, optimizations, mentoring, incident management. Onboarding of contractors to delegate prod support responsibilities to them.

Boston, Ma, Us

Responsibilities: 1. Management of more than 100 high load SQL Servers (AlwaysOn, Failover Clusters).2. Level 3 support role for troubleshooting of complex issues with database systems (performance or infrastructure related).3. Optimization and troubleshooting of complex replication topologies (thousands of subscriptions, high load).4. Troubleshooting of a custom data transfer solution based on SQL Server change tracking technology.5. Interviewing and mentoring Level 2 and Level 3 database administrators.6. Implementation of custom monitoring and automation solutions based on Windows Power Shell.7. Design and implementation of a disk usage prediction system.8. Design and implementation of data archiving from SQL Server to Hive using Apache Sqoop.

Part Of Frasers Group, Au

Responsibilities:1. Management of high load cloud-based virtual servers with SQL Server 2008, 2008R2, 2014, 2016 instances.2. Planning infrastructure of database servers for new projects.3. Testing performance of database servers to identify optimal configuration.4. Setting up performance monitoring, security audit and change tracking on SQL Server instances.5. Review T-SQL code from performance, unwanted locking and security perspective.6. Planning and configuring Development and PreRelease database environments.7. Optimizing security subsystem on database servers.8. Planning and configuring data archiving system (T-SQL, PowerShell, AWS S3).9. Design and testing disaster recovery plan (from private cloud to AWS).10. Managing AWS Redshift datawarehouse (security, maintenance tasks, monitoring).11. Implementation of Apache Drill to analyze raw data.12. Troubleshooting performance issues with stored procedures.

St.Petersburg, Ru

Responsibilities:1. Troubleshooting and fine-tuning of databases (OLTP and DW) for its performance and concurrency (queries, schema)2. Configuring High Availability and Disaster Recovery on MSSQL 2012 with Failover Clustering, AlwaysOn, Mirroring, Replication3. Migration of SQL server 2008 R2 to SQL Server 2012 in Microsoft Windows Server 2008 R2 Enterprise Edition4. Installation of Two-Node cluster Active/Passive on Microsoft Windows Server 2008 R2 Enterprise Edition on SAN environment5. Migration of database servers to a new datacenter.6. Troubleshooting and optimization of security subsystem on instance and database levels.7. Configuration of a monitoring system for database servers (Spotlight, mssql alerts, etc.).8. Fine-tuning of a RAID-controller configuration for better performance.9. Fixing deadlock issues.10. Configuration of ETL processes with SSIS and T-SQL jobs.11. Installation and maintenance of SSAS and SSRS instances.

Москва, Москва, Ru

Responsibilities:1. Management of database servers: 3 Two-Node Clusters MS SQL 2005, 1 Two-Node Cluster MS SQL 2008 R2.2. Design and development of database schemas for new projects.3. Troubleshooting and fine-tuning of databases (web-portal) for better performance and concurrency (queries, schema).4. Configuration and support of replication topologies.5. Configuration of a monitoring system for database servers (SCOM 2007 R2, mssql alerts, etc.).6. Performance analysis with Quest Performance Analysis tool and making recommendations for performance improvements (index creation, index modification, rewriting queries, etc.).

Москва, Ru

Responsibilities:1. Installation and maintenance of payment system servers (Windows 2008 R2, MSSQL 2008 R2 Failover Cluster).2. Implementation of a monitoring system for database servers (perfmon, SQL Profiler, mssql alerts, etc.).3. Task automation using Windows PowerShell.4. Implementation of a security audit on MSSQL 2008 R2.5. Troubleshooting and fine-tuning of databases (OLTP) for better performance and concurrency (queries, schema).6. Configuration of Windows 2008 R2 (AD, DNS, IIS).

Moscow, Ru

Responsibilities:1. Management of database servers (10 instances of MSSQL 2005).2. Implementation of a monitoring system for database servers (perfmon, SQL Profiler, mssql alerts, etc.).3. Task automation using VBS-scripts.4. Preparation of technical documentation about database servers.5. Communication with developers and making recommendations for performance improvements (implementation partitioning, index creation, index modification, rewriting queries, etc.).6. Implementation of a security audit on MSSQL 2005.7. Configuration of SSIS instances.8. Configuration of High Availability and Disaster Recovery on MSSQL 2005 with Mirroring, Replication, Quest LiteSpeed Backup tool.9. Communication with system administrators and making recommendations about RAID level for database servers.

Responsibilities:1. Management of database servers (1 instance MSSQL 2005, 25 instances MSSQL 2000).2. Development of stored procedures for reporting and administrative purposes.3. Implementation of ETL processes with DTS-packages.4. Development of reports (with FastReport component) for the financial department.5. Troubleshooting and fine-tuning of databases (OLTP and DW) for better performance and concurrency (queries, schema).6. Implementation of a monitoring system for database servers (mssql alerts, perfmon, vbs-scripts etc.).7. Planning and configuration of a new database server.8. Performed installation of MSSQL 2005 Enterprise version on Windows 2003.9. Management of domain services (Active Directory, DHCP, DNS, Terminal Services).10. Installation and maintenance of MS Exchange 2007.11. Management of a mail server MDaemon.12. Configuration of routers Cisco 2811, 7200 and switches Cisco Catalyst 2960.