Sql Manager

860-***-**** Cell

Victor Pavlov *************@*******.***

Database Professional with extensive experience in leading DBA Team in configuration, design, architecture and optimization of various sizes and Versions of SQL Server and Postgress Databases on premises and Cloud.

QUALIFICATIONS

Extensive experience working as a Database Administration and Management in a distributed missions critical environments of various versions and sizes on premises and cloud.

Contributed with standardizing and improving database development process through object design, code review and implementing continuous integration and delivery for database projects.

Experienced in Microsoft Reporting Services, Analysis Services, and Integration Services. Microsoft Azure and AWS with SQL backend

Familiar with multiple third party tools such as Quest Foglight, Quest Spotlight, Idera Diagnostic Manager, SQL Sentry.

PROFESSIONAL EXPIRIENCE

IDEMIA, Billerica, MA

Principal DBA (2019-Present)

oResponsible for installation, configuration and support Microsoft SQL Server on Azure and Premises

oInvolved in POC of Snowflake

oResponsible for installing and configuring SQL on AWS (EC2)

oResponsible for support AWS RDS

oResponsible for supporting Amazon Aurora with Postgress

oResponsible for Managing Database Security

oResponsible for Planning Migration, upgrades of Production environment

oResponsible for setting up disaster recovery and high availability using Microsoft SQL Cluster, High Availability Group (Always On) with one or more read only replicas

oPerform code reviews and provide recommendations for performance improvements.

oResponsible for moving SQL Server from on premises to cloud.

oResponsible for installing and configuring Microsoft Reporting services on SQL 2016, 2017 and 2019.

oResponsible for performance, tuning, automation and monitoring of Production servers.

oResponsible for database design and review.

oResponsible for installing and configuring SQL Server on Azure

oResponsible for Administering Azure databases

oSupporting Databases on AWS (EC2)

oResponsible for Database Management, Architecture and design.

TSD Rental, North Andover, MA

Senior SQL Server DBA (2018-2019)

Responsible for installation, configuration and support AWS with SQL Server back end on EC2

Responsible for setting up disaster recovery and high availability using Microsoft SQL Cluster, High Availability Group (Always On) with one or more read only replicas

Perform code reviews and provide recommendations for performance improvements.

Responsible for moving SQL Server from on premises to Amazon EC2 cloud.

Responsible for performance, tuning, automation and monitoring of Production servers.

Responsible for database design and review.

UNFI, Providence, RI

Senior SQL Server DBA/Team Lead (2005-2018)

oPerform database upgrades and migrations from/to multiple versions of SQL Server

oMeet directly with customers to scope and plan SQL Server based projects

oOversee and implement SQL Server based projects

oReview Work Queue, work in-take processes, execute work, task requests, and work any other requests from clients or SQL Server manager might assign.

oPerform research and provide recommendation for SQL Server upgrades as well as new tools to management.

oAct as technical consultant on projects providing recommendations for database design and data load

oPerform research and provide recommendation for SQL Server upgrades as well as new tools to management.

oProvide analysis and recommendations for storage space saving, backup solution (saved close to $05mil by moving to Data Domain backups), memory adjustments and other configurations to meet enterprise performance and save overall budget.

oSaved closed to $300,000 in license cost by virtualizing SQL Server Installations.

oResponsible for tracking and assigning tickets to the team as well as ensuring that they are completed within SLAs using Remedy.

oPerform auditing and provide reports for SOX compliance.

oPerformance troubleshooting and tuning with execution plans, SQL Server Profiler, DMV’s and third party tools.

oSet up high availability environments using failover clustering, Always On high availability.

oSetting up and supporting Database Mirroring, Database Log Shipping and SQL Server Replications.

oResponsible for Microsoft SQL Server patching

oAutomated database monitoring tasks such as database size, auto-growth, failed jobs as well as SQL Installation and configuration.

oDevelop security requirements for data access controls of sensitive data.

oPerform code reviews and provide recommendations for performance improvements.

oPerform database disaster recovery activities during emergency situations.

oResponsible for maintaining and refreshing various non-production environments.

oResponsible for managing contractors and junior DBA’s

oProvide off hour on call support.

CONNECTED CORP Framingham, ma

Software Support Engineer (May 2005-June 2005)

oExperience in a customer-focused, deadline-oriented environment

oExperience working in a remote end-user application support environment, leading resolution from beginning to end

oResponsible for first line of contact

oResponsible for determining the source of the problem such as software, hardware OS or database related.

oPerform steps to duplicate customer problems on test system. (i.e. Build SQL Server, install the same software, run the same patch updates. Build and run some SQL Scripts, perform SQL Database Maintenance).

oSupport clients over the phone.

ECOPY, INC Nashua, NH

SQL Server DBA (May 2004-Dec 2004)

oResponsible for Database design and performance tuning of SQL Server 7.0 and 2000

oWorked with business to create functional specifications, define and enforce processes and procedures for database development and system integration.

oProvided application level SQL Server DBA support to multiple project teams.

oResponsible for Database backup/recovery

oResponsible for performance, integrity and maintenance of all existing databases

oMaintained and controlled database security.

oMonitored databases access and usage.

oResponsible for Disaster Recovery planning.

oResponsible for setting up and maintaining replication and log shipping

OCO-INC Sudbury, MA

DBA (Dec 2003-Jan 2004)

oResponsible for Oracle/SQL Server Installation, configuration and patch updates

oResponsible for Database backup/recovery

oFormatting data for upload to the primary databases

oCreate new database, user permissions

oResearch, test, implement and maintain new technologies

oResponsible for performance, tuning, integrity and maintenance of SQL Server and Oracle

oMaintained Disaster Recovery servers and procedures

oMaintained documentation and standards relating to all database projects

oPerformed data migrations from Oracle to SQL Server

SYRATECH CORPORATION East Boston, MA

SQL DBA (1999-2004)

oResponsible for SQL Server 6.5/7.0/2000 and Oracle 8I installation on Windows2000/Windows NT Platform

oMigrated SQL Server from 6.5 to 7.0

oResponsible for performance, integrity and maintenance of all SQL Server databases

oResponsible for physical database design, backup planning and security

oParticipated in the disaster recovery project and testing

oSet up and tuned replication

oCreated and modified databases, tables, indexes, stored procedures and views.

oAnalyzed, tested and deployed any customer requests for database modification.

oAnalyzed any database modifications and any data flow changes to see how changes will affect database performance.

oUsed data modeling tools such as ER/Studio, DBArtisan, and Rapid SQL.

oSupport Fail Over servers using log shipping

oCreate customer reports using Crystal Reports

oParticipated in on –call rotation

CCMI Braintree, MA

SQL DBA (Jan 1999-Sep 1999)

Gathered functional specifications from business users

Processed and analyzed client data using SQL Server 6.5

Created and maintained internal databases for employee use

Ran weekly/daily reports using SQL Server and MS Access

Analyzed any customer request for database modification

Analyzed any database modifications and any data flow changes to see how changes will affect database performance.

Monitored database access and usage

Resolved database capacity problems

Responsible for creating, testing and implementing disaster recovery procedures.

Responsible for troubleshooting errors and technical support issues.

EDUCATION

Penn Foster

Contact this candidate