Boris Zatulovsky

e-mail:ad3xg9@r.postjobfree.com

Tel:347-***-****

SUMMARY:

Boris is a SQL DBA with over 15 years of experience.

Boris is Snowflake, Azure Managed SQL, MySQL, SQL DBA in last 2 years.

EDUCATION

Master’s Degree, Electro-Mechanical Engineering (Kiev Polytechnic Institute, c.Kiev, Ukraine, 1988).

Bachelor Degree, Electro-Mechanical Engineering (Kiev Polytechnic Institute, c.Kiev, Ukraine, 1986).

TECHNICAL SKILLS

SOFTWARE:

SQL SERVER 7.0- 2019, Snowflake, MySQL8, Postgres SQL11, Foglight, SentryOne, Tivoli, LightSpeed, VISUAL BASIC 5/ 6/.Net (ADO, COM/DCOM), CRYSTAL7/8/9, CRM, PERL, ORACLE 8.0, POWERBUILDER 6.0, ASP, HTML, Java Script, XML, PL/SQL, DEVELOPER/2000, MS-OFFICE 2000/2007,,PERL, ADOBE PHOTOSHOP 4.0, Unix Shell Script, VSS.

OPERATING SYSTEM:

WINDOWS /2000/XP/2003/2008/2012/2016,WINDOWS NT 4.0, Unix Shell Scripts

APPLICATIONS:

Medical Insurance, Financial, Data Warehouse, CRM, EPR.

PROFESSIONAL EXPERIENCE

City of Portland,Oregon November 2021 - Present

Sr. SQL DBA

Support Cluster(AG) PROD\UAT\DEV environments SQL 2014\2016\2019.

Writing\configuring\optimizing Complex TSQL\SP as per client's requests.

Monitor PROD\UAT\DEV environments through RedGate, Rubrik Monitoring software.

Modified\Deployed SSIS\SSRS based on Client’s requirements.

Environment: MSSQL2014\2016\2019, AG, SSIS, SSRS, RedGate

Inspire Brands, Inc (BWW, Sonic, JJ, Arbys, Baskin Robins) May 2020-November 2021

Sr. SQL/Snowflake/MySQL/Azure SQL DBA(Data Engineer)

Build, Audited, configured, patched, tested, monitored, and supported MS SQL

Collectors (SQL2008/2012/2014/2016/2019, High Availability groups, cluster, TSM).

Support, administer Client’s databases on Azure: CosmosDB, Snowflake, Postgres, MySQL.

Creating, administrating Warehouse notebooks, roles, credits on Azure CosmosDB, Snowflake.

Designing and optimizing SQL Database modelling (normalization, relation, relativity).

Troubleshooting PROD performance, tuning\analysing Application scripts (SSIS\SSAS).

Installing\configuring 10+ SQL 2016 AWS/Azure servers.

Support Azure SQL 2019 Exadata (BigData, DataLake Analytics).

Established HA group (SQL2014\2016) for synchronization of data.

Environment: MSSQL2014\2016\2019,Snowflake, Azure, AWS, SentryOne, CosmosDB, TSM, PowerShell.

Liveperson, Inc September 2017 – May 2020

Sr. SQL DBA

•Migrated 100+ SQL servers from 2008 to 2016/2019(Standalone\Cluster) to AWS, Azure.

•Installed configured 100+ instances of SQL on AWS through snapshots or build ins.

•Installed and Configured 10+ SQL 2019 servers on AWS. Established Read-Scale AG (2016\2019) on AWS.

•Migrated several Oracle projects from ASM to AWS using AWS Data Migration Tool.

•Created, modified autosys backup jobs with Powershell, Unix Shell Script.

•Migrated Postgres SQL 11.2 to AWS with using DMS tool.

•Configured and supported SQL 2016 Cluster environment on AWS

•Troubleshooting PROD performance, tuning\analyzing Application scripts (SSIS\SSAS).

•Installing\Configuring Recovery Backup Strategy Software and Backup Models – Quest.

•Designed, developed, implemented Complex Data Warehouse Report System (Oracle Developer, ETL, SSIS, SSRS).

•Installing\Configuring 3rd party Monitoring Software on SQL boxes(NetBackUp, Entegra, Tivoli)

•Automating SQL code promotion pipelines through Datical, TFC and Jenkins tools.

•Audited, configured, patched, tested, monitored, and supported MS SQL Collectors (SQL2000/2005/2008, BMC, Log shipping, Tivoli, Integra, SSIS, SSRS).

•Installing\configuring Always On SQL 2016\2017 servers on AWS

•Supporting Cluster PROD environment SQL2005\2008\2012\2016 on AWS, Azure.

Environment: MS SQL 2014\2016\2017, AWS, Azure, Snowflake, Postgres11, MySQL 8

