Sql Server Engineer Ii

SCOTT J. SOVINEE

*** *** ******, #1-201-***-****

Jersey City, NJ 07302-2759 ******.***@*******.***

Summary

Mr. Sovinee is an IT professional with over 25 years’ experience, including 15 years in Equities/Electronic Trading. His experience as a Microsoft SQL Server DBA/Developer spans 20 years, including SQL 2019.

In his last role, he was an Senior Engineer II / Database Services (DBA) for HedgeServ Corporation (Fund Administration) supporting PROD and lower-lane Microsoft SQL Server and multiple Snowflake accounts.

Highlights of core duties include:

Enhanced and maintained a multi-tenant warehousing system for reference data that incorporated 200+ Bloomberg feeds. Initial ETL and data verification performed in SQL Server for export to Snowflake for application consumption.

Migrated Microsoft SQL 2016 Production, stand-alone instances to SQL 2019 with DevOps methodology using AWS tool set (YAML, CodeBuild, etc)

Coding, Troubleshooting, Performance Tuning and Optimization (PTO) of T-SQL objects (stored procs, views, functions, etc.) using Execution Plans, DMVs, Foglight, etc. Refactoring legacy T-SQL for: parallelism, materialization, windowing functions, and set-based processing.

He also has an extensive background in analysis, requirement definition, specifications, data modeling, system design, and documentation serving both business and technical stakeholders.

DBA Tools:

SolarWinds DPA (Database Performance Analyzer), Foglight for Databases (Quest), Redgate SQL ToolBelt

Core System Maintenance:

Ola Hallengren – backup, index optimization. LiteSpeed for SQL Server (Quest). Familiarity with Maintenance Plans and Redgate SQL Backup.

Scripting / PowerShell IDE;

ActiveDirectory – AD group/user assignment forensics.

AWS Tools for PowerShell – manage S3 DB backup copies for archival/restore.

dbatools – Migration commands used for instance consolidation / decommissioning.

HA:

Always-On. Familiarity with legacy DB mirroring, log shipping, DB subscriptions.

Other Microsoft:

SQL Server Kerberos Configuration Manager (reset SPNs), Assessment and Planning Toolkit (organizational SQL instance discovery to support ELA negotiations).

Other DBMS:

Snowflake (cloud-based warehousing) – Administration, troubleshooting, development and DR.

Redis (No-SQL) – clean-up of keys without TTL for estimated annual storage cost savings > $18 k.

Oracle 7.1 (Solaris), Sybase System 10 (NLM), ERwin 3.5.x

Development:

SDLC/SCM:

Jira & Confluence (Atlassian Cloud), Visual Studio Code, GitHub/GitHub Desktop (Windows), Visual Studio Team System 2013 Professional, Team Foundation Server 2013

DevOps:

Working familiarity with YAML and AWS Stack (CodeBuild, CodePipeline, Secrets Manager, AWS Console, etc.)

Reporting:

Microsoft SQL Server Reporting Services, Seagate Info 7.5, Crystal Reports 8.0.

Misc:

AutoSys JIL (scheduling), RedHat Linux, PuTTY (SSH Client), SSMS Tools Pack, ODBC, NAnt (Database builds), FTP, SFTP, HTTPS, Connect:Direct

Ops:

Microsoft Teams, Slack, RDP, Cisco AnyConnect Secure Mobility Client (MFA/DUO).

HedgeServ Corporation, New York, NY (www.hedgeserv.com/) 9/22– 3/25

Senior Engineer II / Database Services (DBA) – Core duties listed above.

Equinox Group, New York, Ny (www.equinox.com/) 3/17 – 9/22

Application Data Architect / DBA

Supported PROD and lower-lane SQL Always-On (HA) instances deployed on AWS (self-managed) with multi-regional DR.

Coding, Troubleshooting, Refactoring, Performance Tuning & Optimization (PTO) of SQL objects using Execution Plans, DMVs, SolarWinds DPA

Installation, Maintenance & enhancement of SQL Server 2017 Always-On instances deployed on AWS. Topology includes PRIMARY & SECONDARY nodes on multiple subnets at AWS East (synchronous), DR node at AWS Oregon (asynchronous), read-only SECONDARY, Listeners, AWS NLBs, etc.

Transitioned SQL security from SQL logins to Windows AD. Custom SQL role-based security with database triggers. Module based security techniques include context switching and code signing. Familiarity with GDPR, data masking and obfuscation.

Bank of America, Jersey City, NJ (www.bankofamerica.com) 7/15 – 1/17

Senior Database Engineer ARCTIC Team / Consultant through TEKSystems

ARCTIC is Bank of America’s in-house trade & position data repository serving enterprise-wide business functions including Credit, Margin, Regulatory, Compliance, Client Valuation, Treasury and Finance.

PTO of T-SQL objects: procs, views, triggers, scalar/tabular functions, sequences, etc.

Database application load-balancing and partitioning due to schema enhancements or volume integrating > 300 upstream feeds (real-time & end-of-day/month).

Analysis, development & execution of data lineage effort to fulfil regulatory requirements post-TARP.

ACI Worldwide, Parsippany, NJ (www.aciworldwide.com) 10/14 – 5/15

Senior Software Engineer (Database) / Consultant

Design, development and maintenance of a high-throughput, full lifecycle, OLTP Credit Card processing.

Monitoring and enhancing large-scale (~ 2.5 TB) daily batch ETL processes.

Creation and enhancement of 100+ multi-step SQL Agent jobs per customer.

Note - from 8/11 to 9/14, Mr. Sovinee worked outside of IT, writing a feature-length screenplay.

Lava Trading, Inc / Citigroup / FlexTrade, New York, NY (www.FlexTrade.com) 5/03 – 7/11

ColorPalette SQL Developer / System Architect / DBA

Worked extensively on FlexTrade’s “ColorPalette”, an OMS (Order Management System) product designed for high throughput and automation, targeting sellside institutional and retail customer orders.

Installation and configuration of SQL Server 2008 R2/2005/2000 in QA and DEV.

Requirement definition, design and coding of customer reports including Clearing, Compliance and Regulatory using SQL Server Reporting Service (SSRS). Compiled initial specifications and requirements for PROD “scale-out” Reporting Service clustering installation. Installation and configuration of SSRS Server instances.

Interface SQL Server with various other 3rd Party systems – SalesForce, CRMS systems, PeopleSoft HR modules.

NYCE Corporation, Secaucus/Woodcliff Lake, NJ 1/02 – 4/03

Consultant / System Architect / DBA 4/96 – 10/00

Designed and developed a monthly custom enterprise billing system serving over 1500 customers.

Installed, configured, upgraded, and administered Microsoft SQL Server. Tuning of mission-critical, slow running for a 200% performance gain.

EDUCATION

Professional

DevelopMentor: SQL Server 2005 for Developers (instructed by Bob Beauchemin) – 10/03

Sybase: FastTrack, Open Client, Open Server

Microsoft: Invited by Microsoft to participate in a 1-week SQL Server 2005 Beta Lab in Redmond, WA (10/03) to benchmark / optimize “real” Lava Trading production batches under SQL 2005.

Academic

Rutgers University, New Brunswick, N.J.

B.A., double major - English & Business Administration, Honor’s Graduate, Dean’s List.

References furnished upon request.

Contact this candidate