Sql Server Database Administrator

Josh Pokrasov

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

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

SUMMARY:

Over 25 years of experience in SQL Server and Oracle database design, administration, and development. Expert in performance tuning, relational database design (logical and physical), automation, high availability, disaster recovery, and ETL processes. Proficient in N-Tier and Client/Server architectures, as well as Object-Oriented Programming. Extensive experience in user interaction, system analysis, and full-cycle implementation of commercial products across Client/Server and cloud environments. Known for delivering professional work with high 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, Power BI, IIS, Git, Zendesk, Jira, Confluence, Visio, Lucid Chart, VMware 17 Operating Systems: MS Windows Server 2016, 2019, 2022 Other: MFA, DUO

EXPERIENCE:

Lead Database Engineer

Campus Innovation, INC

February 2023 – Present

● Solely responsible for design, development, and administration of all in-house and over 100 cloud-hosted SQL Server databases.

● Wrote cumulative scripts to upgrade database structure including Tables, Views, Stored Procedures, Triggers, Functions, Automation, ETL and DTS Packages.

● Performed query optimization, performance tuning, index analysis, upgrades, automation, monitoring, HA/DR, backup and restore of all in-house and cloud-hosted databases.

● Designed and developed SQL Server database automation (ETL) for client’s Imports and Exports.

● Developed PowerShell automation scripts for client onboarding, including user, role, and database provisioning, as well as server monitoring and upgrade scheduling.

● Set up company infrastructure in Hosted Environment and Wasabi Cloud.

● Performed setup and configuration of Active Directory and Microsoft Entra ID for secure identity and access management.

● Set up company database infrastructure in Azure. Created Azure Resource Groups, Database Managed Instance, Azure SQL Databases, Virtual Networks, Storages. Used Data Factories to create Pipelines for client’s imports and exports. Set up Monitors and Alerts.

● 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 proof-of-concept ASP.NET application to replace middle tier written in ColdFusion. Which will save over $100,000 in licensing fees

● 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.

● Guided team in SQL Server usage, SSIS integration, and query design best practices.

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

Lead Database Administrator

Adirondack Solutions, INC

September 2002 – February 2023

● Designed, developed, and supported all in-house and over 600 cloud-hosted SQL Server, and on-site Oracle databases.

● Performed analysis, query optimization, performance tuning, index analysis, upgrades, automation, monitoring, user setup and configuration, HA/DR, replication, transaction log shipping of all in-house and hosted client databases.

● Wrote cumulative scripts 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 monitoring, and upgrade scheduling

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

● Created reports using SSRS and Power BI.

● Designed and developed SQL Server database Automation (ETL) for client’s Imports and Exports.

● Collaborated with engineering, development, and DevOps teams to ensure seamless integration and optimal performance within the overall company infrastructure.

● Mentored teams on using SQL Server tools, including SSIS and DTS, and proper query design techniques.

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

Senior DB Architect Software Engineer Project Leader, Contractor International Fragrance and Flavors

June 2002- September 2002

● Designed and developed warehouse management application using VB.NET with an Oracle database backend.

● Created communication drivers for measuring and storage devices using API calls. Full Stack Engineer Project Lead Contractor

November, 2001-June, 2002

Emergency Medical Services

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

● Architected and implemented a SQL Server database to support application data and operations.

● Created and deployed Crystal Reports for inventory and scheduling analysis Senior Associate DBA

November 7, 1999 – October 31, 2001

Price Waterhouse Coopers.

● Supervised a small team of programmers and QA specialists.

● Worked with users. Gathered business rules, analyzed, and wrote specifications for new projects. Full life cycle database and software development.

● Set up a SourceSafe database for the project development team.

● Set 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.

● Set up of Windows Failover clusters, SQL Server Replication and Mirroring. Software Engineer Contractor

HAVA Technologies.

March 1999 – November 7, 1999

Designed and developed web-based e-commerce application using SQL Server and Active Server Pages.

Programmer / Analyst

Nicolas J. Bouras, Inc.

February 1998 – March 1999

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 Programmer / Analyst

ProWorks Systems, Inc.

January 1996 – February 1998

Designed and developed all stages of Warehouse Inventory Control System using MS Access and Visual Basic

EDUCATION:

College of Rocket and Space Engineering, Dnipro National University, Ukraine B.S. Computer Science

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 and Development

CALC Canterbury:

Networking Essentials ( # 572 B )

Knowlagehut:

Certified ScrumMaster (CSM)

Contact this candidate