CitiBank, Inc. June 2007 – September 2017

SQL DBA

•Build, Audited, configured, patched, tested, monitored, and supported MS SQL Collectors (SQL 2005/2008/2012/2014,High Availability groups,cluster, TSM).

•Created Ad-Hoc modules (Ledger, Accounting, Time Entry etc..) using Oracle JDEdwards.

•Developed, implemented, supported Back-end developments for various Web- based, Client-Server Financial (Credit Card) applications–.Net (ADO, COM/ DCOM), SQL2008\SQL2012(T-SQL),SQL 2008\SQL2012 (SSRS).

•Troubleshooting PROD performance, tunning\analyzing Application scripts(SSIS\SSAS).

•Designing\configuring Data Mart Warehouse(ETL), SQL2012(ETL,SSIS)

•Designed, developed, implemented Complex Data Warehouse Report System (Oracle Developer, ETL,SSIS,SSRS).

•Install\Configuring Recovery Backup Strategy Software and Backup Models – LiteSpeed(Quest).

•Creating\Modifying\Supporting Autosys jobs(Unix,IBM DB2,Perl Scripts).

•Installing\Configuring 3 rd party Monitoring Software on SQL boxes(NetBackUp, LiteSpeed, Entegra, Tivoli)

•Analyzing historical data using SQL Server Analysis Services [SSAS].

•Analyzing historical Data warehouse data using ETL functons.

•Support Cluster PROD environment SQL 2008\2012

•Audited, configured, patched, tested, monitored, and supported MS SQL Collectors (SQL2000/2005/2008, BMC, Log shipping, Tivoli, Integra, SSIS, SSRS).

•Installing\configuring SQL\SSRS\SSIS\SSAS on SQL 2005\2008\2012 boxes

•Installing\configuring Always On SQL 2012 boxes

•Supporting Cluster PROD environment SQL2005\2008\2012

•Writing complex reports using SQL Server Reporting Services [SSRS].

•Supporting PROD environment SQL2000\2005\2008\2012 and Oracle 10g.

•Validating VMware host requirements for SQL server install\configurations

•Performing tuning,\analyzing on complex T-SQL using SSAS.

•Performance Tuning & Index Tuning, Disaster Recovery Planning, Security Management, Managing server and clients using all components of SQL 2005 Management Studio

•Tuned complex T-SQL, troubleshoot database performance problems, supported new and existing application development, worked closely with development groups on logical database design to support new and existing applications (SQL 2000/2005/2008).

•Evaluated the benefits of available system upgrades and enhancements (SQL 2000/2005/2008/2012).

•Monitored and fine tuned of the system for optimal performance, taking responsibility for production patching, maintenance and support activity (SQL 2000/2005/2008/2012).

Environment: MS SQL 2008/2012/2014,VMWare, Oracle JD Edwards,Net-Back Up, TIVOLI, LiteSpeed

Costa Cruise Lines, Inc. (Hollywood, FL) November 2004 – June 2007

SQL DBA/Developer

•Developed, implemented, supported Back-end developments for various Web- based, Client-Server Financial (Credit Card) applications–.Net (ADO, COM/ DCOM), SQL2000, Crystal 9 and Oracle10.

•Configured, patched, tested, monitored, and supported MS SQL instances (SQL2000).

•Designed, developed and implemented several ad-hoc applications–VB.Net (ADO), SQL2000.

•Designed, developed, implemented Complex Data Warehouse Report System (Oracle Developer).

•Database SQL 2000- Maintenance, Back Up, Recovery, Tasks Automation (DTS, T-SQL, RDBMS, User Roles and Access).

Environment: SQL 2000, VB6, .Net (ADO, COM/DCOM), Oracle 10g, Crystal 9, VSS 6.0.

Emplifi, Inc. (Pittsburgh, PA) June 1999 – November 2004

Programmer/Analyst

•Team member in Warehouse project for Arrow Industrial used Visual Basic 6.0, SQL 7.0

•Developed, implemented, tested Web Pages for Intellitrans, LLC (JScript, ASP, XML).

•Designed, developed and implemented Medical Software – “LightYear”- .Net (ADO, COM/DCOM),

•Designed, developed, implemented Back End Database: SQL 2000(tables, SP, views, DTS, security etc..)

•Database SQL 2000- Maintenance, Back Up, Recovery, Tasks Automation (DTS, T-SQL, RDBMS, User Roles and Access).

•Created Relational Database for NCAD (back end) using Oracle8.

•Developed NCAD application (front end) using Visual Basic 6.0, Oracle 8.

Environment: VB 6.0(ADO, COM/DCOM), Crystal Reports 7/8, Access, Excel, Oracle8, ASP, XML, HTML, JAVA Script, VB Script, SQL Server 6.5/ 7/ 2000, VSS.

Contact this candidate