Sql Server Database Engineer

Josh Pokrasov

Tel. 727-***-****

E-mail: ***********@*****.***

SUMMARY:

Over 25 years of SQL Server and Oracle Database Design, Administration and development. Expert in Relational Databases logical and physical design, Automation, Performance tuning, ETL. Proficient in N-Tier, Client/Server architecture and Object- Oriented Programming. User interaction, system analysis, design and implementation of several Commercial products under Client/Server and Web environments. Proven ability to produce professional work with the highest quality and creativity TECHNICAL SKILLS:

RDBMS: SQL Server 6.5, 7.0, 2000, 2005, 2008, 2012, 2014, 2016, 2017, 2019, 2022.

Oracle 8i, 9i, 11g, 19c. MS Access

Cloud Technologies: Microsoft Azure, AWS, Wasabi Cloud Storage Languages: SQL, T-SQL, PL/SQL, Visual Basic, VBA, C#, ASP.NET, ColdFusion, PowerShell, JavaScript, Angular 16, HTML

Automation & Tools: SSMS, SSIS, SSRS, Failover Clusters, Availability Groups, Transaction log shipping, Replication, Mirroring, SQL Sentry, Plan Explorer, TOAD, Visual Studio, ODBC, VS Code, Crystal Report, IIS, Git, Zendesk, Jira, Confluence, Visio, Lucid Chart, VMware 17

Operating Systems: MS Windows Server 2016, 2019, 2022 Other: MFA, DUO

EXPERIENCE:

February 2023 – Present Campus Innovation, INC Lead Database Engineer

Design, development, and support of all in-house and cloud-hosted client SQL Server databases.

Writing cumulative script to upgrade database structure including Tables, Views, Stored Procedures, Triggers, Functions, Automation, ETL and DTS Packages.

Analyzing, Optimizing, Performance Tuning, Index Analysis, Upgrading, Automating, Monitoring, User setup and configuration, HA/DR, backup and restore of all in house and cloud hosted client databases.

Developed comprehensive procedural documentation detailing all database administration tasks, including configuration, maintenance, optimization, troubleshooting, and deployment processes. Ensured clarity and consistency to support team collaboration, knowledge sharing, and operational efficiency.

Design and develop SQL Server database Automation (ETL) for client’s Imports and Exports.

Setup company infrastructure in Hosted Environment and Wasabi Cloud.

Setup company database infrastructure in Azure. Creating Azure Resource Groups, Database Managed Instance, Azure SQL Databases, Virtual Networks, Storages. Using Data Factories to create Pipelines for client’s imports and exports.

Migrated Hostek Hosted Databases to Azure Managed Instance and connected them to Client applications on Hostek Web Servers.

Designed and developed SQL Server database Backup and Retention Process Automation with Point-in-time restore which works with any Hosted Environment and Cloud Storage

Designed and developed C# automation to update vehicle data from NHTSA API

Designed and developed ASP.NET application to replace middle tier written in ColdFusion.

Participated in Angular front-end and ColdFusion middle-tier design, development, and support for all company products.

September 2002 – February 2023 Adirondack Solutions, INC Lead Database Administrator

Designed, developed, and supported all in-house and client SQL Server and Oracle databases.

Analyzing, Optimizing, Performance Tuning, Index Analysis, Upgrading, Automating, Monitoring, User Setup and configuration, HA/DR, Replication, Transaction Log Shipping of all in-house and client databases.

Wrote cumulative script to upgrade database structure including Tables, Views, Stored Procedures, Triggers, Functions, Automation Jobs and DTS Packages.

Created PowerShell automation scripts for new client onboarding, servers monitor, and upgrade scheduling

Designed and developed migration tool to convert Oracle databases to SQL Server using VB.NET

Created reports using SSRS.

Design and develop SQL Server database Automation (ETL) for client’s Imports and Exports.

Participated in front-end and middle-tier design, development, and support for all company products.

June 2002- September 2002 IFF (International Fragrance and Flavors) Consultant

Design and development of warehouse VB.NET application with Oracle database backend.

Creating communication drivers for measuring and storage devices using API calls. November, 2001-June, 2002 Emergency Medical Services Consultant

Designed and developed VB.NET application for scheduling and warehouse of emergency medical supply.

Designed and developed SQL Server database.

Creating reports using Crystal Report

November 7, 1999 – October 31, 2001 Price Waterhouse Coopers. Senior Associate/DBA

Supervising a small team of programmers.

Meeting users. Gathering business rules, analyzing, and writing specifications for new projects. Full life cycle database and software development.

Setting up a SourceSafe database for the project development team.

Setting up a code library to prevent unnecessary development.

Client support.

Mapping, configuration, and software installation on client’s machines.

Oracle and SQL Server database Design and Administration.

Setup of Windows Failover clusters, SQL Server Replication and Mirroring. March 1999 – November 7, 1999 HAVA Technologies. Consultant Design and development of web-based e-commerce application using SQL Server and Active Server Pages.

February 1998 – March 1999 Nicolas J. Bouras, Inc. Programmer / Analyst Full scale design of Sales Management and warehouse systems of steel decking and joists for the construction industry using Visual Basic 6. In-house SQL Server database administration. Creating Reports using Crystal Report

January 1996 – February 1998 ProWorks Systems, Inc. Consultant Design and development stages of Warehouse Inventory Control System using MS Access and Visual Basic

EDUCATION:

Dnepropetrovsk College of Space Missile Constructions, Ukraine B.S. Computer Science, Diploma with Honor

Professional Computer Training Center, Fair Lawn, NJ Curriculum: GUI Development, using Visual Basic 4.0/5.0 and MS SQL SERVER 6.5 in Client- Server environment. Involved in work-study projects, using Visual Basic and MS ACCESS. Learning Tree International:

Oracle Database Administration and PL/SQL Programming SQL Server Administration

CALC Canterbury:

Networking Essentials ( # 572 B )

Knowlagehut:

Certified ScrumMaster (CSM)

Contact this candidate